View Full Version : AP Raffle

11-30-2010, 10:14 PM
I've downloaded a php script called AP Rafffle.

And i have created a database , uploaded the raffle folder and am trying to install it and i get this 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 'INSERT INTO raf_emails VALUES (1, 'Email Verification Link', 'You or someone els' at line 12

I have been trying to fix this for ages, i can post the files or a link if its any help to anyone?

11-30-2010, 10:27 PM
The problem is completely the script. Where is it getting that data from for insertion? Since the error is incomplete, its hard to say exactly what the issue is; make sure there is no ' in any of the data that's inserting, and if there is you need to escape it with mysql_real_escape_string first. Other potential problems are datatypes in your database.
Pull out the line 12 from that script with that query in it, and post the data. It doesn't matter if its parsed or not at this point. Also post the result of a query for SHOW CREATE TABLE raf_emails to show us your database structure.

11-30-2010, 10:57 PM
Table Create Table
raf_emails CREATE TABLE `raf_emails` (
`enum` int(11) NOT N...

11-30-2010, 11:08 PM
Thats a little short. We need the whole code as well as that whole insertion statement to compare the datatypes.