Gossamer Forum
Home : Products : Gossamer Links : Discussions :

A fatal error

Quote Reply
A fatal error
Can someone understand what is this error?

A fatal error has occured:
Database error: Failed to execute query: 'SELECT glinks_Links.ID FROM glinks_CatLinks,glinks_Links WHERE glinks_CatLinks.LinkID = glinks_Links.ID AND (glinks_CatLinks.CategoryID = '2') ORDER BY Title,isValidated DESC,ASC LIMIT 0, 25': You have an error in your SQL syntax near 'ASC LIMIT 0, 25' at line 1 at /var/apache/cgi-bin/Links/admin/Links/Browser.pm line 1782. Thanks

Quote Reply
Re: [banana] A fatal error In reply to
The query is broken; in particular, the part "DESC,ASC". What did you do to get that error?

Adrian
Quote Reply
Re: [brewt] A fatal error In reply to
Andrian:

This happened in Links Admin panel. when I go to tab browse and click on one of the two categories (we have two only), the error came up. I backuped my data, still panic. I did several things and I wonder which one is the cause:

1. I changed the sort order to title first in admin panel-set up.
2. We have two licenses for Links. I installed the second one into a different directory, but created tables (those tables are under different names) into the same database. So in database links I have got the whole set empty tables and I dropped those table later.

Which one is my problem?

Please help!

Banana
Quote Reply
Re: [banana] A fatal error In reply to
If you send me admin panel access, I can take a quick look at it.

Adrian