Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RavenNuke(tm) v2.5x
Author Message
vaudevillian
Worker
Worker



Joined: Jan 18, 2008
Posts: 143

PostPosted: Fri Apr 17, 2015 6:58 am Reply with quote

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.
 
View user's profile Send private message Send e-mail
kguske
Site Admin



Joined: Jun 04, 2004
Posts: 6405

PostPosted: Fri Apr 17, 2015 12:36 pm Reply with quote

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?

_________________
I google, therefore I exist...
nukeSEO - nukeFEED - nukePIE - nukeSPAM - nukeWYSIWYG
 
View user's profile Send private message
kguske







PostPosted: Fri Apr 17, 2015 12:51 pm Reply with quote

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







PostPosted: Fri Apr 17, 2015 3:30 pm Reply with quote

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







PostPosted: Fri Apr 17, 2015 3:32 pm Reply with quote

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







PostPosted: Fri Apr 17, 2015 3:33 pm Reply with quote

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.
 
kguske







PostPosted: Fri Apr 17, 2015 3:37 pm Reply with quote

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).
 
vaudevillian







PostPosted: Tue Apr 21, 2015 6:00 am Reply with quote

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



Joined: Aug 28, 2003
Posts: 6795
Location: Ha Noi, Viet Nam

PostPosted: Mon Apr 27, 2015 9:19 pm Reply with quote

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.
 
View user's profile Send private message Send e-mail
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RavenNuke(tm) v2.5x

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©