Community
    • Categories
    • Recent
    • Popular
    • Users
    • Search
    • Register
    • Login

    Isys_exception_database error

    Scheduled Pinned Locked Moved Operating
    6 Posts 3 Posters 3.6k Views 1 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • A Offline
      amr922
      last edited by

      hi all
      after i installed i-doit i got this error
      isys_exception_database : Query error: 'SHOW TABLES LIKE 'isys_registry';': (Extended Information: NULL)

      Fatal error: Uncaught Exception occured in (/var/www/html/src/classes/components/isys_component_dao_registry.class.php:92): isys_exception_general : Could not find table 'isys_registry' (Extended Information: General exception occured) thrown in /var/www/html/src/classes/components/isys_component_dao_registry.class.php on line 92

      i using PHP 5.1.6 and mysql 5.0.44

      –---------------------------

      [root@docs html]# mysql -uadmin -p**** -hlocalhost
      Welcome to the MySQL monitor.  Commands end with ; or \g.
      Your MySQL connection id is 34
      Server version: 5.0.44 Source distribution

      Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

      mysql> SHOW TABLES LIKE 'isys_registry';
      ERROR 1046 (3D000): No database selected
      mysql> use idot_sys;
      ERROR 1049 (42000): Unknown database 'idot_sys'
      mysql> use idoit_sys;
      Reading table information for completion of table and column names
      You can turn off this feature to get a quicker startup with -A

      Database changed
      mysql> SHOW TABLES LIKE 'isys_registry';
      +–-----------------------------------+
      | Tables_in_idoit_sys (isys_registry) |
      +-------------------------------------+
      | isys_registry                      |
      +-------------------------------------+
      1 row in set (0.00 sec)

      mysql> select * from isys_mandator ;
      +-------------------+----------------------+----------------------------+--------------------------+------------------------+------------------------+------------------------+------------------------+------------------------+------------------------+---------------------+-----------------------------------+---------------------------------------+
      | isys_mandator__id | isys_mandator__title | isys_mandator__description | isys_mandator__dir_cache | isys_mandator__dir_tpl | isys_mandator__db_host | isys_mandator__db_port | isys_mandator__db_name | isys_mandator__db_user | isys_mandator__db_pass | isys_mandator__sort | isys_mandator__default_lang_const | isys_mandator__default_language_short |
      +-------------------+----------------------+----------------------------+--------------------------+------------------------+------------------------+------------------------+------------------------+------------------------+------------------------+---------------------+-----------------------------------+---------------------------------------+
      |                1 | NILEWEB (DE)        | NILEWEB                    | cache_idoit_data        | default                | 127.0.0.1              |                  3306 | idoit_data            | admin                  | bgfr436                |                  1 | ISYS_LANGUAGE_GERMAN              | de                                    |
      |                2 | NILEWEB (EN)        | NILEWEB                    | cache_idoit_data        | default                | 127.0.0.1              |                  3306 | idoit_data            | admin                  | bgfr436                |                  2 | ISYS_LANGUAGE_ENGLISH            | en                                    |
      +-------------------+----------------------+----------------------------+--------------------------+------------------------+------------------------+------------------------+------------------------+------------------------+------------------------+---------------------+-----------------------------------+---------------------------------------+
      2 rows in set (0.00 sec)

      mysql>


      how can i fix it ?

      Regards , 🙂

      1 Reply Last reply Reply Quote 0
      • N Offline
        npotthast
        last edited by

        Maybe the posting in http://www.i-doit.de/forum/index.php/topic,387.0.html can help.

        MfG,
        Niclas Potthast

        1 Reply Last reply Reply Quote 0
        • A Offline
          amr922
          last edited by

          i tried that but it still not work 😞

          1 Reply Last reply Reply Quote 0
          • N Offline
            npotthast
            last edited by

            Sounds weird. Have you tried another install of i-doit? Sometimes this does it.

            MfG,
            Niclas Potthast

            1 Reply Last reply Reply Quote 0
            • A Offline
              amr922
              last edited by

              thanks i fixed it 🙂

              1 Reply Last reply Reply Quote 0
              • dsD Offline
                ds
                last edited by

                isys_exception_database : Query error: 'SHOW TABLES LIKE 'isys_registry';': (Extended Information: NULL)

                • mostly means that your idoit system database was not found, so always take a look at the database settiings in your idoit/src/config.inc.php and check the php/mysqlclient connectivity to your configured database
                1 Reply Last reply Reply Quote 0
                • First post
                  Last post