1.按照说明备份数据和文件,防止升级失败!!
2.升级时不要删除的install这个目录(升级清单有误),否则不能升级
3.在后台重新设置安装路径,否则不能正常显示!

4.升级完成后如果首页不能正常显示(显示一大堆数据库连接错误之类),进入后台"网站数据备份 "-->"Sql数据操作",在"请粘贴要执行的SQL语句代码"里面输入下面代码然后提交:

delete from php168bbs_label

5.后台重新设置标签

如有问题请跟帖提出

马上再试下。成功的话我就先给你磕头

对了，新安装的在线人数没显示（0）

还是一样哦,升级完成后如果首页不能正常显示(显示一大堆数据库连接错误之类),
已经运行
delete from php168bbs_label
我是3.1的.论坛也是自己带的,对了,我的3.1有一个表5M,无法备份,不敢试啊,用以前备份的在本机上试的

本文引用 4 楼 菜鸟先飞发表的话题

Quote:

还是一样哦,升级完成后如果首页不能正常显示(显示一大堆数据库连接错误之类),
已经

后台显示正常吗

升级失败的请上传压缩包里的install目录重新升级

我的后台一切正常,就是首页最上面出现了若干
如下:

数据库连接出错:select * from where ( >0 ) new AND picnews<>'' order by desc limit 0,4

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 'where ( >0 ) new AND picnews<>'' order by desc limit 0,4' at
1064数据库连接出错:select * from where ( >0 ) new AND picnews<>'' order by desc limit 0,1

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 'where ( >0 ) new AND picnews<>'' order by desc limit 0,1' at
1064数据库连接出错:select * from where ( >0 ) new AND picnews<>'' order by desc limit 0,1

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 'where ( >0 ) new AND picnews<>'' order by desc limit 0,1' at
1064数据库连接出错:select * from where ( >0 ) new AND picnews<>'' order by desc limit 0,1

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 'where ( >0 ) new AND picnews<>'' order by desc limit 0,1' at
1064数据库连接出错:select * from where ( >0 ) new AND picnews<>'' order by desc limit 0,1

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 'where ( >0 ) new AND picnews<>'' order by desc limit 0,1' at
1064数据库连接出错:select * from where ( >0 ) new AND picnews<>'' order by desc limit 0,4

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 'where ( >0 ) new AND picnews<>'' order by desc limit 0,4' at
1064数据库连接出错:select * from where ( >0 ) new order by desc limit 0,7

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 'where ( >0 ) new order by desc limit 0,7' at line 1
1064数据库连接出错:select a.* from a where a.>0 10 order by a. desc limit 0,1

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 '>0 10 order by a. desc limit 0,1' at line 1
1064数据库连接出错:select r.* from r where ='' order by desc limit 0,1

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 '='' order by desc limit 0,1' at line 1
1064

烦请帮忙,多谢了

我的也一样哦，怎么办？

我的是3.5测试二的升级后在首页也是出现了一大堆的东西，其他正常。
数据库连接出错:select * from music_music order by posttime desc limit 0,7

Table '168.music_music' doesn't exist
1146数据库连接出错:select * from music_music where ( special='99990' OR special=5 ) order by posttime desc limit 0,16

Table '168.music_music' doesn't exist
1146数据库连接出错:select * from music_music order by posttime desc limit 0,9

Table '168.music_music' doesn't exist
1146数据库连接出错:select * from music_music order by posttime desc limit 0,7

Table '168.music_music' doesn't exist
1146数据库连接出错:select * from flash_artic where ( fid='99990' OR fid=11 OR fid=13 OR fid=14 OR fid=21 OR fid=23 OR fid=24 OR fid=25 OR fid=26 ) order by posttime desc limit 0,8

Table '168.flash_artic' doesn't exist
1146数据库连接出错:select * from music_music where ( special='99990' OR special=8 ) order by posttime desc limit 0,16

Table '168.music_music' doesn't exist
1146数据库连接出错:select * from flash_artic where ( fid='99990' OR fid=4 OR fid=5 OR fid=6 OR fid=7 OR fid=8 OR fid=9 OR fid=10 ) order by posttime desc limit 0,8

Table '168.flash_artic' doesn't exist
1146数据库连接出错:select * from 168bbs_artic where ( fid='99990' OR fid=1 OR fid=864 OR fid=139 OR fid=8 OR fid=9 OR fid=12 OR fid=17 OR fid=19 OR fid=59 OR fid=60 OR fid=61 OR fid=62 OR fid=63 OR fid=64 OR fid=100 OR fid=135 OR fid=66 OR fid=67 OR fid=69 OR fid=138 OR fid=72 OR fid=73 OR fid=75 OR fid=76 OR fid=77 OR fid=1020 OR fid=79 OR fid=80 OR fid=83 OR fid=84 OR fid=86 OR fid=137 OR fid=89 OR fid=90 OR fid=91 OR fid=92 OR fid=93 OR fid=98 OR fid=99 OR fid=101 ) order by posttime desc limit 0,7

Table '168.168bbs_artic' doesn't exist
1146数据库连接出错:select * from 168bbs_artic where ( fid='99990' OR fid=1 OR fid=864 OR fid=139 OR fid=8 OR fid=9 OR fid=12 OR fid=17 OR fid=19 OR fid=59 OR fid=60 OR fid=61 OR fid=62 OR fid=63 OR fid=64 OR fid=100 OR fid=135 OR fid=66 OR fid=67 OR fid=69 OR fid=138 OR fid=72 OR fid=73 OR fid=75 OR fid=76 OR fid=77 OR fid=1020 OR fid=79 OR fid=80 OR fid=83 OR fid=84 OR fid=86 OR fid=137 OR fid=89 OR fid=90 OR fid=91 OR fid=92 OR fid=93 OR fid=98 OR fid=99 OR fid=101 ) order by lastpost desc limit 0,13

Table '168.168bbs_artic' doesn't exist
1146数据库连接出错:select * from 168bbs_artic where ( fid='99990' OR fid=1028 ) order by posttime desc limit 0,8

Table '168.168bbs_artic' doesn't exist
1146数据库连接出错:select * from 168bbs_artic where ( fid='99990' OR fid=247 ) order by posttime desc limit 0,10

Table '168.168bbs_artic' doesn't exist
1146数据库连接出错:select * from 168bbs_artic where ( fid='99990' OR fid=244 ) order by posttime desc limit 0,10

Table '168.168bbs_artic' doesn't exist
1146

我的新安装首页也出现以下错误，后台一切正常。


数据库连接出错:select * from php168bbs_artic where fid='2' order by list desc limit 8

Table 'sq_lotteryfans.php168bbs_artic' doesn't exist
1146数据库连接出错:select * from php168bbs_artic where fid='3' order by list desc limit 8

Table 'sq_lotteryfans.php168bbs_artic' doesn't exist
1146数据库连接出错:select * from php168bbs_artic where fid='4' order by list desc limit 8

Table 'sq_lotteryfans.php168bbs_artic' doesn't exist
1146数据库连接出错:select * from php168bbs_artic where fid='5' order by list desc limit 8

Table 'sq_lotteryfans.php168bbs_artic' doesn't exist
1146数据库连接出错:select * from php168bbs_artic where ( fid>0 ) AND picnews<>'' order by posttime desc limit 0,4

Table 'sq_lotteryfans.php168bbs_artic' doesn't exist
1146数据库连接出错:select * from php168bbs_artic where ( fid='99990' OR fid=51 OR fid=52 OR fid=53 OR fid=54 OR fid=55 OR fid=98 ) order by posttime desc limit 0,7

Table 'sq_lotteryfans.php168bbs_artic' doesn't exist
1146数据库连接出错:select * from php168bbs_artic order by posttime desc limit 0,5

Table 'sq_lotteryfans.php168bbs_artic' doesn't exist
1146数据库连接出错:select * from php168bbs_artic where ( fid='99990' OR fid=83 ) order by posttime desc limit 0,5

Table 'sq_lotteryfans.php168bbs_artic' doesn't exist
1146数据库连接出错:select * from php168bbs_artic where ( fid='99990' OR fid=84 ) order by posttime desc limit 0,5

Table 'sq_lotteryfans.php168bbs_artic' doesn't exist
1146数据库连接出错:select * from php168bbs_artic where ( fid='99990' OR fid=85 ) order by posttime desc limit 0,5

Table 'sq_lotteryfans.php168bbs_artic' doesn't exist
1146数据库连接出错:select * from php168bbs_artic where ( fid='99990' OR fid=2 ) order by posttime desc limit 0,8

Table 'sq_lotteryfans.php168bbs_artic' doesn't exist
1146数据库连接出错:select * from php168bbs_artic where ( fid='99990' OR fid=3 ) order by posttime desc limit 0,8

Table 'sq_lotteryfans.php168bbs_artic' doesn't exist
1146数据库连接出错:select * from php168bbs_artic where ( fid='99990' OR fid=4 ) order by posttime desc limit 0,7

Table 'sq_lotteryfans.php168bbs_artic' doesn't exist
1146数据库连接出错:select * from php168bbs_artic where ( fid='99990' OR fid=5 ) order by posttime desc limit 0,7

Table 'sq_lotteryfans.php168bbs_artic' doesn't exist
1146数据库连接出错:select * from php168bbs_artic where ( fid='99990' OR fid=6 ) order by posttime desc limit 0,7

Table 'sq_lotteryfans.php168bbs_artic' doesn't exist
1146数据库连接出错:select * from php168bbs_artic where ( fid='99990' OR fid=7 ) order by posttime desc limit 0,7

Table 'sq_lotteryfans.php168bbs_artic' doesn't exist
1146数据库连接出错:select * from php168bbs_artic where ( fid='99990' OR fid=8 ) order by posttime desc limit 0,7

Table 'sq_lotteryfans.php168bbs_artic' doesn't exist
1146数据库连接出错:select * from php168bbs_artic where ( fid='99990' OR fid=2 ) order by posttime desc limit 0,7

Table 'sq_lotteryfans.php168bbs_artic' doesn't exist
1146数据库连接出错:select * from php168bbs_artic where ( fid='99990' OR fid=82 ) order by posttime desc limit 0,16

Table 'sq_lotteryfans.php168bbs_artic' doesn't exist
1146数据库连接出错:select * from php168bbs_artic where ( fid='99990' OR fid=8 ) order by posttime desc limit 0,12

Table 'sq_lotteryfans.php168bbs_artic' doesn't exist
1146数据库连接出错:select * from php168bbs_artic where ( fid>0 ) AND picnews<>'' order by posttime desc limit 0,4

Table 'sq_lotteryfans.php168bbs_artic' doesn't exist
1146数据库连接出错:select * from php168bbs_artic order by posttime desc limit 0,10

Table 'sq_lotteryfans.php168bbs_artic' doesn't exist
1146数据库连接出错:select * from php168bbs_artic order by lastpost desc limit 0,9

Table 'sq_lotteryfans.php168bbs_artic' doesn't exist
1146

第一步就开始出错

数据库连接出错: DROP TABLE `php168bbs_hack`

Unknown table 'php168bbs_hack'
1051点击下一步,同步数据表结构

接着是

程序升级中。。。。

点击下一步,删除临时数据表

点击下一步,更新网站核心设置

点击下一步,更新栏目设置

点击下一步,更新用户组设置

点击下一步,更新附件数据

升级完毕,请点击进入后台更新缓存,与配置相关栏目设置及首页标签,如果网站出现不正常现象,请更修改栏目设置及用户组设置即可解决

升级完毕,请点击进入后台更新缓存,与配置相关栏目设置及首页标签,如果网站出现不正常现象,请更修改栏目设置及用户组设置即可解决

同时请手工删除此升级文件,否则不安全



注意,必须使用前台管理员登录后台,原来的管理员可能有些会造成登录不了,因为之前的后台管理员已失效.
如果你确实登录不了后台,请新注册一个帐号,然后修改文件php168/admin_1.php把里边的内容清空,添加如下代码
<?$admin_1="你新注册的用户名";?>
如果文件不存在的话,请创建一个,添加以上内容,再使用此帐号登录后台

死翘翘！还没成功！连站长先生我都进不去了。呜呼~~

顶给老大看

第一步就开始出错

数据库连接出错: DROP TABLE `php168bbs_hack`

Unknown table 'php168bbs_hack'
1051点击下一步,同步数据表结构

我的3.1版本运行update.php就出现


MYSQL 连接成功,但当前使用的数据库 不存在

No Database Selected
1046

楼上的,请问你确认删除新版目录中的
php168/web_config.php吗?

确认删除了

打开任何一个栏目，顶部都有这个，文章页面没有，后台也没发现什么问题

数据库连接出错:select * from where ( ='99990' 18, ) new order by desc limit 0,10

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 'where ( ='99990' 18, ) new order by desc limit 0,10' at line
1064数据库连接出错:select * from where ( ='99990' 17, ) new order by desc limit 0,6

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 'where ( ='99990' 17, ) new order by desc limit 0,6' at line
1064数据库连接出错:select * from where ( ='99990' 15,27, ) new order by desc limit 0,10

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 'where ( ='99990' 15,27, ) new order by desc limit 0,10' at l
1064数据库连接出错:select * from where ( ='99990' 12, ) new order by desc limit 0,21

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 'where ( ='99990' 12, ) new order by desc limit 0,21' at line
1064数据库连接出错:select * from where ( >0 ) new order by desc limit 0,10

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 'where ( >0 ) new order by desc limit 0,10' at line 1
1064数据库连接出错:select a.* from a where a.>0 10 order by a. desc limit 0,1

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 '>0 10 order by a. desc limit 0,1' at line 1
1064数据库连接出错:select r.* from r where ='' order by desc limit 0,1

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 '='' order by desc limit 0,1' at line 1
1064数据库连接出错:select * from where ( >0 ) hits order by desc limit 0,10

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 'where ( >0 ) hits order by desc limit 0,10' at line 1
1064数据库连接出错:select * from where ( ='99990' 19, ) new order by desc limit 0,11

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 'where ( ='99990' 19, ) new order by desc limit 0,11' at line
1064数据库连接出错:select * from where ( ='99990' 17, ) new order by desc limit 0,20

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 'where ( ='99990' 17, ) new order by desc limit 0,20' at line
1064