[Freddy已测试][完全可用][插件]版主申请(加强版) For D25 SP1

很多人升级数据库时,都会出现以下状况！
Discuz! info: MySQL Query Error

User: 烂苹果
Time: 2005-12-18 11:43am
Script: /admincp.php

SQL: CREATE TABLE modapp ( appid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment, userid smallint(4) NOT NULL, theone varchar(100) NOT NULL, wichforum varchar(100) NOT NULL, connection varchar(100) NOT NULL, internet varchar(100) NOT NULL, other varchar(100) NOT NULL, other_forum_names varchar(100) NOT NULL, english varchar(100) NOT NULL, other_m varchar(100) NOT NULL, name varchar(100) NOT NULL, email varchar(100) NOT NULL, username varchar(100) NOT NULL, websites varchar(100) NOT NULL, about varchar(200) NOT NULL, ratetotal varchar(100) NOT NULL, PRIMARY KEY (appid));
Error: Invalid default value for 'appid'
Errno.: 1067

Similar error report has beed dispatched to administrator before.

你们就试试升级这个...

1. CREATE TABLE modapp (
   
2.   appid smallint(5) unsigned NOT NULL auto_increment,   
   
3.   userid smallint(4) NOT NULL,
   
4.   theone varchar(100) NOT NULL,
   
5.   wichforum varchar(100) NOT NULL,
   
6.   connection varchar(100) NOT NULL,
   
7.   internet varchar(100) NOT NULL,
   
8.   other varchar(100) NOT NULL,
   
9.   other_forum_names varchar(100) NOT NULL,
   
10.   english varchar(100) NOT NULL,
    
11.   other_m varchar(100) NOT NULL,
    
12.   name varchar(100) NOT NULL,
    
13.   email varchar(100) NOT NULL,
    
14.   username varchar(100) NOT NULL,
    
15.   websites varchar(100) NOT NULL,
    
16.   about varchar(200) NOT NULL,
    
17.   ratetotal varchar(100) NOT NULL,
    
18.   PRIMARY KEY (appid)
    
19. );

复制代码

[ 本帖最后由 谈天说地-烂苹果 于 2005-12-18 14:55 编辑 ]

谢谢楼上的，我升级你的数据库可以用了，但是我想删除一个会员的申请，确出现空白页面，为什么那？。。。