Difference between revisions of "X-Cart:SQL errors"
m (moved X-Cart:Troubleshooting to X-Cart:SQL errors) |
(→User 'mysqluser' has exceeded the 'max questions' resource (current value: 50000)) |
||
| Line 24: | Line 24: | ||
===User 'mysqluser' has exceeded the 'max questions' resource (current value: 50000)=== | ===User 'mysqluser' has exceeded the 'max questions' resource (current value: 50000)=== | ||
| + | |||
| + | ===User [name] has already more than 'max_user_connections' active connections=== | ||
| + | |||
| + | <pre> | ||
| + | Warning: mysql_connect(): User [name] has already more than 'max_user_connections' active connections | ||
| + | in /home/[path_to_xcart_dir]/include/func.php on line 43 | ||
| + | |||
| + | Could not connect to SQL db | ||
| + | </pre> | ||
| + | |||
| + | This means that your mysql user has exceeded the max_user_connections limit (mysql configurable parameter). For example, when several users browse your site, several instances of x-cart scripts are called and the scripts try to connect to the mysql database. If the number of those scripts instances is higher than the max_user_connections limit defined on your server, user will see such error message. | ||
| + | |||
| + | You should contact your hosting administrators and ask them to increase the limit number of mysql connections per mysql user, i.e. 'max_user_connections' limit. | ||
[[Category:X-Cart user manual]] | [[Category:X-Cart user manual]] | ||
Revision as of 15:29, 3 February 2010
Contents
- 1 SQL errors
- 1.1 Got error 28 from storage engine
- 1.2 Lost connection to MySQL server during query
- 1.3 Mysql connect(): Too many connections
- 1.4 MySQL server has gone away
- 1.5 SQL error when deleting products
- 1.6 The size of the data package being transmitted is greater than maximum allowed by the server
- 1.7 Unknown column 'xcart products.productid' in 'on clause'
- 1.8 User 'mysqluser' has exceeded the 'max questions' resource (current value: 50000)
- 1.9 User [name] has already more than 'max_user_connections' active connections
SQL errors
Got error 28 from storage engine
This error appeared due to the lack of free space in the file system on the hard disc drive where MySQL is installed. The solution is rather simple - to clean up some disc space.
Lost connection to MySQL server during query
This error message means that when executing the query the conenction with MySQL server was lost
- if such errors are numerous , most likely the reason is the same as described here: http://kb.x-cart.com/article/mysql-server-has-gone-away
- if it is a one time error, then most likely it was caused by the MySQL srever restart
- also the problem may be caused by the low value of the max_allowed_packet option: http://kb.x-cart.com/article/the-size-of-the-data-package-being-transmitted-is-greater-than-maximum-allowed-by-the-server
Mysql connect(): Too many connections
MySQL server has gone away
SQL error when deleting products
The size of the data package being transmitted is greater than maximum allowed by the server
Unknown column 'xcart products.productid' in 'on clause'
User 'mysqluser' has exceeded the 'max questions' resource (current value: 50000)
User [name] has already more than 'max_user_connections' active connections
Warning: mysql_connect(): User [name] has already more than 'max_user_connections' active connections in /home/[path_to_xcart_dir]/include/func.php on line 43 Could not connect to SQL db
This means that your mysql user has exceeded the max_user_connections limit (mysql configurable parameter). For example, when several users browse your site, several instances of x-cart scripts are called and the scripts try to connect to the mysql database. If the number of those scripts instances is higher than the max_user_connections limit defined on your server, user will see such error message.
You should contact your hosting administrators and ask them to increase the limit number of mysql connections per mysql user, i.e. 'max_user_connections' limit.
