Difference between revisions of "X-Cart:SQL errors"

From X-Cart 4 Classic
Jump to: navigation, search
(Mysql connect(): Too many connections)
(Mysql connect(): Too many connections)
Line 13: Line 13:
 
===Mysql connect(): Too many connections===
 
===Mysql connect(): Too many connections===
  
The limit of simultaneous connections to MySQL server is exceeded. This limit is set by the max_connections MySQL option - see http://dev.mysql.com/doc/refman/5.0/en/too-many-connections.html
+
The limit of simultaneous connections to MySQL server is exceeded. This limit is set by the max_connections MySQL option - see http://dev.mysql.com/doc/refman/5.0/en/too-many-connections.html. The problem can be resolved in the following ways:
  
The problem can be resolved in the following ways:
 
 
* Increase the <u>max_connections</u> option value
 
* Increase the <u>max_connections</u> option value
 
* if the images are stored in the database(are called via image.php), [[X-Cart:Images Location Management|move them to the file system]]
 
* if the images are stored in the database(are called via image.php), [[X-Cart:Images Location Management|move them to the file system]]

Revision as of 16:02, 3 February 2010

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

Mysql connect(): Too many connections

The limit of simultaneous connections to MySQL server is exceeded. This limit is set by the max_connections MySQL option - see http://dev.mysql.com/doc/refman/5.0/en/too-many-connections.html. The problem can be resolved in the following ways:

  • Increase the max_connections option value
  • if the images are stored in the database(are called via image.php), move them to the file system
  • change the hosting company

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.