vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Invalid SQL: UPDATE adminutil SET text = UNIX_TIMESTAMP() WHERE title ... (https://vborg.vbsupport.ru/showthread.php?t=327560)

postcd 09-26-2019 10:50 AM
Invalid SQL: UPDATE adminutil SET text = UNIX_TIMESTAMP() WHERE title ...
 
Hello,

this is the error i am getting:

Quote:
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 09-26-2019 06:00 PM
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 09-27-2019 08:40 PM
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 10-01-2019 10:26 AM
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 10-09-2019 06:14 AM
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 10-09-2019 06:46 AM
Upgrade as Dave stated.

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

postcd 10-09-2019 06:52 AM
Quote:
Originally Posted by snakes1100 (Post 2600907)
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 10-09-2019 07:13 AM
What version of php?

postcd 10-09-2019 03:11 PM
Quote:
Originally Posted by snakes1100 (Post 2600909)
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 10-10-2019 06:51 AM
Ok, as Dave already stated & myself, you need to upgrade vbulletin to 4.2.5

postcd 10-11-2019 09:07 PM
> 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 10-12-2019 01:35 AM
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 10-12-2019 07:13 AM
@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:

Code:
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 10-12-2019 11:21 AM
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 10-20-2019 11:24 AM
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..


All times are GMT. The time now is 01:04 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01082 seconds
  • Memory Usage 1,755KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (15)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete