[wicked] Re: cvs problem

[Jason M. Felice]

Craig White wrote:

>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.
>  
>
Is there an new_wicked_pages table?  The script shouldn't drop the table 
unless it has successfully copied all the pages to the new table.

>Craig
>  
>


-- 
 Jason M. Felice
 Cronosys, LLC <http://www.cronosys.com/>
 216.221.4600 x302