Delete members not working.

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?

Quote · 10 Aug 2014

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.

Quote · 10 Aug 2014

try clearing site cache and browser cache - see if that helps.

caredesign.net
Quote · 10 Aug 2014

 

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
Quote · 11 Aug 2014

no, clearing cache makes no difference.

Quote · 11 Aug 2014

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
Quote · 11 Aug 2014

 

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
Quote · 11 Aug 2014

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.

Quote · 11 Aug 2014

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
Quote · 11 Aug 2014

 

_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
Quote · 11 Aug 2014

 

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
Quote · 11 Aug 2014

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.

Quote · 11 Aug 2014

 


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
Quote · 11 Aug 2014

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
Quote · 11 Aug 2014

 yes...

Ok.  Do you have this module installed?

Membership Management Pro

 

Quote · 11 Aug 2014

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?

Quote · 11 Aug 2014

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
Quote · 11 Aug 2014

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.

Quote · 11 Aug 2014
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.