Isys_exception_database : Query error:

lakmal777

I have installed i-doIT successfully using the automatic installation , but it is not connecting to the DB

I'm using FC 5 ( 2.6.15-1.2054_FC5smp)
PHP5
Mysql 5.0.16-standard
Apache 2.2

I'm getting the following error

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

Fatal error: Uncaught Exception occured in (/usr/local/apache2/htdocs/i-doit_v09/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 /usr/local/apache2/htdocs/i-doit_v09/src/classes/components/isys_component_dao_registry.class.php on line 92

Can anyone pls help

ds

Look into the table: "isys_mandator" in your system database and check the database connection of your mandator entries there.


myslql -uroot -p -Didoit_system_database

select * from isys_mandator;

If you haven't got any mandators listed, take a look at this:
http://docu.i-doit.org/wiki/New_Mandator

Guest

@ds:

Look into the table: "isys_mandator" in your system database and check the database connection your mandator entries there.
myslql -uroot -p -Didoit_system_database

select * from isys_mandator;
If you haven't got any mandators listed, take a look at this:
http://docu.i-doit.org/wiki/New_Mandator

What if there are mandators?


 mysql -Dinet1 -e"select isys_mandator__id, isys_mandator__default_lang_const  from isys_mandator;"
+-------------------+-----------------------------------+
| isys_mandator__id | isys_mandator__default_lang_const |
+-------------------+-----------------------------------+
|                 1 | ISYS_LANGUAGE_GERMAN              | 
|                 2 | ISYS_LANGUAGE_ENGLISH             | 
+-------------------+-----------------------------------+

I have FC6, but same error after automatic installation.

Guest

OK. The problem is the GRANT statements only include```
@'%'

Additional GRANT statements are needed to allow localhost (127.0.0.1). I used the example from [http://doc.i-doit.org/wiki/Install](http://doc.i-doit.org/wiki/Install) but using```
@'localhost'

Guest

Quick patch against svn is attached.

i-doit.inst-grant.txt

ds

thanks for your patch, its included in the next version.

stevie

I created the new GRANT access for localhost, but it still dont work. Any sugesstions?

Benutzer  	Host  	Typ  	Rechte  	Grant  	Aktion
i-doit  	%  	 Platzhalter: idoit_sys   	  ALL PRIVILEGES    	 Ja  	Rechte ändern
i-doit 	localhost 	Platzhalter: idoit_sys 	ALL PRIVILEGES 	Ja 	Rechte ändern

Mandatory exists:
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 connextis (DE) connextis cache_idoit_data default 127.0.0.1 3306 idoit_data i-doit i-doit

Error:```

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

Fatal error: Uncaught Exception occured in (/var/www/i-doit/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/i-doit/src/classes/components/isys_component_dao_registry.class.php on line 92

Guest

@stevie:


Fatal error: Uncaught Exception occured in
 (/var/www/i-doit/src/classes/components/isys_component_dao_registry.class.php:92):
 isys_exception_general : Could not find table 'isys_registry'

Find out what happened to 'isys_registry' …

bobrivers

Any help?

I have the same problem. I tryed to apply the patch, but it doens't work. I also tryed to give localhost access, but again, no success.

TIA,

Bob

ds

Which error do you get exactly, bobrivers?
Does your i-doit work properly? If not - check your src/config.inc.php for correct database settings.

..because the message: "isys_exception_general : Could not find table 'isys_registry'" occurs when the system database cannot be found (isys_registry is a table of it) - or, when the connection to the system database does not work.