Installation problem: application installation

[bdirsch]

Hello everybody,

I’m installig eGroupware for the first time. I’m stuck at “Step 1 - simple application management” in the eGroupware setup.

The database has been created, but when the the “All applications” are supposed to be installed I get the following error messages:

---

CreateTableSQL(‘egw_config’,‘config_app C(50) NOTNULL PRIMARY, config_name C(255) NOTNULL PRIMARY, config_value X’) sql=Array ( [0] => CREATE TABLE egw_config ( config_app VARCHAR(50) NOT NULL, config_name VARCHAR(255) NOT NULL, config_value TEXT, PRIMARY KEY (config_app, config_name) )CHARACTER SET utf8 )

Table ‘egroupware.egw_config’ already exists

CreateTableSQL(‘egw_applications’,‘app_id I AUTOINCREMENT NOTNULL PRIMARY, app_name C(25) NOTNULL, app_enabled I4 NOTNULL, app_order I4 NOTNULL, app_tables X NOTNULL, app_version C(20) NOTNULL DEFAULT ‘0.0’, app_icon C(32), app_icon_app C(25), app_index C(64)’) sql=Array ( [0] => CREATE TABLE egw_applications ( app_id INTEGER NOT NULL AUTO_INCREMENT, app_name VARCHAR(25) NOT NULL, app_enabled INTEGER NOT NULL, app_order INTEGER NOT NULL, app_tables TEXT, app_version VARCHAR(20) NOT NULL DEFAULT ‘0.0’, app_icon VARCHAR(32), app_icon_app VARCHAR(25), app_index VARCHAR(64), PRIMARY KEY (app_id) )CHARACTER SET utf8 )

Table ‘egroupware.egw_applications’ already exists

CreateIndexSQL(NULL,‘egw_applications’,‘app_name’,Array ( [0] => UNIQUE ) ) sql=Array ( [0] => ALTER TABLE egw_applications ADD UNIQUE INDEX egw_applications_name (app_name) )

Table ‘egroupware.egw_applications’ doesn’t exist

CreateIndexSQL(NULL,‘egw_applications’,Array ( [0] => app_enabled [1] => app_order ) ,Array ( ) ) sql=Array ( [0] => ALTER TABLE egw_applications ADD INDEX egw_applications_enabled_order (app_enabled, app_order) )

Table ‘egroupware.egw_applications’ doesn’t exist
…

---

This is followed by another bunch of “egw_application’ doesn’t exist” messages.
The tables egw_applications & egw_config don’t actually exist in the database.

I hope somebody can shed some light into my problem.

Thanks in advance
Boris

[Ralf_Becker_Stylite]

Hi Boris,

Hello everybody,

I’m installig eGroupware for the first time. I’m stuck at “Step 1 - simple
application management” in the eGroupware setup.

The database has been created, but when the the “All applications” are
supposed to be installed I get the following error messages:

---

CreateTableSQL(‘egw_config’,‘config_app C(50) NOTNULL PRIMARY, config_name
C(255) NOTNULL PRIMARY, config_value X’) sql=Array ( [0] => CREATE TABLE
egw_config ( config_app VARCHAR(50) NOT NULL, config_name VARCHAR(255)
NOT NULL, config_value TEXT, PRIMARY KEY (config_app, config_name)
)CHARACTER SET utf8 )

Table ‘egroupware.egw_config’ already exists
Your database should be empty, but it contains some tables.

Drop all tables via mysql commandline or phpMyAdmin and try again.

Ralf

CreateTableSQL(‘egw_applications’,‘app_id I AUTOINCREMENT NOTNULL PRIMARY,
app_name C(25) NOTNULL, app_enabled I4 NOTNULL, app_order I4 NOTNULL,
app_tables X NOTNULL, app_version C(20) NOTNULL DEFAULT ‘0.0’, app_icon
C(32), app_icon_app C(25), app_index C(64)’) sql=Array ( [0] => CREATE TABLE
egw_applications ( app_id INTEGER NOT NULL AUTO_INCREMENT, app_name
VARCHAR(25) NOT NULL, app_enabled INTEGER NOT NULL, app_order INTEGER
NOT NULL, app_tables TEXT, app_version VARCHAR(20) NOT NULL DEFAULT
’0.0’, app_icon VARCHAR(32), app_icon_app VARCHAR(25), app_index
VARCHAR(64), PRIMARY KEY (app_id) )CHARACTER SET utf8 )

Table ‘egroupware.egw_applications’ already exists

CreateIndexSQL(NULL,‘egw_applications’,‘app_name’,Array ( [0] => UNIQUE ) )
sql=Array ( [0] => ALTER TABLE egw_applications ADD UNIQUE INDEX
egw_applications_name (app_name) )

Table ‘egroupware.egw_applications’ doesn’t exist

CreateIndexSQL(NULL,‘egw_applications’,Array ( [0] => app_enabled [1] =>
app_order ) ,Array ( ) ) sql=Array ( [0] => ALTER TABLE egw_applications
ADD INDEX egw_applications_enabled_order (app_enabled, app_order) )

Table ‘egroupware.egw_applications’ doesn’t exist
…

---

This is followed by another bunch of "egw_application’ doesn’t exist"
messages.
The tables egw_applications & egw_config don’t actually exist in the
database.

I hope somebody can shed some light into my problem.

Thanks in advance
Boris

–
Ralf Becker
Director Software Development

Stylite AG

Morschheimer Strasse 15 | Tel. +49 6352 70629 0
D-67292 Kirchheimbolanden | Fax. +49 6352 70629 30

Email: rb@stylite.de

www.stylite.de | www.egroupware.org

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer

VAT DE214280951 | Registered HRB 31158 Kaiserslautern Germany

[bdirsch]

HiRalf,

thanks for your quick reply.

I cannot delete the mentioned tables since they do not exist in the database:

MariaDB [(none)]> use egroupware;
Database changed
MariaDB [egroupware]> show tables;
Empty set (0.00 sec)

I cannot find the tables (e.g. “egw_applications.frm”) anywhere in the system.

maybe it’s indicative that while the installation command complains about the existing tables it writes:
– "Table ‘egroupware.egw_applications’ already exists"
while lateron it states:
– "Table ‘egroupware.egw_applications’ doesn’t exist"
this times the ` are missing.

Thanks again
Boris