vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   vBulletin 4.2.5 DB error on usercp (https://vborg.vbsupport.ru/showthread.php?t=327187)

copydown 04-04-2019 02:49 PM

vBulletin 4.2.5 DB error on usercp
 
when any of the members try to go to /usercp.php this DB error pops

I'm running vBulletin 4.2.5 with php 7.1, LiteSpeed Web Server
--------------------------------------
Database error in vBulletin 4.2.5 Beta 2:

Invalid SQL:

SELECT post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, thread.pollid,
thread.open, thread.replycount, thread.postusername, thread.postuserid,
thread.prefixid, thread.taglist, thread.dateline, thread.views, thread.iconid AS threadiconid,
thread.notes, thread.visible, threadread.readtime AS threadread,
thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpostid

FROM lb_thread AS thread
LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 1
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)


WHERE thread.threadid IN(12421)

ORDER BY lastpost DESC;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LEFT JOIN post AS post ON(post.postid = thread.firstpostid)


WHER' at line 10
Error Number : 1064
Request Date : Thursday, April 4th 2019 @ 05:43:31 PM
Error Date : Thursday, April 4th 2019 @ 05:43:31 PM
Script : http://***.net/usercp.php
Referrer : https://***.net/index.php
IP Address : 175.***.***.227
Username :
Classname : vB_Database_MySQLi
MySQL Version : 10.2.22-MariaDB-log-cll-lve
Server : ***.***.***.**
User Agent :
----------------------------------------


I tried replacing all the original files disabling all the plugins but nothing seemed to be worked. can anyone help me with this please

iA1 04-04-2019 04:35 PM

There is no closing bracket at the end of line # 9.

copydown 04-05-2019 04:09 AM

Quote:

Originally Posted by iA1 (Post 2598982)
There is no closing bracket at the end of line # 9.

can you tell me which file I should edit I'm kind a confused, I'm not a coder myself

thanks :)

snakes1100 04-05-2019 06:14 AM

Disable your addons via config.php

If the error goes away, enable addons in config.php, then 1st disable any addon related to usercp

copydown 04-05-2019 06:40 AM

Quote:

Originally Posted by snakes1100 (Post 2598995)
Disable your addons via config.php

If the error goes away, enable addons in config.php, then 1st disable any addon related to usercp

that is the first thing I tried but it did not worked for me.

snakes1100 04-05-2019 07:16 AM

Install a default style & check the issue still persists.

copydown 04-05-2019 07:32 AM

Quote:

Originally Posted by snakes1100 (Post 2598998)
Install a default style & check the issue still persists.

tried that but the problem still exist :(

snakes1100 04-05-2019 07:44 AM

You can try uploading the default fies for vb, but unless you edited one recently, not sure how you would suddenly be missing a closing bracket as iA1 mentioned.

Just noticed this, are you actually running the beta 2?

Database error in vBulletin 4.2.5 Beta 2:

copydown 04-05-2019 07:59 AM

Quote:

Originally Posted by snakes1100 (Post 2599000)
You can try uploading the default fies for vb, but unless you edited one recently, not sure how you would suddenly be missing a closing bracket as iA1 mentioned.

Just noticed this, are you actually running the beta 2?

Database error in vBulletin 4.2.5 Beta 2:

yes I am running 4.2.5 Beta 2 is that the problem? I did not upgraded to 4.2.5 final because 1 of the plugins stopped working as soon as I upgraded. so I decided to stop at beta 2 (checked that in localhost did not upload or messed up with files in the server)

--------------- Added [DATE]1554461863[/DATE] at [TIME]1554461863[/TIME] ---------------

well it seems something was wrong with the 4.2.5 Beta 2 upgraded to 4.2.5 final DB error was fixed.

Thanks everyone :)


All times are GMT. The time now is 09:17 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.01021 seconds
  • Memory Usage 1,731KB
  • 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
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (9)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