Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 04 Apr 2019, 17:49
copydown copydown is offline
 
Join Date: Jan 2014
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

Last edited by copydown; 05 Apr 2019 at 11:58.
Reply With Quote
  #2  
Old 04 Apr 2019, 19:35
iA1 iA1 is offline
 
Join Date: Jul 2018
There is no closing bracket at the end of line # 9.
__________________
Make your forum mobile friendly and get app-like features:
App-like icon on your smartphone homescreen
Responsive style - for vBulletin 4.2.x as well as vB 3.8.x - Contact for custom work
Push notifications for new replies, likes and PM
Reply With Quote
  #3  
Old 05 Apr 2019, 07:09
copydown copydown is offline
 
Join Date: Jan 2014
Originally Posted by iA1 View Post
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
Reply With Quote
  #4  
Old 05 Apr 2019, 09:14
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
Disable your addons via config.php

If the error goes away, enable addons in config.php, then 1st disable any addon related to usercp
Reply With Quote
  #5  
Old 05 Apr 2019, 09:40
copydown copydown is offline
 
Join Date: Jan 2014
Originally Posted by snakes1100 View Post
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.
Reply With Quote
  #6  
Old 05 Apr 2019, 10:16
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
Install a default style & check the issue still persists.
Reply With Quote
  #7  
Old 05 Apr 2019, 10:32
copydown copydown is offline
 
Join Date: Jan 2014
Originally Posted by snakes1100 View Post
Install a default style & check the issue still persists.
tried that but the problem still exist
Reply With Quote
  #8  
Old 05 Apr 2019, 10:44
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
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:
Reply With Quote
  #9  
Old 05 Apr 2019, 10:59
copydown copydown is offline
 
Join Date: Jan 2014
Originally Posted by snakes1100 View Post
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 05 Apr 2019 at 11:57 ---------------

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
Reply With Quote
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
End-User Options Change your UserCP Navbar with the New UserCP Dropdown Menu! Nоrman vBulletin 3.7 Add-ons 40 10 Jun 2009 19:43
End-User Options GTUserCP - Enhanced USERCP Interface + USERCP Menu Princeton vBulletin 3.6 Template Modifications 440 19 Jun 2008 21:00



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 09:30.

Layout Options | Width: Wide Color: