View Full Version : [SOLVED] DB error : trap vendor table
marcounet
10-01-2007, 02:36 PM
Since I have update to 1.4.1 from 1.4 patched, I have this error when I attempt to access to a service configuration:
DB Error : SELECT id, alias FROM traps_vendor order by alias [nativecode=1146 ** Table 'oreon.traps_vendor' doesn't exist]
1.4.1 --> 1.4 ??? !!!!
(Date in french format)
29/03/2007: Oreon 1.4 release :) (03/29/2007)
03/04/2007: Oreon 1.4-1 patch
06/04/2007: Oreon 1.4-2 patch
...
25/04/2007: Oreon 1.4-5 patch
06/08/2007: Centreon 1.4.1 release (08/06/2007)
Why would you upgrade 1.4.1 on 1.4 ??? back to the future ?
marcounet
10-01-2007, 02:47 PM
no I'hv update 1.4 patch5 ---> 1.4.1
:confused:
have you read this ?
http://wiki.oreon-project.org/index.php/How_to_update_Centreon-1.4_to_Centreon-1.4.1_%3F
When you upgrade centreon, have you apply UpdateDB-1.4_to_1.4.1.sql on web interface ?
marcounet
10-01-2007, 03:25 PM
Of course , line after line
You can see traps table on oreon DB ?
mysql -u root -p oreon
show tables;
On my Db
...
| topology |
| topology_JS |
| traps |
| traps_service_relation |
| traps_vendor |
On sql script you have a CREATE TABLE traps_vendor command : (line 61)
61 CREATE TABLE `traps_vendor` (`id` int(11) NOT NULL auto_increment, `name` varchar(254) default NULL, `alias` varchar(254) default NULL, `description` text, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
62 INSERT INTO `traps_vendor` (`id`, `name`, `alias`, `description`) VALUES (1, 'cisco', 'Cisco Networks', NULL), (2, 'hp', 'HP Networks', NULL), (3, '3com', '3Com', NULL), (4, 'ciscolinksys', 'Cisco-Linksys', NULL), (6, 'dell', 'Dell', NULL), (7, 'Generic', 'Generic', 'References Generic Traps');
63
http://trac.oreon-project.org/browser/tags/centreon-1.4.1/www/install/sql/UpdateDB-1.4_to_1.4.1.sql
When you upgrade oreon install. have you sure this script passed correctly ?
marcounet
10-01-2007, 05:16 PM
Ok , I redo line 61 and 62 of UpdateDB-1.4_to_1.4.1.sql and it works fine thanks
no pb :) please check all line, if this line failed, it's possible your have another problems