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

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 :)

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.

Install a default style & check the issue still persists.

tried that but the problem still exist :(

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 :)