Im trying to delete a load of spam threads, but ticking the boxes and then going to inlinemod.php where it aks it soft delete and I click perm delete, after that I get this error:
Database error in vBulletin 3.5.0:
Invalid SQL:
SELECT
attachment.attachmentid,
attachment.userid,
post.postid,
post.threadid,
post.dateline AS post_dateline,
post.userid AS post_userid,
thread.forumid
FROM attachment AS attachment
LEFT JOIN post AS post ON (post.postid = attachment.postid)
LEFT JOIN thread AS thread ON (thread.threadid = post.threadid)
WHERE attachment.postid IN (32906,-1);
MySQL Error : Can't find file: './forums/attachment.frm' (errno: 990)
Error Number : 1017
Date : Monday, November 28th 2005 @ 12:30:34 PM
But got this once entered in:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax near ';
CREATE TABLE attachmentviews (
attachmentid INT UNSIGNED NOT NULL DEFAULT ' at line 1
DROP TABLE IF EXISTS attachmentviews;
CREATE TABLE attachmentviews (
attachmentid INT UNSIGNED NOT NULL DEFAULT '0',
KEY postid (attachmentid)
);
I installed:
vbseo sitemaps last night.
Ive uninstalled it and still seems to be problems.
what does ssh telnet into server and typing this result in output
mysqlcheck -s mysqlusername -p forumdatabasename
you can ignore session table related error messages
any errors for attachment table ? any hacks installed ?
Database error in vBulletin 3.5.0:
Invalid SQL:
SELECT SUM(filesize) AS size FROM attachment;
MySQL Error : Can't find file: './forums/attachment.frm' (errno: 990)
Error Number : 1017
Date : Tuesday, November 29th 2005 @ 08:06:16 PM
Script : http://domain.co.uk/admincp/index.php?do=home
Referrer : http://domain.co.uk/admincp/index.php?do=nav
IP Address : 81.179.196.43
Username : Bill
Classname : vb_database
http://members.vbulletin.com/membersupport_contactform.php
Be sure to include the login info to your Admin CP, phpMyAdmin and FTP. Please also include a complete description of the problem.
#If you have any other info about this subject , Please add it free.# |
