7.1 - in build, delete members doesnt do anything.
Had a few spam members join recently, not put anti spam measures properly in place just yet.
However, I can deactivate a member in admin and their profile names 'greys out', or I can 'ban' them and they show in 'red', but try and delete them?... nothing.
'delete spammer' and 'delete' just doesnt do anything at all. screen refreshes, and no change.
Any suggestions?
|
also, in members area in admin, when logged in as admin, I still get the message at bottom -
You are not currently an active member. Please ask the site administrator to make you an active member so you can use this feature.
|
try clearing site cache and browser cache - see if that helps. caredesign.net |
also, in members area in admin, when logged in as admin, I still get the message at bottom -
You are not currently an active member. Please ask the site administrator to make you an active member so you can use this feature.
I saw that once. I think it went away when I cleared /cache and /cache_public (do not delete the .htaccess files in those directories) and cleared the cache in admin.
Geeks, making the world a better place |
no, clearing cache makes no difference. |
Try turning off JS caching and compression in dolphin.
Also. A member is deleted in admin with a ajax call. Which is javascript. Ajax makes it very difficult to determine if a error is occurring. The reason i dislike ajax and feal it should only be used if absolutly necessary. Unfortunately people are constantly asking for ajax so everything can occur on one page instead of several pages. But it has it's drawbacks as well. Debugging is the biggest drawback.
So try this. Change the members password so you can log directly into there account. Then remove it that way using unregister.php. Using that script should reveal any errors that occur. https://www.deanbassett.com |
also, in members area in admin, when logged in as admin, I still get the message at bottom -
You are not currently an active member. Please ask the site administrator to make you an active member so you can use this feature.
I cannot find that text in any of dolphins default files. Perhaps that is from a 3'rd party module.
https://www.deanbassett.com |
JS cache and compressions is already off, as is all other cache.
The language string is from this block - _adm_btn_mp_unban - which is a system file.
|
logged on as one of the accounts to be deleted, and went to unregister.php
following error shows :-)
Database query error
Query: SELECT `cmt_id`, `cmt_parent_id`, `cmt_object_id` FROM [db_prefix]_img_cmts WHERE `cmt_author_id` = '11' AND `cmt_replies` = 0
Mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[db_prefix]_img_cmts WHERE `cmt_author_id` = '11' AND `cmt_replies` = 0' at line 1
|
_adm_btn_mp_unban
The content of that language key is 'Unban' It is not You are not currently an active member. Please ask the site administrator to make you an active member so you can use this feature.
So i still do not know where that is coming from.
https://www.deanbassett.com |
img_cmts
That table name in your database error does not belong to any default dolphin modules. So a 3'rd party module is causing it. Considering the key [db_prefix] is actually showing up in the query rather than the actual modules database prefix i can only assume that it is from a module that you may have recently uninstalled that did not completely uninstall.
Whats happening is when deleting a member dolphin is calling an alert that is in the database which in turn is attempting to call that module to delete what appears to be image comments for the member being deleted. But cannot do it due to the error.
If you have a local copy of your site and a tool to search through all your files for strings such as agent_ransack then you could find out which module it is by searching all site files for "_img_cmts" Once you know which module it is, you will then be able to go from there such as removing the alerts it installed in the database.
https://www.deanbassett.com |
Thanks. Ive got an idea what it may be as recently had issues un-installing a module...
As for the language string, its definately the unban one...
this is the full string text within the string itself.
<div style="width: 80%">You are not currently an active member. Please ask the site <a href="mailto:{7}">administrator</a> to make you an active member so you can use this feature.</div>
its the only string that shows when I search the text.
odd though, in admin, it shows this text twice. Once in a 'button' that spans the width of the admin interface, then again just in text underneath.
|
this is the full string text within the string itself.
<div style="width: 80%">You are not currently an active member. Please ask the site <a href="mailto:{7}">administrator</a> to make you an active member so you can use this feature.</div>
Very strange. I have checked though a freshly unpacked archive. I cannot find that string anywhere. And the language key _adm_btn_mp_unban in all the copys of dolphin that i have contain the string "Unban"
So i cannot explain it.
https://www.deanbassett.com |
Ok. Do you have this module installed?
Membership Management Pro
I believe that is what installed or changed the default unban string to
You are not currently an active member. Please ask the site administrator to make you an active member so you can use this feature.
There are other topics in the forums with that string and one of those topics points out that module from martinboi
I know it has to be a 3'rd party module. I have checked a dozen times in 4 different versions of dolphin. That string does not exist in stock dolphin.
https://www.deanbassett.com |
yes...
Ok. Do you have this module installed?
Membership Management Pro
|
strange.
Ive searched img_cmts in my whole site files but no ref to it being found.
I did uninstall AndrewP's Photo Albums for Groups module recently and had issues un-installing it due to bad upload. Since managed to re-install and its working fine, could be something to do with this as its referring to image comments...
Any ideas where I would be looking within phpmyadmin?
|
You could try this query in phpMyAdmin
SHOW TABLES LIKE '%_img_cmts'
That should show you the full table name. Once you have that you should know which module it belongs to. https://www.deanbassett.com |
fixed.
they were in sys_objects_cmts
I had manually updates some sql files on a module, and it duplicated these tables but with wrong prefix.
removed those and all working fine now :-)
thanks for assistance.
|