ANGLICO
03-05-2012, 09:04 PM
This morning, I increased the number of photos that an Admin can store in an album, in order to upload photos from a reunion.
This afternoon, as members begin to access the album, error messages are being generated.
I noticed that the number of active users has dropped to a few percent of the actual total. If I click on my own UserCP or on another user name, I get a similar error messages online to that which I am receiving by emails.
I'd upgrade, I paid for 4 in the pre-release sale, but I can't get a guarantee that we can have a site with the same appearance as today. Wish vBulletin could do that.
But that's off the topic. Will these errors self-correct, or is the database somehow corrupted?
Thanks,
Vance Hall
Database error in vBulletin 3.7.4:
Invalid SQL:
SELECT pm.*, pmtext.*, userlist_ignore.userid AS ignored
,icon.iconpath, icon.title AS icontitle
FROM pm AS pm
INNER JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN userlist AS userlist_ignore ON
(userlist_ignore.userid = 5 AND userlist_ignore.relationid = pmtext.fromuserid AND userlist_ignore.type = 'ignore')
LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid = 5
AND pm.messageread = 0
ORDER BY pmtext.dateline DESC
LIMIT 5;
MySQL Error : Got error 28 from storage engine
Error Number : 1030
This afternoon, as members begin to access the album, error messages are being generated.
I noticed that the number of active users has dropped to a few percent of the actual total. If I click on my own UserCP or on another user name, I get a similar error messages online to that which I am receiving by emails.
I'd upgrade, I paid for 4 in the pre-release sale, but I can't get a guarantee that we can have a site with the same appearance as today. Wish vBulletin could do that.
But that's off the topic. Will these errors self-correct, or is the database somehow corrupted?
Thanks,
Vance Hall
Database error in vBulletin 3.7.4:
Invalid SQL:
SELECT pm.*, pmtext.*, userlist_ignore.userid AS ignored
,icon.iconpath, icon.title AS icontitle
FROM pm AS pm
INNER JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN userlist AS userlist_ignore ON
(userlist_ignore.userid = 5 AND userlist_ignore.relationid = pmtext.fromuserid AND userlist_ignore.type = 'ignore')
LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid = 5
AND pm.messageread = 0
ORDER BY pmtext.dateline DESC
LIMIT 5;
MySQL Error : Got error 28 from storage engine
Error Number : 1030