安装好uchome 但进不去怎么回事..

MySQL Error
Message: MySQL Query Error
SQL: SELECT main.* FROM uchome_event main WHERE 1 ORDER BY main.dateline desc LIMIT 0,4
Error: Table 'liuzukun.uchome_event' doesn't exist
Errno.: 1146
Click here to seek help.


这个怎么处理..后台能进的

数据库出错
消息：MySQL查询错误
的SQL：选择主.*从uchome_event主要其中1的ORDER BY main.dateline递减极限0,4
错误：表'liuzukun.uchome_event不存在
访问Errno。：1146

这个表uchome_event没有安装上
执行下面的SQL语句

1. CREATE TABLE uchome_event (
   
2.   eventid mediumint(8) unsigned NOT NULL auto_increment,
   
3.   topicid mediumint(8) unsigned NOT NULL default '0',
   
4.   uid mediumint(8) unsigned NOT NULL default '0',
   
5.   username varchar(15) NOT NULL default '',
   
6.   dateline int(10) unsigned NOT NULL default '0',
   
7.   title varchar(80) NOT NULL default '',
   
8.   classid smallint(6) unsigned NOT NULL default '0',
   
9.   province varchar(20) NOT NULL default '',
   
10.   city varchar(20) NOT NULL default '',
    
11.   location varchar(80) NOT NULL default '',
    
12.   poster varchar(60) NOT NULL default '',
    
13.   thumb tinyint(1) NOT NULL default '0',
    
14.   remote tinyint(1) NOT NULL default '0',
    
15.   deadline int(10) unsigned NOT NULL default '0',
    
16.   starttime int(10) unsigned NOT NULL default '0',
    
17.   endtime int(10) unsigned NOT NULL default '0',
    
18.   public tinyint(3) NOT NULL default '0',
    
19.   membernum mediumint(8) unsigned NOT NULL default '0',
    
20.   follownum mediumint(8) unsigned NOT NULL default '0',
    
21.   viewnum mediumint(8) unsigned NOT NULL default '0',
    
22.   grade tinyint(3) NOT NULL default '0',
    
23.   recommendtime int(10) unsigned NOT NULL default '0',
    
24.   tagid mediumint(8) unsigned NOT NULL default '0',
    
25.   picnum mediumint(8) unsigned NOT NULL default '0',
    
26.   threadnum mediumint(8) unsigned NOT NULL default '0',
    
27.   updatetime int(10) unsigned NOT NULL default '0',
    
28.   hot mediumint(8) unsigned NOT NULL default '0',
    
29.   PRIMARY KEY  (eventid),
    
30.   KEY grade (grade,recommendtime),
    
31.   KEY membernum (membernum),
    
32.   KEY uid (uid,eventid),
    
33.   KEY tagid (tagid,eventid),
    
34.   KEY topicid (topicid,dateline)
    
35. ) ENGINE=MyISAM;
    

复制代码

怎么执行................

pma或mysql上执行

MySQL Error
Message: MySQL Query Error
SQL: SELECT main.* FROM uchome_event main WHERE 1 ORDER BY  ...
liuzukun 发表于 2009-10-9 10:40

建议重新安装吧

不要忘了上传install.sql

我是想重新装的...删也有点麻烦...