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

    Isys_exception_database error

    Scheduled Pinned Locked Moved Operating
    6 Posts 3 Posters 3.8k 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

                Hello! It looks like you're interested in this conversation, but you don't have an account yet.

                Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

                With your input, this post could be even better 💗

                Register Login
                • First post
                  Last post