Page 1 of 1

Problems after upgrade to 2.0.17

Posted: Sat Jul 30, 2005 9:37 am
by ~Romil
Fortunately, I got a full backup of my db bofore palying around a bit.

Installed a mint version of 2.0.17, all done okay.. but after I restored the database I get this error while accessing the board:

Code: Select all

phpBB : Critical Error 

Error creating new session


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 ('d3dea2a9f6dc93d0cd2f48b7401e3c80', -1, 1122715437, 1122715437, '3d10c31e', 0, 0, 0)

Line : 172
File : sessions.php
Not very good with PHP but I can smell some rat over sessions.php. Also, with the fact that I had to reconfigure the MySQL database with the new install information maybe causing some problem.

Also, I had JustFooty template before I took that backup, but I FTPed the template file back too.

What could be the possible problem? :)

Board URL:
Info: PHP 5, MySQL 4.x, Apache

Posted: Sat Jul 30, 2005 9:40 am
by zeroK
You have to run the install/update_to_latest.php to also update your database :)

Posted: Sat Jul 30, 2005 9:43 am
by KCgame
I have the same problem before even after executing update_to_lastest..

I solve it by repairing the database tables by phpmyadmin.

Hope it helps you also :)

Posted: Sat Jul 30, 2005 9:57 am
by ~Romil
Hehe, that is the "magic matra" of phpBB ;) And yeah, it worked! :lol:

Thanks for pointing me towards that, I did more complex things than that.

phpBB ahoy!