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

[postcd]

> upgrade vbulletin to 4.2.5
I was thinking why. because 4.2.0 worked on previous server so i would think version is not the cause. But i spend my time to upgrade to 4.2.5, but that NOT helped. Same error.

[iA1]

Do you get any other errors at the same time? Check server error logs.

The db error that you have posted in OP does not give any error information.

[postcd]

@iA1

thank you. I enabled debug mode

and visited the page that is reported having the error mentioned in the first post of this topic. This one:
http://mydomain.com/domains/mydomain.com/public_html/archive/index.php/f-43.html
(note that after move to a new server, site started showing bad URL in adress bar as seen above, but that is possibly another issue not related)
i am then redirected to:
http://mydomain.com/domains/mydomain.com/public_html/sitemap/f-43.html
where is the mentioned SQL error and thanks to debug mode, i see something more:

Stack Trace:

#0 vB_Database->halt() called in [path]/includes/class_core.php on line 1400
#1 vB_Database_MySQLi->execute_query() called in [path]/includes/class_core.php on line 445
#2 vB_Database->query_write() called in [path]/includes/class_datastore.php on line 725
#3 vB_Datastore_Filecache->lock() called in [path]/includes/class_datastore.php on line 640
#4 vB_Datastore_Filecache->build() called in [path]/vbseo/includes/functions_vbseo_startup.php on line 215
#5 vbseo_set_datastore() called in [path]/vbseo/includes/functions_vbseo_startup.php on line 188
#6 vbseo_update_datastore() called in [path]/vbseo/includes/functions_vbseo_startup.php on line 180
#7 vbseo_check_datastore() called in [path]/vbseo/includes/functions_vbseo_vb.php on line 1224
#8 vbseo_get_forum_info() called in [path]/vbseo/includes/functions_vbseo.php on line 1343
#9 make_crawlable() called in [path]/vbseo.php on line 183

when i reloaded page, it shows without issue (so this looks like a random issue?). As you suggested i also looked after error_log file, but there was none in the sites root directory. But hosting control panel has access to error log and found errors like here.

[Dave]

If you're running vbseo, I highly doubt it's compatible with PHP 7 (because it hasn't been updated for many years) which is why it's throwing those errors.

[postcd]

My URLs was shows wrong: http://mydomain.com/domains/mydomain....php/f-20.html and that i should fix it first.
I ended up enabling vbseo plugin, going to admincp, vbseo, Settings, Options, Advanced settings and set DocRoot path there to be /home/myusername/domains/mydomain.com/public_html
Now URLs show up right and a few days i seen no MySQL error :erm: i think these URL things can also relate to .htaccess. I will report back if the issue re-appear..