[Phpgroupware-developers] problem dont creating all tables during newinstall of phpgw

[aeb]

hey,
the problem creating the tables during a new install using mysql is fixed
(i hope).
when there were more than one column spcified as index, the resulting
query string for mysql putted the INDEX (org_id)INDEX (active) ... just
together, for mysql is a comma needed to seperate the indizes.

Create Table phpgw_contact_personDatabase error: Invalid SQL: CREATE TABLE
phpgw_contact_org (org_id int NOT NULL, name varchar(80) NOT NULL, active
char(1) NOT NULL DEFAULT 'Y', parent int, created_on int NOT NULL,
created_by int NOT NULL, modified_on int NOT NULL, modified_by int NOT
NULL, INDEX (org_id)INDEX (active))
MySQL Error: 1064 (You have an error in your SQL syntax near ')' at line
9)

so for pgsql it works in the way the indizes just are putted together
without space and/or comma...?  odd

i changed function _GetIX in class.schema_proc.inc.php to add commata
between the index specifications. it works for mysql, cant test pgsql.
also im not sure if it will work with all mysql versions...

i added a check for mysql, so the commata atm just get added if using
mysql. so for pgsql it works like before, without adding spaces and
commata.

the same problem we will have with more than one fk, pk and uc and mysql i
guess, since all of that functions work in the same way.

lex: when you droped the indizes from the api table_current file you just
removed these ones from table_acl and table_config , but all of the
contact indizes were still there. this caused setup broke and stopped
creating the tables.

could you (all) please test properly before committing that important
function changes.

i am pretty upset, btw. who creates the next 16 release version and
what reason? *There were some problems with the original 0.9.16.000-1
tarballs...* rofl

grtx. ceb(ranting)