Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
2 registered (Dunny, Ruben), 48 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/05/06
Posts: 709
Top Posters (30 Days)
Ruben 50
DennyP 24
Gizmo 24
Dunny 15
SteveS 13
AllenAyres 12
dbremer 10
SD 10
drkknght00 9
driv 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#223192 - 02/26/09 11:49 AM [FIXED for 7.5.1] can not delete member
Stan Offline

old hand
Registered: 06/05/06
Posts: 709
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 = ?



Edited by Rick (02/27/09 10:46 AM)
Top
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."
#223194 - 02/26/09 11:54 AM Re: can not delete member [Re: Stan]
SD Offline
Registered: 04/19/07
Posts: 4056
Loc: SoCal, USA
that's a bug.. remove the PROFILE_ID=? line in the code smile

oops.. Rick has the fix0r already posted

Linky Poo™
_________________________

Threads tutorials . Threads & Wordpress experts . UBB resume

If I you, click this link as to why
Top
#223196 - 02/26/09 11:58 AM Re: can not delete member [Re: Stan]
Ruben Online   hyper

Registered: 12/20/03
Posts: 4424
Loc: 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
Top
#223197 - 02/26/09 12:05 PM Re: can not delete member [Re: Ruben]
Stan Offline

old hand
Registered: 06/05/06
Posts: 709
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
Top
#223201 - 02/26/09 12:19 PM Re: can not delete member [Re: Stan]
SD Offline
Registered: 04/19/07
Posts: 4056
Loc: SoCal, USA
well, don't remove the WHOLE LINE...

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

Threads tutorials . Threads & Wordpress experts . UBB resume

If I you, click this link as to why
Top
#223203 - 02/26/09 12:20 PM Re: can not delete member [Re: Stan]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Fix not quite applied right. You have to change that or to a where. check here.
Top
#223211 - 02/26/09 12:45 PM Re: can not delete member [Re: Rick]
Stan Offline

old hand
Registered: 06/05/06
Posts: 709
Done thanks
Top



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Forum Stats
10492 Members
36 Forums
33842 Topics
181709 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image