FUDforum: How To » Working with a read only database

Home » FUDforum » How To » Working with a read only database

Show: Today's Messages :: Polls :: Message Navigator

Working with a read only database [message #186487]

Mon, 25 August 2014 06:54

DaveQB

Messages: 109
Registered: January 2006
Location: Sydney

Karma: 0

Senior Member

Hi,

Is there any way to have a fudforum work with a read-only database?
I replicate to another server files and databases. It is a master-slave replication and so the slave is in read-only. It is to be used when the main server goes down as a temp server. Wordpress works, but it looks like FudForum does not. I am getting a:

Quote:

PHP Fatal error: SQL error has occurred! Please contact the <a href="mailto:user(at)example(dot)com?subject=SQL%20Error">administrator</a> and have them look at the Error Log Viewer in the forum's Admin Control Panel. in <fudforum>/include/core.inc on line 268

Looking in the file system at the "sql_error" file, we have this:

Quote:

1290: The MySQL server is running with the --read-only option so it cannot execute this statement<br />
Query: UPDATE ases SET sys_id=

I suspect it would be a session issue.

So can there be a way around this? Move sessions to the file system?
I just want it working enough that the forum can be read. If sessions where on the file system, then users might be able to login to read private area. I understand they would not be able to post etc.

Thanks.

Report message to a moderator

Previous Topic:	Export to PDF
Next Topic:	message storage file, foff and length question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 15:48:42 GMT 2024

Total time taken to generate the page: 0.02370 seconds