[wicked] Re: cvs problem

[Craig White]

On Thu, 2005-03-10 at 22:14 -0700, Craig White wrote:
> Now that I updated, when I edited a page and clicked 'save', I am
> getting this error...
> 
> Save Failed: [db_error: message="DB Error: no such field" code=-19
> mode=return level=notice prefix="" info="INSERT INTO wicked_history
> (page_id, page_name, page_text, page_majorversion, page_minorversion,
> version_created, change_author, change_log) SELECT page_id, page_name,
> page_text, page_majorversion, page_minorversion, version_created,
> change_author, change_log FROM wicked_pages WHERE page_name =
> 'ITDepartmentChanges' [nativecode=1054 ** Unknown column 'page_id' in
> 'field list']"]
> 
> I haven't had time to debug and probably won't for a few days but there
> does seem like something got broken in the last week or so.
> 
> >From the error, it appears that you have changed the sql table...
---
indeed and I found the file...

wicked/scripts/upgrades/2005-03-03_page_id.php

and I ran it...didn't work too well.

ended up dropping wicked_pages table and losing all of the data

wicked_history still has data in it though

It's not that I'm so grieved since this is only a play area but it seems
to me that a script that drops a table should have a warning to back up
the data and require you to type 'Y-E-S' before executing to allow you
to consider a backup.

Craig