How to erase graph duplicated

Post support questions that relate to the Windows 2003/2000/XP operating systems.

Moderators: Developers, Moderators

Post Reply
User avatar
masterofcacti
Posts: 13
Joined: Mon Jun 30, 2008 7:20 am

How to erase graph duplicated

Post by masterofcacti »

HI

bsod can you help me with this problem? Last friday MySQL database was crashed and I had to import a CACTI database's copy by phpAdmin.
I restored yesterday the database but in the CACTI's web I don't see the device's graphs.

I attach two images to show the problem.
thanks
Attachments
I want to know how to erase the duplicated graphs
I want to know how to erase the duplicated graphs
Dibujo1.JPG (38.51 KiB) Viewed 1666 times
When I check over the link, the device´s graphs appear but I check over the link, which is in the treeview, the graph wich belongs to device doesn't appear.
When I check over the link, the device´s graphs appear but I check over the link, which is in the treeview, the graph wich belongs to device doesn't appear.
Dibujo2.JPG (72.36 KiB) Viewed 1666 times
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

The fact you have duplicates is concerning, since sounds like database corruption. Try running: mysqlcheck --auto-repair --databases cacti

Otherwise, go to graph management, select the device in question and delete the graphs...
User avatar
masterofcacti
Posts: 13
Joined: Mon Jun 30, 2008 7:20 am

The same

Post by masterofcacti »

thanks for uor help bsod but MySQL Console says me error 1064 from
mysql> mysqlcheck --auto-repair --databases cacti;

furthermore, my MySQL version is 5.0. Any way to do in phpMyAdmin?
thanks
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

There is no semicolon after that command. No idea about phpmyadmin -- read its help.
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests