Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Links database Problem

Quote Reply
Links database Problem
Have a very unusual and interesting problem...

GT set up the links programme and used a prefix of 'lsql_' in the setup...

What is interesting is that I in fact have a duplicate set of database tables, ie, 'lsql_category' and 'category'.

This is for everything - the original install, all plugins etc.. I have a duplicate set of all tables. But not a duplicate set of data in the databases in the tables. This resides in one only - the one with the 'lsql_' prefix.

Am having massive problems with this database at the moment - one earlier problem that has not been resolved is the crashing of verify.cgi and a few other issues not reported.

Somewhere, links is getting confused, need to find the reason. I feel this is certainly a major part of problems. Andy has been working his backside off (without pay - and many thanks Andy - and at a time you need dollars) trying to resolve a few matters.

Any advice or help is appreciated..

What I feel is happening is that some parts of links is recognising both, ie, prefix and no prefix tables and causing grief.

Last edited by:

Gypsypup: Nov 21, 2003, 4:07 PM
Quote Reply
Re: [Gypsypup] Links database Problem In reply to
Turned out to be an extra 0 being added in the ID numbers somewhere... Laugh Its all fixed now.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!