Error in TeraWurflDatabase_MySQL5.php:120

[anv2011]

Hello,

I've integrated Tera_WURFL into my web-site.

Everything seems fine (under Firefox, Chrome, IE), till I had ran the web site under this User-Agent:

Code: Select all

CSE HTML Validator Professional (http://www.htmlvalidator.com/)

I'm getting the following errors:

Code: Select all

PHP Fatal error:  Uncaught exception 'Exception' with message 'Error in DB RIS Query: The user specified as a definer ('terawurfl'@'localhost') does not exist..../tera-wurfl/DatabaseConnectors/TeraWurflDatabase_MySQL5.php:120

Did anyone run into this problem?

Thank you!

[kamermans]

The error "The user specified as a definer ('terawurfl'@'localhost') does not exist" indicates that the user that created this stored procedure in MySQL is not the user that is trying to access it now. It sounds like you installed it initially with the user "terawurfl" and than changed the database username to something else. If this is the case, reloading the WURFL data should fix the problem since it drops the stored procedures and recreates them.

[anv2011]

Steve,

reloading the WURFL data

did fix the problem.

Thank you!

[kamermans]

You're welcome