PDA

View Full Version : SQL error can some one help


VBUsers
10-26-2005, 05:21 AM
i just upgraded to 3.5.0 from 3.0.6 and i have nothing but errors. this version has given me the most problem out of all of em. i cant see much or login to my forum thru admincp

Database error in vBulletin 3.5.0:

Invalid SQL:

SELECT ranklevel AS l, minposts AS m, rankimg AS i, type AS t, stack AS s, display AS d, ranks.usergroupid AS u
FROM smora_ranks AS ranks
LEFT JOIN smora_usergroup AS usergroup USING (usergroupid)
ORDER BY ranks.usergroupid DESC, minposts DESC;

MySQL Error : Unknown column 'stack' in 'field list'
Error Number : 1054
Date : Wednesday, October 26th 2005 @ 01:10:21 AM

also this one

Database error in vBulletin 3.5.0:

Invalid SQL:

SELECT languageid,
phrasegroup_posting AS phrasegroup_posting,
phrasegroup_postbit AS phrasegroup_postbit,
phrasegroup_showthread AS phrasegroup_showthread,
phrasegroup_inlinemod AS phrasegroup_inlinemod,
phrasegroup_global AS phrasegroup_global,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM smora_language
WHERE languageid = 1;

MySQL Error : Unknown column 'phrasegroup_inlinemod' in 'field list'
Error Number : 1054

Marco van Herwaarden
10-26-2005, 12:09 PM
Restore a backup and do your upgrade again. This time let it run.

VBUsers
10-26-2005, 08:54 PM
Restore a backup and do your upgrade again. This time let it run.


it will get stuck on the upgrades from 3.5.0. should i upgrade 3.0.7 then 3.0.8- etc. each one at a time??? the upgrade files from the 3.50 dont seem to be working properly with my database.

Marco van Herwaarden
10-26-2005, 09:07 PM
Download fresh 3.5 and try again, or post for support at vb.com like i adviced in the other thread.