is there a way to delete users from within Delavo?

[Michael Kruzewicz]

Hi,

i'm testing my installation and wonder if there is a way to delete users from within the script.

I haven't found any "delete user" button yet (only a merge seems to be there).

Do we have to delete the record manually from the db, if we want to get rifd of - for instance testusers?

Regards,

Michael

[Susie Jones]

Hi Michael,

No it is not possible to delete a user from the system. Donna has detailed the reasons in this thread.

http://delavo.com/support/index.php/topic,102.0.html

Cheers,

Susie

[Neil Robins]

Hi Michael

I've the same problem while testing my installation. For the different accounts I've used for my own testing, I just merge them into my master or one other account I keep for testing.

Regards

Neil Robins
www.EasyMarketingGroup.com

[Mitch Powell]

Looks like we're going to need to migrate that post over here.

Mitch

Hi Michael,

No it is not possible to delete a user from the system. Donna has detailed the reasons in this thread.

http://delavo.com/support/index.php/topic,102.0.html

Cheers,

Susie

[SP Zaayman]

Go to MySQL Server

Open phpMyAdmin

In left nav panel - select Delavo database


In main panel - scroll down till you find "jin_user"
Select "jin_user" box and click on browse


All members will be visible in main panel

Select member/users you want to delete by clicking in select box

Click on delete

Next page will open asking:
Do you really want to : DELETE FROM `jin_user` WHERE `jin_user`.`id`....?


If correct then click on YES


User/Users will be deleted


Next page will open and you should see:
"Your SQL query has been executed successfully"



Exit phpMyAdmin



PS. Use at own risk

[Brian Collins]

SP,

I would not recommend this as there are dependencies (like order records, memberships etc. in other tables) for a user and the database may break.

Brian

[SP Zaayman]

Hi Brian

I am still learning and testing the Delavo script.

While I was trying to get my autoresponder (hosted on my server) to integrate with the purchase process I kept testing it and obviously every time I made a "sale" it added the user to my Delavo database.

I eventually decided to remove the users and found no way to do it from within Delavo and proceeded to investigate the database files.

You are 100% correct - data is linked and while I am testing the system it is very easy to trace and remove it.

However - if your system is live with multiple entries it will get confusing for anyone who does`t know their php from their sql. I personally wouldn`t do this on a live database.