Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
4 registered members (Gizmo, isaac, SD, JAISP), 45 guests, and 209 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Posts: 125
Joined: June 2011
Show All Member Profiles 
Top Posters(30 Days)
isaac 22
Ruben 10
Gizmo 8
Geoff 3
Morgan 3
FREAK 2
Slaz 2
DennyP 1
Latest Photos
Testing to drag photos
Comfortable Cats
Test
BSA photos
Chinese Buddhist temple.
Previous Thread
Next Thread
Print Thread
[FIXED for 7.5.1] can not delete member #223192
02/26/09 12:49 PM
02/26/09 12:49 PM
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 11: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 12:54 PM
02/26/09 12:54 PM
SD  Online Coffee
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 12:58 PM
02/26/09 12:58 PM
Ruben  Offline
Joined: Dec 2003
Posts: 5,920
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 01:05 PM
02/26/09 01: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 01:19 PM
02/26/09 01:19 PM
SD  Online Coffee
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 01:20 PM
02/26/09 01: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 01:45 PM
02/26/09 01: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
No Birthdays
Recent Topics
UBB.threads 7.6.2 - Released
by isaac. 09/17/18 08:08 AM
7.6.2 Changelog Discussion
by isaac. 09/17/18 06:35 AM
Upgrade Documentation
by DennyP. 09/15/18 03:55 PM
PHP 7.2
by Geoff. 09/12/18 10:22 PM
Email Cleanup-Is it possible?
by Ruben. 09/06/18 11:25 AM
Forum Statistics
Forums36
Topics35,139
Posts191,443
Members12,106
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2