Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
0 registered members (), 88 guests, and 237 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Steve M
Steve M
MO, USA
Posts: 71
Joined: July 2011
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 17
isaac 9
SteveS 8
Morgan 5
Ruben 4
jorb 4
Zarzal 2
JPG 1
Latest Photos
Test
Testing to drag photos
Comfortable Cats
Test
BSA photos
Previous Thread
Next Thread
Print Thread
[FIXED for 7.5.1] can not delete member #223192
02/26/09 11:49 AM
02/26/09 11:49 AM
Stan  Offline
OP
old hand
Joined: Jun 2006
Posts: 948
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/09 10:46 AM.
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Re: can not delete member [Re: Stan] #223194
02/26/09 11:54 AM
02/26/09 11:54 AM
SD  Offline
Former Developer
Joined: Apr 2007
Posts: 4,313
SoCal, USA
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 [Re: Stan] #223196
02/26/09 11:58 AM
02/26/09 11:58 AM
R
Ruben  Offline

Joined: Dec 2003
Posts: 5,952
Lutz,FL
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 [Re: Ruben] #223197
02/26/09 12:05 PM
02/26/09 12:05 PM
Stan  Offline
OP
old hand
Joined: Jun 2006
Posts: 948
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 [Re: Stan] #223201
02/26/09 12:19 PM
02/26/09 12:19 PM
SD  Offline
Former Developer
Joined: Apr 2007
Posts: 4,313
SoCal, USA
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 [Re: Stan] #223203
02/26/09 12:20 PM
02/26/09 12:20 PM
R
Rick  Offline
Former Developer
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
Fix not quite applied right. You have to change that or to a where. check here.

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


http://clubadventist.com/forums

No longer following the carrot

Shout Box
Today's Birthdays
GoldenEye
Recent Topics
header.php after update from 7.5.x to 7.6.x
by Zarzal. 12/12/18 05:29 AM
Does 7.6.2 support php 71?
by Baldeagle. 12/12/18 02:17 AM
Cannot contact support
by . 12/11/18 06:43 PM
errors importing a database
by andrewjs18. 12/11/18 03:51 AM
Private Message, Opt out of conversation
by jorb. 12/04/18 10:11 PM
Forum Statistics
Forums36
Topics35,176
Posts191,657
Members12,121
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2