Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
3 registered members (M4TT, JAISP, mmkk), 61 guests, and 262 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Posts: 25
Joined: November 2012
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 15
M4TT 11
FREAK 11
mmkk 5
Ruben 5
isaac 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] [7.5] delete a user problem #223174
02/26/09 03:36 AM
02/26/09 03:36 AM
Joined: Jun 2006
Posts: 1,148
Berlin, Germany
Zarzal Offline OP
old hand
Zarzal  Offline OP
old hand
Joined: Jun 2006
Posts: 1,148
Berlin, Germany
I try to delete a user in the control panel and get:

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 = ?

The user seems to be gone.

How can I fix this?


my board: http://www.dragon-clan.de
my hobby: http://www.biker-reise.de
Ich kann bei Fragen zu UBBthreads in Deutsch weiterhelfen oder es zumindest versuchen
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: [7.5] delete a user problem [Re: Zarzal] #223176
02/26/09 04:01 AM
02/26/09 04:01 AM
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
Line 219 of admin/dodeleteuser.php, you'll see this:

PHP Code

	delete from {$config['TABLE_PREFIX']}PROFILE_COMMENTS
	where PROFILE_ID = ?
	or USER_ID = ?
 


Change that, to this:

PHP Code

	delete from {$config['TABLE_PREFIX']}PROFILE_COMMENTS
	where USER_ID = ?
 

Re: [7.5] delete a user problem [Re: Rick] #223179
02/26/09 05:19 AM
02/26/09 05:19 AM
Joined: Jun 2006
Posts: 1,148
Berlin, Germany
Zarzal Offline OP
old hand
Zarzal  Offline OP
old hand
Joined: Jun 2006
Posts: 1,148
Berlin, Germany
that seems to fix my problem, thanks


my board: http://www.dragon-clan.de
my hobby: http://www.biker-reise.de
Ich kann bei Fragen zu UBBthreads in Deutsch weiterhelfen oder es zumindest versuchen

Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Users Unable to Upload Avatar
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,534
Members12,045
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Snapshot build 20171106)