7.6, 3.0 patch errors

kenshell · New Member Joined: May 11, 2005 Posts: 10

7.6 was working fine.
I ran 3.0 patch and got this.
I can ruin a wetdream Sad

phpBB : Critical Error

Error creating new session

DEBUG MODE

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

INSERT INTO nuke_bbsessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('08e9c7b6ecd2812ce98abfb07dfcdd42', '1', '1115944229', '1115944229', '458ecf9f', '0', '0', '0')

Line : 203
File : sessions.php

Raven · Posted: Thu May 12, 2005 8:03 pm

Did you run the upgradedb.php file? If not, then run it. That should fix it. Here is the latest copy

Code:

<?php

require_once("mainfile.php");
include("header.php");
title("Correcting username length and session_admin field in db tables");
OpenTable();

$result = $db->sql_query("alter table ".$prefix."_stories change informant informant varchar(25) not null default ''");
if (!$result) { echo "Modification one to ".$prefix."_stories failed \n"; } else { echo "Modification one to ".$prefix."_stories performed \n"; }
$result = $db->sql_query("alter table ".$prefix."_stories change aid aid varchar(25) not null default ''");
if (!$result) { echo "Modification two to ".$prefix."_stories failed \n"; } else { echo "Modification two to ".$prefix."_stories performed \n"; }
$result = $db->sql_query("alter table ".$prefix."_autonews change informant informant varchar(25) not null default ''");
if (!$result) { echo "Modification one to ".$prefix."_autonews failed \n"; } else { echo "Modification one to ".$prefix."_autonews performed \n"; }
$result = $db->sql_query("alter table ".$prefix."_autonews change aid aid varchar(25) not null default ''");
if (!$result) { echo "Modification two to ".$prefix."_autonews failed \n"; } else { echo "Modification two to ".$prefix."_autonews performed \n"; }
$result = $db->sql_query("alter table ".$prefix."_reviews change reviewer reviewer varchar(25) default NULL");
if (!$result) { echo "Modification to ".$prefix."_reviews failed \n"; } else { echo "Modification to ".$prefix."_reviews performed \n"; }
$result = $db->sql_query("alter table ".$prefix."_reviews_add change reviewer reviewer varchar(25) not null default ''");
if (!$result) { echo "Modification to ".$prefix."_reviews_add failed \n"; } else { echo "Modification to ".$prefix."_reviews_add performed \n"; }
$result = $db->sql_query("ALTER TABLE ".$prefix."_bbsessions ADD COLUMN session_admin tinyint(2) DEFAULT '0' NOT NULL");
if (!$result) { echo "Modification to ".$prefix."_bbsessions failed \n"; } else { echo "Modification to ".$prefix."_bbsessions performed \n"; }
$result = $db->sql_query("UPDATE ".$prefix."_bbconfig SET config_value='.0.15' where config_name='version'");
if (!$result) { echo "Modification to ".$prefix."_bbconfig failed \n"; } else { echo "Modification to ".$prefix."_bbconfig performed \n"; }

echo "Correction finished, Delete this file now! \n";
echo "Back to <a href=\"index.php\">website</a>\n";
CloseTable();
include("footer.php");

?>

Raven · Posted: Thu May 12, 2005 8:05 pm

Or, just use phpMyAdmin and run this query

Code:

ALTER TABLE nuke_bbsessions ADD COLUMN session_admin tinyint(2) DEFAULT '0' NOT NULL

kenshell · New Member Joined: May 11, 2005 Posts: 10

thanks raven.
that did it.

lemme back it up now Wink

Raven wrote:

Or, just use phpMyAdmin and run this query

Code:

ALTER TABLE nuke_bbsessions ADD COLUMN session_admin tinyint(2) DEFAULT '0' NOT NULL

manunkind · Posted: Sun May 15, 2005 9:34 am

I had this problem too. Running the file does not update the DB. I had to do it manually.

Raven · Posted: Sun May 15, 2005 10:32 am

The file that ships with 7.7 does not have that code in it. Chat added it in his 3.0 fixes. That's why I posted the correct one up above and not the one that ships with 7.7

Defcon · Regular Joined: Mar 10, 2005 Posts: 85

I also get this problem too. Raven, did u have a complete patch 7.6 where you already did a correction such this error?

Guardian2003 · Posted: Fri Jul 29, 2005 3:23 am

The upgrade file is shipped with Chatserv's patched 2.9 and 3.0 series for that version of nuke - see the front page of this site for the download link.