daydie
05-25-2010, 08:56 AM
hey guys, i got this error when i tryed to repair all the tables from admincp....
Database error in vBulletin 3.8.0:
Invalid SQL:
SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS threadiconid,
thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
thread.prefixid, thread.taglist, hiddencount, deletedcount
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
, threadredirect.expires
, post_user.displaygroupid AS post_user_displaygid, post_user.usergroupid AS post_user_usergid, last_post_user.displaygroupid AS last_post_user_displaygid, last_post_user.usergroupid AS last_post_user_usergid
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
LEFT JOIN user AS last_post_user ON (thread.lastposter = last_post_user.username)
LEFT JOIN user AS post_user ON (thread.postuserid = post_user.userid)
WHERE thread.threadid IN (0,529338,529336,529333,529332,529331,529325,52932 4,529314,529313,529311,529309,529304,529301,529294 ,529286,529278,529274,529271,529267,529265,8888)
ORDER BY sticky DESC, lastpost DESC;
MySQL Error : Table './daydiee/post' is marked as crashed and last (automatic?) repair failed
Error Number : 144
Request Date : Tuesday, May 25th 2010 @ 03:51:48 AM
Error Date : Tuesday, May 25th 2010 @ 03:51:49 AM
Script : http://daydie.co.uk/download-games-f365/
Referrer : http://daydie.co.uk/
IP Address : xxx-xxx-xxx-xxx
Username : daydie
Classname : vB_Database
MySQL Version : 5.0.91-log
in the post table it has 0 data in. is there any way i can get this working again. when i try view a thread or forum i get this SQL error.
please help
--------------- Added 1274781587 at 1274781587 ---------------
------------------------
i have just tryed re-creating the post databse via install but had no luck, this is what i got back:
Step 3) Creating Tables
Resetting database...
* Removing post table
* Creating access table
Database Error Database error
The database has encountered a problem.
Please try the following:
o Load the page again by clicking the Refresh button in your web browser.
o Open the daydie.co.uk home page, then try to open another page.
o Click the Back button to try another link.
The daydie.co.uk forum technical staff have been notified of the error, though you may contact them if the problem persists.
We apologise for any inconvenience.
Database error in vBulletin : Invalid SQL: CREATE TABLE access ( userid INT UNSIGNED NOT NULL DEFAULT '0', forumid SMALLINT UNSIGNED NOT NULL DEFAULT '0', accessmask SMALLINT UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY userid (userid, forumid) ); MySQL Error : Table 'access' already exists Error Number : 1050 Request Date : Tuesday, May 25th 2010 @ 03:58:35 AM Error Date : Tuesday, May 25th 2010 @ 03:58:36 AM Script : http://daydie.co.uk/install/install.php?do= Referrer : http://daydie.co.uk/install/install.php?step=3&emptydb=true IP Address : 81.105.142.155 Username : Classname : vB_Database MySQL Version : 5.0.91-log
i think it was trying to make access table, even tho i only ticked post table to be deleted and re-created.
--------------- Added 1274782237 at 1274782237 ---------------
i deleted the database, can anybody please help me re-build the basic of the post table. as the install cant do it as it tryed to creat all databases and cant becuase the old ones are still there.
Database error in vBulletin 3.8.0:
Invalid SQL:
SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS threadiconid,
thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
thread.prefixid, thread.taglist, hiddencount, deletedcount
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
, threadredirect.expires
, post_user.displaygroupid AS post_user_displaygid, post_user.usergroupid AS post_user_usergid, last_post_user.displaygroupid AS last_post_user_displaygid, last_post_user.usergroupid AS last_post_user_usergid
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
LEFT JOIN user AS last_post_user ON (thread.lastposter = last_post_user.username)
LEFT JOIN user AS post_user ON (thread.postuserid = post_user.userid)
WHERE thread.threadid IN (0,529338,529336,529333,529332,529331,529325,52932 4,529314,529313,529311,529309,529304,529301,529294 ,529286,529278,529274,529271,529267,529265,8888)
ORDER BY sticky DESC, lastpost DESC;
MySQL Error : Table './daydiee/post' is marked as crashed and last (automatic?) repair failed
Error Number : 144
Request Date : Tuesday, May 25th 2010 @ 03:51:48 AM
Error Date : Tuesday, May 25th 2010 @ 03:51:49 AM
Script : http://daydie.co.uk/download-games-f365/
Referrer : http://daydie.co.uk/
IP Address : xxx-xxx-xxx-xxx
Username : daydie
Classname : vB_Database
MySQL Version : 5.0.91-log
in the post table it has 0 data in. is there any way i can get this working again. when i try view a thread or forum i get this SQL error.
please help
--------------- Added 1274781587 at 1274781587 ---------------
------------------------
i have just tryed re-creating the post databse via install but had no luck, this is what i got back:
Step 3) Creating Tables
Resetting database...
* Removing post table
* Creating access table
Database Error Database error
The database has encountered a problem.
Please try the following:
o Load the page again by clicking the Refresh button in your web browser.
o Open the daydie.co.uk home page, then try to open another page.
o Click the Back button to try another link.
The daydie.co.uk forum technical staff have been notified of the error, though you may contact them if the problem persists.
We apologise for any inconvenience.
Database error in vBulletin : Invalid SQL: CREATE TABLE access ( userid INT UNSIGNED NOT NULL DEFAULT '0', forumid SMALLINT UNSIGNED NOT NULL DEFAULT '0', accessmask SMALLINT UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY userid (userid, forumid) ); MySQL Error : Table 'access' already exists Error Number : 1050 Request Date : Tuesday, May 25th 2010 @ 03:58:35 AM Error Date : Tuesday, May 25th 2010 @ 03:58:36 AM Script : http://daydie.co.uk/install/install.php?do= Referrer : http://daydie.co.uk/install/install.php?step=3&emptydb=true IP Address : 81.105.142.155 Username : Classname : vB_Database MySQL Version : 5.0.91-log
i think it was trying to make access table, even tho i only ticked post table to be deleted and re-created.
--------------- Added 1274782237 at 1274782237 ---------------
i deleted the database, can anybody please help me re-build the basic of the post table. as the install cant do it as it tryed to creat all databases and cant becuase the old ones are still there.