Page 1 of 1

Script error on new server

Posted: Thu Jun 28, 2012 1:16 am
by BMCadvertising
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

Re: Script error on new server

Posted: Thu Jun 28, 2012 9:30 am
by kamermans
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.

Re: Script error on new server

Posted: Thu Jun 28, 2012 10:57 am
by BMCadvertising
That did it! Thanks so much...BTW, any idea when a new version will be released?

Re: Script error on new server

Posted: Thu Jun 28, 2012 11:31 am
by sm_support2
end of summer. But there are quite a few things we want to get right, so there may be delays

Re: Script error on new server

Posted: Fri Jun 29, 2012 1:03 pm
by BMCadvertising
Sounds great...thanks again for the help!

Re: Script error on new server

Posted: Tue Jun 21, 2016 8:46 am
by Kemystery
I'm having a similar issue. Opened a new thread but no one has replied.
How do I reload the WURFL data?