[Error] Read only mode is not working on phpBB2

New D-Addicts phpBB3 forum discussions
User avatar
UsagiYojimbo
Geinou Fansubber
Geinou Fansubber
Posts: 742
Joined: Thu Feb 28, 2008 11:04 pm
Location: Debrecen, Hungary
Contact:

[Error] Read only mode is not working on phpBB2

Postby UsagiYojimbo » Tue Dec 30, 2014 5:19 am

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...
ÁzsiaiFeliratok.hu | AvistaZ (AsiaTorrents) meghívók | MDL.info

Asadora
Posts: 70
Joined: Sat Nov 22, 2014 11:16 pm
Location: Texas,USA

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

Postby Asadora » Tue Dec 30, 2014 6:04 am

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

Asadora
Posts: 70
Joined: Sat Nov 22, 2014 11:16 pm
Location: Texas,USA

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

Postby Asadora » Tue Dec 30, 2014 6:06 am

Oops! I mean in Safari….

MoerkJ
Administrator
Administrator
Posts: 1813
Joined: Sat Dec 06, 2003 8:40 am
Location: Germany

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

Postby MoerkJ » Tue Dec 30, 2014 6:39 am

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:
..:: ( Clubbox | Wiki | FAQ | IRC ) ::..

User avatar
UsagiYojimbo
Geinou Fansubber
Geinou Fansubber
Posts: 742
Joined: Thu Feb 28, 2008 11:04 pm
Location: Debrecen, Hungary
Contact:

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

Postby UsagiYojimbo » Tue Dec 30, 2014 6:43 am

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...
ÁzsiaiFeliratok.hu | AvistaZ (AsiaTorrents) meghívók | MDL.info

Sianspheric
Posts: 10
Joined: Fri Mar 21, 2014 1:56 am

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

Postby Sianspheric » Wed Dec 31, 2014 12:13 am

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: 742
Joined: Thu Feb 28, 2008 11:04 pm
Location: Debrecen, Hungary
Contact:

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

Postby UsagiYojimbo » Wed Dec 31, 2014 4:55 am

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"...
ÁzsiaiFeliratok.hu | AvistaZ (AsiaTorrents) meghívók | MDL.info

User avatar
TimeCompression
Posts: 112
Joined: Mon Jul 23, 2012 1:21 am
Location: Brazil
Contact:

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

Postby TimeCompression » Wed Dec 31, 2014 5:32 pm

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: 742
Joined: Thu Feb 28, 2008 11:04 pm
Location: Debrecen, Hungary
Contact:

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

Postby UsagiYojimbo » Wed Dec 31, 2014 7:04 pm

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...
ÁzsiaiFeliratok.hu | AvistaZ (AsiaTorrents) meghívók | MDL.info

User avatar
TimeCompression
Posts: 112
Joined: Mon Jul 23, 2012 1:21 am
Location: Brazil
Contact:

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

Postby TimeCompression » Wed Dec 31, 2014 7:11 pm

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: 1813
Joined: Sat Dec 06, 2003 8:40 am
Location: Germany

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

Postby MoerkJ » Thu Jan 01, 2015 12:46 am

I hope the problem is solved now.

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


Who is online

Users browsing this forum: No registered users and 3 guests