Bug in CMSMS Schema Creation

[merrony]

Hi,

After several successful installations in separate databases over the last few months I today tried installing a second CMSMS instance into an existing database.  Although the installation has 'worked' to an extent, I notice that no indexes were created on any tables for the second CMS  in the database.

Looking quickly at the database, it seems that the index names do not include the database prefix, so they will only be created for the first CMSMS installation in any database.

CMSMS 1.6.6
Linux
Postgresql 8.2

In my case the site is very small, so indexes are not a big issue, but for others this could cause problems.

Steve

[Peciura]

What is value of "$config['db_prefix']" for the second installation ? If it differs from the first installation, tables with different name prefix are created.

[merrony]

As I said, the tables are all fine - they have the correct prefixes.  It's just the indexes that couldn't be created as the prefix is not prepended to them as it should be.