[Error] Read only mode is not working on phpBB2

New D-Addicts phpBB3 forum discussions
Post Reply
User avatar
UsagiYojimbo
Geinou Fansubber
Geinou Fansubber
Posts: 750
Joined: Feb 28th, '08, 23:04
Location: Debrecen, Hungary
Been thanked: 2 times
Contact:
Hungary

[Error] Read only mode is not working on phpBB2

Post by UsagiYojimbo » Dec 30th, '14, 05:19

I get the following error, when visiting old phpBB2 site at http://www.d-addicts.com/forum:
SQL Error : 1142 UPDATE command denied to user 'daddict_forumbo'@'localhost' for table 'phpbb_sessions_keys'
It seems to be a clever idea to revoke update rights from the engines DB-user, but it tries to store session ID's in a table...

Asadora
Posts: 68
Joined: Nov 22nd, '14, 23:16
Location: Texas,USA

Re: [Error] Read only mode is not working on phpBB2

Post by Asadora » Dec 30th, '14, 06:04

I have the same thing in Safary,but it works normally in Chrome… :nuts:

Asadora
Posts: 68
Joined: Nov 22nd, '14, 23:16
Location: Texas,USA

Re: [Error] Read only mode is not working on phpBB2

Post by Asadora » Dec 30th, '14, 06:06

Oops! I mean in Safari….

MoerkJ
Administrator
Administrator
Posts: 1315
Joined: Dec 6th, '03, 08:40
Location: Germany

Re: [Error] Read only mode is not working on phpBB2

Post by MoerkJ » Dec 30th, '14, 06:39

You always get this error when you try to login on the old board. This is normal because there is no way to configure the phpBB2 board to read-only mode.

We made it read-only simply by locking the whole forum database during migration. This was done to avoid any further changes to the board (i.e. new account registrations, visit count updates, etc.). The consequence is that you cannot lock in anymore.

Perhaps a better way would be to lock each (sub)forum of the old board without locking the database. Maybe we will do that. But why do you still want to log in to the old board?
:scratch:

User avatar
UsagiYojimbo
Geinou Fansubber
Geinou Fansubber
Posts: 750
Joined: Feb 28th, '08, 23:04
Location: Debrecen, Hungary
Been thanked: 2 times
Contact:
Hungary

Re: [Error] Read only mode is not working on phpBB2

Post by UsagiYojimbo » Dec 30th, '14, 06:43

MoerkJ wrote:We made it read-only simply by locking the whole forum database during migration.
Try to grant update rights to only this one table 'phpbb_sessions_keys' in the database...

Sianspheric
Posts: 10
Joined: Mar 21st, '14, 01:56

Re: [Error] Read only mode is not working on phpBB2

Post by Sianspheric » Dec 31st, '14, 00:13

UsagiYojimbo wrote:I get the following error, when visiting old phpBB2 site at http://www.d-addicts.com/forum:
SQL Error : 1142 UPDATE command denied to user 'daddict_forumbo'@'localhost' for table 'phpbb_sessions_keys'
It seems to be a clever idea to revoke update rights from the engines DB-user, but it tries to store session ID's in a table...
I had the same error at first. You need to delete the cookies for d-addict. You can either flush all your cookies in your web browser or just delete the one for d-addict and it should solve the problem. It works for me.

User avatar
UsagiYojimbo
Geinou Fansubber
Geinou Fansubber
Posts: 750
Joined: Feb 28th, '08, 23:04
Location: Debrecen, Hungary
Been thanked: 2 times
Contact:
Hungary

Re: [Error] Read only mode is not working on phpBB2

Post by UsagiYojimbo » Dec 31st, '14, 04:55

Sianspheric wrote:
Sianspheric wrote:It seems to be a clever idea to revoke update rights from the engines DB-user, but it tries to store session ID's in a table...
I had the same error at first. You need to delete the cookies for d-addict. You can either flush all your cookies in your web browser or just delete the one for d-addict and it should solve the problem. It works for me.
Now i understand, what MoerkJ meant by "login on"...

TimeCompression
Posts: 106
Joined: Jul 23rd, '12, 01:21
Location: Brazil
Has thanked: 1 time
Been thanked: 1 time
Brazil

Re: [Error] Read only mode is not working on phpBB2

Post by TimeCompression » Dec 31st, '14, 17:32

lol, I thought d-addicts was down because I was seeing that error message... maybe you should delete all the stored sections to force a logoff for everyone?

User avatar
UsagiYojimbo
Geinou Fansubber
Geinou Fansubber
Posts: 750
Joined: Feb 28th, '08, 23:04
Location: Debrecen, Hungary
Been thanked: 2 times
Contact:
Hungary

Re: [Error] Read only mode is not working on phpBB2

Post by UsagiYojimbo » Dec 31st, '14, 19:04

TimeCompression wrote:lol, I thought d-addicts was down because I was seeing that error message... maybe you should delete all the stored sections to force a logoff for everyone?
It is not solvable on server side, every client must clear its cookie cache for the old forums...

TimeCompression
Posts: 106
Joined: Jul 23rd, '12, 01:21
Location: Brazil
Has thanked: 1 time
Been thanked: 1 time
Brazil

Re: [Error] Read only mode is not working on phpBB2

Post by TimeCompression » Dec 31st, '14, 19:11

It certainly is solvable on server side, though that might not be easy.
What I meant to say is that I think you can delete all rows in phpbb_sessions_keys to force all users to logout and avoid that error message. I may be wrong though, I don't have much experience with phpBB.

MoerkJ
Administrator
Administrator
Posts: 1315
Joined: Dec 6th, '03, 08:40
Location: Germany

Re: [Error] Read only mode is not working on phpBB2

Post by MoerkJ » Jan 1st, '15, 00:46

I hope the problem is solved now.

I deleted all user sessions for the old forum by emptying the sessions table in the database.

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest