MySQL FAQ log

The following are the database error message prompts that appear for common installation plugins:

Code:duplicate column name ' Allowrank '

Upgrade data Occasionally, it means that the table already exists. However, if it is installed, the following steps are not affected. Plugin writing process This problem occurs, just change the name of the table.

CODE:Error:Duplicate entry ' aa2hv2 ' for key 1

Errno.: 1062

Usually the key value is repeated input, resulting in repeated errors, you can re-build the table to solve the problem.

CODE:Error:Unknown system variable ' NAMES '

Errno.: 1193

Easily appear when importing data. Open the SQL file

1. Delete Set NAMES ' GBK '

2, find Engine=myisam DEFAULT CHARSET=GBK, replaced by: Type=myisam

3, find Engine=heap DEFAULT CHARSET=GBK, replaced by: Type=heap

4, Character set GBK collate Gbk_bin, delete.

5, re-restore can be.

CODE:Error:You has an Error in your SQL syntax. Check the manual-corresponds to your MySQL server version for the right syntax-use near ' DEFAULT CHARSET=GBK ' at l INE 1

Errno.: 1064

Generally, the encoding does not match, open the installation file, see the Database Upgrade code, there is ' DEFAULT charset=gbk ' can be deleted.

CODE:Error:You has an Error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' s XXXXX

Errno.: 1064

More difficult problem, is generally the database code write type conflict, such as floating point write the Chinese character will be like this, check their own settings, whether to write the number of written English or Chinese characters. Check the correctness of the database syntax if you encounter it during the plugin authoring process.

If it is data import, it can be avoided with restore.php import.

CODE:Error:Unknown column ' ff.threadperms ' in ' Field list '

This best solution, generally see unknown column hint, indicating that your data table is missing this table, manually created can be resolved.

CODE:Error:Access denied for user: ' [email protected] ' (Using password:yes)

This kind of question does not know what to say good ~ Database password user is not clear, consult space quotient.

Code:can ' t DROP ' Aaaallowrank '; Check that Column/key exists

Typically, an anti-installation is easy to appear, indicating that the table does not exist. In fact, there is no problem, there is no need to reverse the installation.

CODE:Error:Illegal mix of collations (latin1_swedish_ci,implicit) and (gbk_chinese_ci,coercible) for operation ' = '

Errno.: 1267

The database character set does not match the result, please go to phpmyadmin the character set of the data table to modify it.

code:discuz! Info:mysql Query Error

User:admin

Time:2006-4-19 12:32pm

Script:/bbs2/index.php

Sql:delete from cdb_subscriptions WHERE lastpost< ' 1145421168 '-7776000

Error:unknown column ' Lastpost ' in ' WHERE clause '

errno:1054

An error report has a been dispatched to our administrator.

Cause: Subscriptions table missing Lastpos

t Field

Workaround: In phpMyAdmin or DZ forum background "Upgrade database" Enter the following statement

ALTER TABLE cdb_subscriptions ADD lastpost Int (ten) UNSIGNED not NULL DEFAULT ' 0 ' after Tid;

CODE: Connection error message 1251:

#1251-client does not the support authentication protocol requested by server; Consider upgrading MySQL client

Workaround:

mysql> UPDATE mysql.user SET Password = old_password (' password ') WHERE host = ' localhost ' or IP ' and user = ' database user name ';

mysql> FLUSH privileges;

mysql> use MySQL

mysql> Update user Set Password=old_password (' Cnscn ');

ERROR 2006 (HY000): MySQL server has gone away

No connection. Trying to reconnect ...

Connection id:1

Current Database:mysql

Query OK, 5 rows affected (0.01 sec)

Rows Matched:5 Changed:5 warnings:0

mysql> flush Privileges;

Query OK, 0 rows Affected (0.00 sec)

code:discuz! Info:mysql Query Error

User:imoker

TIME:2006-10-17 12:45pm

Script:/bbs/viewthread.php

Sql:select expiration, keywords, relatedthreads from cdb_relatedthreads WHERE tid= ' 3613 '

Error:can ' t find file: ' Cdb_relatedthreads. MYI ' (errno:2)

Errno.: 1017

Similar Error Report have beed dispatched to administrator before.

Error Analysis: The server illegal shutdown, there may be some of the database will have some impact.

General operation will be error

**. MyD cannot be opened.

Can ' t find file: ' * * *. MYI '

Workaround: Use your download forum compression package inside the Utilities directory repair.php repair

How to: Upload repair.php to the forum root directory and run it in the browser

HTTP//Your forum address/repair.php

General Click on the first link "repair.php?html=1&check=1" can be repaired,

If unable to repair can try clicking on the second connection "Repair.php?check=1&iterations=5"

You can do it.

Warm tip: Repair the table after the operation must remember to delete this file from the server repair.php

Their own finishing, October 17 Update, there is a supplement to explain it. 1005: Failed to create table

1006: Failed to create database

1007: Database already exists, database creation failed

1008: Database does not exist, delete database failed

1009: Unable to delete database file causes database failure to be deleted

1010: Unable to delete data directory causes database failure to be deleted

1011: Failed to delete database file

1012: Cannot read records in system tables

1020: Record has been modified by another user

1021: Insufficient space on the hard drive, please increase the hard disk free space

1022: keyword Repeat, change record failed

1023: An error occurred while shutting down

1024: Read File error

1025: An error occurred while changing the name

1026: Write File Error

1032: Record does not exist

1036: The data table is read-only and cannot be modified

1037: Insufficient system memory, please restart the database or restart the server

1038: Insufficient memory for sorting, increase the sort buffer

1040: The maximum number of connections to the database has been reached, please increase the number of available connections to the database

1041: Insufficient system memory

1042: Invalid host name

1043: Invalid connection

1044: Current user does not have access to data
1044 (42000) Error: Attempting to create database when user ' Micah ' @ ' localhost ' accesses database ' menagerie ', which means that your user account does not have the permissions of the necessary permissions library

1045: Unable to connect to database, user name or password error

1046:no Database selected

1048: field cannot be empty

1049: Database does not exist

1050: Data table already exists

1051: Data table does not exist

1054: field does not exist

SET sql_mode= (select admin (@ @sql_mode, ' only_full_group_by ', '));
1305:function Admin.reqlace does not exist


[ERR] 1055-expression #1 of ORDER by clause are not in GROUP by clause and contains nonaggregated column ' Information_sch Ema. PROFILING. SEQ ' which is not functionally dependent on columns in GROUP by clause; This was incompatible with sql_mode=only_full_group_by



[ERR] 1064-you has an error in your SQL syntax; Check the manual-corresponds to your MySQL server version for the right syntax-use near ' name ' varchar defaul T NULL,
Age Int (Ten) is DEFAULT NULL,
PRIMARY Key (ID)
' at line 3

1065: Invalid SQL statement, SQL statement is empty

1081: Unable to establish socket connection

1114: The data sheet is full and cannot hold any records

1116: Too many Open data tables

1129: Database is abnormal, please restart database

1130: Connection to database failed with no permissions to connect to database

1133: Database user does not exist

1141: The current user is not authorized to access the database

1142: The current user does not have permission to access the data table

1143: The current user does not have permission to access fields in the datasheet

1146: Data table does not exist

1147: User access to the data table is undefined

1149:sql statement Syntax error

1158: Network error, read error, please check network connection status

1159: Network error, read timeout, check network connection status

1160: Network error, write error, please check network connection status

1161: Network error, write timeout, please check network connectivity status

1062: Duplicate field value, inbound failed

1169: Duplicate field value, update record failed

1177: Open Data table failed

1180: Commit TRANSACTION failed

1181: ROLLBACK TRANSACTION failure

1203: The current user and database establish a connection that has reached the maximum number of connections to the database, increase the number of available database connections or restart the database

1205: Lock timeout

1211: The current user does not have permission to create a user

1216: FOREIGN KEY constraint check failed, update child table record failed

1217: FOREIGN KEY constraint check failed, delete or modify master table record failed

1226: The current user is using more resources than allowed, please restart the database or restart the server

1227: Insufficient permissions, you do not have permission to do this

1235:mysql version is too low to have this feature

MySQL FAQ log