2 gün önce 3.6xden 3.8x'e geçtim. 2 gündür aynı hatayı alıyorum ve forumum kapalı 2 gündür anasayfa dışında hiçbir yere erişemiyorum. Lütfen yardım edin. Öğrenci olmasaydım bu işi sizden ücretli talep ederdim fakat bunun içinde pek param yok. Yapacağınız yardım için dilerseniz foruma banner, link vb. şeyler ekleyebilirim.
Konuya girmeye çalıştığımda karşılaştığım hata;
Database error in vBulletin 3.8.1:
Invalid SQL:
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
spamlog.postid AS spamlog_postid,
deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason, editlog.hashistory,
postparsed.pagetext_html, postparsed.hasimages,
sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN spamlog AS spamlog ON(spamlog.postid = post.postid)
LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 19 AND postparsed.languageid = 2)
LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 19 AND sigparsed.languageid = 2)
LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
WHERE post.postid IN (0,111140,111142,111189,111223,111236)
ORDER BY post.dateline;
MySQL Error : Table 'genclikn_seref11.spamlog' doesn't exist
Error Number : 1146
Request Date : Friday, May 22nd 2009 @ 09:05:40 AM
Error Date : Friday, May 22nd 2009 @ 09:05:41 AM
Script : http://www.siteadi.com/showthread.php?p=111353
Referrer : http://www.siteadi.com
IP Address : 88.243.223.153
Username : xxx
Classname : vB_Database
MySQL Version : 5.0.45Profile girdiğimde karşılaştığım hata;
Database error in vBulletin 3.8.1:
Invalid SQL:
SELECT COUNT(*)
FROM socialgroup
WHERE creatoruserid = 1
AND moderatedmembers > 0;
MySQL Error : Table 'genclikn_dbadi.socialgroup' doesn't exist
Error Number : 1146
Request Date : Friday, May 22nd 2009 @ 09:07:33 AM
Error Date : Friday, May 22nd 2009 @ 09:07:33 AM
Script : http://www.siteadi.com/usercp.php
Referrer : http://www.siteadi.com
IP Address : 88.243.223.153
Username : xxx
Classname : vB_Database
MySQL Version : 5.0.45Bir üyenin profiline girmeye çalıştığımda aldığım hata
Database error in vBulletin 3.8.1:
Invalid SQL:
SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thumb, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight, sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight, usercsscache.cachedcss, IF(usercsscache.cachedcss IS NULL, 0, 1) AS hascachedcss, usercsscache.buildpermissions AS cssbuildpermissions, IF(userlist1.friend = 'yes', 1, 0) AS isfriend, IF (userlist1.friend = 'pending' OR userlist1.friend = 'denied', 1, 0) AS ispendingfriend, IF(userlist1.userid IS NOT NULL, 1, 0) AS u_iscontact_of_bbuser, IF (userlist2.friend = 'pending', 1, 0) AS requestedfriend, IF(userlist2.userid IS NOT NULL, 1, 0) AS bbuser_iscontact_of_user
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid) LEFT JOIN sigpic AS sigpic ON (user.userid = sigpic.userid) LEFT JOIN usercsscache AS usercsscache ON (user.userid = usercsscache.userid)LEFT JOIN userlist AS userlist1 ON (userlist1.relationid = user.userid AND userlist1.type = 'buddy' AND userlist1.userid = 1)LEFT JOIN userlist AS userlist2 ON (userlist2.userid = user.userid AND userlist2.type = 'buddy' AND userlist2.relationid = 1)
WHERE user.userid = 1;
MySQL Error : Table 'genclikn_dbadi.usercsscache' doesn't exist
Error Number : 1146
Request Date : Friday, May 22nd 2009 @ 09:09:06 AM
Error Date : Friday, May 22nd 2009 @ 09:09:06 AM
Script : http://www.siteadi.com/member.php?u=1
Referrer : http://www.siteadi.com
IP Address : 88.243.223.153
Username : xxx
Classname : vB_Database
MySQL Version : 5.0.45