i have problem in database server

Portal Home > Knowledgebase > Articles Database > i have problem in database server

Posted by islam mohamed, 11-04-2010, 05:58 PM
hello my.cnf :now my problem with mysql i have problem in some forum and some database error E.G : Database error in vBulletin 3.8.5: Invalid SQL: SELECT eventid, userid, event.title, recurring, recuroption, dateline_from, dateline_to, event.calendarid, IF (dateline_to = 0, 1, 0) AS singleday, customfields, dateline_from AS dateline_from_user, dateline_to AS dateline_to_user, utc, dst FROM event AS event INNER JOIN calendar AS calendar USING (calendarid) WHERE ((dateline_to >= 1288733493 AND dateline_from < 1289079093) OR (dateline_to = 0 AND dateline_from >= 1288733493 AND dateline_from <= 1289079093 )) AND visible = 1 AND calendar.options & 512 ORDER BY dateline_from; MySQL Error : Got error 21 from storage engine Error Number : 1030 Request Date : Thursday, November 4th 2010 @ 04:31:33 PM Error Date : Thursday, November 4th 2010 @ 04:31:35 PM Script : http://*.com/ Referrer : Classname : vB_Database MySQL Version how fix that problem form server info tmp and HHD thanks
Posted by badboyx, 11-04-2010, 07:03 PM
i think its a nulled ( stolen ) copy that's why you are facing troubles i suggest to buy an original copy of VB with support
Posted by islam mohamed, 11-04-2010, 07:25 PM
i need help no need Mockery Thank you Dear and his team on every event
Posted by islam mohamed, 11-04-2010, 07:27 PM
that problem not in forum just but that problem in mysql server coz i open that topic
Posted by Hillockhosting, 11-05-2010, 12:09 AM
You need to enable innodb. Right now I dont see it enabled in your config.
Posted by sirius, 11-05-2010, 02:50 PM
Why do you say that?
Posted by badboyx, 11-06-2010, 08:25 AM
because its possible
Posted by krizag, 11-06-2010, 05:40 PM
you can check if innodb is enabled in the server by mysqladmin variables | grep -i innodb or enter to mysql prompt and issue show engines;
Posted by vB-WP-Admin, 11-07-2010, 07:06 AM
Post your query in server configuration section of vbulletin and George will help you out with the settings.