Hi
I am installing epesi 1.3.0 rev9190 on CentOS / MySQL / PHP 5.3. DB install step creates 23 tables and then dies (I successfully installed epesi last year and there were some 145 tables - so apparently it died in the process of creating blocks of tables).
Anyway, the problem seems to be in /libs/phpgacl/gacl_api.class.php:3549
$insert_id = $this->db->GenID($this->_db_table_prefix.$object_type.'_sections_seq',10);
$object_type happens to be aco, and table aco_sections_seq indeed doesn't exist. Not sure if the table should have been created by that time, or the code shouldn't install in _sections_seq... Even more unsure how to solve this problem. It would be very presumptive of me to write in the first post "I found a bug", but that's how it looks.
For completeness, here is the relevant part of Apache log:
PHP Fatal error: mysqlt error: [1146: Table 'epesi.aco_sections_seq' doesn't exist] in EXECUTE("update aco_sections_seq set id=LAST_INSERT_ID(id+1);")\n in /var/www/html/epesi/libs/adodb/adodb-errorhandler.inc.php on line 77
PHP 1. {main}() /var/www/html/epesi/setup.php:0
PHP 2. write_config() /var/www/html/epesi/setup.php:163
PHP 3. install_base() /var/www/html/epesi/setup.php:352
PHP 4. gacl_api->add_object_section() /var/www/html/epesi/setup.php:452
PHP 5. ADODB_mysql->GenID() /var/www/html/epesi/libs/phpgacl/gacl_api.class.php:3549
PHP 6. ADOConnection->Execute() /var/www/html/epesi/libs/adodb/drivers/adodb-mysql.inc.php:212
PHP 7. ADOConnection->_Execute() /var/www/html/epesi/libs/adodb/adodb.inc.php:1018
PHP 8. ADODB_Error_Handler() /var/www/html/epesi/libs/adodb/adodb.inc.php:1043
PHP 9. trigger_error() /var/www/html/epesi/libs/adodb/adodb-errorhandler.inc.php:77
UPDATE: further debugging shows that /libs/phpgacl/schema.xml that is used to create and populate tables does not have the definition for aco_sections_seq, whereas add_object_section apparently relies on this table to be there and hold sequence id... Without knowledge how it was intended to work it's difficult to say anything further - but it sure looks like a bug to me 🙁
I am looking at the old installation (v 1.2.2) and schema.xml doesn't have _seq table, either - but the table is in the database; so it is installed in some other way... but you guys probably know that 🙂
UPDATE 2: Hmm... I tried to install on a different server (the one where I was successful last year) - and I was more successful. All tables, including _seq, were created. The only difference that I can think of, is that the "good" server is running PHP 5.2, and "bad" is running PHP 5.3. I don't have debugging tools on "good" server, so I can't figure out where those additional tables get created. Anyway, I'd be happy to troubleshoot this further - but I need some guidance from the development team... Thanks.
