1054 Unknown column 'session_admin' in 'field list'

Raven · Posted: Thu Feb 02, 2006 1:03 pm

Full error:

Code:

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 ('aff0c6bfee57e429526498cea8862d89', '1', '1138857906', '1138857906', '440ea918', '0', '0', '0')

Line : 203
File : sessions.php

This indicates that you have not run the upgrade.php file that should be in your root nuke folder (where config.php and mainfile.php reside). Just point your browser to

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

after having configured your config.php file and then delete it when finished.

sting · Posted: Tue Feb 07, 2006 9:32 pm

In the words of the great theologians Toad the Wet Sprocket, I "will not repeat myself again, will NOT repeat myself again. . . "

Thanks for the sticky Raven...

-sting

jib_intelli · Hangin' Around Joined: Aug 17, 2004 Posts: 34

Umm, am upgrading from PHPNuke 7.6 to RN 2.20.01 but cannot find upgrade.php

I have run the following files:

upgrade18-19.php to upgrade21-22.php (was running BBtoNuke 2.0.1 Cool

, any other suggestion?

jakec · Posted: Sun Aug 10, 2008 3:58 am

This is an old post and no longer applies to upgrading RN.

Have you read the

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

?

If you are using 7.6 and upgraded BB2Nuke to the latest then the next step is making the core database changes.

jib_intelli · Hangin' Around Joined: Aug 17, 2004 Posts: 34

I have done this:

Quote:

# Apply RavenNuke(tm) Core Database Changes - As of this version, there are four sets of primary code database changes: 1) Resend Email Hack, 2) NSN Groups, 3) HTML Newsletter, and 4) GCalendar. Each of these has a separate SQL file or installer if you need to upgrade/update. Each of these are discussed in its own topic below:

* Resend Email Hack - If you already are using this hack, you should not have to do anything here. However, if you do not have it already, you will need to use phpMyAdmin to execute the SQL found in file INSTALLATION/sql/includedInCore/rn_resendemail.sql. This will alter the nuke_users_temp table.
* NSN Groups - If you already have NSN Groups installed in your original database, you should not have to do anything here as long as the table structure is the same as the 1.7.1 release. However, if you do not have it already, you will need to use phpMyAdmin to execute the SQL found in file INSTALLATION/sql/includedInCore/rn_nsngroups.sql. If your current installation has NSN Groups and it is not compatible table structure-wise with 1.7.1, then you may need to treat this as a fresh install using the file just mentioned, and then manually re-do your groups and assignment of users to groups (so you may wish to note both your groups and user-to-group assignments before executing the SQL in that sql file).
* HTML Newsletter - If you already are using a version of the HTML Newsletter (from Montego Scripts) that is below 1.3.x, then you will need to use the HTML Newsletter installer. You can find this within the RavenNuke(tm) distribution here: AddOnFiles/HTML_Newsletter (read the README.txt and following the instructions). If you do NOT already have the HTML Newsletter installed, simply apply ONLY (!!!) respective step of the installSQL.php script. This will add the necessary HTML Newsletter tables.
* GCalendar - If you already are using a version of GCalendar (from GCalendar Support) that is below 1.7.0, then you will need to use the GCalendar installer. You can find this within the RavenNuke(tm) distribution here: AddOnFiles/GCalendar/html (simply copy over the gcal_install.php to your root and point your browser to it). If you do not already have GCalendar installed, you can also install the tables from this installer.

If you already have a version of any of these add-ons that is greater than what is provided within this distribution, you must take care not to overwrite its files.

Anything else that needs to be done? You may visit the upgraded status of my site at

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

jakec · Posted: Sun Aug 10, 2008 7:44 am

Looking good so far. I would use mySQL Diff to compare your upgraded database to a standard RN database. Then compare your directory's and files to an RN structure using something like Beyond Compare.

You need to make sure your database and files are correct and matches RN. I don't know if you have any mods which you have migrated as well, so if you have obviously you want to retain them.

Then lastly test test test!

jib_intelli · Hangin' Around Joined: Aug 17, 2004 Posts: 34

Hee Haw!!!!! Yay!!!!!

Got it up!!! The forums are now running. Thanks to the wonderful people at Ravenphpscripts!!! You guys rock!!!!

I would love it if you guys could help me out with one minor problem - everything in the site is getting center aligned, be it the blocks, or forums etc. Any idea what could be causing this?

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

jakec · Posted: Wed Aug 13, 2008 1:59 am

I'm glad you got it working. Very Happy

Is it not supposed to be center aligned? It looks like your old site was the same. How do you want it to be aligned? This is most definitely a theme issue.

montego · Posted: Wed Aug 13, 2008 6:09 am

... and not appropriate for this thread. Please search for answers as this issue has been addressed many times and let us leave this thread here on topic. Thanks.