Can not uninstall

[kasimi]

I remember now what the issue is. If you disable mChat and delete mChat data while Rooms is still enabled, you see this warning message:

mchat_delete_data.png

If you disable mChat, disable Rooms and delete mChat data, the Rooms extension isn't running and therefore the warning message can't be displayed.

I will try to find a way for you to get rid of the Rooms extension. In the meantime, assuming that mChat is not installed and Rooms is disabled, try this:

• install mChat
• disable mChat
• enable Rooms
• disable Rooms
• uninstall Rooms
• uninstall mChat

[jan_2017]

(...)

Code: Select all

- This code is only accessible to donors -

Deleting all mChat Rooms data with phpMyAdmin is a messy task as all kinds of tables are involved, I definitely recommend against it.

Ok now it´s perfekt

mchat 2.0.0 install and activated
mchat rooms also activated
clear mchat rooms does not work
create table in myphpadmin (as above)
clear mchat room data once again -without error
clear mchat data
delete files on server (mchat room + mchat)

VERY Thanks for your help

Bye Jan

[kasimi]

Glad you got it working!

[jan_2017]

Same problem once again :-/

phpbb 3.2.0 , mchat 2.0.3 , mchat rooms 1.2.1
i want to activate mchat rroms again

Allgemeiner Fehler
SQL ERROR [ mysqli ]

Unknown column 'mr.room_name' in 'order clause' [1054]

SQL

SELECT mr.room_id FROM (phpbb_mchat_rooms mr) ORDER BY LOWER(mr.room_name) ASC, mr.room_name ASC

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 999
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/ext/kasimi/mchatrooms/migrations/m10_sort_rooms.php
LINE: 61
CALL: phpbb\db\driver\factory->sql_query()

FILE: (not given by php)
LINE: (not given by php)
CALL: kasimi\mchatrooms\migrations\m10_sort_rooms->initial_sort_order()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 711
CALL: call_user_func_array()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 658
CALL: phpbb\db\migrator->run_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 436
CALL: phpbb\db\migrator->process_data_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 288
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 241
CALL: phpbb\db\migrator->update_do()

FILE: [ROOT]/phpbb/extension/base.php
LINE: 78
CALL: phpbb\db\migrator->update()

FILE: [ROOT]/ext/kasimi/mchatrooms/ext.php
LINE: 73
CALL: phpbb\extension\base->enable_step()

FILE: [ROOT]/ext/kasimi/mchatrooms/ext.php
LINE: 35
CALL: kasimi\mchatrooms\ext->trigger_notifications()

FILE: [ROOT]/phpbb/extension/manager.php
LINE: 185
CALL: kasimi\mchatrooms\ext->enable_step()

FILE: [ROOT]/includes/acp/acp_extensions.php
LINE: 197
CALL: phpbb\extension\manager->enable_step()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: acp_extensions->main()

FILE: [ROOT]/adm/index.php
LINE: 82
CALL: p_master->load_active()

[kasimi]

Disable Rooms and delete Rooms extension data, then run these three queries in phpMyAdmin and post the results.

Code: Select all

- This code is only accessible to donors -

Code: Select all

- This code is only accessible to donors -

Code: Select all

- This code is only accessible to donors -

[jan_2017]

Hi kasimi

after i try to enable mchat rooms the error above appears.
if i try delete data it comes white site with an errors

at the moment mchat rooms are disable

i have uploaded mchat files with es explorer at smartphone

Bye Jan

[kasimi]

I don't think there's an easier solution than cleaning your database of all the Rooms tables and columns manually.

Make a full database backup, then run these queries:

1. Code: Select all

   - This code is only accessible to donors -

2. Code: Select all

   - This code is only accessible to donors -

3. Code: Select all

   - This code is only accessible to donors -

4. Code: Select all

   - This code is only accessible to donors -

5. Code: Select all

   - This code is only accessible to donors -

6. Code: Select all

   - This code is only accessible to donors -

[jan_2017]

at point 3:

Fehler

SQL-Befehl:

DROP TABLE phpbb_mchat_rooms_users

MySQL meldet: Dokumentation
#1051 - Unbekannte Tabelle 'DB3118461.phpbb_mchat_rooms_users'

at point 5:

Fehler

SQL-Befehl:

ALTER TABLE phpbb_users DROP user_mchat_rooms_enabled, DROP user_mchat_rooms_enter_all

MySQL meldet: Dokumentation
#1091 - Kann 'user_mchat_rooms_enabled' nicht löschen. Existiert die Spalte oder der Schlüssel?

1,2,4,6 without errors

Now all my installed mcaht extensions are uninstalled. Delete Data works also fine!!!!!

I install mchat 2.1.0 over Filezilla , no smartphone. I test once again to enable mchat rooms with mchat 2.1.0

THANKS Kasimi!!!!!!!!!!!!!!

[kasimi]

Now all my installed mcaht extensions are uninstalled.

I hope that you disabled them yourself and it wasn't caused by these queries.

Glad it works now. For the future, if you want to delete Rooms extension:

1. Disable mChat
2. Disable Rooms
3. Delete Rooms data
4. Delete Rooms files
5. Enable mChat, or delete mChat data if you want to remove mChat as well

[jan_2017]

Now all my installed mcaht extensions are uninstalled.

I hope that you disabled them yourself and it wasn't caused by these queries.

Yes before i started , i disable all mchat extenstions.

Glad it works now. For the future, if you want to delete Rooms extension:

1. Disable mChat
2. Disable Rooms
3. Delete Rooms data
4. Delete Rooms files
5. Enable mChat, or delete mChat data if you want to remove mChat as well

Thanks once again
i hope i never need this no anymore.
Bye Jan