It is an intermittent error because the routine to tally the outbound click count, as well as update the reports table is not even called if consecutive clicks come from same IP address..

if($REMOTE_ADDR != $get_row["OutIP"]){

so on the first click, the outbound click in the links table is incremented for that site, and as your IP address recorded. but the insert to the reports table fails, and you see the error.

A subsequent click by you would come from the same IP address, so the insert to the reports table is never attempted, and the out bound click sount for that site is not incremented.

This is in place to prevent over zealous web masters from artificially increasing their rank on the what popular page.

Did you try replacing the 2 apostrophes with the word NULL ?

eg;

Code:

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

That stoped the errors, but its still not loging data.

OK I don't know whats up, but it has magicly started keeping track of framed content. Maybe when I used the reset, that it had something to do with it. I don't know only guessing. Maybe I uploaded the wrong file and when I syncronized the site it uploaded the changes.
Appears your fix works perfectly dewed, Thanks.

Well, the code change fixed it. The reset of the table just allowed you to see that it worked. As I mentioned, on every click, the viewer's IP is recored. If a subsequent click from the same IP occurs, it is NOT recored. This prevents people from repeatedly clicking a site to boost it's rank in the What's Cool pages.

Once some other IP has clicked the same site, your next click would be recorded... eg; it doesnt count 2 back to back clicks from the same IP, but 2 different IPs could potentially ping pong.. if that makes sense.

Turns out it was uploaded to the wrong folder. Went to a sub directory of public_html, under the true public_html. Goofed with my Dreamweaver document tree.