Script error on new server

The API formerly known as Tera-WURFL
BMCadvertising
Posts: 17
Joined: Wed Apr 04, 2012 2:39 am

Script error on new server

Postby BMCadvertising » Thu Jun 28, 2012 1:16 am

I recently moved servers and ran into a script error that I have never seen before when using the WURFL DB API. Anyone have any idea how to fix this error?

Fatal error: Uncaught exception 'Exception' with message 'Device has an invalid fall back tree: generic_web_browser' in /home/admin/public_html/Tera-Wurfl/TeraWurfl.php:245 Stack trace: #0 /home/admin/public_html/Tera-Wurfl/TeraWurfl.php(215): TeraWurfl->getFullCapabilities('generic_web_bro...') #1 /home/admin/public_html/Tera-Wurfl/TeraWurfl.php(171): TeraWurfl->getDeviceCapabilitiesFromRequest(Array) #2 /home/admin/public_html/----/batch.php(32): TeraWurfl->getDeviceCapabilitiesFromAgent('Mozilla/5.0 (Ma...') #3 {main} thrown in /home/admin/public_html/Tera-Wurfl/TeraWurfl.php on line 245

Thanks so much for the help,
Jayson

BTW, did a little more digging, and it seems like it happens only on certain user agents (even on the test wurfl page on my server)...here's an example of one that gives me the error:

Mozilla/5.0 (iPhone; U; CPU iPhone OS 4_3_2 like Mac OS X; en-us) AppleWebKit/533.17.9 (KHTML, like Gecko) Version/5.0.2 Mobile/8H7 Safari/6533.18.5

(and the error:

Fatal error: Uncaught exception 'Exception' with message 'Error in DB RIS Query: PROCEDURE admin_gtnbt.TeraWurfl_RIS does not exist. Query: CALL TeraWurfl_RIS('Mozilla/5.0 (iPhone; U; CPU iPhone OS 4_3_2 like Mac OS X; xx-xx) AppleWebKit/533.17.9 (KHTML, like Gecko) Version/5.0.2 Mobile/8H7 Safari/6533.18.5',40,'Apple') ' in /home/admin/public_html/Tera-Wurfl/DatabaseConnectors/TeraWurflDatabase_MySQL5.php:124 Stack trace: #0 /home/admin/public_html/Tera-Wurfl/UserAgentMatchers/UserAgentMatcher.php(98): TeraWurflDatabase_MySQL5->getDeviceFromUA_RIS('Mozilla/5.0 (iP...', 40, Object(AppleUserAgentMatcher)) #1 /home/admin/public_html/Tera-Wurfl/UserAgentMatchers/AppleUserAgentMatcher.php(62): UserAgentMatcher->risMatch(40) #2 /home/admin/public_html/Tera-Wurfl/TeraWurfl.php(436): AppleUserAgentMatcher->applyConclusiveMatch(Object(TeraWurflHttpRequest)) #3 /home/admin/public_html/Tera-Wurfl/TeraWurfl.php(213): TeraWurfl->getDeviceIDFromRequestLoose() #4 /home/admin/public_html/Tera-Wurfl/TeraWurfl.php(171): TeraWurfl->getDev in /home/admin/public_html/Tera-Wurfl/DatabaseConnectors/TeraWurflDatabase_MySQL5.php on line 124)
Again, any help would be very much appreciated.
Jayson

kamermans
Posts: 393
Joined: Mon Jun 06, 2011 9:50 am

Re: Script error on new server

Postby kamermans » Thu Jun 28, 2012 9:30 am

It looks like you moved the database from one server to another without moving the stored procedures (mysqldump, for example, does not back them up by default). To fix this, you should reload the WURFL data, which will recreate the missing procedures.
Thanks,

Steve Kamerman
ScientiaMobile

Make sure you check out our WURFL Cloud, WURFL InSight and WURFL InFuze products!

BMCadvertising
Posts: 17
Joined: Wed Apr 04, 2012 2:39 am

Re: Script error on new server

Postby BMCadvertising » Thu Jun 28, 2012 10:57 am

That did it! Thanks so much...BTW, any idea when a new version will be released?

sm_support2
Posts: 294
Joined: Mon Jun 20, 2011 5:04 pm

Re: Script error on new server

Postby sm_support2 » Thu Jun 28, 2012 11:31 am

end of summer. But there are quite a few things we want to get right, so there may be delays

BMCadvertising
Posts: 17
Joined: Wed Apr 04, 2012 2:39 am

Re: Script error on new server

Postby BMCadvertising » Fri Jun 29, 2012 1:03 pm

Sounds great...thanks again for the help!

Kemystery
Posts: 4
Joined: Fri Jun 17, 2016 5:23 am

Re: Script error on new server

Postby Kemystery » Tue Jun 21, 2016 8:46 am

I'm having a similar issue. Opened a new thread but no one has replied.
How do I reload the WURFL data?


Who is online

Users browsing this forum: No registered users and 4 guests