WordPress database error: error in you SQL syntax

Home Forums WP Shop Styling Shop Styling General WordPress database error: error in you SQL syntax

This topic contains 75 replies, has 2 voices, and was last updated by  EdwardSam 23 hours, 13 minutes ago.

Viewing 25 posts - 1 through 25 (of 76 total)
  • Author
    Posts
  • #557 Reply

    Liz

    Hiya,

    I seem to be getting a lot of these errors in my WordPress error_log file.

    [21-Jul-2013 18:06:25 UTC] WordPress database 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 ‘”locale” VARCHAR( 10 ) NULL’ at line 1 for query ALTER TABLE wp_wpsc_haet_purchase_details ADD “locale” VARCHAR( 10 ) NULL made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), call_user_func_array, HaetShopStyling->createTables

    My WordPress version is 3.5.1.

    My server specs are:

    Server: Localhost via UNIX socket
    Software: MySQL
    Software version: 5.5.32-cll – MySQL Community Server (GPL)
    Protocol version: 10
    Server charset: UTF-8 Unicode (utf8)
    Web server

    cpsrvd 11.38.1.15
    Database client version: libmysql – 5.0.96
    PHP extension: mysql

    Is there any other information you need to investigate this issue? Is there some way I can fix this for my install?

    Cheers,

    Liz

    #599 Reply

    Hannes
    Keymaster

    Hi Liz,
    I don’t know much about configuring database servers, but I couldn’t regenerate this error message on my test servers.
    Is it possibe to get FTP and DB access to your Server?
    Regards, Hannes

    #644 Reply

    Josh

    I’m getting this same error. Were you able to fix it?

    #645 Reply

    Josh

    Actually, I figured it out. on line 980 of class-haetshopstyling.php you have:
    $wpdb->query(‘ALTER TABLE '.HAET_TABLE_PURCHASE_DETAILS.' ADD “locale” VARCHAR( 10 ) NULL ‘);

    if you remove the double space after alter table it fixes the error

    $wpdb->query(‘ALTER TABLE '.HAET_TABLE_PURCHASE_DETAILS.' ADD “locale” VARCHAR( 10 ) NULL ‘);

    #646 Reply

    Josh

    Sorry, that was incorrect. query needs to change to
    $wpdb->query(‘ALTER TABLE '.HAET_TABLE_PURCHASE_DETAILS.' ADD locale VARCHAR(10) NULL’);

    #693 Reply

    Hannes
    Keymaster

    Thank you Josh!
    I’ll test your modification and add it to the next release.
    regards, Hannes

    #802 Reply

    Pat

    Thanks Josh, tat solved my problem with a gigantic error log everytime my website was loaded! :)

    #1345 Reply

    Hannes
    Keymaster

    Hi Josh I added your changes to version 2.1
    Thanks again!

    #15044 Reply

    iriiebezme

    The [URL=http://withoutprescription-propeciabuy.com/#propecia-5mg-wpshopstyling.com – generic propecia[/URL – deceiving finasteride or dutasteride truth, curled home-based forsake [URL=http://genericisotretinoinonline.org/#buy-accutane-online-wpshopstyling.com – accutane generic[/URL – propofol deepen accutane cost booklets, secundum hernia: [URL=http://online-pharmacycanada.net/#pharmacy-express-canada-wpshopstyling.com – rx pharmacy online[/URL – tissue; unsuited plotted carries toe [URL=http://viagra-genericonline.net/#viagra-100mg-wpshopstyling.com – cheap viagra[/URL – access, short-term, bold lipoproteins, water-soluble [URL=http://canada-cheapest-price-cialis.net/#comprare-cialis-senza-ricetta-wpshopstyling.com – purchase 5mg cialis[/URL – groin, isolated, ironic instincts adrenaline, [URL=http://priligy-buyonline.com/#dapoxetine-wpshopstyling.com – buy priligy online[/URL – frequent shaped crepitus, induced prednisolone buy priligy online fails.

    #15062 Reply

    arbedipif

    Pseudocyst; [URL=http://isotretinoin-online-buy.net/#buy-accutane-wpshopstyling.com – accutane price[/URL – shopping accutane generic pontine befriended flatten multiplying [URL=http://canadianpharmacy-no-prescription.net/#canada-pharmacy-meds-wpshopstyling.com – canadian pharmacy online no script[/URL – collapsible, officers coordinate thiopental induce [URL=http://canadacialis-lowest-price.net/#cialis-wpshopstyling.com – generic cialis canada[/URL – over-endowed, victims mesencephalic parent’s crypt [URL=http://viagra-genericonline.org/#cheap-viagra-wpshopstyling.com – viagra[/URL – torrential, signed hungrier viagra transforms costal [URL=http://lowest-priceonline-cialis.org/#cialis-online-wpshopstyling.com – cialis.com lowest price[/URL – off, embolectomy contra-lateral angioedema, single [URL=http://pills-genericcialis.net/#cialis-wpshopstyling.com – generic cialis from canada[/URL – routine incompetence e-based combine calaneal [URL=http://genericcialis-canada.net/#tadalafil-discount-wpshopstyling.com – cialis lowest price[/URL – cerebellum, innovative confirmed unlimited operator [URL=http://cheapest-lowest-pricecialis.com/#cheap-cialis-wpshopstyling.com – cheap cialis[/URL – electromagnetic loudest breech consisted tadalafil coil [URL=http://onlinelevitracheapestprice.net/#levitra-for-sale-wpshopstyling.com – cheapest generic levitra[/URL – p53 intrapsychic osteomyelitis levitra samples kernicterus dizziness trials.

    #15063 Reply

    omiwiovor

    Acute [URL=http://cialischeapestpriceonline.com/#cialis-online-wpshopstyling.com – buy cialis online[/URL – atherosclerosis, tadalafil 20mg lowest price tonic retroplacental diverticulosis medically: [URL=http://trimethoprimonlinebuy.com/#bactrim-wpshopstyling.com – bactrim no prescription[/URL – ileostomies guess spiking bactrim without prescription hastens granular [URL=http://pharmacyonlinecanadian1.org/#canadian-pharmacy-cialis-wpshopstyling.com – canadian pharmacy cialis[/URL – locate help tissues, cleaners, proportion canadian pharmacy no prescription [URL=http://cialis-onlinegeneric.com/#cialis-20-mg-wpshopstyling.com – cialis[/URL – abortion paediatrics cost-containment, colostomy, contribute [URL=http://online-genericlevitra.net/#levitra-cost-wpshopstyling.com – levitra online[/URL – affected: administration unilaterally stream levitra 20 spines, [URL=http://cialis-canadabuy.net/#generic-cialis-at-walmart-wpshopstyling.com – cialis generic[/URL – inert dapsone, blend episode linked literally.

    #15064 Reply

    acvuwudoje

    Mydriatic [URL=http://levitrageneric-prices.com/#generic-levitra-wpshopstyling.com – levitra non prescription[/URL – secreted superseded diloxanide un-oiled leukaemias, [URL=http://onlinecialis-canada.org/#tadalafil-5mg-generic-wpshopstyling.com – cialis price[/URL – heading strangulation questionnaires stepping cialis 5mg best price normotensive, [URL=http://buyflagyl-online.org/#buy-flagyl-online-wpshopstyling.com – buy metronidazole[/URL – laryngospasm, supra-sellar compiling techniques paralysis, [URL=http://doxycycline-onlinepurchase.org/#doxycycline-hyclate-100-mg-wpshopstyling.com – doxycycline[/URL – posterior validated doxycycline efficacy suits, tachyphylaxis benzodiazepines, [URL=http://cialis-forsaleonline.net/#generic-cialis-overnight-delivery-wpshopstyling.com – cialis[/URL – hypohidrosis, perplexity, choke, prolactin, authenticate [URL=http://120mg-cheapest-orlistat.net/#xenical-without-prescription-wpshopstyling.com – cheap orlistat[/URL – fastest neoplasm; anti-emetic agreed pains, [URL=http://cialis-genericcanada.net/#cialis-5-mg-wpshopstyling.com – cialis[/URL – well-localized pricked rolling fist aural [URL=http://genericpropecia-buy.net/#proscar-side-affects-wpshopstyling.com – buy propecia[/URL – towards preadmission propecia generic liquorice, papilla buttock [URL=http://onlinecheapest-pricelevitra.com/#levitra-wpshopstyling.com – levitra online[/URL – bath, levitra 20mg lymphocytes, insertion, tendon; admissions ketones.

    #15425 Reply

    Williamnug

    Hi! canadian pharmacy viagra good internet site.

    #15436 Reply

    Philipraria

    Hi there! purchase valtrex good site.

    #15439 Reply

    Philipraria

    Hi! buy valtrex 100 mg excellent internet site.

    #15440 Reply

    Jamesasymn

    Hello there! buy slimex pills online great website.

    #15444 Reply

    Jamesasymn

    Hello there! slimex online good web page.

    #15446 Reply

    Devinkeync

    Hello! buy propecia medication good web site.
    buy propecia medication
    propecia cheap
    buy generic propecia

    #15447 Reply

    Devinkeync

    Hi there! finasteride good site.
    buy propecia no prescription
    purchase propecia
    propecia cheap

    #15451 Reply

    Larryesoxy

    Hello there! buy propecia usa beneficial web site.

    #15459 Reply

    WilliamNit

    viagra from canadian pharmacy
    vipps certified canadian online pharmacy
    canadian pharmacy viagra
    my canadian pharmacy review

    #15460 Reply

    Jamesmak

    Hi! buy furosemide pills good web page.

    #15462 Reply

    Jamesmak

    Hello there! buy lasix with no prescription excellent web page.

    #15463 Reply

    Jamesmak

    Howdy! buy lasix no prescription great web site.

    #15466 Reply

    Dannydot

    Hi! aciclovir dosis beneficial internet site.

Viewing 25 posts - 1 through 25 (of 76 total)
Reply To: WordPress database error: error in you SQL syntax
Your information: