Author Topic: Change User Title : SQL Error  (Read 2316 times)

Offline rockgeek

Change User Title : SQL Error
« on: June 27, 2008, 03:26:27 am »
Code: [Select]
Database 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 'NEW TITLE
WHERE ID_MEMBER = 117
LIMIT 1' at line 3
File: /home/janusz/public_html/forums/Sources/Subs.php
Line: 399

Lines 396, 397, 398 and 399 are:

Code: [Select]
db_query("
UPDATE {$db_prefix}members
SET" . substr($setString, 0, -1) . '
WHERE ' . $condition, __FILE__, __LINE__);

Any help would be greatly appreciated! In fact, it seems to be happening for all shop items!!!
« Last Edit: June 27, 2008, 03:32:16 am by rockgeek »

Offline rockgeek

Re: Change User Title : SQL Error
« Reply #1 on: June 27, 2008, 03:43:40 am »
I've become my own worst nightmare - a n00b that doesn't search!

Found answer: http://www.daniel15.com/forum/index.php/topic,1346.0.html

Thanks!