2.0.13 to 2.0.17 error message

[commanderyoda]

Upgraded a brand new 2.0.13 board to 2.0.17 using the "changed zip" files. The board is Subsilver with no mods. The "update to latest version" file was launched with no errors being reported. The install and contrib directories were appropriately deleted. Below is the error message I get when I attempt to log into this board:

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 ('0b217695ea7f15dfa0710ff384ead7da', -1, 1122520024, 1122520024, '43a92ecb', 0, 0, 0)

Line : 172
File : sessions.php

[Marshalrusty]

You need to finish the update by running the install/update_to_latest.php file.
1) Upload the install folder to the root folder of your forum (the one with the folders 'admin', 'cache', 'db', 'includes', 'language', etc.)
2) Point to the file in your browser. For example: http://www.yoursite.com/phpBB2/install/ ... latest.php

[commanderyoda]

No . . . as I indicated . . . the update file "IS" being installed in the correct root directory and luanched as you indicated. However, this same message continues.

[Marshalrusty]

Do you get any errors when you launch it?

In any case, use phpMyAdmin and run this:

Code: Select all

ALTER TABLE phpb_sessions ADD COLUMN session_admin tinyint(2) DEFAULT '0' NOT NULL";

[MHobbit]

Make sure you're grabbing the most updated update_to_latest.php file.

[commanderyoda]

Is there one "more" updated than 2.0.17 ???

[Marshalrusty]

Is there one "more" updated than 2.0.17 ???

No

In any case, use phpMyAdmin and run this:

Code: Select all

ALTER TABLE phpb_sessions ADD COLUMN session_admin tinyint(2) DEFAULT '0' NOT NULL";

[commanderyoda]

Where do I find "phpMyAdmin" ? Can you then describe what you mean but "run" the code you described?

[Marshalrusty]

I'll make it even easier. Download THIS
Then upload it (unzip first) to the root folder and run. The same way you ran update_to_latest.php, except that this needs to be placed in the root folder.

[commanderyoda]

I downloaded that file. Unziped it and uploaded it to the main root directory. Lauched the file and got this:

error in query 1: You have an error in your SQL syntax near '"' at line 1
done (1 queries).

[Marshalrusty]

I give up. Get phpMyAdmin and run the query above. This seems like a permissions error.

[commanderyoda]

Anyone else have a clue?

[Marshalrusty]

You really should try to install phpMyAdmin, it's a good tool to have access to, are you sure that your host doesn't provide it?

[cybrid23]

Have you tried using the /update_to_latest.php from the full version download?

Give that a shot and see what happens.....

[commanderyoda]

Ok . . . I'll give that a shot . . . thanks.