Debug Errors After Upgrading

registered · Theme Guru Joined: Nov 01, 2003 Posts: 1006

I have been working on a website that I have worked on for years. The site was working perfectly an hour or so ago. Then, I ran the upgrade to RN2.3. Now, when trying to access the forums, not the forum index, but rather the actual topics IE viewtopic.php. I receive an sql error which seems to be happening for all of the bbmods that are installed. They are all similar to below.

Does anyone have any idea what would cause this to happen after the upgrade? The mods functioned correctly before. There are no errors in the error log or showing on the website aside from the debug errors.

I have checked, the tables are there. However, clearly it is not looking for them correctly. As I said, they all worked correctly just before upgrading. Perhaps I have missed something. Everything else on the website seems to be working correctly.

Help would be greatly appreciated. Thank you

Code:




SQL Error : 1146 Table 'blahblah_blahblah.GAMES_TABLE' doesn't exist





SELECT game_id, game_pic, game_highuser, game_name, game_highscore FROM GAMES_TABLE WHERE game_highuser=13 ORDER BY game_name ASC





Line : 1271


File : viewtopic.php

For this example, the actual table for the games is nuke_bbgames

Posted: Sat Dec 20, 2008 7:47 pm

GAMES_TABLE needs to be defined as bbgames in a language file i beleive.

Posted: Sat Dec 20, 2008 7:50 pm

This is the same issue, same error, for every table for every mod that is installed. They all worked perfectly before the upgrade tonight. I have checked and all of the edits are in place. Sad

Posted: Sat Dec 20, 2008 7:58 pm

If you have a bunch of mod installed you are going to have a problem because includes/constants.php was moved to modules/Forums/includes/constants.php. This file holds all the constants for all of your mods. You probably can just overwrite the new one with your old one, but I am not exactly sure.

Posted: Sat Dec 20, 2008 8:00 pm

Yes, this persons website has many forum mods installed such as the arcade. Are you saying that the movement of this file is what is causing the sql errors?

Posted: Sun Dec 21, 2008 5:36 am

Yes this would definitely cause the problem. Many MODs declare their new tables in constants.php As the forums are now looking at the new location they would not have the data from the file in the old location.
If you do a directory compare on
nukeroot/includes/
and
nukeroot/modules/Forums/includes/
you should see all the files that have moved - basically everything in modules/Forums/includes/ are relocated files so you will need to compare the data in all those files.