mysql error

Tablespace for table xxx exists

[mysqld] innodb_data_file_path=ibdata1:10M:autoextend be sure to add within mysqld A little late here but generally I’ve seen this problem occur when you get a ‘tablespace full’ error when running in a ‘innodb_file_per_table’ mode. Without going into too much detail (more here), the database server’s tablespace is defined by the innodb_data_file_path setting and by default is rather small. …

Tablespace for table xxx exists Read More »

Field ‘po_qnty’ doesn’t have a default value

As others said, this is caused by the STRICT_TRANS_TABLES SQL mode. To check whether STRICT_TRANS_TABLES mode is enabled: SHOW VARIABLES LIKE ‘sql_mode’; To disable strict mode: SET GLOBAL sql_mode=”; But the next time MySQL restarts, these settings are lost. It should be:[mysqld]sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES instead of [mysqld]sql_mode=”NO_ENGINE_SUBSTITUTION” then restart mysqld service.

Open chat