Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
  #1  
Old 04-04-2019, 02:49 PM
copydown copydown is offline
 
Join Date: Jan 2014
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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
Reply With Quote
  #2  
Old 04-04-2019, 04:35 PM
iA1 iA1 is offline
 
Join Date: Jul 2018
Posts: 150
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

There is no closing bracket at the end of line # 9.
Reply With Quote
  #3  
Old 04-05-2019, 04:09 AM
copydown copydown is offline
 
Join Date: Jan 2014
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
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 04-05-2019, 06:14 AM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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 04-05-2019, 06:40 AM
copydown copydown is offline
 
Join Date: Jan 2014
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
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 04-05-2019, 07:16 AM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Install a default style & check the issue still persists.
Reply With Quote
  #7  
Old 04-05-2019, 07:32 AM
copydown copydown is offline
 
Join Date: Jan 2014
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
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 04-05-2019, 07:44 AM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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 04-05-2019, 07:59 AM
copydown copydown is offline
 
Join Date: Jan 2014
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

Thread Tools
Display Modes

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

Forum Jump


All times are GMT. The time now is 08:20 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04737 seconds
  • Memory Usage 2,233KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (9)post_thanks_box
  • (9)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (9)post_thanks_postbit_info
  • (9)postbit
  • (9)postbit_onlinestatus
  • (9)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete