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

    I-doIT 0.9 - general questions and critical errors

    Scheduled Pinned Locked Moved Operating
    2 Posts 1 Posters 4.5k 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.
    • N Offline
      npotthast
      last edited by

      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.

      • How can I create new users?

      • 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;
      	}
      
      

      MfG,
      Niclas Potthast

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

        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 😄

        MfG,
        Niclas Potthast

        1 Reply Last reply Reply Quote 0
        • First post
          Last post