Geeklog Forums

When I get to step 2 (click on next) in the upgrade script, I get the following error:

1060: Duplicate column name 'lft'

I am running 10.3.9sr2 with file management plugin (version 1.3) and menu plugin (disabled, 1.6.1) and statics pages (1.4.1).

I've dug through my libcommon.php and config.php and I can't find anything.

Any ideas?

- Jim

Sounds like you've been running the upgrade on the database before. 'lft' is a new field in the comments table that has only been introduced in 1.3.10.

Restore your backup and try again.

bye, Dirk

Thanks Dirk. Will do.

- Jim

I just upgraded and everything was a success but now when I go to my site I get an SQL error, in my log i get ..

Wed Nov 24 16:28:03 2004 - 1054: Unknown column 'STORY_ARCHIVE_ON_EXPIRE' in 'where clause'. SQL in question: SELECT sid,tid,title,expire,statuscode FROM gl_stories WHERE (expire
This has got to be a simple file missing or something, anyone help?

TIA..

Make sure you've updated your config.php. STORY_ARCHIVE_ON_EXPIRE is defined as a constant there.

bye, Dirk

1 last problem I have, and I think I'm good to go.. on the comments for stories, i get the error:

1044: Access denied for user: 'my UIDr@.%' to database 'myDB'. SQL in question: LOCK TABLES gl_comments WRITE

i've talked to my hosting company and they said everything was fine, this only happened after I upgraded from 1.3.9 to 1.3.10. Checked my comment.php file and that is the correct one.

Any idea's dirk?

If your site is running on MySQL 4.x check with your hosting service that the database user has permissions to do table locking. IIRC, this was introduced as a new permission in MySQL 4.0.

bye, Dirk

My hosting service (godaddy) said they can't grant me those permissions because it is a global flag. Why would comments in 1.3.9 work but fail in version 1.3.10rc3?

jeez, this sux if I've lost my comment function.

Because the comment code in 1.3.10 has undergone major changes.


Hmm. To my knowledge, this is just another permission, just like the one to create tables, insert records, etc:


(from the MySQL Manual)

bye, Dirk

I have upgraded 1.3.10rc2 to 1.3.10 but I have the same error.

Why? 1060: Duplicate column name 'lft'

Regards

Did you try to upgrade the database again? That's not necessary - all the Release Candidates and the final version use the same database scheme.

bye, Dirk

Ah okey,thanks Dirk!

The LOCK TABLES bit should be a FAQ. Luckily I came here first when I ran into it after upgrading to 1.3.10.

I am running MySQL 4 and it does look like LOCK TABLES is a global priv. I'm no pro though, I use a mysql admin front end, but that's what it looks like.

The following should fix it, for those who have access to grant privileges:

grant lock tables on geeklog.* to 'login'@'host' identified by 'password';