Problem porting old sql tabels into a 7.6 install

Regular Joined: Oct 15, 2005 Posts: 80

What im doing is porting acrros tables from an old 6.8 nuke site to a new 7.6 one.

What I am doing is porting in the User and temp user tables (which works fine) and then all the BB tables, along with downloads and links.

The problem is when I click on a post to view it comes up with this ....

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 ('c74bbed07b8b659e9bcaddfcc07f9575', '700', '1141029247', '1141029247', 'accbfa94', '0', '1', '0')

Line : 220
File : sessions.php

Now it might be I need to port accorss another table, I'm not sure.
I have actully done a 6.8 port to 7.6 before and the only problem I had last time was to also port in the sessions table and then it worked fine (I think, it was a long time ago)

Anyone know whats going wrong?

Thanks.

Posted: Mon Feb 27, 2006 5:36 am

Ok, I just had a search and from what I can see it needs to have an upgrade php run on the tables to make them compatible with 7.6

Only problem is it's the Raven 7.6 pack and the readme says not to use the upgrade files, and also there isnt a 6.8 to 7.6 upgrade php anyway.

hmmmm Confused

....... help please!

(p.s this should be in install forum I dono why I put it here, move it if you want mods, sorry)

Sells PC To Pay For Divorce Joined: Posts: 5661

well looks to me you forgot an upgrade/update somewhere...
So its new ravens 7.6 ?

Posted: Mon Feb 27, 2006 5:48 am

Yeah its the new Raven 7.6 pack, but the read me in the upgrade section says not to use the upgrade files, so I don't know how to go about this.

Posted: Mon Feb 27, 2006 5:50 am

well i dont think the approach wasnt that good.
in your situation it would have been best to upgrade your old site first...then use these tables to put back in the new version...

Posted: Mon Feb 27, 2006 5:56 am

Well I didnt know what I was doing lol hence the bad approach.
Ok I was thinking the same 2, it's ok I backup the new site Il put it back to the standerd Raven pack and try and upgrade the old one.

I take it in a standerd 7.6 phpnuke there is a 6.8 to 7.6 upgrade php file?

Posted: Mon Feb 27, 2006 6:24 am

well...
to start...

first work on your old site....
upgrade it with the upgrade filers that come with the version..
see folder upgrades.

keep in mind that you have to upgrade your forum also to the newest...
then when everything is done and your old site is updated....all tables will match ravens version,then simply INSERT your old posts,forums etc...

Posted: Mon Feb 27, 2006 6:27 am

ok that makes sence, but with the upgrade files to goes like this ...
6.8 to 6.9 then another file that goes 6.9 to 7.0 ect ect
So do I have to run them all till I get to the last one thats 7.6?

What a pain the ass lol

Posted: Mon Feb 27, 2006 6:28 am

yes....
what it does is just minor ajustment to the version etc..
and upgrade the forum also.. !

Posted: Mon Feb 27, 2006 6:32 am

ok cool, thanks for your help AGAIN hitwalker you always save the day lol
Il let you know how it goes.

Posted: Mon Feb 27, 2006 6:35 am

ok..thanks...do take your time...

registered · Posted: Mon Feb 27, 2006 7:20 am

alexwise, yes, and if you have the means to create a separate test instance of your site to walk through the entire upgrade process on first, that would be best. If you are unable to do this, make absolutely certain that you take a complete EXPORT of your current database and set it aside for safe keeping in case something does not go right. I would also take a back-up of your original site structure/files too, again, just in case.

This is a very significant undertaking and cannot be taken lightly, hence, the suggested backups (which I would recommend before most changes anyways). You coming from such an old version of nuke, that many of your add-on blocks and modules are not going to work without some modification. For example, with nuke7.5, FB moved all of the module administration under the modules/*/admin directory by module. Also, the 3.1 patchset will require that certain minor mods be made to your non-core nuke block files and module index.php files. (These are documented within the distribution directory PatchLevel3.1_Docs.)

Good luck! Also, please remember to check these forums and search on these forums first if you run into issues. Many people have done what you are about to do, and many questions are already answered here for you.

Posted: Mon Feb 27, 2006 7:27 am

k Thanks Ive made backups so if it all goes wrong it wont be a prob, I'm only taking the form part though and I'm not botherd if the old site gets screwed up, it's just a case of making sure all the old posts are on the new site, which has new blocks modules etc nothing is being used from the old apart from the forum posts.

Now ive actully done this before from 6.8 to 7.6, I can't rem how the hell I did it but it's not the way I'm about to do it now, it's on my other comp downstairs and works %100.
I wish I rem how I did it cos this way is gonna take a while.
Again it was just porting the forum, oh well.