Loading...
 
Architecture / Installation

Architecture / Installation


Re: SERIOUS ISSUE: Upgrade gives "Unknown column 'version_minor' in 'field list'" error

posts: 1817 Catalan Countries

For some reason, this partial sql command didn't work in your case:

Copy to clipboard
alter table tiki_pages add column version_minor int(8) NOT NULL DEFAULT 0;


It did work for me in a test on a 2.0 db (on GNU/Linux), but in case it doesn't work for you (case conflict? most upgrade scripts use upper case commands except this, it seems), you can try with this:

Copy to clipboard
ALTER TABLE `tiki_pages` ADD `version_minor` int(8) NOT NULL default '0' AFTER `version`;

which was my initial patch, until I saw that there was already the previous one in lower case already in

installer/schema/20090808_add_wiki_minor_edits_tiki.sql

Please, report back if the lower case command doesn't work for you.

HTH

There are no comments at this time.