Announcement

Collapse
No announcement yet.

SQL Error After Upgrade

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Keith W
    replied
    Can anyone, especially some one from the VB team, help with this

    Leave a comment:


  • express
    replied
    No, i did not mean me at all. Really do not have time for issues as this. However it would be better for you though it seems to maybe go over to vbulletin.org and pay someone over there, someone that could help you and understands mysql and the coding a little bit better. Good Luck.

    Joey

    Leave a comment:


  • Keith W
    replied
    Originally posted by express View Post
    Maybe you need to pay someone that knows vb a little better than you do to fix this for you
    Pardon?

    I suppose you mean you right?

    I do not need to pay anyone, besides which we have paid for our license and support.

    I am asking here on the forum because a. someone may know how to fix this. b. it will help others searching for a fix for the same problem. After all that is what a community forum is all about, members helping other members.

    Leave a comment:


  • express
    replied
    Maybe you need to pay someone that knows vb a little better than you do to fix this for you

    Leave a comment:


  • Keith W
    replied
    Anyone got an answer or fix for this? VB staff?

    Leave a comment:


  • Keith W
    replied
    We are getting loads of these errors

    Anyone have any idea what is going on and more importantly how to fix this issue?

    Leave a comment:


  • Keith W
    replied
    OK rebuilding the search index to did not fix this issue, I am still getting the same error

    Code:
    Database error in vBulletin 4.0.0:
    
    Invalid SQL:
    
    SELECT thread.threadid
    FROM thread AS thread
    
    WHERE thread.forumid IN()
    AND thread.lastpost >= 1262134500
    AND thread.open <> 10
    ORDER BY thread.lastpost desc
    LIMIT 500;
    
    MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
    AND thread.lastpost >= 1262134500
    AND thread.open <> 10
    ORDER BY' at line 4
    Error Number : 1064
    Request Date : Wednesday, December 30th 2009 @ 06:55:00 PM
    Error Date : Wednesday, December 30th 2009 @ 06:55:00 PM
    Script : [URL="http://www.1rtr.net/forum/search.php?do=getdaily&contenttype=vBForum_Post"][COLOR=#000000]http://www.1rtr.net/forum/search.php...e=vBForum_Post[/COLOR][/URL]
    Referrer :
    IP Address : 66.249.71.42
    Username : Unregistered
    Classname : vB_Database
    MySQL Version :

    Leave a comment:


  • Keith W
    replied
    OK, have rebuilt the search index - will post back if the error persists.

    Thanks for your assistance Dody, it is much appreciated

    Leave a comment:


  • Dody
    replied
    You have to rebuild your search index after upgrading. I am not sure if it will fix the problem, but give it a try.

    Leave a comment:


  • Keith W
    replied
    The error is always the same, relating to search

    No I have not rebuilt the search index, would that matter? would it fix this error?

    Leave a comment:


  • Dody
    replied
    Does this error only occurs when you search? did you rebuild the search index?

    Leave a comment:


  • Keith W
    replied
    I didn't have any plugins

    Everything works fine except for this one error that keeps occurring

    Leave a comment:


  • Dody
    replied
    Did you disable all your plugins?

    Leave a comment:


  • Keith W
    started a topic [Forum] SQL Error After Upgrade

    SQL Error After Upgrade

    Hi,

    I keep getting the following error after upgrading to VB 4.0.0

    Can anybody shed any light on this? Of give any pointers on how to fix this issue?

    Code:
    Invalid SQL:
    
    SELECT thread.threadid
    FROM thread AS thread
    
    WHERE thread.forumid IN()
    AND thread.lastpost >= 1262100016
    AND thread.open <> 10
    ORDER BY thread.lastpost desc
    LIMIT 500;
    
    MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
    AND thread.lastpost >= 1262100016
    AND thread.open <> 10
    ORDER BY' at line 4
    Error Number : 1064
    Request Date : Wednesday, December 30th 2009 @ 09:20:16 AM
    Error Date : Wednesday, December 30th 2009 @ 09:20:16 AM
    Script : [URL="http://www.1rtr.net/forum/search.php?do=getdaily&contenttype=vBForum_Post"][COLOR=#000000]http://www.1rtr.net/forum/search.php...e=vBForum_Post[/COLOR][/URL]
    Referrer : [URL="http://www.1rtr.net/forum/"][COLOR=#000000]http://www.1rtr.net/forum/[/COLOR][/URL]
    IP Address : 86.160.125.217
    Username : Unregistered
    Classname : vB_Database
    MySQL Version :
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X