Database errors - 1 and 28

[bosss]

Will just ask ..maybe someone have solutions or tips ...

On my board (vb 4.2.1 ) I and my users (guests also) get database errors nr.1. and nr. 28 (storage engine problem) ... wrote many times to my hosting and they answered that is no problems from server side ...they inspect and deleted (empty) few times /temp directory but errors still persist ...

Users just get error when click to see some post ...submit score ... post new threads ... no rules and errors just come ... not always!
Have you maybe some idea or some solutions why those errors comes up? Is it possible that some of Your mods (dbtech) causes that?

Vbulletin support also said that is no problem with vb board (maybe some mod or server)!

regards

bosss

 

[Ozzy47]

Is that the entire error?

 

[bosss]

Is that the entire error?

No, I get errors like this

Database error in vBulletin 4.2.1:

Invalid SQL:

SELECT
blog.blogid,
blog.title,
blog.dateline AS publishdate,
blog_text.blogtextid,
blog_text.pagetext AS message

, contenttype.class, attachment.attachmentid as previewimage, fd.width, fd.height

FROM blog AS blog
INNER JOIN blog_text AS blog_text ON (blog_text.blogtextid = blog.firstblogtextid)
LEFT JOIN blog_categoryuser AS cu ON (cu.blogid = blog.blogid)

LEFT JOIN contenttype as contenttype ON (contenttype.class = 'BlogEntry')
LEFT JOIN attachment AS attachment ON ( attachment.contentid = blog.blogid ) AND ( contenttype.contenttypeid = attachment.contenttypeid)

LEFT JOIN filedata as fd ON (attachment.filedataid = fd.filedataid)
WHERE 1=1
AND blog.dateline <= 1368136284
AND blog.state = 'visible'
AND ( cu.blogcategoryid IN (1,5,4,6,2,3))

GROUP BY blog.blogid
ORDER BY blog.dateline DESC
LIMIT 3;

MySQL Error : Got error -1 from storage engine
Error Number : 1030
Request Date : Thursday, May 9th 2013 @ 03:51:24 PM
Error Date : Thursday, May 9th 2013 @ 03:51:25 PM
Script : http://www.mysite.com/vb4/cron.php?rand=1368136283
Referrer : http://www.mysite.com/vb4/index.php?autocom=arcade&do=savescore
IP Address : 109.165.170.189
Username : Unregistered
Classname : vB_Database
MySQL Version :

and like this

Database error in vBulletin 4.2.1:

Invalid SQL:

SELECT
blog.blogid,
blog.title,
blog.dateline AS publishdate,
blog_text.blogtextid,
blog_text.pagetext AS message

, contenttype.class, attachment.attachmentid as previewimage, fd.width, fd.height

FROM blog AS blog
INNER JOIN blog_text AS blog_text ON (blog_text.blogtextid = blog.firstblogtextid)
LEFT JOIN blog_categoryuser AS cu ON (cu.blogid = blog.blogid)

LEFT JOIN contenttype as contenttype ON (contenttype.class = 'BlogEntry')
LEFT JOIN attachment AS attachment ON ( attachment.contentid = blog.blogid ) AND ( contenttype.contenttypeid = attachment.contenttypeid)

LEFT JOIN filedata as fd ON (attachment.filedataid = fd.filedataid)
WHERE 1=1
AND blog.dateline <= 1368134481
AND blog.state = 'visible'
AND ( cu.blogcategoryid IN (1,5,4,6,2,3))

GROUP BY blog.blogid
ORDER BY blog.dateline DESC
LIMIT 3;

MySQL Error : Got error 28 from storage engine
Error Number : 1030
Request Date : Thursday, May 9th 2013 @ 03:21:21 PM
Error Date : Thursday, May 9th 2013 @ 03:21:21 PM
Script : http://www.mysite.com/vb4/register.php
Referrer : http://www.mysite.com/vb4/register.php
IP Address : 176.31.181.186
Username : Unregistered
Classname : vB_Database
MySQL Version :

and like this

Database error in vBulletin 4.2.1:

Invalid SQL:
SELECT c.*,g.gname, g.gcat,g.gwords,u.username,u.usergroupid, cat.password
FROM games_list AS g, games_cats AS cat, games_champs AS c LEFT JOIN user AS u ON(c.champ_name = u.username)
WHERE c.champ_score <> 0 AND c.champ_gid=g.gid AND g.gcat=cat.c_id AND cat.password=''
ORDER BY champ_date DESC LIMIT 0,5;

MySQL Error : Got error -1 from storage engine
Error Number : 1030
Request Date : Thursday, May 9th 2013 @ 03:29:25 PM
Error Date : Thursday, May 9th 2013 @ 03:29:28 PM
Script : http://www.mysite.com/vb4/
Referrer : http://www.mysite.com/vb4/ibproarcade.php?do=play&gameid=2690
IP Address : 109.165.170.189
Username : bambolina
Classname : vB_Database
MySQL Version :

and much more .... all have error 1 or 28

regards

bosss

 

[Ozzy47]

IIRC what that means is a disk partition on your forum server’s hard disk ran out of free disk space.

Contact your web host to immediately report that MySQL server is throwing an error and complaining a disk partition on the server has ran out of disk space. Your web host would have to deal with this.

 

[bosss]

IIRC what that means is a disk partition on your forum server’s hard disk ran out of free disk space.

Contact your web host to immediately report that MySQL server is throwing an error and complaining a disk partition on the server has ran out of disk space. Your web host would have to deal with this.

I contact them 6-10 times ...and always get answer that from server side is ok ...

Here is some of their answers

As this does not seem to be any of the typical reasons for this error, I would recommend you contact us by phone when this error occurs so we can look at the current state of the server, and all of the processes occurring.

Thank you for contacting technical support,

No you will not have access to empty the var folder but if you ever notice it's full please give us a call and we can take care of it right away. The folder being full doesn't happen often as we monitor our system will usually catch the issue before it become a problem. Currently the var folder has a plenty of space so if you are still seeing the error then it's not related to a full var folder.

Perhaps the vBulletin wants a specific storage engine and it can be defined on a per table basis. The two supported storage engines are MyISAM and InnoDB. The MyISAM is the default. Please contact vBulletin to determine the proper storage engine to use, especially for certain tables. Then you can make the necessary change in phpMyAdmin

Unfortunately we have not been able to find anything specific that is causing it. However, if you can contact use when the error is occurring we can investigate if there is an abusive user or the Drive is becoming full, any of the other possible causes.

I sincerely apologize for the trouble. If you have any questions regarding this or anything else, please don't hesitate to ask.

and more....

But on my test site I have some Your mods and my main site (Info panels - top 5 stats and forum tabs) - is it possible that some of those 2 mods causes problems?

regards

bosss

 

[Ozzy47]

No, I do believe they are wrong, here is a article that explains it better than I can.

mysql error: Got error 28 from storage engine – mysql error number: 1030 | vbtechsupport.com

 

[Fillip H.]

Error -1 usually means a bad my.cnf variable: innodb - Mysql 'Got error -1 from storage engine' error - Stack Overflow

 

[bosss]

Thanks for links ...just sent to them!

regards

bosss

 

[Ozzy47]

Let us know what they say, it could be interesting.