Results 1 to 10 of 10

Hybrid View

  1. #1
    Join Date
    Oct 2007
    Posts
    98
    Plugin Contributions
    0

    Default SQL error in Referral Sources addon

    I'm getting this error at the top of the admin age in the referrals Sources

    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 website' order by ci.customers_info_id DESC' at line 1
    in:
    [select ci.customers_info_id, ci.customers_info_date_account_created from customers_info ci, sources_other so where so.customers_id = ci.customers_info_id and so.sources_other_name = 'Emily Layton's website' order by ci.customers_info_id DESC]
    If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.


    How would i go about fixing this

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,755
    Plugin Contributions
    9

    Default Re: error in SQl

    Is referrals Sources a 3rd party module?

    Look to their support thread for a solution
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Oct 2007
    Posts
    98
    Plugin Contributions
    0

    Default Re: error in SQl

    its the "How did you hear about us" from the downloads.
    I was unable to find anything with the same error

  4. #4
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,755
    Plugin Contributions
    9

    Default Re: error in SQl

    Did you just install it recently(read the last mod installed)?

    Did you make a backup of your DB before you did this so that you might have a fall back position?
    Zen-Venom Get Bitten

  5. #5
    Join Date
    Oct 2007
    Posts
    98
    Plugin Contributions
    0

    Default Re: SQL error in Referral Sources addon

    i have had this installed from the start. I do have a back up i just wasnt sure what has caused this .

  6. #6
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,755
    Plugin Contributions
    9

    Default Re: SQL error in Referral Sources addon

    i have had this installed from the start
    So is this a new development? or has this always been this way?

    If new, what else has changed?
    Server, phpver, mysql ver, upgrade of Zen Cart?
    Zen-Venom Get Bitten

 

 

Similar Threads

  1. v139h DB/SQL Error when using SQL Patch for Add Pages More Info Sidebox addon
    By maperr55 in forum All Other Contributions/Addons
    Replies: 6
    Last Post: 5 Mar 2012, 09:32 PM
  2. Error on install of a .sql for googleanalytics addon
    By EZorb in forum General Questions
    Replies: 1
    Last Post: 12 May 2010, 09:47 AM
  3. Addon causing a SQL 1024 error in Search
    By izar74 in forum All Other Contributions/Addons
    Replies: 6
    Last Post: 11 Mar 2010, 04:30 AM
  4. Referral Sources- How to add more?
    By bluealice in forum All Other Contributions/Addons
    Replies: 7
    Last Post: 3 Jul 2008, 08:51 PM
  5. Referral sources SQL error
    By dealbyethan.com in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 6 Sep 2007, 08:10 AM

Posting Permissions

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