[柒瑞]小财主[7.1/7.2][update2010.02.13]

SQL: SELECT SUM(sum_7ree) FROM [Table]caizhu_log_7ree WHERE inout_7ree = '0' AND uid_7ree='1'
Error: Table 'sqlkinji.[Table]caizhu_log_7ree' doesn't exist
Errno.: 1146

出现数据库错误的都是更改过DZ数据表前缀的！

大家去后台自己升级：

CREATE TABLE IF NOT EXISTS 【你的表名 如：cdb_】caizhu_class_7ree(
`id_7ree` MEDIUMINT( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`class_7ree` VARCHAR( 100 ) NOT NULL ,
`uid_7ree` MEDIUMINT( 8 ) UNSIGNED NOT NULL ,
`time_7ree` INT( 10 ) UNSIGNED NOT NULL
) ENGINE = MYISAM  DEFAULT CHARSET=gbk;


CREATE TABLE IF NOT EXISTS 【你的表名 如：cdb_】caizhu_log_7ree(
`id_7ree` MEDIUMINT( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`uid_7ree` MEDIUMINT( 8 ) UNSIGNED NOT NULL ,
`inout_7ree` TINYINT( 1 ) UNSIGNED NOT NULL ,
`sum_7ree` decimal(10,2) UNSIGNED NOT NULL ,
`class_7ree` VARCHAR( 100 ) NOT NULL ,
`hidden_7ree` TINYINT( 1 ) UNSIGNED NOT NULL ,
`digest_7ree` TEXT NOT NULL ,
`time_7ree` INT( 10 ) NOT NULL
) ENGINE = MYISAM DEFAULT CHARSET=gbk;

这个要顶一下的

phpMyAdmin直接导入成功:

CREATE TABLE IF NOT EXISTS cdb_caizhu_class_7ree(
`id_7ree` MEDIUMINT( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`class_7ree` VARCHAR( 100 ) NOT NULL ,
`uid_7ree` MEDIUMINT( 8 ) UNSIGNED NOT NULL ,
`time_7ree` INT( 10 ) UNSIGNED NOT NULL
) ENGINE = MYISAM  DEFAULT CHARSET=gbk;


CREATE TABLE IF NOT EXISTS cdb_caizhu_log_7ree(
`id_7ree` MEDIUMINT( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`uid_7ree` MEDIUMINT( 8 ) UNSIGNED NOT NULL ,
`inout_7ree` TINYINT( 1 ) UNSIGNED NOT NULL ,
`sum_7ree` decimal(10,2) UNSIGNED NOT NULL ,
`class_7ree` VARCHAR( 100 ) NOT NULL ,
`hidden_7ree` TINYINT( 1 ) UNSIGNED NOT NULL ,
`digest_7ree` TEXT NOT NULL ,
`time_7ree` INT( 10 ) NOT NULL
) ENGINE = MYISAM DEFAULT CHARSET=gbk;

出现数据库错误的都是更改过DZ数据表前缀的！

大家去后台自己升级：

CREATE TABLE IF NOT  ...
a327173196 发表于 2009-11-4 21:59

    我没改过前缀 也是有错误   有一个表导不进去 好像

36# hongjun521


    那自己去后台升级数据库试试~装好了看看你添加分类的时候会不会出错。。。实在没办法，我添加好把那个添加分类的按钮去掉了~

   我的站go.goyidu.cn  可以去看看

小财主sql升级的问题再次修复完成，请重新下载安装即可。
https://discuz.dismall.com/viewthread.php?tid=1469191