I'm trying to upgrade using to 3.0 - but I hit this:

Performing Links SQL 2.2.1 -> 3.0.0 upgrades...
Adding column CatRoot to Category table...
Could not add column CatRoot: Unable to add column 'CatRoot' - already exists
Adding column CatDepth to Category table...
Could not add column CatDepth: Unable to add column 'CatDepth' - already exists
Adding column Direct_Links to Category table...
Could not add column Direct_Links: Unable to add column 'Direct_Links' - already exists
Adding Category tree...

and it won't move any further....
And the program doesn't quite work right.

If you've got a large link directory, adding the Category tree can take some time (a few minutes). Does your webserver limit the length of time a process can run? It may be killing the installer before it can finish

Adrian

I did get it to run through the entire category tree. But now, it won't build!
I get the following error:

A fatal error has occured:

GT::SQL (28494): File '/var/www/cgi-bin/LinksSQL/admin/defs/lsql_Users.def.tmp.30547.1113588634.9255.def' does not exist or the permissions are set incorrectly at /var/www/cgi-bin/LinksSQL/admin/Links/Import/S2BK.pm line 114.

Thought this might be useful:

Stack Trace
======================================
Links (28494): Links::environment called at /var/www/cgi-bin/LinksSQL/admin/Links.pm line 700 with no arguments.
Links (28494): Links::fatal called at GT::Base::error line 388 with arguments
(GT::SQL (28494): File '/var/www/cgi-bin/LinksSQL/admin/defs/lsql_Users.def.tmp.30547.1113588634.9255.def' does not exist or the permissions are set incorrectly at /var/www/cgi-bin/LinksSQL/admin/Links/Import/S2BK.pm line 114.
).
Links (28494): GT::Base::error called at GT::Base::fatal line 288 with arguments
(GT::SQL=HASH(0xb02870), FILENOEXISTS, FATAL, /var/www/cgi-bin/LinksSQL/admin/defs/lsql_Users.def.tmp.30547.1113588634.9255.def).
Links (28494): GT::Base::fatal called at /var/www/cgi-bin/LinksSQL/admin/GT/SQL/Base.pm line 56 with arguments
(GT::SQL=HASH(0xb02870), FILENOEXISTS, /var/www/cgi-bin/LinksSQL/admin/defs/lsql_Users.def.tmp.30547.1113588634.9255.def).
Links (28494): GT::SQL::Base::table called at /var/www/cgi-bin/LinksSQL/admin/Links/Import/S2BK.pm line 114 with arguments
(GT::SQL=HASH(0xb02870), Users.def.tmp.30547.1113588634.9255).
Links (28494): Links::Import::S2BK::import called at /var/www/cgi-bin/LinksSQL/admin/nph-build.cgi line 312 with arguments
(HASH(0x947c00), CODE(0x8ebcd0), CODE(0x8ebdc0), CODE(0x8ebe40), CODE(0x8eed00)).
Links (28494): main::_build_backup called at /var/www/cgi-bin/LinksSQL/admin/nph-build.cgi line 66 with no arguments.
Links (28494): main::build_all called at /var/www/cgi-bin/LinksSQL/admin/nph-build.cgi line 45 with no arguments.
Links (28494): main::main called at /var/www/cgi-bin/LinksSQL/admin/nph-build.cgi line 33 with no arguments.

One more thing, that file that it says is missing is not missing. It's there. But when I open it with Notepad, there is nothing in it. I don't know what this means.

That def files is a temporary one - delete it.

Adrian

Thanks! That worked. It can build now.