Posted on: 11/23/04 12:59pm
By: Anonymous (jimphelps)
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
Upgrade 10.3.9sr2 to 10.3.10rc4 error: 1060: Duplicate column name 'lft'
Posted on: 11/23/04 01:35pm
By: Dirk
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
Upgrade 10.3.9sr2 to 10.3.10rc4 error: 1060: Duplicate column name 'lft'
Posted on: 11/23/04 02:17pm
By: jimphelps
Thanks Dirk. Will do.
- Jim
Upgrade 10.3.9sr2 to 10.3.10rc4 error: 1060: Duplicate column name 'lft'
Posted on: 11/24/04 05:47pm
By: Anonymous (DeCEiVeR)
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..
Upgrade 10.3.9sr2 to 10.3.10rc4 error: 1060: Duplicate column name 'lft'
Posted on: 11/25/04 02:00am
By: Dirk
Make sure you've updated your config.php. STORY_ARCHIVE_ON_EXPIRE is defined as a constant there.
bye, Dirk
Upgrade 10.3.9sr2 to 10.3.10rc4 error: 1060: Duplicate column name 'lft'
Posted on: 11/27/04 12:46am
By: Anonymous (DeCEiVeR)
[QUOTE BY= Dirk] Make sure you've updated your config.php. STORY_ARCHIVE_ON_EXPIRE is defined as a constant there.
bye, Dirk[/QUOTE]
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?
Upgrade 10.3.9sr2 to 10.3.10rc4 error: 1060: Duplicate column name 'lft'
Posted on: 11/27/04 03:52am
By: Dirk
[QUOTE BY= DeCEiVeR] 1044: Access denied for user: 'my UIDr@.%' to database 'myDB'. SQL in question: LOCK TABLES gl_comments WRITE[/QUOTE]
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
Upgrade 10.3.9sr2 to 10.3.10rc4 error: 1060: Duplicate column name 'lft'
Posted on: 11/29/04 03:27pm
By: Anonymous (DeCEiVeR)
[QUOTE BY= Dirk] [QUOTE BY= DeCEiVeR] 1044: Access denied for user: 'my UIDr@.%' to database 'myDB'. SQL in question: LOCK TABLES gl_comments WRITE[/QUOTE]
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[/QUOTE]
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.
Upgrade 10.3.9sr2 to 10.3.10rc4 error: 1060: Duplicate column name 'lft'
Posted on: 11/29/04 03:47pm
By: Dirk
[QUOTE BY= DeCEiVeR] Why would comments in 1.3.9 work but fail in version 1.3.10rc3?[/QUOTE]
Because the comment code in 1.3.10 has undergone major changes.
[QUOTE BY= DeCEiVeR] My hosting service (godaddy) said they can't grant me those permissions because it is a global flag.[/QUOTE]
Hmm. To my knowledge, this is just another permission, just like the one to create tables, insert records, etc:
[QUOTE BY= MySQL manual] As of MySQL 4.0.2, to use LOCK TABLES you must have the LOCK TABLES privilege and a SELECT privilege for the involved tables. In MySQL 3.23, you must have SELECT, INSERT, DELETE, and UPDATE privileges for the tables.[/QUOTE]
(from the
MySQL Manual[*1] )
bye, Dirk
Upgrade 10.3.9sr2 to 10.3.10rc4 error: 1060: Duplicate column name 'lft'
Posted on: 11/29/04 06:45pm
By: Anonymous (GiAnGy)
I have upgraded 1.3.10rc2 to 1.3.10 but I have the same error.
Why? 1060: Duplicate column name 'lft'
Regards
Upgrade 10.3.9sr2 to 10.3.10rc4 error: 1060: Duplicate column name 'lft'
Posted on: 11/30/04 03:29pm
By: Dirk
[QUOTE BY= GiAnGy] I have upgraded 1.3.10rc2 to 1.3.10 but I have the same error.[/QUOTE]
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
Upgrade 10.3.9sr2 to 10.3.10rc4 error: 1060: Duplicate column name 'lft'
Posted on: 11/30/04 06:03pm
By: Anonymous (GiAnGy)
Ah okey,thanks Dirk!
Upgrade 10.3.9sr2 to 10.3.10rc4 error: 1060: Duplicate column name 'lft'
Posted on: 12/16/04 06:03pm
By: Anonymous (horseflesh)
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.
Upgrade 10.3.9sr2 to 10.3.10rc4 error: 1060: Duplicate column name 'lft'
Posted on: 10/18/05 11:45pm
By: Anonymous (Ghost)
The following should fix it, for those who have access to grant privileges:
grant lock tables on geeklog.* to 'login'@'host' identified by 'password';