Announcement

Collapse
No announcement yet.

[SOLVED] DB error : trap vendor table

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [SOLVED] DB error : trap vendor table

    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]

  • #2
    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 ?
    Centreon 2.x

    Comment


    • #3
      no I'hv update 1.4 patch5 ---> 1.4.1

      Comment


      • #4
        :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 ?
        Centreon 2.x

        Comment


        • #5
          Of course , line after line

          Comment


          • #6
            You can see traps table on oreon DB ?

            Code:
             mysql -u root -p oreon
            show tables;
            On my Db
            Code:
            ...
            | topology                               |
            | topology_JS                            |
            | traps                                  |
            | traps_service_relation                 |
            | traps_vendor                           |
            Centreon 2.x

            Comment


            • #7
              On sql script you have a CREATE TABLE traps_vendor command : (line 61)

              Code:
              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 ?
              Centreon 2.x

              Comment


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

                Comment


                • #9
                  no pb please check all line, if this line failed, it's possible your have another problems
                  Centreon 2.x

                  Comment

                  Working...
                  X