error: Table 'cacti.1' doesn't exist

[avalox]

Hi,

installed cacti on Fedora 4 with MySQL 5.0.18

I did everything like the README said. When i do a select on any table in the DB i get the following error (done with MySQL ControlCenter:

ERROR 1146: Table 'cacti.1' doesn't exist

I also tried to use the patch i found in the forum

MySQL-5x-Patch.php

and

mysql_5x_strict.patch

when i use the mysql_5x_strict.patch i become an error too

patch -p1 -N < mysql_5x_strict.patch
patching file cacti.sql
Hunk #1 FAILED at 1846.
1 out of 1 hunk FAILED -- saving rejects to file cacti.sql.rej
patching file lib/database.php
Hunk #1 FAILED at 214.
1 out of 1 hunk FAILED -- saving rejects to file lib/database.php.rej
patching file lib/template.php
Hunk #1 FAILED at 642.
1 out of 1 hunk FAILED -- saving rejects to file lib/template.php.rej

I hope someone can help getting cacti work.

regards Sebastian

[gandalf]

What version of cacti did you install? From where? Please use the downloads provided at http://cacti.net. I recently applied all patches to cacti 0.8.6h without problems
Reinhard

[rony]

There is not table in the cacti database named "1".

check that you have "sql_mode" commented out in your my.cnf file.

[NetVicious]

This it's not a cacti error, Mysqlcc doesn't runs ok with MySql 5.0.

I have a patch for the 0.9.4-Beta source if you want compile it, or I could send you a binary file.

[martytime]

Read below

[martytime]

NetVicious -

I would love to get my hands on that patch.

My email is frenchy44_____AT_____gmail

Thanks

[NetVicious]

See it here

http://lists.mysql.com/gui-tools/1842

If you have some problem post here