Can not uninstall

Chat rooms for mChat with optional password protection and 1-on-1 chats
User avatar
kasimi
mChat developer
Posts: 795
Joined: 06 Oct 2016, 09:56
Location: Germany
Contact:

Re: Can not uninstall

#11

Post by kasimi » 29 Apr 2018, 12:27

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
You do not have the required permissions to view the files attached to this post.

User avatar
jan_2017
Distinguished Donor
Posts: 131
Joined: 13 May 2017, 18:07

Re: Can not uninstall

#12

Post by jan_2017 » 29 Apr 2018, 12:48

kasimi wrote:
29 Apr 2018, 12:14
(...)

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 :D

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 :beer: :beer: :beer: :beer: :beer: :beer:

Bye Jan :D

User avatar
kasimi
mChat developer
Posts: 795
Joined: 06 Oct 2016, 09:56
Location: Germany
Contact:

Re: Can not uninstall

#13

Post by kasimi » 29 Apr 2018, 12:49

Glad you got it working! :+1:

User avatar
jan_2017
Distinguished Donor
Posts: 131
Joined: 13 May 2017, 18:07

Re: Can not uninstall

#14

Post by jan_2017 » 18 Aug 2018, 14:01

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()

User avatar
kasimi
mChat developer
Posts: 795
Joined: 06 Oct 2016, 09:56
Location: Germany
Contact:

Re: Can not uninstall

#15

Post by kasimi » 18 Aug 2018, 14:11

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 -

User avatar
jan_2017
Distinguished Donor
Posts: 131
Joined: 13 May 2017, 18:07

Re: Can not uninstall

#16

Post by jan_2017 » 18 Aug 2018, 14:19

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

User avatar
kasimi
mChat developer
Posts: 795
Joined: 06 Oct 2016, 09:56
Location: Germany
Contact:

Re: Can not uninstall

#17

Post by kasimi » 18 Aug 2018, 14:34

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 -

User avatar
jan_2017
Distinguished Donor
Posts: 131
Joined: 13 May 2017, 18:07

Re: Can not uninstall

#18

Post by jan_2017 » 18 Aug 2018, 14:44

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!!!!!!!!!!!!!! :beer: :ugeek:

User avatar
kasimi
mChat developer
Posts: 795
Joined: 06 Oct 2016, 09:56
Location: Germany
Contact:

Re: Can not uninstall

#19

Post by kasimi » 18 Aug 2018, 14:52

jan_2017 wrote:
18 Aug 2018, 14:44
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

User avatar
jan_2017
Distinguished Donor
Posts: 131
Joined: 13 May 2017, 18:07

Re: Can not uninstall

#20

Post by jan_2017 » 18 Aug 2018, 15:07

kasimi wrote:
18 Aug 2018, 14:52
jan_2017 wrote:
18 Aug 2018, 14:44
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.
kasimi wrote:
18 Aug 2018, 14:52
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 :+1:
i hope i never need this no anymore. :geek:
Bye Jan

Post Reply

Who is online

Users browsing this forum: rammstein and 1 guest