2.0.13 to 2.0.17 error message

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
commanderyoda
Registered User
Posts: 169
Joined: Tue Sep 07, 2004 12:18 am

2.0.13 to 2.0.17 error message

Post by 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

User avatar
Marshalrusty
Project Manager
Project Manager
Posts: 29253
Joined: Mon Nov 22, 2004 10:45 pm
Location: New York City
Name: Yuriy Rusko
Contact:

Post by 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
Have comments/praise/complaints/suggestions? Please feel free to PM me.

Need private help? Hire me for all your phpBB and web development needs

commanderyoda
Registered User
Posts: 169
Joined: Tue Sep 07, 2004 12:18 am

Post by 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.

User avatar
Marshalrusty
Project Manager
Project Manager
Posts: 29253
Joined: Mon Nov 22, 2004 10:45 pm
Location: New York City
Name: Yuriy Rusko
Contact:

Post by 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";
Have comments/praise/complaints/suggestions? Please feel free to PM me.

Need private help? Hire me for all your phpBB and web development needs

User avatar
MHobbit
Former Team Member
Posts: 4761
Joined: Thu Mar 18, 2004 5:32 pm
Location: There and Back Again

Post by MHobbit »

Make sure you're grabbing the most updated update_to_latest.php file.
Former phpBB MOD Team member
No private support is offered.
"There’s too many things to get done, and I’m running out of days..."

commanderyoda
Registered User
Posts: 169
Joined: Tue Sep 07, 2004 12:18 am

Post by commanderyoda »

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

User avatar
Marshalrusty
Project Manager
Project Manager
Posts: 29253
Joined: Mon Nov 22, 2004 10:45 pm
Location: New York City
Name: Yuriy Rusko
Contact:

Post by Marshalrusty »

commanderyoda wrote: Is there one "more" updated than 2.0.17 ???

No
Marshalrusty wrote: 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";
Last edited by Marshalrusty on Thu Jul 28, 2005 3:43 am, edited 1 time in total.
Have comments/praise/complaints/suggestions? Please feel free to PM me.

Need private help? Hire me for all your phpBB and web development needs

commanderyoda
Registered User
Posts: 169
Joined: Tue Sep 07, 2004 12:18 am

Post by commanderyoda »

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

User avatar
Marshalrusty
Project Manager
Project Manager
Posts: 29253
Joined: Mon Nov 22, 2004 10:45 pm
Location: New York City
Name: Yuriy Rusko
Contact:

Post by 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.
Have comments/praise/complaints/suggestions? Please feel free to PM me.

Need private help? Hire me for all your phpBB and web development needs

commanderyoda
Registered User
Posts: 169
Joined: Tue Sep 07, 2004 12:18 am

Post by 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).

User avatar
Marshalrusty
Project Manager
Project Manager
Posts: 29253
Joined: Mon Nov 22, 2004 10:45 pm
Location: New York City
Name: Yuriy Rusko
Contact:

Post by Marshalrusty »

I give up. Get phpMyAdmin and run the query above. This seems like a permissions error.
Have comments/praise/complaints/suggestions? Please feel free to PM me.

Need private help? Hire me for all your phpBB and web development needs

commanderyoda
Registered User
Posts: 169
Joined: Tue Sep 07, 2004 12:18 am

Post by commanderyoda »

Anyone else have a clue?

User avatar
Marshalrusty
Project Manager
Project Manager
Posts: 29253
Joined: Mon Nov 22, 2004 10:45 pm
Location: New York City
Name: Yuriy Rusko
Contact:

Post by 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?
Have comments/praise/complaints/suggestions? Please feel free to PM me.

Need private help? Hire me for all your phpBB and web development needs

cybrid23
Former Team Member
Posts: 9877
Joined: Wed Jun 29, 2005 5:55 am
Location: Somewhere in the Midwest...
Contact:

Post by cybrid23 »

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

Give that a shot and see what happens.....
---Never leave home without a towel and your peril sensitive sunglasses.
---Do Not PM Me For Support. It will go unanswered.
Thanks.

commanderyoda
Registered User
Posts: 169
Joined: Tue Sep 07, 2004 12:18 am

Post by commanderyoda »

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

Locked

Return to “2.0.x Support Forum”