Photo upload on wall Bug for 7.04

While uploading a photo to Wall Module I am not able to to include Single or Double quotes in the Photo description. If I do the photo will not upload and I receive an Error message in my email from Cron Check. So if I say ( that's the way it is) the single quote in thats will fail the Query. Remove the Quote and photo uploads.

zQuery:

INSERT INTO `bx_wall_events`(`owner_id`, `object_id`, `type`, `action`, `content`, `title`, `description`, `date`) VALUES('0', '5', 'wall_common_photos', '', '<div class=\"wall-post-media\">
    <div class=\"wall-pm-thumbnail\" style=\"width:144px; height:144px;\">
        <a href=\"http://www.fish4bucks.com/m/photos/view/SSPX0055-2011-03-01-0\">
            <img class=\"wall-pm-thumbnail\" src=\"http://www.fish4bucks.com/templates/tmpl_uni/images/spacer.gif\" style=\"width:144px; height:144px; background-image:url(http://www.fish4bucks.com/m/photos/get_image/browse/e607ee0eba957ff09976640ff5991cc5.jpg);\" title=\"SSPX0055\" alt=\"SSPX0055\" />
        </a>
    </div>
    Captain Greg on the 53\'Hatteras from the bridge just another day at the office
    <div class=\"wall-clear\">&nbsp;</div>
</div>', 'Captain_Greg _wall_added_photos', 'Captain Greg on the 53'Hatteras from the bridge just another day at the office', UNIX_TIMESTAMP())

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 'Hatteras from the bridge just another day at the office', UNIX_TIMESTAMP())' at line 1

Found error in the file '/home/fish4buc/public_html/modules/boonex/wall/classes/BxWallDb.php' at line 60.
Called 'query' function with erroneous argument #0.

Quote · 2 Mar 2011

Capt Greg,

i dont think its a bug. i just gave it a test on an unmodified 7.0.5 version

 

 

semi-dedicated-lookup-results
from the 45' 2" hardtail, to the 2009 Ultra Classic Super Glide.

I am going to use 'single quotes, and the "double quotes" in the images "desc' rip'tion"

now if this is a bug, it will crawl out now?

 

that is what i put on the description, and as you can see i abused single and double quotes. so i am not able to reproduce the problem.

 

can somebody else test this please?

When a GIG is not enough --> Terabyte Dolphin Technical Support - Server Management and Support
Quote · 2 Mar 2011

I only have 7.05 installed so I can't speak to whether this is applicable for 7.04 (which was indicated as being used)

However, I can say that it seems to work find in 7.05.

 

PicDepict.com Free Image Hosting

I used different variations of quotes to see if it would trigger an error and it posted to the wall fine - as can be seen in the image above.

I'm with DosDawg on this one. I don't think it's a bug - at least not with Dolphin.

Maybe something wrong with your installation / setup (?)

Quote · 3 Mar 2011

Thanks Guys, for the quick response I will update the site next week. I have a lot of mods so it takes me a full day to do a Upgrade.

Quote · 3 Mar 2011
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.