Page 1 of 1

Error in TeraWurflDatabase_MySQL5.php:120

PostPosted: Thu Jul 28, 2011 1:35 pm
by 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!

Re: Error in TeraWurflDatabase_MySQL5.php:120

PostPosted: Thu Jul 28, 2011 1:49 pm
by 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.

Re: Error in TeraWurflDatabase_MySQL5.php:120

PostPosted: Fri Jul 29, 2011 12:17 am
by anv2011
Steve,
reloading the WURFL data
did fix the problem.

Thank you!

Re: Error in TeraWurflDatabase_MySQL5.php:120

PostPosted: Fri Jul 29, 2011 12:47 am
by kamermans
You're welcome :)