RADBMX.CO.UK

Forum => Q&A, Ideas & Feedback => Topic started by: TheOriginalNutter on August 09, 2009, 01:23 PM

Title: error ....
Post by: TheOriginalNutter on August 09, 2009, 01:23 PM

http://www.radbmx.co.uk/mkportal/modules/coppermine/displayimage.php?album=3

shows

ERROR: Database error.
Cannot execute the query: INSERT INTO mkpcpg_usergroups VALUES (24, 'SMF_Hoffman's Love Child', 0, 0, 1, 1, 1, 1, 1, 1, 0, 3, 0, 5, 3)
MySql Error returned: 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 Love Child', 0, 0, 1, 1, 1, 1, 1, 1, 0, 3, 0, 5, 3)' at line 1
MySql Error code: 1064

Title: Re: error ....
Post by: SteveD on August 09, 2009, 03:10 PM

yeah i always get that error if i click on the big pic lower down the home page

Title: Re: error ....
Post by: SteveD on August 09, 2009, 10:00 PM

I know the reason for this problem, Its an SQL thing . . .

'SMF_Hoffman's Love Child'

should read

'SMF_Hoffman''s Love Child',

thats two single quotes eg '' and not a double quote eg "

Title: Re: error ....
Post by: TheOriginalNutter on August 12, 2009, 07:24 PM

addslashes() or htmlentities() then .... why is it inserting anyway?

webmistress!!