everything works fine except "Add A Site" button, which gives this error:

Invalid query: 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 'order by RAND() LIMIT 1' at line 1


http://greatlifeinsurancegroup.com/links/directory/

line #352 of include/add.php should read . . . .

Code:

$capquery = "SELECT * FROM $tb_captcha order by RAND() LIMIT 1";

You should also have a line near the bottom of /include/config.php

Code:

$tb_captcha = 'phplinks_captcha';

If both look correct, you could try checking with PHPMyAdmin that the captcha table exists and that its name is correctly specified in the config file

PS

It looks like you have upgraded, or something. The sample entries you show are from an older version prior to the captcha routine being added, so you may need to manually create and populate the captcha table.

You'll find the neccesary queries to do that here
http://www.dew-code.com/source/?filename=./dew-newphplinks.v.2.1.0.1b.sef/docs/NewPHPLinks.sql

near the bottom

The

"CREATE TABLE IF NOT EXISTS `phplinks_captcha` ( "

query and then the following 16 queries that start with

"INSERT INTO phplinks_captcha VALUES("

Sorry, I forgot to mention I did a manual update install on HostGator server. I went back and put my mysql data in config.php and uploaded to get that fixed, but now I am having problems manually importing phplinks_captcha.SQL table - I get a server upload error from data you provided:

Error

SQL query:

INSERT INTO `phplinks_related`
VALUES ( 1, 5, 453 ) ;

MySQL said: Documentation
#1062 - Duplicate entry '1' for key 'PRIMARY'

This file I am trying to import into MySQL database

The error you mention is because the "related" table is already populated and doesn't allow duplicate entries. Also, the pre-defined related table entries are for example only and not necessary for the script to operate.

Since this is an upgrade there is no need to populate it.

You do not need to run every query from the file I linked above, only the ones related to creating the captcha table near the bottom and just below that the queries for inserting the 16 entries to the captcha table.