[FIXED for 7.5.1] can not delete member - UBB.threads PHP Forum Software Community

You are not logged in. [Log In] UBB.threads PHP Forum Software Community » Forums » UBB.threads 7 Discussion » Bug Reports
» Fixed Bugs » [FIXED for 7.5.1] can not delete member

Site Links

Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com

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

Basildon Town Centre looking from the rounderbout

Topic Options

#223192 - 02/26/09 11:49 AM

[FIXED for 7.5.1] can not delete member

Stan

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	Registered: 04/19/07 Posts: 4056 Loc: SoCal, USA

that's a bug.. remove the PROFILE_ID=? line in the code

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

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

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