Error deleting members! =(

[Buraaq]

Heya all!!

My forum was running perfectly fine up till yesterday, when I tried deleting a member so they could re register (their email validation was giving them some problem). Anyways, when I deleted the user, I got this error:

Unknown column 'id_member' in 'where clause'
File: /home/dastakd1/public_html/cscf/Sources/Subs-Members.php
Line: 385

Now the thing is, when I go back and view my memberlist, that particular member is not there anymore. BUT, they can STILL not register as they end up getting an error that an account with their provided email address already exists.

I can still get them registered using invitation, but I want this error out of the system. What do I do?

Thanks a lot in advance! 

[xenovanis]

Admin -> Maintenance -> Forum Maintenance -> Routine -> Check all files against current versions

Could you please post back the results of that? If any files in red, please mark them red here as well.

[Buraaq]

done that already. everything is up to date. and Thanks for the response =)

[xenovanis]

What mods have you installed?

Are there any errors in your log?

[Buraaq]

Yup! MANY!

   ENotify    1.0.8     
   Remember Position After Login/Logout    1.0.0     
   Custom Form Mod    1.6     
   Facebook Video BBC    1.0     
   SA FBConnect    1.0 Beta5 Rev264 
   Facebook_Like v.1.3    1.3     
   Google Analytics Code    1.1     
   AjaxChat Integration    3.2.1 (modified for SMF 2 RC3)     
   UrbanDictionary.com BBC    1.0     
   Pretty URLs    1.0RC2a     
   Advanced Reputation System    1.8.1     
   Drafts (for SMF 2.0 / SMF 1.1)    2.0.1     
   Enhanced Dropdown    1.1     
   SMF Arcade    2.5 RC1 
   Caps_Lock_Detection_on_Login    1.1.0.1     
   EmailValidator    1.0     

And yup I tried installing Board sorts method mod; it showed error. I tried fixing the issue but didn't work out so I DID install it without resolving the errors. The mod didn't work so I uninstalled it =/

[xenovanis]

Please, feel free to elaborate on the errors in your log.

In addition, attach the file /Sources/Subs-Members.php.

[Buraaq]

well in my logs, there are over 2000 errors, 3 of them "critical" and 9 of them relating to database. You FOllowing are the critical ones:

Shoaib Alvi
58.181.102.30   
September 10, 2010, 12:25:18 AM
45add08571b4928a5a136af067c4598b
Type of error: Critical
http://dastakdo.com/cscf/index.php?action=admin;area=viewmembers;sa=browse;type=approveAdministration login attempt!
Referer: http://dastakdo.com/cscf/index.php?action=admin;area=viewmembers;sa=browse;type=approve
User agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US) AppleWebKit/533.4 (KHTML, like Gecko) Chrome/5.0.375.127 Safari/533.4
IP: 58.181.102.30

Shoaib Alvi
58.181.102.30   
September 09, 2010, 11:46:25 PM
dfcd12615839fe60eefd4f15ad25a2f3
Type of error: Critical
http://dastakdo.com/cscf/index.php?action=adminAdministration login attempt!
Referer: http://dastakdo.com/cscf/index.php?action=admin
User agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US) AppleWebKit/533.4 (KHTML, like Gecko) Chrome/5.0.375.127 Safari/533.4
IP: 58.181.102.30
   
Shoaib Alvi
58.181.102.89   
September 09, 2010, 11:24:59 AM
e5371b31b21d6eb72e9cfb2c7c863c18
Type of error: Critical
http://dastakdo.com/cscf/index.php?action=adminAdministration login attempt!
Referer: http://dastakdo.com/cscf/index.php?action=admin
User agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US) AppleWebKit/533.4 (KHTML, like Gecko) Chrome/5.0.375.127 Safari/533.4
IP: 58.181.102.89

i have no clue what to make of all this. I can post the 9 database logs or any other logs you like too if that would help? As for the error related to boards method mod, it was that general error you get when you try installing a mod which is not passing the tests. It read as follows anyway:

[xenovanis]

This is your problem:

Drafts (for SMF 2.0 / SMF 1.1)    2.0.1

For some reason, it's using the wrong tablename.

Code Select Expand


DELETE FROM {db_prefix}drafts


should be

Code Select Expand


DELETE FROM {db_prefix}post_drafts


Could you try uploading attached file and see if that helps?

[Buraaq]

sure. gonna try it now. Thanks a million mate!!

[Buraaq]

Nopes xenovanis. No luck.

I made up a dummy account, and deleted it afterwards. Same error =/

[xenovanis]

Try clearing your cache in Admin -> Maintenance -> Forum Maintenance, then try again.

[Buraaq]

still no luck mate 

[xenovanis]

It's time for bed here. I'll try to have another look at it tomorrow.

[Buraaq]

sure! same here =)

[xenovanis]

Sorry for the late reply, Buraaq. Had some things over the weekend.

I found the problem in this line in Subs-Members.php

Code Select Expand


WHERE id_member IN ({array_int:users})',


should be

Code Select Expand


WHERE member_id IN ({array_int:users})',


Tested succesfully

You can upload attached file to fix it.

[Buraaq]

Oh greaT!! works perfectly fine! Thanks a lot, you are a life saver!!