Mobile Joomla Error Log Messages

folmag
14 years, 6 months ago
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
miohtama
14 years, 6 months ago
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.
dryabov
14 years, 6 months ago
folmag wrote:
User folmag_main360 already has more than 'max_user_connections' active connections


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
folmag
14 years, 5 months ago
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
dryabov
14 years, 5 months ago
folmag, this issue should be fixed in TeraWURFL2.1.3, and we will update MJ as soon as possible.
folmag
14 years, 4 months ago
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
alra
14 years, 4 months ago
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.
dryabov
14 years, 4 months ago
folmag wrote:
[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


It seems that there is problem with jos_TeraWurflMerge table (absenсe of 'generic' record), but I don't know the reason of it.
dryabov
14 years, 4 months ago
alra wrote:
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


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

By continuing to use this site you consent to the use of cookies on your device as described in our cookie policy unless you have disabled them. This site will not function correctly without cookies.

I accept cookies from this site.