Error with tables (aro_groups)

wirehack7

Hello,

whenever I try to install epesi some erros are occuring. The first error is a blank box after starting the database steps. I entered the connection details and clicked Next. After some time the next page loads, but there is only the blank box where the content should appear. No error message, nothing.
Then I reloaded the page with the main url, there I have to enter login details and SMTP. After clicking next these errors are occuring:

Type: 256

Message: mysqlt error: [1146: Table 'epesi.aro_groups' doesn't exist] in EXECUTE("SELECT id FROM aro_groups WHERE value='User'")

File: H:\xampp\htdocs\epesi\libs\adodb\adodb-errorhandler.inc.php

Line=77

error backtrace:

[PHP core called function]

    function called: handle_epesi_error(256, "mysqlt error: [1146: Table 'epesi.aro_groups' doesn't exist] in EXECUTE(\"SELECT id FROM aro_groups WHERE value='User'\") ", "H:\xampp\htdocs\epesi\libs\adodb\adodb-errorhandler.inc.php", 77, Array ("mysqlt", "EXECUTE", 1146, "Table 'epesi.aro_groups' doesn't exist", "SELECT id FROM aro_groups WHERE value='User'", false, Object (ADODB_mysqlt), "SELECT id FROM aro_groups WHERE value='User'", false, "mysqlt error: [1146: Table 'epesi.aro_groups' doesn't exist] in EXECUTE(\"SELECT id FROM aro_groups WHERE value='User'\") "))

File: H:\xampp\htdocs\epesi\libs\adodb\adodb-errorhandler.inc.php

    line 77

    function called: trigger_error("mysqlt error: [1146: Table 'epesi.aro_groups' doesn't exist] in EXECUTE(\"SELECT id FROM aro_groups WHERE value='User'\") ", 256)

File: H:\xampp\htdocs\epesi\libs\adodb\adodb.inc.php

    line 1043

    function called: ADODB_Error_Handler("mysqlt", "EXECUTE", 1146, "Table 'epesi.aro_groups' doesn't exist", "SELECT id FROM aro_groups WHERE value='User'", false, "Object (ADODB_mysqlt)")

File: H:\xampp\htdocs\epesi\libs\adodb\adodb.inc.php

    line 1018

    function called: _Execute("SELECT id FROM aro_groups WHERE value='User'", false)

File: H:\xampp\htdocs\epesi\libs\phpgacl\gacl_api.class.php

    line 1447

    function called: Execute("SELECT id FROM aro_groups WHERE value='User'")

File: H:\xampp\htdocs\epesi\include\acl.php

    line 75

    function called: get_group_id("User")

File: H:\xampp\htdocs\epesi\modules\CRM\Acl\AclInstall.php

    line 15

    function called: add_groups(Array (Array (#1)))

[PHP core called function]

    function called: install()

File: H:\xampp\htdocs\epesi\include\module_manager.php

    line 518

    function called: call_user_func(Array (Object (CRM_AclInstall), "install"))

File: H:\xampp\htdocs\epesi\include\module_manager.php

    line 199

    function called: install("CRM_Acl", 0, false)

File: H:\xampp\htdocs\epesi\include\module_manager.php

    line 500

    function called: satisfy_dependencies("Base_User_Settings", 0, false)

File: H:\xampp\htdocs\epesi\include\module_manager.php

    line 199

    function called: install("Base_User_Settings", 0, false)

File: H:\xampp\htdocs\epesi\include\module_manager.php

    line 500

    function called: satisfy_dependencies("Utils_Tooltip", 0, false)

File: H:\xampp\htdocs\epesi\include\module_manager.php

    line 199

    function called: install("Utils_Tooltip", 0, false)

File: H:\xampp\htdocs\epesi\include\module_manager.php

    line 500

    function called: satisfy_dependencies("Base_About", 0, false)

File: H:\xampp\htdocs\epesi\include\module_manager.php

    line 199

    function called: install("Base_About", 0, false)

File: H:\xampp\htdocs\epesi\include\module_manager.php

    line 500

    function called: satisfy_dependencies("Base", 0, false)

File: H:\xampp\htdocs\epesi\modules\FirstRun\FirstRun_0.php

    line 130

    function called: install("Base", null, false)

[PHP core called function]

    function called: done(Array (Array (#2), "\"\\"Array (#5)\\"\"", "\"\\"Array (#5)\\"\"", "\"\\"Array (#2)\\"\"", "\"\\"Array (#2)\\"\"", "\"\\"Array (#1)\\"\"", "\"\\"Array (#1)\\"\""))

File: H:\xampp\htdocs\epesi\modules\Utils\Wizard\Wizard_0.php

    line 227

    function called: call_user_func_array(Array (Object (FirstRun), "done"), Array (Array (#7)))

[PHP core called function]

    function called: body(Array (Object (FirstRun), "done"))

File: H:\xampp\htdocs\epesi\include\module.php

    line 793

    function called: call_user_func_array(Array (Object (Utils_Wizard), "body"), Array (Array (#2)))

File: H:\xampp\htdocs\epesi\include\module.php

    line 713

    function called: get_html_of_module(Object (Utils_Wizard), Array (Array (#2)), null)

File: H:\xampp\htdocs\epesi\modules\FirstRun\FirstRun_0.php

    line 112

    function called: display_module("Object (Utils_Wizard)", Array (Array (#2)))

File: H:\xampp\htdocs\epesi\include\epesi.php

    line 209

    function called: body()

File: H:\xampp\htdocs\epesi\include\epesi.php

    line 265

    function called: go(Object (FirstRun))

File: H:\xampp\htdocs\epesi\process.php

    line 32

    function called: process("_qf__libs_qf_aa146f0e514131eaa8473bf23ad239e0=&submited=1&button_prev=Prev&button_next=Next&__action_module__=%2FFirstRun%7C0%2FUtils_Wizard%7C0", false)

Yes I tried first to run it local in XAMPP for testing purposes.

Also I tried to install with easyinstall.php. There are no errors shown at the first step for compatibility.
I hope you are able to help.

jasiek

Hi,
In epesi/data directory you should find first run log file. Inspect it or post it here.
Do you have data directory populated with subfolders (catalogs)? Was config.php file created? How about the database? Did epesi setup create any tables? Check MySQL log file for errors if you don't see any tables. From what you described your setup can not be completed and in the very early stages.

Check this post: viewtopic.php?f=3&t=496&p=1929#p1929

My feeling is - tables are not created - you don't have sufficient permissions given to the database.

wirehack7

The log says
2012-03-27 08:06:43: installing "Base" ...

Also the database user has the rights, I tried it with root. And the database was created during install from the install routine.

A config.php file was created in data/

Oh, and tables are created, but not all of them.

jasiek

Thank you for posting the log. It is very short. The setup quits at a very early stage.

Do you have access to mysql and php error logs? Something must prevent the setup to continue. It is server specific. We installed and tested epesi on many, many combinations of hardware, os and configurations: Linux and Windows, OS X, IIS and Apache, Windows with Apache, with and without accelerators, MySQL and PostgreSQL. Lots of different hosting providers. Maybe some missing extension needs to be enabled? These logs should give you some clue.

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge