Upgraded, ERROR: SQL Error 1054 session_admin

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
User avatar
cwipperman
Registered User
Posts: 36
Joined: Wed May 01, 2002 9:40 am

Upgraded, ERROR: SQL Error 1054 session_admin

Post by cwipperman » Tue Oct 18, 2005 10:06 am

HELP PLEASE!!!! 8O

I just upgraded from 2.13 to 2.17, and got the following error message...

Code: Select all

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 ('f7f7a3eb4b756d9c59f37d2c83ec0d08', -1, 1129629749, 1129629749, '454ce601', 0, 0, 0)

Line : 172
File : sessions.php 
I have tried searching the forums but the search feature is not working (I just get a blank page). Thanks in advance for any help.

User avatar
cwipperman
Registered User
Posts: 36
Joined: Wed May 01, 2002 9:40 am

Post by cwipperman » Tue Oct 18, 2005 10:29 am

Fixed,

I finally found another post with the solution. For anyone else - make sure you find also upload the "install" directory. It is not inside the individual upgrade package (when you extract the file using winzip - you must extract the entire package - along with your individual upgrade package).

lakis
Registered User
Posts: 2
Joined: Tue Oct 18, 2005 11:47 am

Post by lakis » Tue Oct 18, 2005 11:52 am

I have same problem and I noticed in phpMyadmin page that there's no session_admin column in field list. So what I supposed to do so that my bb would be back and running normally?

And this problem came up when I updated bb from 2.0.12 to 2.0.17

lakis
Registered User
Posts: 2
Joined: Tue Oct 18, 2005 11:47 am

Post by lakis » Tue Oct 18, 2005 12:22 pm

Fixed.

Locked

Return to “2.0.x Support Forum”