Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Mon Aug 21, 2017 10:37 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Nectar plugin issue?
PostPosted: Tue May 16, 2017 4:59 am 
Offline
Cacti User

Joined: Tue Jun 20, 2006 2:48 am
Posts: 226
Location: Italy
Hello,

After migrating (still in test) from 0.8.8a to 1.0.0 I'm seeing these errors in the log:
Code:
DBCALL ERROR: SQL Assoc Failed!, Error:1054, SQL:"SELECT * FROM reports WHERE mailtime < ? AND enabled="on""
DBCALL ERROR: SQL Assoc Failed!, Error: Unknown column 'mailtime' in 'where clause'


Here the table:

Code:
MariaDB [cacti]> show create table reports\G
*************************** 1. row ***************************
       Table: reports
Create Table: CREATE TABLE `reports` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `hour` int(2) NOT NULL DEFAULT '0',
  `minute` int(2) NOT NULL DEFAULT '0',
  `email` text NOT NULL,
  `rtype` varchar(12) NOT NULL DEFAULT 'attach',
  `lastsent` int(32) NOT NULL DEFAULT '0',
  `daytype` text NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1
1 row in set (0.00 sec)


mailtime is missing. Maybe upgrade fail?

Ideas?

Thanks,

Simon


Top
 Profile  
 
 Post subject: Re: Nectar plugin issue?
PostPosted: Thu Jul 06, 2017 6:46 pm 
Offline
Cacti User
User avatar

Joined: Mon Jan 05, 2015 10:10 am
Posts: 481
The structure was changed in 1.x. Please review the cacti.sql for the new structure and run an alter statement to get to the correct format.

_________________
Before history, there was a paradise, now dust.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group