Hi,
I just updated to your new version of mobile joomla, and now I have even more errors in my error log that is coming from the component. In the previous version I had some, but now I have a lot more. These errors take up a lot of storage space. Here is a sample and please fix this or let me know if it is serious and will slow down my server. Will this cause a slow down of my server and other problems? Do other users have the same errors?
Robin

[01-Sep-2010 01:48:06] Caught exception 'Exception' with message 'Cannot connect to database: User folmag_main360 already has more than 'max_user_connections' active connections' in /home/folmag/public_html/plugins/mobile/terawurfl/TeraWurfl.php:137
[01-Sep-2010 01:48:06] PHP Warning: mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: (42000/1203): User folmag_main360 already has more than 'max_user_connections' active connections in /home/folmag/public_html/plugins/mobile/terawurfl/DatabaseConnectors/TeraWurflDatabase_MySQL5.php on line 491
[01-Sep-2010 01:48:06] Caught exception 'Exception' with message 'Cannot connect to database: User folmag_main360 already has more than 'max_user_connections' active connections' in /home/folmag/public_html/plugins/mobile/terawurfl/TeraWurfl.php:137
[01-Sep-2010 01:48:06] Caught exception 'Exception' with message 'Cannot connect to database: User folmag_main360 already has more than 'max_user_connections' active connections' in /home/folmag/public_html/plugins/mobile/terawurfl/TeraWurfl.php:137
[01-Sep-2010 01:48:06] Caught exception 'Exception' with message 'Cannot connect to database: User folmag_main360 already has more than 'max_user_connections' active connections' in /home/folmag/public_html/plugins/mobile/terawurfl/TeraWurfl.php:137
[01-Sep-2010 01:48:06] Caught exception 'Exception' with message 'Cannot connect to database: User folmag_main360 already has more than 'max_user_connections' active connections' in /home/folmag/public_html/plugins/mobile/terawurfl/TeraWurfl.php:137
[01-Sep-2010 01:48:07] PHP Warning: mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: (42000/1203): User folmag_main360 already has more than 'max_user_connections' active connections in /home/folmag/public_html/plugins/mobile/terawurfl/DatabaseConnectors/TeraWurflDatabase_MySQL5.php on line 491
[01-Sep-2010 01:48:07] Caught exception 'Exception' with message 'Cannot connect to database: User folmag_main360 already has more than 'max_user_connections' active connections' in /home/folmag/public_html/plugins/mobile/terawurfl/TeraWurfl.php:137
[01-Sep-2010 01:48:07] PHP Warning: mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: (42000/1203): User folmag_main360 already has more than 'max_user_connections' active connections in /home/folmag/public_html/plugins/mobile/terawurfl/DatabaseConnectors/TeraWurflDatabase_MySQL5.php on line 491
[01-Sep-2010 01:48:07] Caught exception 'Exception' with message 'Cannot connect to database: User folmag_main360 already has more than 'max_user_connections' active connections' in /home/folmag/public_html/plugins/mobile/terawurfl/TeraWurfl.php:137
[01-Sep-2010 01:48:07] PHP Warning: mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: (42000/1203): User folmag_main360 already has more than 'max_user_connections' active connections in /home/folmag/public_html/plugins/mobile/terawurfl/DatabaseConnectors/TeraWurflDatabase_MySQL5.php on line 491
[01-Sep-2010 01:48:07] Caught exception 'Exception' with message 'Cannot connect to database: User folmag_main360 already has more than 'max_user_connections' active connections' in /home/folmag/public_html/plugins/mobile/terawurfl/TeraWurfl.php:137
[01-Sep-2010 01:48:08] PHP Warning: mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: (42000/1203): User folmag_main360 already has more than 'max_user_connections' active connections in /home/folmag/public_html/plugins/mobile/terawurfl/DatabaseConnectors/TeraWurflDatabase_MySQL5.php on line 491
[01-Sep-2010 01:48:08] Caught exception 'Exception' with message 'Cannot connect to database: User folmag_main360 already has more than 'max_user_connections' active connections' in /home/folmag/public_html/plugins/mobile/terawurfl/TeraWurfl.php:137
[01-Sep-2010 01:48:08] PHP Warning: mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: (42000/1203): User folmag_main360 already has more than 'max_user_connections' active connections in /home/folmag/public_html/plugins/mobile/terawurfl/DatabaseConnectors/TeraWurflDatabase_MySQL5.php on line 491
[01-Sep-2010 01:48:08] Caught exception 'Exception' with message 'Cannot connect to database: User folmag_main360 already has more than 'max_user_connections' active connections' in /home/folmag/public_html/plugins/mobile/terawurfl/TeraWurfl.php:137

Terawurlf handset database may be too heavy for your database hosting. I suggest you ask your hosting provider how database set-up is arranged and see if they can give you more max_users_connections.

folmag wrote:


It means that you have many simultenious connections to database server. Note, that for each request one connection is reserved by Joomla, and one by TeraWURFL. That is total number of connections is 2 x (number of simultaneous requests to the site).

More on MySQL limits: dev.mysql.com/doc/refman/5.0/en/user-resources.html

Hi Folks,
Thanks for getting back to me. I emailed my host and they gave me more max connections but I am still having the same errors in my error log. Here is what the host said. "The server should be able to handle this connections.
max_connections = 250 max_user_connections = 100. I see normal activity, every process counts as one. Those sleep processes are connections open but not doing anything as the coding is not properly closing them and the sum up one connection. You should ask your developer about this."
Is the code closing the connections? Any suggestions? Are you or other sites having this problem? Is there more I should be doing?

Sorry about my long sample in my first post.

Sincerely,
Robin

folmag, this issue should be fixed in TeraWURFL2.1.3, and we will update MJ as soon as possible.

Hi Mobile Joomla,
This is an update to let you know that with the new version I am no longer getting max connection errors. But now I am getting these error messages. What does this mean? Sometimes the messages say run a repair. I do and still get these messages. Please let me know what to do. Is there a simple fix?
Thanks.
Robin
[14-Oct-2010 19:42:51] Caught exception 'Exception' with message 'Tried to lookup an invalid WURFL Device ID: generic' in /home/folmag/public_html/plugins/mobile/terawurfl/DatabaseConnectors/TeraWurflDatabase_MySQL5.php:69
[14-Oct-2010 19:57:41] Caught exception 'Exception' with message 'Tried to lookup an invalid WURFL Device ID: generic' in /home/folmag/public_html/plugins/mobile/terawurfl/DatabaseConnectors/TeraWurflDatabase_MySQL5.php:69

I have a couple of hundreds of these:

PHP Fatal error: Call to a member function templateurl() on a non-object in /home/xxxxxx/public_html/templates/mobile_imode/index.php on line 23

and even if I set the user agent to anything other than Wurlf is still quires the whole tera wurlf db.

folmag wrote:


It seems that there is problem with jos_TeraWurflMerge table (absenсe of 'generic' record), but I don't know the reason of it.

alra wrote:


There is no call to templateurl() in this file. What version of MJ do you use? Did you change this file?