I have a a very big Problem. I have 3.5.4 version of vbulletin in my forum. Yesterday i try tu upgrade it to 3.6.0. Y download the version in this forum, i upload all the filles. Then i run the sm-chek, and sm-keygen. When i tried to upgarde , the lisencese number is required. I try again with the key gen , but it dont validate. One thing the key gen run well, becase it give me de lisennce and customer number. If i put this number in the valdiaton , it didnt work. So i check this forum and i download the autetication.php file, becase a lot of people have this problem. When i upload, and run again the upgrade, the same happens. VALIDATION IS REQUIRED. Now i cant do anathing becase my SQL was modified, if i upload again the 3.6.0. the same happens, and if a upload. THE SAME FILES, like before with the 3.5.4 , i cant see the index, but i see the forum.php, but i cant see the treads.
I have the buck up of the sql. BUT IT IS VERY BIG, and it hard that i cant upload again. Is a way to modified the sql , to run the 3.5.4 like before. or tu upgrde.
Here i put the errors.
Database error in vBulletin 3.5.4:
Invalid SQL:
SELECT IF(votenum >= 1, votenum, 0) AS numbvote, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg,
thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext, allowsmilie
,thread.iconid AS threadiconid, iconpath AS threadiconpath
FROM thread AS thread
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN post_parsed AS post_parsed ON (post_parsed.postid = post.postid AND post_parsed.styleid_code = -1 AND post_parsed.styleid_html = -1 AND post_parsed.styleid_php = -1 AND post_parsed.styleid_quote = -1)
LEFT JOIN icon AS icon ON (icon.iconid = thread.iconid)
WHERE thread.threadid IN(829,852)
AND thread.forumid NOT IN(34,46,47,48)
GROUP BY post.postid
ORDER BY sticky DESC,thread.dateline DESC
LIMIT 10;
MySQL Error : Table 'comunidadunder.post_parsed' doesn't exist
Error Number : 1146
Date : Tuesday, October 24th 2006 @ 11:11:32 AM
Script :
http://www.comunidad-under.com.ar/index.php
Referrer :
IP Address : 201.240.229.136
Username : Unregistered
Classname : vB_Database
Database error in vBulletin 3.5.4:
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,
level,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
post_parsed.pagetext_html, post_parsed.hasimages,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
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 reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid AND post_parsed.styleid_code = -1 AND post_parsed.styleid_html = -1 AND post_parsed.styleid_php = -1 AND post_parsed.styleid_quote = -1)
WHERE post.postid IN (0,292,782,872)
ORDER BY post.dateline;
MySQL Error : Table 'comunidadunder.post_parsed' doesn't exist
Error Number : 1146
Date : Tuesday, October 24th 2006 @ 06:25:13 AM
Script :
http://www.comunidad-under.com.ar/showthread.php?t=251
Referrer :
IP Address : 66.249.72.2
Username : Unregistered
Classname : vB_Database
THANKSSSSSSSS
Problem With Sql "important"
