usermodifylisting errors

[CHRD]

Hi, Im doing a new build and Im getting there errors on usermodifylisting.php
Notice: Query failed: 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 '' at line 1 SQL: SELECT cTitleCharacters,cShortDescCharacters,cCharacters, cDisURL FROM class_cartproducts WHERE id= in /home/xxx/public_html/mysite/includes/classes/database/mysql.php on line 135

also in modify images I get
Notice: Query failed: 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 '' at line 1 SQL: SELECT images,numimages FROM class_cartproducts WHERE id= in /home/xxx/public_html/mysite/includes/classes/database/mysql.php on line 135

Notice: Query failed: 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 '' at line 1 SQL: SELECT id FROM class_prodimages WHERE pid= in /home/xxx/public_html/mysite/includes/classes/database/mysql.php on line 135

and
I am sorry, but you have either not uploaded any images or the listing package you have selected does not allow images.

Im only seeing this error when I goto modify a listing thats "Not Active", when the listing is active I dont see the errors

[Lhotch]

Is this a fresh install with the default template or have you modified anything?

[CHRD]

yes its a fresh install, the only this Iv done is cut the tag stripper out from functions.php
$allowed_tags = array("<br>", "<a>", "<b>","<p>","</p>","<strong>","</strong>","<em>","</em>","<blockquote>","</blockquote>","<ul>","</ul>","<ol>","</ol>","<li>","</li>");
$str = strip_tags($str, $allowed_tags);

Iv added listings ok but now Im getting
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 '' at line 1
when I click submit from the listing information page

would working on extra fields as listings are being added cause these problems

[Maffo]

I have had other customers who have had trouble with the tag stripper. Rather than strip it out you can change it to this.

$str = strip_tags($str, '<br> <a> <b> <p>');

In that kind of format it should work fine.

[CHRD]

OK I have found the problem

I have 19 extra fields and the last 3 are multi line text boxes and I only get the errors when I add �$� sysbols in any of these boxes, I get a white page with this text:
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 '' at line 1

and the info entered into the multi line text box gets dropped and other info below get dropped as well

[CHRD]

bump bump, Iv still got this problem

[CHRD]

Bump Bump Bump, sorry, Iv emailed support weeks ago with no reply, anybody?????

[dpete]

By adding "addslashes" the external.php file, users can now include apostrophes the first time they place an ad. The problem comes when they try to modify the ad. If the modification includes apostrophes, the description field disappears altogether.


Is there something that can be edited here in usermodifylisting.php?

//trim out html
$shortDescription = safeStripSlashes($rs['shortDescription']);
$shortDescription = str_replace('<br />', "\n", $shortDescription);
$shortDescription = htmlspecialchars($shortDescription);

$description = safeStripSlashes($rs['description']);
$description = str_replace('<br />', "\n", $description);
$description = htmlspecialchars($description));