Just got the weirdest Error Message!!!
ERROR: Unable to execute query
INSERT INTO `process_queue` SET
file='aligetsaquiverfromclaw.wmv',
title ='Claw Presents Ali with a Quiver',
description='This was taken at the Blackberry Hollow Annual BBQ August 2007. Claw made a BEAUTIFUL quiver for Ali to commemerate Ali's induction into the Order of the Grey Goose Shaft (OGGS) in the Kingdom of An Tir.',
keywords='grynmoors oggs ali quiver claw blackberry hollow',
channels='15',
type='public',
user='deletedfor privacy',
user_ip='xxx.xxx.xx.xxx',
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 's induction into the Order of the Grey Goose Shaft (OGGS) in the Kingdom of An T' at line 4
Is this because there's an apostrophe in the description?
Re: Just got the weirdest Error Message!!!
Quote:
Originally Posted by grynmoors
ERROR: Unable to execute query
INSERT INTO `process_queue` SET
file='aligetsaquiverfromclaw.wmv',
title ='Claw Presents Ali with a Quiver',
description='This was taken at the Blackberry Hollow Annual BBQ August 2007. Claw made a BEAUTIFUL quiver for Ali to commemerate Ali's induction into the Order of the Grey Goose Shaft (OGGS) in the Kingdom of An Tir.',
keywords='grynmoors oggs ali quiver claw blackberry hollow',
channels='15',
type='public',
user='deletedfor privacy',
user_ip='xxx.xxx.xx.xxx',
status=2
Have you installed BugFix available at
http://forums.buyscripts.in/viewtopic.php?t=1372
It will fix the problem.
Re: Just got the weirdest Error Message!!!
Quote:
Originally Posted by admin
I had upgraded after that fix came out, so I assumed that it was included with the upgrade files I downloaded. Maybe not. I'll do the fix and try to upload a video with special characters in the description to see what happens.
I did notice I have a new member who shows one video, but when I go to click on it, it says no videos found, so I'm wondering if maybe this happened to them.
Update...
Installing that bug fix did not fix the problem.
Quote:
ERROR: Unable to execute query
INSERT INTO `process_queue` SET
file='file-636370711.flv',
title ='NY Giants Jeremy Shockey',
description='The New York Giants' Jeremy Shockey',
keywords='new york giants jeremy shockey nfl football',
channels='49',
type='public',
user='SportsFan',
user_ip='XX.XXX.XXX.XXX',
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 'Jeremy Shockey', keywords='new york giants jeremy shockey nfl football', cha' at line 4
Is there something I can manually edit to correct the problem? An apostrophe is a pretty common character to type, and I imagine a lot of people would encounter this at some point. I use to have apostrophe's in the description before the last update, so it is something new that is causing this.