Results 1 to 3 of 3
  1. #1

    problem withmysql

    I am trying to run this on my db:

    INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Large Image Width (Pop-up)', 'LARGE_IMAGE_WIDTH', , 'The pixel width of large images (Pop-up)<br>(Use 0 for non-specific size)', 4, 32, now(), now(), NULL, NULL);
    INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Large Image Height (Pop-up)', 'LARGE_IMAGE_HEIGHT', , 'The pixel height of large images (Pop-up)<br>(Use 0 for non-specific size)', 4, 35, now(), now(), NULL, NULL);

    How ever I keep getting this error:

    INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
    VALUES (
    '', 'Large Image Width (Pop-up)', 'LARGE_IMAGE_WIDTH', , 'The pixel width of large images (Pop-up)<br>(Use 0 for non-specific size)', 4, 32, now( ) , now( ) , NULL , NULL
    );

    MySQL said: Documentation
    #1064 - 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 ' 'The pixel width of large images (Pop-up)<br>(Use 0 for non-sp

    What would be the correction for this?
    Thanks, Kevin

  2. #2
    Join Date
    Feb 2003
    Location
    Canada
    Posts
    1,010
    You have two comma's together, where as there should be a value in between (be it a NULL, or empty quotes, or a value.

    It looks like you have 11 fields but 10 values.

  3. #3
    Join Date
    Feb 2006
    Location
    Lancashire, UK
    Posts
    474
    yeah remove the double comma where the error is

Posting Permissions

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