sql error 1064

[vijayakumar]

Hai friends,

Am getting following problem can you people help me out...........??????

ERROR 1064 (42000) at line 1890: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to us
e near ''',
PRIMARY KEY (host_id,snmp_query_id,field_name,snmp_index),
KEY host_id ' at line 7

Cacti----cacti-0.8.6j
php------php-5.2.3
OS-----WIN-XP
mysql-5.0.41

[BSOD2600]

1) You get that error when doing what?

2) have you followed my installation guide (in signature), specially for mysql configuration?

[vijayakumar]

hai Buddy,
thanks for the help .....
I have gone through ur installation guide ,

Now my problem is When am trying to import the cacti.sql file to cacti database am getting above mentioned error.I have gone through cacti database in MYSQL Server ,before error it has made 22 tables and not able to make tables after host_graph...

Specificcally mentioning means its not able to make table with the command below in cacti.sql

CREATE TABLE host_snmp_cache (
host_id mediumint(8) unsigned NOT NULL ,
snmp_query_id mediumint(8) unsigned NOT NULL ,
field_name varchar(50) NOT NULL default ,
field_value varchar(255) default NULL,
snmp_index varchar(255) NOT NULL default ,
oid TEXT NOT NULL,
PRIMARY KEY (host_id,snmp_query_id,field_name,snmp_index),
KEY host_id (host_id,field_name),
KEY snmp_index (snmp_index)
) TYPE=MyISAM;


error is at
PRIMARY KEY (host_id,snmp_query_id,field_name,snmp_index),
KEY host_id (host_id,field_name),

waiting for suggestions

Thanks in advance......................

[BSOD2600]

Sound like sql-strict mode is enabled in my.ini. Per the installation guide, you must DISABLE it (aka comment it out).

[TheWitness]

Not 100% sure that is the issue. What version of MySQL?

TheWitness

[vijayakumar]

I am using mysql version 5.0.41..

[vijayakumar]

Hai friends,

I recovered that problem..............

it might be because of file cacti.sql .

I replaced the same with oe lower version and its working fine now...


Thanks for the help..........


Now my problem is http://localhost/cacti doesnot giving any images.......

can you help me out......................



Regards........


vijayakumar

[BSOD2600]

I replaced the same with oe lower version and its working fine now...

Wait a minute, you took a cacti.sql from an OLDER release?? If so, very bad idea, since the mysql tables tend to change from release to release.

As for your graph problem, read http://forums.cacti.net/viewtopic.php?t=11747