Chat rooms for mChat with optional password protection and 1-on-1 chats
-
kasimi
- mChat developer
- Posts: 866
- Joined: 06 Oct 2016, 09:56
- Location: Germany
-
Contact:
#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.
-
jan_2017
- Distinguished Donor
- Posts: 131
- Joined: 13 May 2017, 18:07
#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
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
- mChat developer
- Posts: 866
- Joined: 06 Oct 2016, 09:56
- Location: Germany
-
Contact:
#13
Post
by kasimi » 29 Apr 2018, 12:49
Glad you got it working!

-
jan_2017
- Distinguished Donor
- Posts: 131
- Joined: 13 May 2017, 18:07
#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()
-
kasimi
- mChat developer
- Posts: 866
- Joined: 06 Oct 2016, 09:56
- Location: Germany
-
Contact:
#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 -
-
jan_2017
- Distinguished Donor
- Posts: 131
- Joined: 13 May 2017, 18:07
#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
-
kasimi
- mChat developer
- Posts: 866
- Joined: 06 Oct 2016, 09:56
- Location: Germany
-
Contact:
#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:
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 -
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
- Distinguished Donor
- Posts: 131
- Joined: 13 May 2017, 18:07
#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!!!!!!!!!!!!!!

-
kasimi
- mChat developer
- Posts: 866
- Joined: 06 Oct 2016, 09:56
- Location: Germany
-
Contact:
#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:
- Disable mChat
- Disable Rooms
- Delete Rooms data
- Delete Rooms files
- Enable mChat, or delete mChat data if you want to remove mChat as well
-
jan_2017
- Distinguished Donor
- Posts: 131
- Joined: 13 May 2017, 18:07
#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:
- Disable mChat
- Disable Rooms
- Delete Rooms data
- Delete Rooms files
- 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
Users browsing this forum: Bing [Bot] and 1 guest