vbulletin upgrade sorunu | | vbulletinde forumu 3.8.4 den 4.0.2 ye upgrade etmiştim..
sonra 3.8.4'e geri dönmek zorunda kaldım geri 3.8.4 dosyaları yükledim.. ama admin panelinde bazı bölümlerinde şu sorunları aldım..
admin panelinde Alıntı:
Database error in vBulletin 4.0.0 Beta 3:
Invalid SQL:
SELECT SUM(filesize) AS size FROM attachment;
MySQL Error : Unknown column 'filesize' in 'field list'
Error Number : 1054
Request Date : Sunday, August 8th 2010 @ 10:47:49 PM
Error Date : Sunday, August 8th 2010 @ 10:47:49 PM
Script : http://www. xxxxxxx .com/frm/admincp/index.php?do=home
Referrer : http://www. xxxxxxx .com/frm/admincp/index.php?do=nav
| panelde eklenti yönetiminde Alıntı:
Database error in vBulletin 4.0.0 Beta 3:
Invalid SQL:
SELECT user.username, post.username AS postusername, attachment.filename, attachment.postid, thread.forumid, thread.threadid, attachment.thumbnail_dateline,
attachment.attachmentid, IF(thumbnail_filesize > 0, 1, 0) AS hasthumbnail, thumbnail_filesize, attachment.filesize, attachment.dateline
FROM attachment AS attachment
LEFT JOIN post AS post ON (attachment.postid = post.postid)
LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)
LEFT JOIN user AS user ON (attachment.userid = user.userid)
WHERE thread.forumid IN(562, 563, 564, 565, 566, 567, 568, 569, 570, 571, 572, 573, 574, 575, 576, 577, 578, 579, 580, 581, 582, 583, 584, 585, 586, 587, 588, 589, 590, 591, 592, 593, 594, 595, 596, 597, 598, 599, 600, 601, 602, 603, 604, 605, 606, 607, 608, 609, 610, 611, 612, 613, 615, 616, 617, 618, 619, 620, 630, 621, 622, 623, 624, 625, 626, 627, 628, 629) AND attachment.visible = 0 AND attachment.postid <> 0;
MySQL Error : Unknown column 'thumbnail_filesize' in 'field list'
Error Number : 1054
Request Date : Sunday, August 8th 2010 @ 10:53:20 PM
Error Date : Sunday, August 8th 2010 @ 10:53:20 PM
Script : http://www. xxxx .com/frm/modcp/moderate.php?do=attachments
Referrer : http://www. xxx .com/frm/admincp/index.php?do=nav
| bu sorunu nasıl çözerim yardım eder misiniz?..
her yerde sorun var sanırım..
forumda Alıntı:
Database error in vBulletin 4.0.0 Beta 3:
Invalid SQL:
SELECT * FROM search AS search
WHERE searchhash = '0cfb82747cf1fdb3ace7d1a761d2648f'
AND userid = 4
AND completed = 1;
MySQL Error : Table 'benimdatabase.search' doesn't exist
Error Number : 1146
Request Date : Sunday, August 8th 2010 @ 11:00:33 PM
Error Date : Sunday, August 8th 2010 @ 11:00:33 PM
Script : http://www. xxx .com/frm/search.php?do=process
Referrer : http://www. xxxx.com/frm/group.php
| Alıntı:
Database error in vBulletin 4.0.0 Beta 3:
Invalid SQL:
SELECT album.*,
picture.pictureid, picture.extension, picture.idhash, album.moderation,
picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height
FROM album AS album
LEFT JOIN picture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0)
WHERE album.userid = 3
AND album.state IN ('public', 'private', 'profile')
AND (album.visible > 0 OR album.moderation > 0)
ORDER BY album.lastpicturedate DESC
LIMIT 2;
MySQL Error : Table 'benimdatabse.picture' doesn't exist
Error Number : 1146
Request Date : Sunday, August 8th 2010 @ 11:03:32 PM
Error Date : Sunday, August 8th 2010 @ 11:03:32 PM
Script : http://www. xxx .com/frm/member.php?u=3
Referrer : http://www. xxx .com/frm/index.php
|
__________________ Ardında yüz köpek havlamayan kurt , gerçek kurt sayılmaz !
Konu xxx786 tarafından (08-08-2010 Saat 23:28:34 ) değiştirilmiştir..
|