I moved my hosting from one to another. Now I get the following warning.
Warning: mysqli::real_escape_string() [mysqli.real-escape-string]: Couldn't fetch mysqli in /var/www/library/Tera-WURFL/DatabaseConnectors/TeraWurflDatabase_MySQL5.php on line 541
I have mysqli installed and enabled in my application
My WURFL Version: http://www.scientiamobile.com - 2011-06-06
My PHP Version - 5.3.5
Couldnt fetch mysqli
Re: Couldnt fetch mysqli
Can you go to the admin/install.php page in your browser and see if there are any errors? Also, what do you see when you try to updated the database?
Thanks,
Steve Kamerman
ScientiaMobile
Make sure you check out our WURFL Cloud, WURFL InSight and WURFL InFuze products!
Steve Kamerman
ScientiaMobile
Make sure you check out our WURFL Cloud, WURFL InSight and WURFL InFuze products!
-
- Posts: 10
- Joined: Sat Aug 20, 2011 3:37 pm
Re: Couldnt fetch mysqli
Actually I forgot to create the mysql user, which I identified from the error in the admin page. Now, I have fixed it by creating a mysql user and giving access to the terawurfl database.
Now my web application is showing a blank page, will see what this problem is.
Now my web application is showing a blank page, will see what this problem is.
Re: Couldnt fetch mysqli
Usually, when moving the DB API (Tera-WURFL) from one host to another, it is best to completely delete the database tables, this causes the API to recreated them and the stored procedures using new MySQL user's credentials. This is important because only the user that defined the procedures can modify them, or even call them in some cases. This is likely to be the problem, so I would just delete everything including the procedures and go to the admin page, then update the database. Let me know if this resolves the problem.
Thanks,
Steve Kamerman
ScientiaMobile
Make sure you check out our WURFL Cloud, WURFL InSight and WURFL InFuze products!
Steve Kamerman
ScientiaMobile
Make sure you check out our WURFL Cloud, WURFL InSight and WURFL InFuze products!
-
- Posts: 10
- Joined: Sat Aug 20, 2011 3:37 pm
Re: Couldnt fetch mysqli
Yes. The problem is resolved by installing Tera-WURFL from the admin page. Thanks.
I have asked for the sample code to the Cloud Beta service here - http://www.scientiamobile.com/forum/vie ... ?f=12&t=40
Yet to get a reply over there.
I have asked for the sample code to the Cloud Beta service here - http://www.scientiamobile.com/forum/vie ... ?f=12&t=40
Yet to get a reply over there.
Re: Couldnt fetch mysqli
Thank you very much for this information! I changed servers also and had a similar error message. I tried the re-installation as you suggested, and it worked out great! This is a huge relief to me, because I have been wresting with this issue for days now. I was wondering, does anyone here know anything about cloud computing strategy? What is it, and what can you tell me about it? I appreciate your input here!
Who is online
Users browsing this forum: No registered users and 55 guests