Posted on: 06/17/05 12:27am
By: Anonymous (FreakWorld)
I was forced to move my site.
I had geeklog 1.3.9
I also had a backup of my database.
Well I uploaded the database to the new server and thin tried to update it to 1.3.11 and got that error
1060: Duplicate column name 'lft'
I seen the fix here but my host is not welling to go thou the trouble.
The site well make a new database.
Just not update the old one.
Is there some other way to get it updated.
Can I do it by hand?
If so, what needs to be changed.
2 days trying to fix it.
Posted on: 06/17/05 09:33am
By: Anonymous (FreakWorld)
also finding out that even with a new install, the article.php is not working on this new server.
Any Ideas.
Any links to it go to a 404 page
Not Found
The requested document was not found on this server.
--------------------------------------------------------------------------------
Web Server at freakworld.com
2 days trying to fix it.
Posted on: 06/17/05 09:40am
By: Anonymous (FreakWorld)
if you go strait to the article.php it well go to the index.
Go to comments and you get the 404.
Use the link in admin you get the 404 error.
changing the title don't help.
2 days trying to fix it.
Posted on: 06/17/05 03:27pm
By: Mikez
I just changed my username cuz Google is tracking me.
I am still having the problums and need help.
2 days trying to fix it.
Posted on: 06/17/05 04:06pm
By: Dirk
The 'lft' field was only introduced in Geeklog 1.3.10, so either you've already tried to run the upgrade on that database or it wasn't a 1.3.9 database to begin with. If in doubt, drop the DB, reimport your backup and try again.
The 404 error may have to do with URL rewriting - maybe your new host doesn't support it.
bye, Dirk
2 days trying to fix it.
Posted on: 06/17/05 07:47pm
By: Mikez
I re did the database as much as I can by hand.
But still having a problem with the article.php.
When you click comments or anything like that.
It goes to a 404 page.
Not Found
The requested document was not found on this server.
--------------------------------------------------------------------------------
Web Server at freakworld.com
What on the server well do that?
The article.php file is there and set to 777.
This is not working even with a fresh install.
So it's not me playing with the database.
Any Ideas?
2 days trying to fix it.
Posted on: 06/17/05 08:08pm
By: Mikez
It is the $_CONF['url_rewrite'].
Is there something my host can do to make it work when set to true?
2 days trying to fix it.
Posted on: 06/18/05 07:20am
By: Dirk
[QUOTE BY= Mikez] Is there something my host can do to make it work when set to true?[/QUOTE]
If your site is running on Apache 2, ask them to switch
AcceptPathInfo[*1] to "On".
bye, Dirk
2 days trying to fix it.
Posted on: 06/23/05 06:11am
By: Mikez
Cool I just let them know
2 days trying to fix it.
Posted on: 07/04/05 04:37pm
By: Vapour71
[QUOTE BY= FreakWorld] I was forced to move my site.
I had geeklog 1.3.9
I also had a backup of my database.
Well I uploaded the database to the new server and thin tried to update it to 1.3.11 and got that error
1060: Duplicate column name 'lft'
I seen the fix here but my host is not welling to go thou the trouble.
The site well make a new database.
Just not update the old one.
Is there some other way to get it updated.
Can I do it by hand?
If so, what needs to be changed.[/QUOTE]
I too HAD the same problem but I discovered that somehow somewhere that when I upgraded once before, either my config file was not correct and was operating off the old one. Basically I never uploaded the new config file but just saved the old one on the server. Also, I remember a while ago I was installing some SR releases and when I went to upgrade to the latest version of GL I was getting errors so I just reuploaded all previous files from my original version of GL that was originally there before I started the upgrade.
Here's the interesting thing I found. In my admin block I have to chow what release version of GL I was using and it said 1.3.9 SR1 so I tried something and changed the current version to the 1.3.10 instead of what was showing in my admin block. So for some reason it was already at 1.3.10 and not the 1.3.9 SR1 and it was all because I either didn't change the config file to the new version and left my original one on. Yes I was taking a shortcut and it didn't pay off so the DB I am assuming along with the config file were not on the same page. Config was saying 1.3.9 SR1 and the DB was running 1.3.10. So in short, you can try chosing 1.3.10 as your current version instead of the 1.3.9 version. This worked for me and I am not having any problems whatsoever now. Its kind of hard to explain on here but I will explain as best I can if this is confusing. Just tell me what part you don't understand in what I have posted and I will try explaining it in a different way.