Error when apostrophe included in the description
I'm getting a very weird error when I have an apostrophe ( ' ) anywhere in the description of the video I'm trying to upload. The upload seems to be fine, but then right after, it sends me to this error page:
ERROR: Unable to execute query
INSERT INTO `process_queue` SET
file='wdigm.avi',
title ='testing apostrophe',
description='why won't this work?',
keywords='testing',
channels='2',
type='public',
user='trailerspy',
user_ip='140.251.36.48',
status=2
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 't this work?', keywords='testing', channels='2', type='public', user='tr' at line 4
Also, I tried deleting the debug.txt file and reuploading, but it didn't create a new debug.txt file.
Any idea what I need to do to make it so that it doesn't flip out whenever there's an apostrophe in the description?
Re: Error when apostrophe included in the description
Download latest vshare with the download url, reupload upload.php and include/functions_upload.php
After doing this try again.
Re: Error when apostrophe included in the description
We encountered this right after the last upgrade. Admin got the problem sorted though. All is good now.
viewtopic.php?f=4&t=1412
Re: Error when apostrophe included in the description
Hmm...for some reason the upload.php that I downloaded from the download url didn't work (the upload page wouldn't load). I tried it again with just the new include/function_uploads.php, but I got the same result. Can you check the upload.php file, or can you maybe send it to me directly?
Re: Error when apostrophe included in the description
Thanks SportsGaming. I don't know how I missed that thread, but it did the trick. I uploaded the fix included in that thread (http://www.buyscripts.in/vshare/vshare_ ... 0827_3.zip), and everything works properly now.
Admin, you may want to take a look at the upload.php included in the latest download...I think it's busted.