I am getting the following error when clicking on a link I have added from Admin:
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 'values ('', '3', 'EDIT', 'Opera/9.80 (Windows N' at line 1

The link is clicked on from the front end.

Has anyone seen this before?

I have tried it in Firefox and Opera.

I have added the link but there is not reciprocal link inserted and no e-mail address.

Could this be the reason?

The Dew Links link with the script gives out the same error.

Although I wish to use DewLinks for Reciprocal Links I also just want to be able to add Links in Categories so that I can use it for a personal bookmark system, (although of course it would be public).
The idea is to create a Link Directory to CMS and phpScripts, extensions, FAQ and web design related content.

Anyone wishing to use it for reciprocal links is welcome to do so although primarily I want to as it for a directory as described above.
This means that most links will not be reciprocal.

Server version: 5.0.85-community
Protocol version: 10
PHP version 5.2.11

phpMyAdmin - 2.11.9.5
MySQL client version: 4.1.22
Used PHP extensions: mysql

Apache version 2.2.14 (Unix)

Any ideas out there anyone?

Thanks in advance.

It seems MySQL 4 and 5 treat NULL values differently.

In your out.php file, locate near the bottom

Code:

$sql = "insert into $tb_track values ('', '$ID', '$page_desc', '$user_agent', '$ip', '$date_added')";

I think MySQL 4 is complaining the '' being used to indicate a NULL value, try one of these variations, one should work with your version

Code:

$sql = "insert into $tb_track values (, '$ID', '$page_desc', '$user_agent', '$ip', '$date_added')"; or $sql = "insert into $tb_track values (NULL, '$ID', '$page_desc', '$user_agent', '$ip', '$date_added')";

PS, that MySQL query is used for the reports function available though the admin panel, if you don't plan to use that feature the whole block could be commented out, saving a database call

Disabling that whole chunk would look like this

Code:

/* if ($ID > 0){ $page_desc = "<a href=./edit_site.php?ID=".$ID.">EDIT</a>"; $user_agent = mysql_real_escape_string(getenv("HTTP_USER_AGENT")); $ip = getenv("REMOTE_ADDR"); $date_added = date("Y-m-d"); $table_name = "page_track"; $sql = "insert into $tb_track values ('', '$ID', '$page_desc', '$user_agent', '$ip', '$date_added')"; $result = mysql_query($sql) or die (mysql_error()); } */

Thanks for the Reply Dewed.

I will try your suggestions a little later and report back.

Wrapped up in some Joomla templating at the moment.

Thought I would give it a quick try:
Well both lines avoid the sql error but I am getting white screened on the link which I have set to open within dewphplinks in a new tab.
Also when trying to add a site from the front end I get:

Code:

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

As this could be a files permissions issue, (white screening often is), I have chmodded all files to 644 and directories to 755. I will read the included docs a little later. Thanks again Dewed.

White screening can also be a regular PHP error, when error reporting is turned off. Possibly you have an error_log file ?

Might be a good idea to pester your host to upgrade to MySQL 5 Version 4 was buggy regarding things like treatment of nulls for autoindex columns

Anyway, where did you get this copy of the script you are running ? What version is it ?