منتدى استراحات زايد

منتدى استراحات زايد (http://vb.ma7room.com/index.php)
-   منتدى أخبار المواقع والمنتديات العربية والأجنبية (http://vb.ma7room.com/forumdisplay.php?f=183)
-   -   Forum Album crashing the forum? (http://vb.ma7room.com/showthread.php?t=358347)

محروم.كوم 03-17-2010 11:50 AM

Forum Album crashing the forum?
 
I just tried to load my test installation of VB4 (the suite), and when I try to go to the forum homepage it crashes and I get this in my e-mail:
Code:
Database error in vBulletin 4.0.2:

Invalid SQL:

SELECT albumpicture.*, album.*, user.username, user.usergroupid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM vb4_2_attachment AS albumpicture
LEFT JOIN vb4_2_album AS album ON(album.albumid = albumpicture.contentid)
LEFT JOIN vb4_2_user AS user ON(user.userid = album.userid)
WHERE album.state = 'public' and albumpicture.contenttypeid = 8
ORDER BY rand(NOW()) DESC LIMIT 0, 5;

MySQL Error : Got error 28 from storage engine
Error Number : 1030
Request Date : Wednesday, March 17th 2010 @ 12:17:44 AM
Error Date : Wednesday, March 17th 2010 @ 12:17:44 AM
Script : http://test.mydomain.com/forum.php
Referrer : http://www.mydomain.com/
IP Address : 180.5.25.22
Username : Webbstre
Classname : vB_Database
MySQL Version : 5.1.39-log
I'm not sure what to do about this. I haven't done any changes in several days, and I know for a fact that it loaded just fine yesterday. The CMS page loads fine, as does my installation of DownloadsII and VaultWiki, but the Forum and Blogs pages crash. I notice in the top one it mostly appears to mention album stuff. Here is the error message for the blog:

Code:
Database error in vBulletin 4.0.2:

Invalid SQL:

SELECT blog.blogid, user.username, blogtextid, blog.title, blog_text.dateline, blog_text.pagetext, user.*, blog_user.title AS blogtitle, blog_text.title AS commenttitle,
blog_text.state,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid, options_ignore, options_buddy, options_member, options_guest
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM vb4_2_blog_text AS blog_text
LEFT JOIN vb4_2_blog AS blog ON (blog.blogid = blog_text.blogid)
LEFT JOIN vb4_2_user AS user ON (user.userid = blog_text.userid)
LEFT JOIN vb4_2_blog_user AS blog_user ON (blog_user.bloguserid = blog.userid)

LEFT JOIN vb4_2_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb4_2_customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE blog.state IN('visible', 'moderation')
AND blog.dateline = 1268205682
ORDER BY blog_text.dateline DESC
LIMIT 10;

MySQL Error : Got error 28 from storage engine
Error Number : 1030
Request Date : Wednesday, March 17th 2010 @ 12:21:22 AM
Error Date : Wednesday, March 17th 2010 @ 12:21:24 AM
Script : http://test.mydomain.com/blog.php
Referrer : http://www.mydomain.com/
IP Address : 180.5.25.22
Username : Webbstre
Classname : vB_Database
MySQL Version : 5.1.39-log
Any help?

Update: It happens when I go to my profile too, but not the admin panel.
Code:
Database error in vBulletin 4.0.2:

Invalid SQL:

SELECT user.*, (user.options & 512) AS invisible , avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, customavatar.filedata_thumb, customavatar.height AS avheight, customavatar.width AS avwidth, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb

FROM vb4_2_userlist AS userlist
INNER JOIN vb4_2_user AS user ON (user.userid = userlist.relationid)
LEFT JOIN vb4_2_avatar AS avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN vb4_2_customavatar AS customavatar ON (customavatar.userid = user.userid)

WHERE userlist.userid = 1
AND userlist.type = 'buddy'
AND userlist.friend = 'yes'

ORDER BY RAND()
LIMIT 0, 1;

MySQL Error : Got error 28 from storage engine
Error Number : 1030
Request Date : Wednesday, March 17th 2010 @ 12:28:03 AM
Error Date : Wednesday, March 17th 2010 @ 12:28:04 AM
Script : http://test.mydomain.com/member.php/1-Webbstre
Referrer : http://test.mydomain.com/search.php?do=getnew&contenttype=vBForum_Post
IP Address : 180.5.25.22
Username : Webbstre
Classname : vB_Database
MySQL Version : 5.1.39-log


الساعة الآن 10:01 PM

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.5.2 TranZ By Almuhajir


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227