Database Cross over PROBLEM!!!!!

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
parapilot
Registered User
Posts: 29
Joined: Fri Oct 15, 2004 2:03 pm

Database Cross over PROBLEM!!!!!

Post by parapilot » Tue Nov 01, 2005 10:55 pm

I have just backed up my database, installed the latest .18 software on a fresh install. Went to admin and clicked restore database. It did not work and i get this
phpBB : Critical Error

Error creating new session

DEBUG MODE

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

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('133aaa424285efa740076941cb0da89d', -1, 1130885549, 1130885549, '55d28cb6', 0, 0, 0)

Line : 189
File : sessions.php


Is the database changable from different versions????

Nightmare

Thanks
Jamie.

JimDandy
Registered User
Posts: 134
Joined: Thu Jul 15, 2004 2:50 pm
Location: Norway

Post by JimDandy » Tue Nov 01, 2005 11:04 pm

The .18 version has you make changes to the DB, afaIk. Did you do this?

What I did was run the DB updates on a .17 board, then do the backup of the DB. Then I did a fresh install of .18 and imported the DB. Perhaps you can do that if you're at a loss (you'd have to install .17 again I guess and do a DB backup).
"Ah! Opposable digits!"

parapilot
Registered User
Posts: 29
Joined: Fri Oct 15, 2004 2:03 pm

Post by parapilot » Tue Nov 01, 2005 11:10 pm

No i have not done this, and my old database is gone now (only have 1 my Sql). i asumed the backup would work! Can i Manually mod it from the text file? any other way?

Thank You
Jamie.

parapilot
Registered User
Posts: 29
Joined: Fri Oct 15, 2004 2:03 pm

Post by parapilot » Tue Nov 01, 2005 11:53 pm

Hi,

I just installed a .17 board and did the database restore, same thing happened. The old board that i did the backup from was .10
phpBB : Critical Error

Error creating new session

DEBUG MODE

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

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('5397aae36b18293b88ab9bd849230d56', -1, 1130889018, 1130889018, '55d28cb6', 0, 0, 0)

Line : 172
File : sessions.php


PLEASE HELP!!!!!!

Thanks
Jamie.

FX
Registered User
Posts: 254
Joined: Thu Aug 01, 2002 9:29 pm
Location: France
Contact:

Post by FX » Tue Nov 01, 2005 11:55 pm

Run install/update_to_latest.php to update your database.

Locked

Return to “2.0.x Support Forum”