MySQL Error

[derrick.joseph]

Hi,

I need help here coz I'm a newbie in using MySQL ... so here are some of the info:

OS: FreeBSD 5.1
MySQL: mysql-server-4.1.0_1

Please refer below for the contents of my cacti.sql file.

The following errors appear when I execute mysql cacti < cacti.sql

ERROR 1064 at line 5: 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 'hash varchar(32) NOT NULL default '',
name varchar(255) NOT N

***INSIDE MY CACTI.SQL FILE ***
CREATE TABLE cdef (
id mediumint(8) unsigned NOT NULL auto_increment,
hash varchar(32) NOT NULL default '',
name varchar(255) NOT NULL default '',
PRIMARY KEY (id),
UNIQUE KEY ID (id),
KEY id_2 (id)
) TYPE=MyISAM;

Need you help and expertise in this matter.

Thank you.

Deejay

[rony]

What version of Cacti?

[derrick.joseph]

I am using cacti-cactid-0.8.6d.tar.gz

Thanks

[rony]

That is just the cactid faster poller.

What version of cacti are you running?

[derrick.joseph]

I used this file to install cacti cacti-cactid-0.8.6d.tar.gz

[rony]

No, you couldn't have, that is just the cactid poller. You had to of install cacti to even consider using cactid.

Please check again.

At this point, I can only assume you are using cacti 0.8.6c.

Concerning you SQL error, that shouldn't happen, please reinstall from source, http://www.cacti.net/downloads/cacti-0.8.6c.tar.gz, and let me know if you still have the problem.

[derrick.joseph]

Hi Rony,

I am still having problems on my SQL

mysql cacti < cacti.sql

ERROR 1064 at line 5: 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 'hash varchar(32) NOT NULL default '',
name varchar(255) NOT N

What should be the problem in here ?

Many thanks.

Deejay

[rony]

I don't know, I have loaded the file multiple times on mySQL server 3.2.x series.

Try down grading mySQL? I don't know what to say...