Database Query Error when deleting a user

Any help anyone can provide on DB Query Error when a user is deleting his/her account from the site?

Thanks

 State the error you are getting.

 I got this error after I had added a new member and the system directed me to the account page, where I decided to click on the Unregister Menu Option, clicked on Delete Account. Immediately I got the error below.

Just as a note I also have a previous error which I have no idea how it was generated, since someone else caused it. If you need to see the other error let me know.

Query:

SELECT `cmt_id`, `cmt_parent_id` FROM abusiness_listing_product_cmts WHERE `cmt_author_id` = '99' AND `cmt_replies` = 0

Mysql error: Table 'ummahlin_dol.abusiness_listing_product_cmts' doesn't exist

Found error in the file '/home2/ummahlin/public_html/inc/classes/BxDolCmtsQuery.php' at line 167.
Called 'getAll' function with erroneous argument #0.

 oddly enough, seems the complaint here is that the comment has already been deleted, and mysql says it does not exist. however, it seems to have been removed in a non-standard method. typically if you cannot replicate the error, then its not really much to worry about.

if you can replicate the error, or provide a means in which steps you had taken to produce the error, then it can be traced and addressed.

SELECT `cmt_id`, `cmt_parent_id` FROM abusiness_listing_product_cmts WHERE `cmt_author_id` = '99' AND `cmt_replies` = 0

 also,

can you please state:

dolphin version

module - default or modified, or 3rd party

i will go now and try this on an unmodified dolphin 7.0.8, and report back

Latest Dolphin version 7.0.8. I just Joined a new member, the system took me to the Account Page after joining, there i clicked Unregister then Clicked on Delete Accoutn and Wham the error.

So, yes I tried it again and the same thing.

Did you previously have a business listing mod installed and then uninstalled it?

Not that I am aware of.  I must chat with my Splash Page installer then, looks like they are mucking about with some sort of testing.

This is not good. So you are saying there is residence of some sort of mod within the DB?

It's trying to delete something from the table "abusiness_listing_product_cmts" but that table isn't there. It doesn't look familiar to me so I thought it was part of a mod.

So you are saying that a table has been created on my DB, when I delete a member, it is searching to see if there is a value in that table which it is trying to delete, but it cannot find the Table in question?

Is that the jist of it?

@presscon

i could not replicate this error. 

i have a newly registered, unconfirmed user on a Dolphin 7.0.8 account

i logged in and hit the unregister link and all went well. 

but it also seems that you are in the middle of the registration, since when you get sent to the profile page, and at this juncture you should be adding an avatar i think. so i will try that as well.

here is the video, and will create another when i create this new account, and upon being sent to the profile page, which for me, it will require email verification to be redirected to that page. 

but back in a moment or so with results. 

but yes, mscott is correct, that column that it is trying to write to, seems that is non-default. 

http://www.youtube.com/watch?v=9ZV1P1z65Bk

Yes, that's the jist of it. Normally this happens when a mod is installed and then un-installed but not everything get's taken out. In this case it would be the code in the delete account function that deletes the users product comments.

@DosDawg and @mscott - I thank you both for your most prompt responses. At least I know it is not Dolphin causing this.

Thanks again and modzzz appreciate your initial response to get it started.

 @presscon

i have created the second video, in our attempt at deciphering your report. 

 abusiness_listing_product_cmts

this table is what is producing the error it seems. so you have some added module, that may at some point been removed, though the database didnt clean up or you have danglers, which need to be cleaned.

Extended Investigation on database error report when unregistering newly created user. 

http://www.youtube.com/watch?v=HwYf3CfzrzQ

Terrific Thanks again, so very much.

You definitely have (or had) a business listing mod installed on your site. PM me your FTP details and I will tell you what it is.