Previous Thread
Next Thread
Print Thread
Hop To
[FIXED for 7.5.1] can not delete member
#223192 02/26/2009 11:49 AM
Joined: Jun 2006
Posts: 869
Stan Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 869
get this error

Tried to replace 2 placeholders with 1 replaces. That's bad. Here's the query: delete from ubbt_PROFILE_COMMENTS where PROFILE_ID = ? or USER_ID = ?


Last edited by Rick; 02/27/2009 10:46 AM.
Re: can not delete member
Stan #223194 02/26/2009 11:54 AM
Joined: Apr 2007
Posts: 3,938
SD Offline
Former Developer
Offline
Former Developer
Joined: Apr 2007
Posts: 3,938
that's a bug.. remove the PROFILE_ID=? line in the code smile

oops.. Rick has the fix0r already posted

Linky Poo™

Re: can not delete member
Stan #223196 02/26/2009 11:58 AM
Joined: Dec 2003
Posts: 6,056
Likes: 3
Offline
Joined: Dec 2003
Posts: 6,056
Likes: 3
You know I am seeing a lot of errors on user profile items on this release.
I believe Rick did repost the install zip with some cleanup in the code.
Also here is a post on the same issue with a fix from Rick.
HERE


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: can not delete member
Ruben #223197 02/26/2009 12:05 PM
Joined: Jun 2006
Posts: 869
Stan Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 869
did that now I get this error

Quote
Script: /var/www/vhosts/clubadventist.org/httpdocs/forum/admin/dodeleteuser.php
Line#: 222
SQL 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 'or USER_ID = 748' at line 2
SQL Error #: 1064
Query: delete from ubbt_PROFILE_COMMENTS or USER_ID = 748


http://clubadventist.com/forums

No longer following the carrot
Re: can not delete member
Stan #223201 02/26/2009 12:19 PM
Joined: Apr 2007
Posts: 3,938
SD Offline
Former Developer
Offline
Former Developer
Joined: Apr 2007
Posts: 3,938
well, don't remove the WHOLE LINE...

gotta keep the 'where' there .. the linky poo i gave you shows ricks fix wink

Re: can not delete member
Stan #223203 02/26/2009 12:20 PM
Joined: Jun 2006
Posts: 9,243
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,243
Fix not quite applied right. You have to change that or to a where. check here.

Re: can not delete member
Rick #223211 02/26/2009 12:45 PM
Joined: Jun 2006
Posts: 869
Stan Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 869
Done thanks


http://clubadventist.com/forums

No longer following the carrot

Link Copied to Clipboard
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
how to check forum for slow posting
by Ruben - 02/25/2020 2:17 PM
AWS Lightsail platform
by jjjjj - 02/20/2020 7:27 AM
Users cant register after upgrade to Version 7
by Jim0421 - 02/13/2020 11:32 PM
Looking for best site firewall and CDN service
by Ruben - 02/11/2020 3:01 PM
Who's Online Now
0 members (), 68 guests, and 40 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Snapshot build 20200221)