Problem with upgrade tables

alexwise · Regular Joined: Oct 15, 2005 Posts: 80

This is a post relates to this one ...

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

But im moving myself here cos I think it relates more in the section.

Im using the new Distro pack and im porting accros forum tables from an old 6.8 site.
I did the upgrade on the 6.8 site so the tables are upto 7.6, and then exported them and installed them into the raven pack site, and got this error

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 ('c2a3dc870bf54eb1ea1f690799903b6e', '1', '1141088101', '1141088101', 'acbc7326', '0', '0', '0')

Line : 220
File : sessions.php

Which is the same kind of error you get when you havent updated the tables so ........
I then installed a New stanterd 7.6 with no addons (patch etc) and it worked fine with the forum tables, you could post read search etc etc

Now im using all the tables with BB infron for the forums, and also the User list and the Temp list, is there a table im missing which this pack needs or is it somthing else?

Thanks.

alexwise · Regular Joined: Oct 15, 2005 Posts: 80

K cos the error pointed to the sessions.php just for a quick test (dont worry I have backups) I moved a sessions.php file from a normal 7.6 nuke and its now working.

Now that of corse isnt the fix cos I know there is NukeSentinel code in the file.
So whats the fix to this then? is it just somthing on that line that needs changing ?

Please help, cos this upgrade im doing has gone well over time, and im getting people breathig down my neck.

Thanks guys.

*Edit
Ive also looked at the BBsessions table and there isnt a coloum for "session_admin" but the sessions.php file is trying to imput data there, and the normal 7.6 sessions file dosnt have that coloum at all mentioned in the php file.

I swear I didnt touch the bbsessions table lol, and ive installed it 2 times, that colum isnt there.

Confused

alexwise · Regular Joined: Oct 15, 2005 Posts: 80

Right ok all solved now, when I moved the tables from 6.8 to the 7.6 site I selected ALL the BB forum tables how I would normally do, however, moving the bbsessions table acrros ment it no longer had the session_admin collum in it.

That took me hours to work out , I hope somone sees this before they make the same mistake.

montego · Posted: Tue Feb 28, 2006 7:21 am

alexwise, thank you letting us know. Glad you figured it out! Way to go!