Geeklog Forums

I have tried several times to upgrade my version 1.4.1 to 1.5 cvs. Every time I get an error stating:
1060: Duplicate column name 'rdf_last_modified'

Anyone else run into this and have a solution?
Can anyone tell me where this table is located so I can see if it exists in 1.4.1? (maybe I can delete it before the upgrade)

I have backed up my db and restored it each time I have tried to upgrade. I have used 1.5 before with major problems but I was going to try it again on a test site but can't get it to install now.

If I don't restore the backup and just refresh the page after the 1060 error, I get:
1051: Unknown table 'gl_tzcodes'
(back page and run update again)
An SQL error has occurred. Please see error.log for details.
(I have turned on debugging in config.php and siteconfig.php but still get the generic error and the error.log is empty)
(try to update again without restoring db and it says the db is already updated)
Enter site and get the generic sql error with both debugging settings above on)

I would prefer not to have to do a clean install and manually add all the stories and other components on my site.

The rdf_last_modified field (in the gl_blocks table) was only added in 1.5.0. Are you saying it exists in your 1.4.1 database? Did you experiment with CVS versions before?

bye, Dirk

I did at one time but I do believe that this install of 1.4.1 is and should be just 1.4.1. When first attempting to upgrade it totally toasted the site and I had to start from scratch. I'm pretty sure that none of the original 1.5 tables were installed. I started with a totally empty db and installed 1.4.1 and all the plugins.

I have checked the blocks table on the original 1.4.1 site and yes the table is in there... all with null values.
Were all the rdf columns added in 1.5 or just the 'rdf_last_modified'?
I also have rdfurl, rdfupdated, rdf_etag and rdflimit.

I guess somehow I have some of the tables mixed with 1.5 .. can't figure out how but I guess I do

I deleted the rdf_last_modified and rdf_etag now I'm getting 1060: Duplicate column name 'commentcode'

I checked the obvious gl_usercomment, gl_commentcodes, gl_commentmodes and gl_comments but I don't see that column.
can you help me out ... do you know of any other columns that were added or should I just keep posting each time I get a duplicate if I can't find the column myself?

sql/updates/mysql_1.4.1_to_1.5.0.php contains all the DB changes from 1.4.1 to 1.5.0 - there are quite a few.

The commentcodes is probably from that Static Pages plugin, which got comments in 1.5.0.

bye, Dirk

Ok thanks,

I think I figured out how the tables got mixed. When I remade the site I think I may have imported the blocks, stories, polls and static pages from the original db... which probably had the updated tables

I will go through the update file and see what I need to remove and see where that gets me. Thanks for the help I may have to get back to you in a bit if I run into any more difficulties..

And yeah, I did find the column in static pages and also in stories and polls