osCmax v2.5 User Manual
Results 1 to 7 of 7

Easy Populate SQL Error

This is a discussion on Easy Populate SQL Error within the osCMax v2 Features Discussion forums, part of the osCmax v2.0 Forums category; I have the file laid out right for import but when I try I get... 1064 - You have an ...

      
  1. #1
    New Member
    Join Date
    Oct 2007
    Posts
    12
    Rep Power
    0


    Default Easy Populate SQL Error

    I have the file laid out right for import but when I try I get...

    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 's (Normal, Classic, Rock, Jazz & Pop)
    Upgradeable Firmware
    PC and Mac Comp' at line 11

    INSERT INTO products_description (products_id, language_id, products_name, products_description, products_url) VALUES ( '9', 1, 'MP3 PLAYER/USB FLASH DRIVE with BUILT-IN 256MB FLASH MEMORY', 'FEATURES:
    256 MB Built-in Flash Memory
    Mobile Music, Data, Documents and Pictures Storage.
    Direct Connection into USB Port (No Cable Required)
    Plug and Play (No Software Required for Windows ME/XP/2000 and Mac OS X)
    Voice Recording Up to 16 Hours
    Displays Song Title, Album and Artist
    Digital Preset EQ's (Normal, Classic, Rock, Jazz & Pop)
    Upgradeable Firmware
    PC and Mac Compatible
    Requires 1 x "AAA" Battery for MP3 Playback (Not Included)

    SPECIFICATIONS:
    Unit Dimensions: 3.69" x 1.18" x 0.8"(WHD)
    Blister Packaging: 7.09" x 9.84" x 9.95"(WHD)

    ACCESSORIES INCLUDED:
    Installation CD
    USB Cable
    Carrying Strap
    Professional Digital Neckband Stereo Headphones', '' )

    [TEP STOP]



    Anyone have any ideas on how to fix this? My server uses mySQL5

    Thanks in advance

  2. #2
    osCMax Testing Team
    Join Date
    Oct 2006
    Location
    Atlanta GA
    Posts
    201
    Rep Power
    12


    Default Re: Easy Populate SQL Error

    You just need to upgrade to the new ver. you are having trouble importing with @%$%$^&**())(*;;'/. The new one works with csv

    Will fix your problem

    Adam

  3. #3
    osCMax Development Team met00's Avatar
    Join Date
    Oct 2005
    Location
    wherever I happen to be at the moment
    Posts
    854
    Blog Entries
    2
    Rep Power
    26


    Default Re: Easy Populate SQL Error

    "Digital Preset EQ's"

    Single quote error. escape it. error will go away. The change is a simple one in easypop... Before you do the insert on the description line, use an addslashes() and the problem will go away.
    so endith the lesson
    <think>sometimes I just sit's and thinks</think>
    "Here you are with a hand full of holes, a thumb up your ass, and a big grin to pass the time of day with." - TWB

  4. #4
    osCMax Testing Team
    Join Date
    Oct 2006
    Location
    Atlanta GA
    Posts
    201
    Rep Power
    12


    Default Re: Easy Populate SQL Error

    met00 is also correct

    But if you would like to keep the "Digital Preset EQ's" you can upgrade and it will import correctly.

  5. #5
    Member
    Join Date
    Aug 2008
    Location
    Canada
    Posts
    61
    Rep Power
    4


    Default Re: Easy Populate SQL Error

    met00 can you explain what you mean for this? i added the new version of like ALElder suggested but i still get the 1064 error because of the single quote. Its mainly from my category names now. So do i just add the addslashes() within each category title or do you mean within each cell with a ' in it?

    Thanks

  6. #6
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


    Default Re: Easy Populate SQL Error

    Escape the quote - put a backslash \ in front of it.
    Michael Sasek
    osCMax Developer


    osCmax Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  7. #7
    osCMax Development Team met00's Avatar
    Join Date
    Oct 2005
    Location
    wherever I happen to be at the moment
    Posts
    854
    Blog Entries
    2
    Rep Power
    26


    Default Re: Easy Populate SQL Error

    before you enter anything into the database use addslashes() to normalize it for entry to the database. mysql sees a ' as a special character addslashes() will turn the ' to a \' which will allow it to be inserted.
    so endith the lesson
    <think>sometimes I just sit's and thinks</think>
    "Here you are with a hand full of holes, a thumb up your ass, and a big grin to pass the time of day with." - TWB

Similar Threads

  1. not so 'easy populate', upload error
    By danhosts in forum osCmax v2 Installation issues
    Replies: 5
    Last Post: 09-29-2006, 12:28 PM
  2. Easy Populate Error Message
    By markymrk22 in forum osCommerce 2.2 Modification Help
    Replies: 1
    Last Post: 07-07-2005, 11:42 AM
  3. easy populate - error
    By jloyzaga in forum osCmax v1.7 Discussion
    Replies: 22
    Last Post: 03-08-2004, 09:11 PM
  4. easy populate fatal error
    By americamba in forum osCommerce 2.2 Modification Help
    Replies: 0
    Last Post: 01-18-2004, 11:43 AM
  5. Easy Populate https error
    By john- in forum osCMax v1.7 General Mods Discussion
    Replies: 0
    Last Post: 12-27-2003, 05:13 PM

Bookmarks

Posting Permissions

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