need a little help with an error

Worker Joined: Jan 18, 2008 Posts: 143

Code:

File: /***REMOVED***/db/mysqli.php - Line: 201


Code: 1054 - Message: Unknown column 'attached_forum_id' in 'where clause'


SQL was: SELECT * FROM nuke_bbforums WHERE forum_id = 31 OR attached_forum_id =31 ORDER BY attached_forum_id ASC

When I go to the forums they are blank, when I access the forums through the forum admin it says error beside the forum name.

when I try to create a new forum I get this

Code:

SQL Error : 1054 Unknown column 'attached_forum_id' in 'where clause'





SELECT * FROM `nuke_bbforums` WHERE `attached_forum_id`=-1 AND `cat_id`=16 ORDER BY `forum_order`

This was a RN upgrade, everything looked right until someone used the prune function. Thin this this started happening.

Site Admin Joined: Jun 04, 2004 Posts: 6432

Looks like the upgrade didn't happen correctly. Did you have RN previously or were you upgrading from another distribution? Did you see any error messages during the upgrade?

Posted: Fri Apr 17, 2015 12:51 pm

That attribute was added in the RN 2.40.01 upgrade. Did you successfully complete /INSTALLATION/rndb_upgrade.php ?

Posted: Fri Apr 17, 2015 3:30 pm

I was upgrading from 2.4. If there is not a quick easy fix I will rebuild.

Posted: Fri Apr 17, 2015 3:32 pm

If I run the db upgrade again will it break anything else?

Posted: Fri Apr 17, 2015 3:33 pm

Need to understand if you ran the rndb_upgrade.php script. If not, the quick / easy fix is to run it. If so (and there is an issue with the script), it's more complex.

Posted: Fri Apr 17, 2015 3:37 pm

It shouldn't break anything, but it might not fix anything either. It will determine what to do based on the RN version in your config. If the version in your config table is past 2.40.01, it won't fix this issue. If you reset the version in your config to 2.40.00, it might fix this issue and give you errors in other places.

Another option: you could run Guardian's compare_tables.php script to determine what needs to be done to make your installation current, then pull the necessary SQL from rndb_upgrade to fix things. This is more involved, but it would be fairly precise, too.

What is the value of the version attribute in the nuke_config table? (there should only be 1 record in this table, which might have a different prefix, depending on your installation).

Posted: Tue Apr 21, 2015 6:00 am

I ran it one more time and seemed to fix everything, except the attachment mod.

Posted: Mon Apr 27, 2015 9:19 pm

I'm on holiday right now and don't have access to my files but if you run the compare_tables.php it should tell you where the problem is and offer to fix each specific problem.
The code is quite old and I probably need to re-write that script to make things more presentable but if you look for notifications relating to the Forums tables it should offer an option to "fix" any missing table columns.