Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4

Thread: AP Raffle

  1. #1
    New to the CF scene
    Join Date
    Nov 2010
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    AP Raffle

    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?

  • #2
    God Emperor Fou-Lu's Avatar
    Join Date
    Sep 2002
    Location
    Saskatoon, Saskatchewan
    Posts
    16,987
    Thanks
    4
    Thanked 2,660 Times in 2,629 Posts
    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.
    PHP Code:
    header('HTTP/1.1 420 Enhance Your Calm'); 

  • #3
    New to the CF scene
    Join Date
    Nov 2010
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Table Create Table
    raf_emails CREATE TABLE `raf_emails` (
    `enum` int(11) NOT N...

  • #4
    God Emperor Fou-Lu's Avatar
    Join Date
    Sep 2002
    Location
    Saskatoon, Saskatchewan
    Posts
    16,987
    Thanks
    4
    Thanked 2,660 Times in 2,629 Posts
    Thats a little short. We need the whole code as well as that whole insertion statement to compare the datatypes.
    PHP Code:
    header('HTTP/1.1 420 Enhance Your Calm'); 


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •