sdjnzsg 发表于 2010-10-7 11:58:45

[已解决]着急数据库出问题，请管理员帮忙看一下怎么回事。

MySQL Query:CREATE TABLE `destoon_ad` ( `aid` int(10) unsigned NOT NULL auto_increment, `title` varchar(100) NOT NULL default '', `pid` int(10) unsigned NOT NULL default '0', `typeid` tinyint(1) unsigned NOT NULL default '0', `amount` float NOT NULL, `currency` varchar(20) NOT NULL, `url` varchar(255) NOT NULL default '', `introduce` varchar(255) NOT NULL default '', `hits` int(10) unsigned NOT NULL default '0', `username` varchar(30) NOT NULL default '', `addtime` int(10) unsigned NOT NULL default '0', `editor` varchar(30) NOT NULL default '', `edittime` int(10) unsigned NOT NULL default '0', `fromtime` int(10) unsigned NOT NULL default '0', `totime` int(10) unsigned NOT NULL default '0', `stat` tinyint(1) unsigned NOT NULL default '0', `note` text NOT NULL, `code` text NOT NULL, `text_name` varchar(100) NOT NULL default '', `text_url` varchar(255) NOT NULL default '', `text_title` varchar(100) NOT NULL default '', `image_src` varchar(255) NOT NULL default '', `image_url` varchar(255) NOT NULL default '', `image_alt` varchar(100) NOT NULL default '', `flash_src` varchar(255) NOT NULL default '', `flash_url` varchar(255) NOT NULL default '', `key_moduleid` smallint(6) unsigned NOT NULL default '0', `key_catid` smallint(6) unsigned NOT NULL default '0', `key_word` varchar(100) NOT NULL default '', `key_id` bigint(20) unsigned NOT NULL, `listorder` smallint(4) unsigned NOT NULL, `status` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`aid`), KEY `pid` (`pid`)) ENGINE=MyISAM AUTO_INCREMENT=66 DEFAULT CHARSET=gbk COMMENT='???
MySQL 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 ''???' at line 1 MySQL Errno:1064
Message:MySQL Query Error

sdjnzsg 发表于 2010-10-7 12:41:42


广告管理也出现问题
http://bbs.destoon.com/static/image/smiley/default/mad.gif

MySQL Query:SELECT min(aid) AS fid FROM destoon_ad LIMIT 0,1
MySQL Error:Table 'sq_sdjnly1.destoon_ad' doesn't exist MySQL Errno:1146
Message:MySQL Query Error

sdjnzsg 发表于 2010-10-7 13:54:56


广告数据库出错了destoon_ad

先备份下这个表 然后删除掉


用官方默认的广告管理替换 再恢复试试

sdjnzsg 发表于 2010-10-7 23:32:52


已经解决，感谢版主。
页: [1]
查看完整版本: [已解决]着急数据库出问题，请管理员帮忙看一下怎么回事。