2007-02-27, 10:36 AM
Mano Wrote:The database was dumped Successfully BUt Now I am Getting This...
===================
MySQL error: 1054
Unknown column 'b.olddisplaygroup' in 'field list'
Query: SELECT u.*, f.*, b.dateline AS bandate, b.lifted AS banlifted, b.oldgroup AS banoldgroup, b.olddisplaygroup as banolddisplaygroup, b.oldadditionalgroups as banoldadditionalgroups FROM mybbosho_users u LEFT JOIN mybbosho_userfields f ON (f.ufid=u.uid) LEFT JOIN mybbosho_banned b ON (b.uid=u.uid) WHERE u.uid='1'
=====================================
This is what i did :
1. Since i wanted the ver 1.2.3 I installed a new copy of MYBB using a new database
[say 'DB' ] and using the same table prefix.
2. I took the backup of the old database [ say 'old-DB' ] ; excluding mybb_settings
3. I deleted all the tables in the 'DB' excluding mybb_settings.
4. Dumped the database..successfully nad the tables are showing up in PhpMyAdmin
5. But now this error......
You need to upgrade your board.
read here
Mano Wrote:Just now i just experimented and used different database...
The forum is not showing up ...But admin cp is working.
I am able to see all my forums Through 'Manage forums'
Since mybb_settings is not backed up i am getting the foll..in ACP
MySQL error: 1146
Table 'freewebw_xxx.mybbosho_settings' doesn't exist
Query: SELECT g.*, COUNT(s.sid) AS settingcount FROM mybbosho_settinggroups g LEFT JOIN mybbosho_settings s ON (s.gid=g.gid) WHERE g.disporder>0 GROUP BY s.gid ORDER BY g.disporder
pepotiger Wrote:OK, Here little thing we can try, remove inc/settings.php .
then give the folder inc CHMOD 777 and tell me the result.
This is not a fix for the mentioned problem. The table doesn't exists in the DB.
I recommend from you to start all again taking in cosideration that you need to run the upgrade file.