Can't access forums

Nuke Cadet Joined: Apr 06, 2007 Posts: 8

I am running phpnuke 7.9, when I try to access the forums from nuke admin, I get this message:
------------------------------------------------------
phpBB : Critical Error

Could not query config information

DEBUG MODE

SQL Error : 1146 Table 'bosbccej_nuke1.config' doesn't exist

SELECT * FROM config

Line : 228
File : common.php
-----------------------------------------------------------

I believe the path should look like this 'bosbccej_nuke1.nuke_config'
HELP!?! My site went online yesterday, can't afford these problems!

Site Admin Joined: Aug 17, 2003 Posts: 12364

For some reason, its not listing the proper prefix.
Do you have this $prefix set in config.php ?

Is this phpNuke 7.9 unpatched or Patched? Any BBToNuke upgrades? And addons?

Nuke Cadet Joined: Apr 06, 2007 Posts: 8

Main file config lists the prefix:

$dbhost = "localhost";
$dbuname = "bosbccej_nuke1";

$dbname = "bosbccej_nuke1";
$prefix = "nuke";
$user_prefix = "nuke";
$dbtype = "MySQL";
$sitekey = "SwSDsyrrVImDS9UcHpL2Df/%(-0394·$%/";
$gfx_chk = 0;
$subscription_url = "";
$admin_file = "admin";
$tipath = "images/topics/";
$nuke_editor = 1;
$display_errors = false;

Forums config looks like this:

<?php

if(defined('INSIDE_MOD')) {
@include_once("mainfile.php");
} else {
@include_once("../../mainfile.php");
}
define('PHPBB_INSTALLED', true);

?>

I am running 7.9 unpatched, no upgrades

Sergeant Joined: Mar 03, 2007 Posts: 127

Hide your dbpass...

$prefix must be ok or the entire site would lock.
This happens only while admin module access?
It really seems that you modded something...

It's kinda weird, but admin/common.php calls for config_table, witch should be _bbconfig and not _config...

Is

Code:

$sql = "SELECT *
FROM " . CONFIG_TABLE;
if( !($result = $db->sql_query($sql)) )
{
message_die(CRITICAL_ERROR, "Could not query config information", "", __LINE__, __FILE__, $sql);
}

this the line in your file?

And isn't

Code:

define('CONFIG_TABLE', $prefix.'_bbconfig');

this in your constants.php ?

Nuke Cadet Joined: Apr 06, 2007 Posts: 8

The code was in common.php, constants.php looks like:

define('CONFIG_TABLE', $table_prefix.'config');

I added _bb, didn't help.

I do get the same error message when trying to access forum from the website.

Sergeant Joined: Mar 03, 2007 Posts: 127

Put the line exactly has a gave it...
If it doesn't work Just change $table_prefix to $prefix

Nuke Cadet Joined: Apr 06, 2007 Posts: 8

public_html/includes/constants.php-
changed line to - define('CONFIG_TABLE', $prefix.'_bbconfig');

Now get this message - "message_die() was called multiple times. This isn't supposed to happen. Was message_die() used in page_tail.php?"

Sergeant Joined: Mar 03, 2007 Posts: 127

Well... That was my best shot...
Can you place your entire Table names from constants.php here?

One thing I am sure: that constants.php file you have is NOT the default 7.9 build nor the patched one... Are you sure of your nuke build?

Nuke Cadet Joined: Apr 06, 2007 Posts: 8

7.9 installed from cPanel. I have a copy of 7.9 that I downloaded from phpnuke.org, should I try replacing the constants file?

// Table names
define('CONFIRM_TABLE', $table_prefix.'confirm');
define('AUTH_ACCESS_TABLE', $table_prefix.'auth_access');
define('BANLIST_TABLE', $table_prefix.'banlist');
define('CATEGORIES_TABLE', $table_prefix.'categories');
define('CONFIG_TABLE', $table_prefix.'_bbconfig');
define('DISALLOW_TABLE', $table_prefix.'disallow');
define('FORUMS_TABLE', $table_prefix.'forums');
define('GROUPS_TABLE', $table_prefix.'groups');
define('POSTS_TABLE', $table_prefix.'posts');
define('POSTS_TEXT_TABLE', $table_prefix.'posts_text');
define('PRIVMSGS_TABLE', $table_prefix.'privmsgs');
define('PRIVMSGS_TEXT_TABLE', $table_prefix.'privmsgs_text');
define('PRIVMSGS_IGNORE_TABLE', $table_prefix.'privmsgs_ignore');
define('PRUNE_TABLE', $table_prefix.'forum_prune');
define('RANKS_TABLE', $table_prefix.'ranks');
define('SEARCH_TABLE', $table_prefix.'search_results');
define('SEARCH_WORD_TABLE', $table_prefix.'search_wordlist');
define('SEARCH_MATCH_TABLE', $table_prefix.'search_wordmatch');
define('SESSIONS_TABLE', $table_prefix.'sessions');
define('SESSIONS_KEYS_TABLE', $table_prefix.'sessions_keys');
define('SMILIES_TABLE', $table_prefix.'smilies');
define('THEMES_TABLE', $table_prefix.'themes');
define('THEMES_NAME_TABLE', $table_prefix.'themes_name');
define('TOPICS_TABLE', $table_prefix.'topics');
define('TOPICS_WATCH_TABLE', $table_prefix.'topics_watch');
define('USER_GROUP_TABLE', $table_prefix.'user_group');
define('USERS_TABLE', $table_prefix.'users');
define('WORDS_TABLE', $table_prefix.'words');
define('VOTE_DESC_TABLE', $table_prefix.'vote_desc');
define('VOTE_RESULTS_TABLE', $table_prefix.'vote_results');
define('VOTE_USERS_TABLE', $table_prefix.'vote_voters');

Sergeant Joined: Mar 03, 2007 Posts: 127

If you have no contents to save, just delete that crap and install either raven 7.6 build or 7.9 patched.

It's pretty hard to guess what structure your cpanel nuke has...

Nuke Cadet Joined: Apr 06, 2007 Posts: 8

I replaced the constants file. I can access from the website. It appears that I have a faulty forum template. In forum admin, all I see is the phpbb logo and these 4 sentences:

Welcome to phpBB
Forum Statistics
Version Information
Who is Online

Nothing that I can click to change the theme. Is there a way to change the theme from db?

Sergeant Joined: Mar 03, 2007 Posts: 127

Why try to fix this here and there when you have no idea of what will come in a few days? The builds I suggested you are very secure and above all are known to us. If a problem happens, there will be someone here able to help you.

That build from your cpanel seems to be buggy... I have no idea of what was the last version using $table_prefix (if there even was one).

Nuke Cadet Joined: Apr 06, 2007 Posts: 8

Can I save my registered member login info, I don't want to upset my brand new members. Site has only been live a couple days.

I really appreciate all of your help!!!

Sergeant Joined: Mar 03, 2007 Posts: 127

It would be easier for you to create a new db for your new build.
Then you can check if your nuke_users tables are equivalent (structure).

If they are, just export-import'em. The fields must be in the exact name and order...

If they are different, you can manually add your (few) users and copy each field to it's rightful place...