服务器上安装了三次都提示这个错误

MySQL Error
Message: MySQL Query Error
SQL: SELECT album.albumname, album.friend, space.username, space.name, space.namestatus, main.* FROM uchome_pic main LEFT JOIN uchome_album album ON album.albumid=main.albumid LEFT JOIN uchome_space space ON space.uid=main.uid WHERE 1 ORDER BY main.dateline desc LIMIT 0,28
Error: Table 'mysql.uchome_pic' doesn't exist
Errno.: 1146


但本地安装正常,服务器就总是不行,经检查,服务器上有几十个表装不进去

提示说明这个表不存在，可以手动执行下面的SQL

1. CREATE TABLE uchome_pic (
   
2.   picid mediumint(8) NOT NULL auto_increment,
   
3.   albumid mediumint(8) unsigned NOT NULL default '0',
   
4.   topicid mediumint(8) unsigned NOT NULL default '0',
   
5.   uid mediumint(8) unsigned NOT NULL default '0',
   
6.   username varchar(15) NOT NULL default '',
   
7.   dateline int(10) unsigned NOT NULL default '0',
   
8.   postip varchar(20) NOT NULL default '',
   
9.   filename varchar(100) NOT NULL default '',
   
10.   title varchar(255) NOT NULL default '',
    
11.   `type` varchar(20) NOT NULL default '',
    
12.   size int(10) unsigned NOT NULL default '0',
    
13.   filepath varchar(60) NOT NULL default '',
    
14.   thumb tinyint(1) NOT NULL default '0',
    
15.   remote tinyint(1) NOT NULL default '0',
    
16.   hot mediumint(8) unsigned NOT NULL default '0',
    
17.   click_6 smallint(6) unsigned NOT NULL default '0',
    
18.   click_7 smallint(6) unsigned NOT NULL default '0',
    
19.   click_8 smallint(6) unsigned NOT NULL default '0',
    
20.   click_9 smallint(6) unsigned NOT NULL default '0',
    
21.   click_10 smallint(6) unsigned NOT NULL default '0',
    
22.   magicframe tinyint(6) NOT NULL default '0',
    
23.   PRIMARY KEY  (picid),
    
24.   KEY albumid (albumid,dateline),
    
25.   KEY topicid (topicid,dateline)
    
26. ) ENGINE=MyISAM;
    

复制代码

可是不止这一个表啊,很多表,从M开头的以后的表都没有,顺便说一下,我的是海外服务器,有影响吗

安装过程中没有提示错误或者中断过吗

我开始也是这个问题   我执行了 玻璃屋女孩的 SQL   然后就变成这个错误了

Discuz! info: MySQL Query Error

User: 铏庡皵
Time: 2010-4-29 2:14pm
Script: /bbsblog/bbs/index1.php

SQL: SELECT p.* FROM uchome_pic p, uchome_album a WHERE a.friend='0' AND a.albumid=p.albumid ORDER BY p.dateline DESC LIMIT 4
Error: Table 'bbs.uchome_album' doesn't exist
Errno.: 1146

到 http://faq.comsenz.com 搜索此错误的解决方案

求助帮助