Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: Very odd error :/

Aug 25, 2008, 12:40 PM

Andy

Veteran / Moderator (17297 posts)

Aug 25, 2008, 12:40 PM

Post #1 of 5

Shortcut

Very odd error :/

Hi,

Not sure if anyone can help me, but has anyone come across this error before?

Quote:

A fatal error has occured:

GT::SQL (21404): File '/srv/www/vhosts/domain.com/cgi-bin/admin/defs/glinks2_Users.def.bak.def' does not exist or the permissions are set incorrectly at /srv/www/vhosts/domain.com/cgi-bin/admin/Links/Import/S2BK.pm line 114.

Please enable debugging in setup for more details.

Really got me confused (mainly, as to why exactly its trying to even copy them =))

TIA

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

Aug 25, 2008, 12:41 PM

Andy

Veteran / Moderator (17297 posts)

Aug 25, 2008, 12:41 PM

Post #2 of 5

Shortcut

Re: [Andy] Very odd error :/ In reply to

Hi,

Welp, after all that - I just managed to fix it (sods law I just posted :P)

Basically - there was a file named glinks2_Users.def.bak.def inside the /defs folder (god knows why!) - and deleting that now worked :)

Cheers

Andy (mod)
andy@ultranerds.co.uk

Aug 25, 2008, 12:46 PM

Andy

Veteran / Moderator (17297 posts)

Aug 25, 2008, 12:46 PM

Post #3 of 5

Shortcut

Re: [Andy] Very odd error :/ In reply to

Damn, another error now :(

GT::SQL::error = Failed to execute query: 'SELECT glinks2_CatLinks.CategoryID,glinks2_CatLinks.LinkID FROM glinks2_CatLinks LEFT OUTER JOIN glinks2_Links ON WHERE (glinks2_Links.ID IS NULL) ': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE (glinks2_Links.ID IS NULL)' at line 1

This is on a Repair Tables. Could this be a MySQL problem?

This is a move from an NT server ==> Plesk Unsure

Cheers

Andy (mod)
andy@ultranerds.co.uk

Aug 25, 2008, 8:05 PM

brewt

Staff (4066 posts)

Aug 25, 2008, 8:05 PM

Post #4 of 5

Shortcut

Re: [Andy] Very odd error :/ In reply to

Check your Links and CatLinks def files. The relation between them must be broken as it seems to be not joining the tables together properly there.

Adrian

Aug 26, 2008, 12:25 AM

Andy

Veteran / Moderator (17297 posts)

Aug 26, 2008, 12:25 AM

Post #5 of 5

Shortcut

Re: [brewt] Very odd error :/ In reply to

Hi,

Thanks for the reply :)

In the end, I just re-setup the tables (via the Setup > SQL Server area), and then had to just re-add the fields (although there were quite a lot :() ... guess something got buggered during the transfer (had all kinds of problems with the M$ Server that it was last hosted on, as it kept on lowercasing the files - a roya PITA :()

Anyway, all seems to work fine now :)

Cheers

Andy (mod)
andy@ultranerds.co.uk