Isys_exception_database error
-
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 distributionType '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 -ADatabase 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 ,
-
Maybe the posting in http://www.i-doit.de/forum/index.php/topic,387.0.html can help.
-
i tried that but it still not work
-
Sounds weird. Have you tried another install of i-doit? Sometimes this does it.
-
thanks i fixed it
-
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
