EX1290 Something went wrong. Please try again.

[John_C]

I keep getting this:

EX1290 Something went wrong. Please try again. 

Admin CP:

UPDATE `ipb_core_members` core_members  SET `last_visit`=1468130256 WHERE member_id=1 
IPS\Db\Exception: The MySQL server is running with the --read-only option so it cannot execute this statement (1290)
#0 /home/content/54/6456154/html/STREETNTRACK/system/Db/Db.php(836): IPS\_Db->preparedQuery('UPDATE `ipb_cor...', Array)
#1 /home/content/54/6456154/html/STREETNTRACK/system/Patterns/ActiveRecord.php(460): IPS\_Db->update('core_members', Array, Array)
#2 /home/content/54/6456154/html/STREETNTRACK/system/Member/Member.php(312): IPS\Patterns\_ActiveRecord->save()
#3 /home/content/54/6456154/html/STREETNTRACK/system/Login/Login.php(435): IPS\_Member->save()
#4 /home/content/54/6456154/html/STREETNTRACK/applications/core/modules/admin/system/login.php(52): IPS\_Login->authenticate()
#5 /home/content/54/6456154/html/STREETNTRACK/system/Dispatcher/Controller.php(94): IPS\core\modules\admin\system\_login->manage()
#6 /home/content/54/6456154/html/STREETNTRACK/system/Dispatcher/Dispatcher.php(129): IPS\Dispatcher\_Controller->execute()
#7 /home/content/54/6456154/html/STREETNTRACK/admin/index.php(13): IPS\_Dispatcher->run()
#8 {main}

Forum side:

UPDATE `ipb_core_members` core_members  SET `last_visit`=1468124324,`last_activity`=1468130222 WHERE member_id=1 
IPS\Db\Exception: The MySQL server is running with the --read-only option so it cannot execute this statement (1290)
#0 /home/content/54/6456154/html/STREETNTRACK/system/Db/Db.php(836): IPS\_Db->preparedQuery('UPDATE `ipb_cor...', Array)
#1 /home/content/54/6456154/html/STREETNTRACK/system/Patterns/ActiveRecord.php(460): IPS\_Db->update('core_members', Array, Array)
#2 /home/content/54/6456154/html/STREETNTRACK/system/Member/Member.php(312): IPS\Patterns\_ActiveRecord->save()
#3 /home/content/54/6456154/html/STREETNTRACK/system/Session/Session.php(204): IPS\_Member->save()
#4 /home/content/54/6456154/html/STREETNTRACK/system/Session/Session.php(94): IPS\_Session->init()
#5 /home/content/54/6456154/html/STREETNTRACK/system/Theme/Theme.php(245): IPS\_Session::i()
#6 /home/content/54/6456154/html/STREETNTRACK/system/Dispatcher/Standard.php(50): IPS\_Theme::i()
#7 /home/content/54/6456154/html/STREETNTRACK/system/Dispatcher/Front.php(526): IPS\Dispatcher\_Standard::baseCss()
#8 /home/content/54/6456154/html/STREETNTRACK/system/Dispatcher/Front.php(64): IPS\Dispatcher\_Front::baseCss()
#9 /home/content/54/6456154/html/STREETNTRACK/system/Dispatcher/Dispatcher.php(86): IPS\Dispatcher\_Front->init()
#10 /home/content/54/6456154/html/STREETNTRACK/index.php(13): IPS\_Dispatcher::i()
#11 {main}

What the crap is causing this? 

[MADMAN32395]

2 hours ago, John_C said:

\Exception: The MySQL server is running with the --read-only option

Appears the SQL server is in readonly... take the option off, and restart/reload SQL, and it should work. If needed contact your host for help performing that action.

[John_C]

Interesting. It does that at random sometimes at least once a day for a 5 or more minute periods. My hosting account doesn't allow me that level of access, so I'd have to call GoDaddy.... 

[John_C]

I had this error again... Called godaddy and they said they can't see what could be causing it.

Forum isn't updated yet because I'm working on moving it to a new hosting account with a newer version of PHP to support it. 

[TSP]

Does it seem consistent on the timing this occurs? What MySQL version is it?

It could be something that's done by Godaddy automatically as part of a backup routine, although it sounds weird they wouldn't know about it. It's possible you didn't "catch" someone in support personnel that is entirely knowledgeable on it. 

Another alternative would be that you have a third-party IPS application or plugin installed that causes it, but I highly doubt it. 

 

[MADMAN32395]

1 hour ago, TSP said:

done by Godaddy automatically as part of a backup routine

hmm. i never thought of that... yea it could be goDaddy toggling that for backup.. a level1 tech may not be aware of it but level2 or higher should be.