Previous Thread
Next Thread
Print Thread
Hop To
Joined: Jun 2006
Posts: 869
old hand
old hand
Joined: Jun 2006
Posts: 869
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/2009 11:46 AM.
Stan #223194 02/26/2009 12:54 PM
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
that's a bug.. remove the PROFILE_ID=? line in the code smile

oops.. Rick has the fix0r already posted

Linky Poo™

Stan #223196 02/26/2009 12:58 PM
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
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
Joined: Jun 2006
Posts: 869
old hand
old hand
Joined: Jun 2006
Posts: 869
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
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
well, don't remove the WHOLE LINE...

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

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Fix not quite applied right. You have to change that or to a where. check here.

Joined: Jun 2006
Posts: 869
old hand
old hand
Joined: Jun 2006
Posts: 869
Done thanks


http://clubadventist.com/forums

No longer following the carrot

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (rootman), 641 guests, and 112 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)