Just updated to client 2.3. Cleared cache and all blastchat cookies. Frontend seems to be working ok...

When accessing the config from admin backend side ( / com_blastchatc / config) I get this error:

QUOTE:
Error updating database: DB function failed with error number 1060
Duplicate column name 'adm_expand' SQL=ALTER TABLE `jos_blastchatc` ADD `adm_expand` BINARY( 1 ) DEFAULT '1' NOT NULL
SQL =

UPDATE `jos_components` SET name='BlastChat client 2.3' WHERE link LIKE 'option=com_blastchatc'

When I try to access the user mgmnt side ( / com_blastchatc / users) I get the error.

QUOTE:

Error updating database: DB function failed with error number 1060
Duplicate column name 'adm_expand' SQL=ALTER TABLE `jos_blastchatc` ADD `adm_expand` BINARY( 1 ) DEFAULT '1' NOT NULL
SQL =

UPDATE `jos_components` SET name='BlastChat client 2.3' WHERE link LIKE 'option=com_blastchatc'

and Registration ( / com_blastchatc / register) shows the same

QUOTE:

Error updating database: DB function failed with error number 1060
Duplicate column name 'adm_expand' SQL=ALTER TABLE `jos_blastchatc` ADD `adm_expand` BINARY( 1 ) DEFAULT '1' NOT NULL
SQL =

UPDATE `jos_components` SET name='BlastChat client 2.3' WHERE link LIKE 'option=com_blastchatc'

All instanses with nothing more than the error message.

So whattaheck am I supposed to do now?

Do not panic

1. Did you uninstall 2.2 and install 2.3, or uploaded and overwritten files?
2. Edit your blastchatc table and delete column "adm_expand"

1. uninstalled & installed, both com & mod
2. trying.... did so.

QUOTE:
Error updating database: DB function failed with error number 1091
Can't DROP 'session_id'; check that column/key exists SQL=ALTER TABLE `jos_blastchatc_users` DROP INDEX `session_id`
SQL =

UPDATE `jos_components` SET name='BlastChat client 2.3' WHERE link LIKE 'option=com_blastchatc'

I suppose I now need to delete or clear column "session_id" from jos_blastchatcusers table?

nope, just edit blastchatc table row, and change version field from value "2.2" to "2.3"

(or delete that key in session table, but also delete adm_expand in blastchatc, database upgrade did not finish, that's why all the problems)

works! Thanks!

Hi,

How can I edit your blastchatc table? I have no idea where the table is. Thanks.

ultraming