Some help please *forum* issues.

icewolf · Hangin' Around Joined: Jul 10, 2006 Posts: 32

Hello, I recently re-installed my website and when I try to browse the forums I get this error:

Code:

phpBB : Critical Error

Error doing DB query userdata row fetch

DEBUG MODE

SQL Error : 1146 Table 'z7rsq3_******.SESSIONS_KEYS_TABLE' doesn't exist

SELECT u.* FROM nuke_users u, SESSIONS_KEYS_TABLE k WHERE u.user_id = 2 AND u.user_active = 1 AND k.user_id = u.user_id AND k.key_id = 'b4cc92640322fc12ac6f5251dc34efa7'

Line : 89
File : sessions.php

I need some help please, if you guys can help me out with this.
Thank you in advance.

utssace · Worker Joined: Feb 18, 2006 Posts: 155 Location: Virginia

Were you reinstalling a previously working site with backed up site files & database or are you starting over with a fresh install?

icewolf · Hangin' Around Joined: Jul 10, 2006 Posts: 32

Greetings, I started up with a fresh install.

Gremmie · Posted: Sat Sep 08, 2007 10:17 am

What did you install? Nuke or phpBB? What version? Sort of looks like you are missing or have a corrupt database table.

icewolf · Hangin' Around Joined: Jul 10, 2006 Posts: 32

I installed Nuke 8.1, which includes both.

Gremmie · Posted: Sat Sep 08, 2007 11:40 am

Do you have the file includes/constants.php on your server?

gotcha · Regular Joined: Mar 14, 2005 Posts: 91

Looks like the includes/constants.php is missing the definition for SESSIONS_KEYS_TABLE..

define('SESSION_KEYS_TABLE', $prefix.'_bbsessions_keys');

icewolf · Hangin' Around Joined: Jul 10, 2006 Posts: 32

/public_html/modules/Forums/includes/constants.php
Yes

icewolf · Hangin' Around Joined: Jul 10, 2006 Posts: 32

gotcha wrote:

Looks like the includes/constants.php is missing the definition for SESSIONS_KEYS_TABLE..

define('SESSION_KEYS_TABLE', $prefix.'_bbsessions_keys');

After adding that I get this error:

phpBB : Critical Error

Error doing DB query userdata row fetch

DEBUG MODE

SQL Error : 1146 Table '*****_*****.nuke_bbsessions_keys' doesn't exist

SELECT u.* FROM nuke_users u, nuke_bbsessions_keys k WHERE u.user_id = 2 AND u.user_active = 1 AND k.user_id = u.user_id AND k.key_id = 'b4cc92640322fc12ac6f5251dc34efa7'

Line : 89
File : sessions.php

icewolf · Hangin' Around Joined: Jul 10, 2006 Posts: 32

So I suppose there are some parts missing from the SQL, weird.., is there an SQL file I should get that has all the tables?

Gremmie · Posted: Sat Sep 08, 2007 11:57 am

icewolf wrote:

/public_html/modules/Forums/includes/constants.php
Yes

No, I said includes/constants.php, meaning public_html/includes/constants.php, not modules/Forums/includes/constants.php.

Otherwise I'm not familiar with how PHP-Nuke 8 does the forums. I assumed it was using BBtoNuke, in which case all the includes are in the root directory, not under forums.

icewolf · Hangin' Around Joined: Jul 10, 2006 Posts: 32

That be a no, usually for phpnuke they have it in modules/forums/includes/constants.php
But no there is no constants.php on the public_html/includes/constants.php

icewolf · Hangin' Around Joined: Jul 10, 2006 Posts: 32

Hey should I try to install 7.9 and then keep upgrading to 8.1? that may work.

Gremmie · Posted: Sat Sep 08, 2007 12:50 pm

I am familiar with RavenNuke, Nuke Evolution, and PHP-Nuke 7.9. They all use the BBtoNuke package to achieve phpBB integration. And all of these put the forums includes stuff in <root>/includes, not modules/Forums/includes. So either 8.x is doing something different, or you have the files in the wrong locations.

You are better off trying to go to RavenNuke if you are going to go anywhere. Wink

icewolf · Hangin' Around Joined: Jul 10, 2006 Posts: 32

Gremmie wrote:

I am familiar with RavenNuke, Nuke Evolution, and PHP-Nuke 7.9. They all use the BBtoNuke package to achieve phpBB integration. And all of these put the forums includes stuff in <root>/includes, not modules/Forums/includes. So either 8.x is doing something different, or you have the files in the wrong locations.

You are better off trying to go to RavenNuke if you are going to go anywhere. Wink

I don't think I put files in the wrong locations.
Anyways I went to

Only registered users can see links on this board!
Get registered or login to the forums!

but not sure which one to download (ravenuke) I could use some help.

Gremmie · Posted: Sat Sep 08, 2007 1:05 pm

They are all the same, they just differ on how they are archived (.zip, .rar, etc). You won't need the core table fix package.

icewolf · Hangin' Around Joined: Jul 10, 2006 Posts: 32

Alrighty, I installed everything, now when I try to go to the forums and post something it takes me to Your Account page, not sure whats going on, btw Gremmie, do you have anything that we can use to talk real time? msn or something.

Gremmie · Posted: Sat Sep 08, 2007 3:55 pm

You have to be logged in as a user probably to make a forum post. Are you just logged in as God admin?

icewolf · Hangin' Around Joined: Jul 10, 2006 Posts: 32

my username is the same as the god admin, I logged out from god admin and still kept going to the same page when I tried to post or reply to a thread.
Here is a screenshot:

Only registered users can see links on this board!
Get registered or login to the forums!

Gremmie · Posted: Sat Sep 08, 2007 4:33 pm

What are the forum permissions? Clear your cookies just in case.

icewolf · Hangin' Around Joined: Jul 10, 2006 Posts: 32

Looks like clearing my cookies fixed the problem! thank you so much, I believe I am all good to go!
Thank you so much Gremmie you are truly amazing.

Gremmie · Posted: Sat Sep 08, 2007 5:20 pm

Glad you got it working!

icewolf · Hangin' Around Joined: Jul 10, 2006 Posts: 32

Looks like it wasn't just me but other users were not able to post, should I tell them to just go ahead and delete cookies for all ?

Gremmie · Posted: Sat Sep 08, 2007 7:35 pm

Sure, I guess....??? Can't hurt.

icewolf · Hangin' Around Joined: Jul 10, 2006 Posts: 32

Sorry to add this, as I go I keep getting more and more errors:
When I try to update my info (adding avatar) or something else I get error saying:
Invalid Session. Please resubmit the form.
I get that over and over again, I also tried from Profile (the phpnuke one instead of the forums one) and same bug, instead of uploading the avatar it re-directs me to the avatar page (the one with all the icons)
Its weird.