Error when update List Properties (v1.0.6)

[Kevin Hoang]

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]

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]

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]

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