Error when update List Properties (v1.0.6)

1 view
Skip to first unread message

Kevin Hoang

unread,
Oct 28, 2008, 12:53:42 AM10/28/08
to KiweeCommerce Forum
I got the following error message when I edit List Properties.
MYSQL 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 '"United States WHERE id=1' at line 1

help me fix this error!

Kevin.

Richard Northcott

unread,
Oct 28, 2008, 4:43:52 AM10/28/08
to kiweec...@googlegroups.com
Hi Kevin

The error is an incorrect syntax in the update process (started the quotes but not ending the quotes for desc) - see line 188 (approx) under function list_update()

     $kiwee->db->upd($kiwee->config['fpx'], 'lists', 'name="' . $name . '", description="' . $desc, 'id=' . $id);

should be

     $kiwee->db->upd($kiwee->config['fpx'], 'lists', 'name="' . $name . '", description="' . $desc . '"', 'id=' . $id);



Richard

Kevin Hoang

unread,
Oct 28, 2008, 10:49:26 PM10/28/08
to KiweeCommerce Forum
I edited and it run. Thanks Richard!

I don't know how to I can find errors, so I'd like ask you: what's
tool you use to develop and find error like this case.
I think Kiwee should have detail log like this: Error 36: You have an
error in your SQL syntax ..... In list.php at line 188.

Richard Northcott

unread,
Oct 29, 2008, 6:09:31 AM10/29/08
to kiweec...@googlegroups.com
There are error capture commands for MySQL but I have not started to add them - the original version had some instances of this (eg. $result = mysql_query($qry) or die ('ERROR: ' . mysql_error());)

This type of error can be more detailed/helpful b adding at least the function that was calling the MySQL query.

I will certainly consider doing this as it will be helpful all around.


Richard
Reply all
Reply to author
Forward
0 new messages