Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Updating from beta1 to final

Quote Reply
Updating from beta1 to final
Hi!
Anyone know whats wrong?
I made a copy of the mysql database from beta1, an installed final version with it. When I build all, I get this error message:

Building Home Page ...
Done (0.00 s)

Building What's New Index ...
Building Subpage: 2001-01-28 ... 2 links ok.
Building Subpage: 2001-01-30 ... 2 links ok.
Done (1.00 s)

Building What's Cool Index ...
Done (0.00 s)

Building Top Rated ...
Done (0.00 s)

Skipping Detailed Build (disabled).

Building Category pages ...

Building category Allmennmedisin ...
Links: 13
A fatal error has occured:
Failed to execute query: 'SELECT RelatedID,RelationName FROM CatRelations WHERE CategoryID = '1' ' Reason: Unknown column 'RelationName' in 'field list' at (eval 22) line 78, chunk 1.

Please enable debugging in setup for more details.


Quote Reply
Re: Updating from beta1 to final In reply to
I think this means that one of your resources from the old sql has a related category that doesnt exist in the new version.

Paul Wilson. Shocked
(Dont blame me if I'm wrong!)
Quote Reply
Re: Updating from beta1 to final In reply to
I'm upgrading from beta 5 to final and have the same problem. No categories have changed. Went through the usual routine - Backup, upgrade, restore, rebuild. Searching the index now also produces no results. Running nph-index from shell returns

% perl nph-index.cgi
GT::SQL (18923): Wrong argument passed to this subroutine. Usage: The defs direc
tory '/usr/local/etc/httpd/htdocs/surfsafely/cgi-bin/links/admin/defs' does not
exist, or is not a directory. at Links.pm line 78.
BEGIN failed--compilation aborted at nph-index.cgi line 22.


Mark Brasche
http://SurfSafely.com/
Quote Reply
Re: Updating from beta1 to final In reply to
Check the path to your def files and edit it.

Paul Wilson.
NEW website coming soon...
Quote Reply
Re: Updating from beta1 to final In reply to
I still cant get it to work. Is it not possible to import data from beta1 to final linkssql 2.0? There is no option for this. What do i do?

Quote Reply
Re: Updating from beta1 to final In reply to
Hi,

See: http://www.gossamer-threads.com/p/123795. You need to run these queries in order to update your tables.

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: Updating from beta1 to final In reply to
Thanks a lot, I will try that.

Quote Reply
Re: Updating from beta1 to final In reply to
That did the trick. Everything seems to work perfectly now. Thanks a lot.