++++ .. I was happily adding links to my db and I suddenly get the following error message ..
Code:
Database error in vBulletin 3.0.3:
Invalid SQL:
SELECT DISTINCT link.linkid AS linkid, link.linkname AS linkname, link.linkuserid AS linkuserid,
link.linkusername AS linkusername, link.linkurl AS linkurl, link.linkimg AS linkimg, link.linkdesc AS linkdesc,
link.linkhits AS linkhits, link.linkstatus AS linkstatus, link.linkdate AS linkdate,
link.linkmoderate AS linkmoderate,
ltoc.catid AS linkcatid, ltoc.displayorder AS linkdorder, ltoc2.catid AS linkcatid2
FROM (local_linkslink AS link
LEFT JOIN local_linksltoc AS ltoc
ON link.linkid = ltoc.linkid)
LEFT JOIN local_linksltoc AS ltoc2
ON link.linkid = ltoc2.linkid
WHERE
ltoc.catid = '6'
AND link.linkforum NOT IN (0)
ORDER BY linkdorder ASC, linkname ASC, linkcatid ASC
mysql error: Can't open file: 'local_linkslink.MYD'. (errno: 145)
mysql error number: 1016
Date: Monday 16th of May 2005 10:40:41 AM
Script: /local_links.php?catid=6
Referer: /local_links.php?action=links&catid=-1
Username: Slave
IP Address: 81.433.23.12
So I go and have a look at the local_linkslink table within the db and it's empty! and semingly corrupted ..
So a quick reminder to peeps to keep things backed up .. just in case! Luckily I've got a backup from a few days ago I think so it's not too bad ..
AndrewD .. anything in the code that would cause this? .. or have you heard anything like that before?