[SOLVED] DB error : trap vendor table

[marcounet]

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]

[WAtt]

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]

no I'hv update 1.4 patch5 ---> 1.4.1

[WAtt]

:confused:


have you read this ?
http://wiki.oreon-project.org/index....reon-1.4.1_%3F


When you upgrade centreon, have you apply UpdateDB-1.4_to_1.4.1.sql on web interface ?

[marcounet]

Of course , line after line

[WAtt]

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                           |

[WAtt]

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/browse...4_to_1.4.1.sql

When you upgrade oreon install. have you sure this script passed correctly ?

[marcounet]

Ok , I redo line 61 and 62 of UpdateDB-1.4_to_1.4.1.sql and it works fine thanks

[WAtt]

no pb please check all line, if this line failed, it's possible your have another problems