数据库常见错误信息和解决方法集中讨论贴

谢啊　．．．．．支持

Discuz! info: MySQL Query Error

User: admin
Time: 2007-8-5 2:19pm
Script: /post.php

SQL: select count(*) FROM [Table]postban where (fid='36' or fid='65535') AND username='admin' AND timelimit > 1186294769
Error: Can't open file: '[Table]postban.ibd' (errno: 1)
文件无法打开，请修复数据表

Similar error report has beed dispatched to administrator before.

导致论坛无法发帖，请求帮助

路过支持下......支持dz......

Discuz! info: MySQL Query Error

User: admin
Time: 2007-8-6 10:05am
Script: /bbs/admincp.php

SQL: SELECT COUNT(*) FROM [Table]styles WHERE name='?󉽧
Error: Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
Errno.: 1267

Similar error report has beed dispatched to administrator before.

Discuz! info: MySQL Query Error

User: admin
Time: 2007-8-5 2:19pm
Script: /post.php

SQL: select count(*) FROM [Table]postban where (fid='36' or fid='65535') AND username='admin' AND timelimit > 1186294769
Error: Can't open file: '[Table]postban.ibd' (errno: 1)
文件无法打开，请修复数据表

Similar error report has beed dispatched to administrator before.

导致论坛无法发帖，请求帮助

难道真的没有人肯伸出援手阿？

原帖由 李文韬 于 2007-8-6 12:46 发表
难道真的没有人肯伸出援手阿？

你牛逼， 这么老的， 都被你顶出来了

没有爱心~~~

Discuz! info: MySQL Query Error

Time: 2007-8-10 1:39am
Script: /index.php

SQL: DELETE FROM [Table]sessions WHERE sid='34NCzH' OR lastactivity<(1186681194-) OR ('0'<>'0' AND uid='0') OR (uid='0' AND ip1='218' AND ip2='19' AND ip3='19' AND ip4='205' AND lastactivity>1186681194-60)
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') OR ('0'<>'0' AND uid='0') OR (uid='0' AND ip1='218' AND ip2='19' AND ip3='19' ' at line 1
Errno.: 1064

Similar error report has beed dispatched to administrator before.