Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
1 registered members (OneCNC_Aus), 56 guests, and 249 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
mmkk
mmkk
Beijing
Posts: 28
Joined: November 2012
Show All Member Profiles 
Top Posters(30 Days)
isaac 18
Gizmo 12
Ruben 11
Morgan 3
BB 2
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
Joined: Jun 2006
Posts: 948
Stan Offline OP

old hand
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
Joined: Apr 2007
Posts: 4,313
SoCal, USA
SD Offline
Carpal Tunnel
SD  Offline
Carpal Tunnel
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
Joined: Dec 2003
Posts: 5,898
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,898
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
Joined: Jun 2006
Posts: 948
Stan Offline OP

old hand
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
Joined: Apr 2007
Posts: 4,313
SoCal, USA
SD Offline
Carpal Tunnel
SD  Offline
Carpal Tunnel
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
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
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
Joined: Jun 2006
Posts: 948
Stan Offline OP

old hand
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
Custom Insert won't save
by Baldeagle. 06/18/18 07:44 PM
New Image capabilities ver 7.6.1
by Abbott. 06/14/18 02:28 PM
Thread deleted?
by Lisanne. 06/05/18 11:13 AM
random 500 server errors on post
by Bad Frog. 05/31/18 09:34 AM
Upgraded from 7.6.0 to 7.6.1.1
by BB. 05/30/18 12:33 PM
Forum Statistics
Forums36
Topics35,121
Posts191,324
Members12,085
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2
(Preview build 20180524)