Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
2 registered members (mmkk, Ruben), 72 guests, and 415 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Morgan
Morgan
Sweden
Posts: 518
Joined: June 2006
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 18
M4TT 12
FREAK 11
Ruben 8
isaac 4
mmkk 4
Latest Photos
Chinese Buddhist temple.
My buddha beads.
Rendered Walls
Multi-Screen wallpaper
Stockholm Metro
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
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 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
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 11:58 AM
02/26/09 11:58 AM
Joined: Dec 2003
Posts: 5,827
Lutz,FL
Ruben Online yawn

Ruben  Online Yawn


Joined: Dec 2003
Posts: 5,827
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
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 12:19 PM
02/26/09 12: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 12:20 PM
02/26/09 12: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 12:45 PM
02/26/09 12: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
Users Unable to Upload Avatar [Not a Bug]
by M4TT. 12/13/17 08:51 AM
Shout Box Sound Effect
by M4TT. 11/29/17 08:28 PM
Ad island
by TGCsanderson. 11/25/17 06:41 PM
Taking to long to connect to DB
by AstroCat. 11/24/17 12:34 PM
Forum Statistics
Forums36
Topics35,015
Posts190,544
Members12,045
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Snapshot build 20171106)