Invalid SQL: UPDATE adminutil SET text = UNIX_TIMESTAMP() WHERE title ...

[postcd]

Hello,

this is the error i am getting:

Database error in vBulletin 4.2.0:

Invalid SQL:

UPDATE adminutil SET
text = UNIX_TIMESTAMP()
WHERE title = 'datastorelock' AND text < UNIX_TIMESTAMP() - 15;

MySQL Error :
Error Number :
Request Date : Thursday, September 26th 2019 @ 05:30:03 AM
Error Date : Thursday, September 26th 2019 @ 05:30:04 AM
Script : http://mydomain.com/domains/mydomain...t&postid=25527
Referrer : https://mydomain.com/domains/mydomai...t&postid=25527
IP Address : 172.69.60.131
Username : Admin
Classname : vB_Database_MySQLi
MySQL Version :

I am getting same invalid SQL error also on other pages like mydomain.com/domains/mydomain.com/public_html/archive/index.php/f-20.html

It happening since the hosting account was transferred to a new server with higher MySQL version and higher PHP version. I also changed mysql to mysqli in config.php file if i am not wrong.

What should i try please? I want to stay on current vB version.

[Dave]

Based on the error you pasted here, you are still running vBulletin 4.2.0. If you need to run vBulletin 4 with PHP 7+, you must upgrade to the latest vBulletin 4 version.

[postcd]

I have disabled and then enabled following plugins:
Helpful Answers
DragonByte Tech: Advanced Post Thanks / Like (Lite)
In AdminCP/Maintenance menu cleared cache.
I no longer have that problem.

[postcd]

No, it is back. I think it may has to do with the quick edit'or (when i go to advanced editting, then no problem), but when i try to submit quick edit, then the submit button wheel is turning and nothing happens (post was editted on background, but i received that mentioned SQL error - SQL command is OK when executed via PHPmyadmin)

I also had an idea if this is caused by the cloudflare. No it is not. Browser dev. console shown some FAIL: deltype_hard and when i duck.com it, i found [this post](https://forum.vbulletin.com/forum/vb...01#post3548501) where is described change in /vb/ckeditor.php

PHP Code:

Line 507:
htmlspecialchars($value)

Changed to

htmlspecialchars($value, ENT_COMPAT | ENT_HTML401, "ISO-8859-1") 


now quick editor works (for the time being) and no SQL error mail ��

[postcd]

No, that was not the fix.
Issue is there, but when i go to vbulletin adminCP, Maintenance section, Clear system cache. Then it fix the problem temporarily - Quick editor completing editting and no error. But maybe 24 hours later quick editor will not complete - Save button wheel is turning and editor not close. (post text change is saved on the background without problem).

Any idea why the problem is in System cache. and how to disable it, what to try? Thanks

[snakes1100]

Upgrade as Dave stated.

What version of MySQL is the new server running, it stated right in the AdminCP home page?

[postcd]

Originally Posted by snakes1100

What version of MySQL is the new server running

Newer than one the forum worked on.
currently it is: "MySQL Version 5.7.27"

[snakes1100]

What version of php?

[postcd]

Originally Posted by snakes1100

What version of php?

Hosting gives an option to use various PHP versions, so while it was not working on 5.6 i switched to 5.3 which i used on previous server where there was no problem..

[snakes1100]

Ok, as Dave already stated & myself, you need to upgrade vbulletin to 4.2.5