Announcement

Collapse
No announcement yet.

SQL Error When Pruning Posts

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

  • Steve Machol
    replied
    I said thread.php because that's the script causing the problem - not showthread.php.

    Leave a comment:


  • kilcher
    replied
    showthread.php? You said thread.php, just want to make sure.

    Leave a comment:


  • Steve Machol
    replied
    Reupload the original thread.php file from the 2.2.9 zip file. Make sure you upload in ASCII and overwrite the one on the server.

    Leave a comment:


  • kilcher
    replied
    Same as this?

    http://www.vbulletin.com/forum/showt...threadid=69408

    My error is slightly different but the same code. When I look in my unzipped folder it looks like the showthread.php file hasn't been modified from the original.
    Last edited by kilcher; Sat 12 Apr '03, 7:13am.

    Leave a comment:


  • kilcher
    started a topic SQL Error When Pruning Posts

    SQL Error When Pruning Posts

    I'm trying to prune posts that haven't had a reply in the last 365 days. Once I hit the prune button it hangs for about 30 seconds and then I get the following error:

    Database error in vBulletin Control Panel 2.2.9:

    Invalid SQL: DELETE FROM searchindex WHERE wordid IN (0,56243,56246) AND postid=
    mysql error: You have an error in your SQL syntax near '' at line 1

    mysql error number: 1064

    Date: Saturday 12th of April 2003 10:49:21 AM
    Script: http://www.veggieboards.com/boards/b...min/thread.php
    Referer: http://www.veggieboards.com/boards/admin/thread.php
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X