原帖由 119977 于 2006-1-19 13:18 发表
SQL: SELECT * FROM cdb_images_album WHERE userid = '1' AND havewith = '0' ORDER BY havetime DESC
Error: 抛捞喉 'wccccc.cdb_images_album' 绰 粮犁窍瘤 臼嚼聪促.
数据表缺失,请恢复备份数据 ... 原帖由 acer_peri 于 2006-1-19 20:26 发表
点照相馆时,有这个错误: 请高手帮忙解决:
Discuz! info: MySQL Query Error
User: ryland
Time: 2006-1-19 8:23pm
Script: /bbs/plugin.php
SQL: SELECT * FROM cdb_images_album WHERE userid = '1' ...
请作下数据库升级
- DROP TABLE IF EXISTS {$tablepre}images_album;
- CREATE TABLE {$tablepre}images_album (
- id int(10) unsigned NOT NULL auto_increment,
- userid mediumint(8) unsigned NOT NULL default '0',
- photoadd varchar(200) NOT NULL default '',
- photoname varchar(50) NOT NULL default '',
- photojianjie text NOT NULL,
- havetime int(10) unsigned NOT NULL default '0',
- havewith mediumint(8) unsigned NOT NULL default '0',
- status varchar(25) NOT NULL default '',
- PRIMARY KEY (id)
- ) TYPE=MyISAM;
复制代码
- DROP TABLE IF EXISTS {$tablepre}images_order;
- CREATE TABLE {$tablepre}images_order (
- id int(10) unsigned NOT NULL auto_increment,
- orderfrom mediumint(8) unsigned NOT NULL default '0',
- orderto mediumint(8) unsigned NOT NULL default '0',
- photoname varchar(50) NOT NULL default '',
- photojianjie text NOT NULL,
- type char(3) NOT NULL default '',
- front char(2) NOT NULL default '',
- back char(2) NOT NULL default '',
- ordertime int(10) unsigned NOT NULL default '0',
- answertime int(10) unsigned NOT NULL default '0',
- status varchar(4) NOT NULL default '',
- delstat varchar(7) NOT NULL default '',
- PRIMARY KEY (id)
- ) TYPE=MyISAM;
复制代码 |