Urgent problem with mysql database

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
pchristofides
Posts: 2
Joined: Wed Jan 05, 2005 12:17 pm

Urgent problem with mysql database

Post by pchristofides »

I was running cacti 0.8.6c and I had also installed cacti 0.6.5. By mistake I have started the old version of cacti and started the installation on the database of the new version. Now the new cacti 0.8.6c down not operating and replies with:

Error

You are attempting to install cacti 0.8.6c onto a 0.6.x database. To continue, you must create a new database, import 'cacti.sql' into it, and update 'include/config.php' to point to the new database.

What shall I do. I have tried to do some things but no luck. Is there a way to upgrade this database?

Thanks in advance.
User avatar
rony
Developer/Forum Admin
Posts: 6022
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:

Post by rony »

Try the following query on the cacti database... Will get past the install problem, but you may have more issues.

Code: Select all

update version set cacti = '0.8.6c';
Good luck,
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
pchristofides
Posts: 2
Joined: Wed Jan 05, 2005 12:17 pm

Problem fixed

Post by pchristofides »

Thanks for the response,

I have already solved the problem by doing the same thing.

I have edited the table "version" in the database and changed the value from 0.6.5 to 0.8.6c and the cacti was back and working fine. The only thing is that I lost the data for the time that cacti was down.

Thanks and regards.
Post Reply

Who is online

Users browsing this forum: No registered users and 6 guests