I-doIT 0.9 - general questions and critical errors
-
Hi there!
At frequent intervals we'll give you the newest fixes for the most recent version that we have released.
We'd be very happy if all betatesters would participate in helping us and posting the bigger errors in this thread.But, back to our thread. In the following list we will publish all answers to the most common questions and bugs we have encountered so far. If you can't find you answer in here, please feel free to reply to this post and add a new question to this thread. After that we will answer your post and in addition to that add the answer to the now following list:
-
When you have problems with the framework, such as an empty (or white) screen, or the Apache-log error message "child pid XXXXX exit signal
Segmentation fault" do the following: change the parameter memory_limit in your php.ini to 32 MB instead of 8 or 16 MB, this should help. -
A wrong combination of mySQL server and mySQL client library can result in an error when logging i to the database system. The reason for that is that mySQL AB from version 4.1 uses new algorythms to save passwords. This is not supported by all PHP-mySQL-client-libraries. Therefor you have to change the parameter "old_passwords" in your my.ini/my.cnf to the value "1".
-
"SHOW TABLES LIKE isys_registry… no database selected... ". If you see this you should try logging in via CLI (concole) and check the mySQL accounts in "src/config.inc.php" and in the mandator table (isys_mandator in the system database).
-
If you have a wrong character set, change the default_charset for server, client and collation to "latin1_german_ci". Your Apache should have the addition "AddDefaultCharset" changed to "ISO-8859-1". In php the default_charset should be also set to "iso-8859-1".
-
Interesting news: on the Ubuntu LTS 6.06 server the installation works perfectly when you choose 'Install LAMP' when installing the system.
-
Fatal error: Call to a member function handle() on a non-object in C:\xampp\htdocs\i-doit\src\classes\components\isys_component_database.class.php on line 84
If you have this problem the only thing that seems to help (on some older systems) to rewrite the function close() in the file \src\classes\components\isys_component_database.class.php to the following code:
public function close() { //global $g_dbg; if($this->m_db_link) { //the global variable isn't loaded above, so we have to use this: $g_dbg = isys_debugger::get(); $g_dbg->handle(isys_debugger::c_err_debug, "Connection closed (" . $this->m_db_name . ")."); mysql_close($this->m_db_link); return ISYS_TRUE; } return ISYS_FALSE; } -
-
First connect yourself with the mandator database and see the structure of the table 'isys_person_intern':
| isys_person_intern__id | int(10) unsigned | | PRI | NULL | auto_increment | | isys_person_intern__title | varchar(255) | YES | | NULL | | | isys_person_intern__description | text | YES | | NULL | | | isys_person_intern__user_pass | varchar(255) | YES | | NULL | | | isys_person_intern__property | int(10) unsigned | YES | | 0 | | | isys_person_intern__status | int(10) unsigned | YES | | 1 | |The content of this table:
| 1 | guest | NULL | 084e0343a0486ff05530df6c705c8bb4 | 0 | 1 | | 11 | reader | Reader | 1de9b0a30075ae8c303eb420c103c320 | 0 | 1 | | 12 | editor | Editor | 5aee9dbd2a188839105073571bee1b1f | 0 | 1 | | 13 | author | Author | 02bd92faa38aaa6cc0ea75e59937a1ef | 0 | 1 | | 14 | archivar | Archivar | 4baf8329be21a4ad4f4401295cc130a9 | 0 | 1 | | 15 | admin | Admin | 21232f297a57a5a743894a0e4a801fc3 | 0 | 1 |To add new users create a new dataset in this table. 'isys_person_intern__title' defines the username and 'isys_person_intern__user_pass' is the password (as an MD5-Hash -> http://dev.mysql.com/doc/refman/5.0/en/security-guidelines.html
INSERT INTO isys_person_intern VALUES('%', 'einBenutzer', 'Markus Mueller', MD5('einPasswort'), 0, 1);Then log in with 'einBenutzer' and 'einPasswort' and have fun with it
