Forum and Member's List Problem

Premium Joined: Jun 12, 2003 Posts: 58

Hello,

I am using the snapshot of bNC from 7/23/03.

Using all orginal bNC files and my orginal database (plus the Milo theme):
http://www.codydecker.com/beta
Notice the errors in "Forums" and in "Member's List"

Using PhpNuke 6.5 with Fixes up to including Service Fix 4 and my original database (plus modified Milo theme):
http://www.codydecker.com
Notice no errors in "Forums" and in "Member's List"

Given that both sites are using the exact same database, I don't think the database is the problem...

I recieved the following error initally when I click on the Forums links:

Code:

phpBB : Critical Error

Could not obtain ban information

DEBUG MODE

SQL Error : 1054 Unknown column 'ban_expire_time' in 'field list'

SELECT ban_ip, ban_userid, ban_email, ban_email, ban_expire_time, ban_priv_reason, ban_pub_reason_mode, ban_pub_reason FROM nuke_bbbanlist WHERE ban_ip IN ('443323e3', '443323ff', '4433ffff', '44ffffff') OR ban_userid = 3 OR ban_email LIKE 'cody@codydecker.com' OR ban_email LIKE '@codydecker.com'

Line : 163
File : /var/www/html/beta/includes/sessions.php

After replacing the bNC bundle sessions.php file with the sessions.php file from my original site (http://www.codydecker.com), I recieved the following error:

Code:

General Error

Tried obtaining data. It failed

DEBUG MODE

SQL Error : 1146 Table 'nuke.nuke_board_message' doesn't exist

SELECT msg_id, title, message, showpage , auth, width, images, ordr, bbcode_uid, startdate, enddate, users_timezone FROM nuke_board_message WHERE ((showpage <> '-9999' AND showpage = '' ) OR showpage = '9999') AND MID(days,4,1) = '1' AND auth <= 3 AND startdate <= 1058998426 AND enddate >= 1058998426

Line : 131
File : /var/www/html/beta/includes/functions_bm.php

Note that the above examples can be seen live by going to http://www.codydecker.com/beta and clicking on the "Forums" or the "Member's List" links.

Thanks for any help you might have!
Cody

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

So the sessions.php from bNC is bad? This is odd, because the forums at betanc are working. Hmm...

Premium Joined: Jun 12, 2003 Posts: 58

Hello,

Well, I not exactly for sure where the problem is coming from... I am getting errors from both versions of the sessions.php file.

Cody

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

Ahh, the error seems to be a table problem in your database. Make sure you have all those columns.

Guest

Zhen-Xjell wrote:

Ahh, the error seems to be a table problem in your database. Make sure you have all those columns.

Hello Zhen,

I think the database is working correctly... http://www.codydecker.com and http://www.codydecker.com/beta are using the EXACT same database (e.g. modifying any part of the database "nuke" effects BOTH sites).

http://www.codydecker.com, the site that using the original PhpNuke 6.5 package (with fixes) is working fine (including the forums and member's list); however, the bNC bundle (http://www.codydecker.com/beta) displays errors in the "Forums" and "Member's List" modules.

Any help is appreciated!

Cody

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

I'll compare on my end.

Premium Joined: Jun 12, 2003 Posts: 58

Hello,

Just for anybody else having this same problem...

I was able to create a database using the nuke.sql that came with bNC, then, I force copied my database over the database filled by the nuke.sql file. This resolved the problem.

mysql nuke < nuke.sql
mysql nuke < backup.sql --force

Thanks,
Cody

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

Interesting approach, thanks Cody.