PDA

View Full Version : Trouble Upgrading from 3.5.3 to 3.6.1



cartooner
Sun 17th Sep '06, 10:47pm
I got this message part way through uploading files to my server..

Database error in vBulletin 3.5.3:
Invalid SQL:
SELECT eventid, userid, event.title, recurring, recuroption, dateline_from, dateline_to, event.calendarid, IF (dateline_to = 0, 1, 0) AS singleday,
dateline_from AS dateline_from_user, dateline_to AS dateline_to_user, utc, dst
FROM vb3_event AS event
INNER JOIN vb3_calendar AS calendar USING (calendarid)
WHERE ((dateline_to >= 1158373956 AND dateline_from < 1158719556) OR (dateline_to = 0 AND dateline_from >= 1158373956 AND dateline_from <= 1158719556 ))
AND visible = 1
AND calendar.options & 512
ORDER BY dateline_from;
MySQL Error : Unknown column 'dst' in 'field list'
Error Number : 1054
Date : Sunday, September 17th 2006 @ 07:32:36 PM
Script : http://www.edtoonsboard.com/
Referrer : http://www.edtoonsboard.com/
IP Address : 71.86.218.47
Username : cartooner
Classname : vB_Database

I didn't edit the config.php.new file because instructions said one upgrading from 3.5.3 to 3.6. 1 it wasn't necassary...

What am I doing wrong...also I didn't delete the old Intal directory before uploading....because it didn't have an install.php file in it..

I need help..

if you go to http://www.edtoonsboard.com..you'll see the above message error message..

cartooner
Mon 18th Sep '06, 12:15am
ok..i got rid of that error message by editing the config.php file.but i still can't get in as ADMIN...

when I point my browser to my board it Cannot Find Server.....

i contacted the server company and confirmed all the info is correct in the config.php file

I have MySql 4,1,2 and PHP 5.0.2

All the info in the config file is same as when I was running 3.5.3..

cartooner
Mon 18th Sep '06, 12:32am
I did get ahold of server company, they looked at config file and everything is ok for server info. I was wondering when I did the install I did not delete the INSTALL folder. I thought it wasn't necessary because there was no install.php file.


Should I delete the Install directory and try again. or is it ok to overwrite the install folder.

Steve Machol
Mon 18th Sep '06, 3:30pm
What error are you getting now? The one in post #1 is because you had not run the upgrade scripts yet.