Forum Lots of errors for my forums

محروم.كوم · #1 04-29-2010, 01:40 PM

I am getting errors for my two licenced products. What must I do?

I am getting lots of errors for database in my 2 licenced vBulletin 4.0 products:

Database error in vBulletin :

Invalid SQL:

SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache','userstats','birthdaycach e','maxloggedin','iconcache','eventcache','mailque ue');

MySQL Error : Incorrect information in file: './islamveb_burgutorum/datastore.frm'
Error Number : 1033
Request Date : Thursday, April 29th 2010 @ 12:18:11 PM
Error Date : Thursday, April 29th 2010 @ 12:18:11 PM
Script : http://www.islamvebiz.net/ivbforum/
Referrer :
IP Address : 204.236.249.179
Username :
Classname : vB_Database
MySQL Version :

-----------------------------------------------------------

Database error in vBulletin 4.0.1:

Invalid SQL:

SELECT tagcontent.tagid, tag.tagtext, COUNT(*) AS searchcount
FROM tagcontent AS tagcontent
INNER JOIN tag AS tag ON (tagcontent.tagid = tag.tagid)
INNER JOIN blog AS blog ON (tagcontent.contenttypeid = 15 AND tagcontent.contentid = blog.blogid)
INNER JOIN blog_user AS blog_user ON (blog.userid = blog_user.bloguserid)

WHERE blog.dateline 1240860312
GROUP BY tagcontent.tagid, tag.tagtext
ORDER BY searchcount DESC
LIMIT 70;

MySQL Error : Incorrect information in file: './islamveb_iandus9/tagcontent.frm'
Error Number : 1033
Request Date : Tuesday, April 27th 2010 @ 10:25:12 PM
Error Date : Tuesday, April 27th 2010 @ 10:25:12 PM
Script : http://www.islamvebiz.net/islamandusforum/blog.php
Referrer : http://www.islamvebiz.net/islamandusforum/forum.php
IP Address : 78.162.52.4
Username : Unregistered
Classname : vB_Database
MySQL Version :

------------------------------------

Database error in vBulletin 4.0.1:

Invalid SQL:

SELECT data.tagid, data.tagtext, SUM(data.searchcount) AS searchcount
FROM
(
SELECT tagcontent.tagid, tag.tagtext, COUNT(*) AS searchcount
FROM tagcontent AS tagcontent
INNER JOIN tag AS tag ON (tagcontent.tagid = tag.tagid) INNER JOIN thread AS thread ON (tagcontent.contentid = thread.threadid)
WHERE tagcontent.contenttypeid IN (2) AND
tagcontent.dateline > 1240860293 AND thread.open 10 AND thread.visible = 1 AND thread.forumid IN (3,1,2,173,174,269,430,4,5,6,7,8,9,10,11,12,13,14, 118,117,170,172,183,184,185,186,15,16,17,73,74,18, 19,75,76,77,78,79,80,81,82,83,84,85,86,87,20,21,22 ,88,89,90,23,24,25,91,92,26,187,188,189,190,27,28, 29,30,31,32,33,34,35,93,94,95,96,97,36,37,38,39,40 ,41,98,99,100,163,164,165,166,167,168,169,171,175, 177,178,179,180,181,182,235,283,284,285,286,287,28 8,289,290,291,292,293,294,295,296,297,299,300,298, 301,42,43,120,119,121,122,123,124,125,126,127,130, 135,143,337,338,339,340,341,342,343,344,345,346,34 7,44,359,360,361,362,363,364,365,366,367,368,369,3 70,371,372,373,374,375,376,377,378,379,380,381,45, 46,47,144,145,316,317,318,319,320,321,322,323,324, 325,326,327,328,329,330,331,332,333,334,335,336,48 ,382,383,384,385,386,387,388,389,390,391,392,393,3 94,395,396,397,398,399,400,401,402,403,404,49,128, 129,131,132,133,134,136,137,138,139,140,141,142,34 8,349,350,351,352,353,354,355,356,357,358,405,406, 407,408,409,410,411,412,413,414,415,416,417,418,41 9,420,421,422,423,424,425,426,427,428,429,50,51,10 1,102,52,103,104,105,53,55,56,57,58,106,107,59,60, 61,62,63,64,65,66,108,109,110,67,68,69,70,71,72,11 1,112,146,147,148,149,150,151,152,153,154,155,156, 157,158,159,160,161,162,176,191,192,195,196,197,19 8,199,200,201,202,203,193,204,205,206,207,208,209, 210,211,194,212,213,214,215,217,218,219,216,220,22 1,222,223,224,225,226,227,228,229,230,231,232,233, 234,236,237,238,239,240,241,242,243,244,245,246,24 7,248,249,250,251,252,253,254,255,256,257,258,259, 260,261,262,263,264,265,266,267,268,270,271,272,27 3,274,275,276,277,278,279,280,281,282,302,303,304, 305,306,307,308,309,310,311,312,313,314,315)

GROUP BY tagcontent.tagid, tag.tagtext
UNION ALL
SELECT tagcontent.tagid, tag.tagtext, COUNT(*) AS searchcount
FROM tagcontent AS tagcontent
INNER JOIN tag AS tag ON (tagcontent.tagid = tag.tagid) JOIN cms_node AS cms_node ON
tagcontent.contenttypeid = cms_node.contenttypeid AND tagcontent.contentid = cms_node.contentid

WHERE tagcontent.contenttypeid IN (1 AND
tagcontent.dateline > 1240860293 AND cms_node.publishdate < 1272396293
GROUP BY tagcontent.tagid, tag.tagtext
) AS data
GROUP BY data.tagid, data.tagtext
ORDER BY searchcount DESC
LIMIT 30;

MySQL Error : Incorrect information in file: './islamveb_iandus9/tagcontent.frm'
Error Number : 1033
Request Date : Tuesday, April 27th 2010 @ 1053 PM
Error Date : Tuesday, April 27th 2010 @ 1053 PM

Script : http://www.islamvebiz.net/islamandusforum/forum.php
Referrer : SMILING FACE OF ISLAM - Hello world
IP Address : 78.162.52.4
Username : Unregistered
Classname : vB_Database
MySQL Version __DEFINE_LIKE_SHARE__