Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2010
    Location
    Northants, England
    Posts
    82
    Plugin Contributions
    0

    Default Aftersales Automatic Trigger (Mailbeez) Issue

    After installing the automatic trigger campaign module (mailbeez) without any problem, I have gone to Tools -> Mailbeez to look at configuring some of the options.
    If I go into any of the options - we'll use Birthday Greetings as an example. I click on Birthday Greetings -> edit -> then check the settings are how I want and then press update.
    I then get met with a blank screen (no admin front end) and a message:-

    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 Computers' where configuration_key = 'MAILBEEZ_BIRTHDAY_SENDER_NAME'' at line 1

    update configuration set configuration_value = 'Brendon's Computers' where configuration_key = 'MAILBEEZ_BIRTHDAY_SENDER_NAME'

    [TEP STOP]



    - Can any one help me please?

    I am running v1.3.9h with no other problems.

  2. #2
    Join Date
    Jun 2010
    Location
    Copenhagen, Danmark
    Posts
    464
    Plugin Contributions
    7

    Default Re: Aftersales Automatic Trigger (Mailbeez) Issue

    Quote Originally Posted by darkmarauder View Post
    configuration_value = 'Brendon's Computers'
    the mailbeez support thread is on
    http://www.zen-cart.com/forum/showthread.php?p=952718


    it is the ' in brendon's which causes the error - I need to fix this.

    workaround: try to type brendon\'s instead or without the '

    cord

  3. #3
    Join Date
    Feb 2010
    Location
    Northants, England
    Posts
    82
    Plugin Contributions
    0

    Default Re: Aftersales Automatic Trigger (Mailbeez) Issue

    Mailbeez

    Can you please tell me where to find this bit of text (Brendon's Computers) so I can remove the ' symbol?


    I trawled through the 14 pages of the topic and couldn't find anything.

  4. #4
    Join Date
    Jun 2010
    Location
    Copenhagen, Danmark
    Posts
    464
    Plugin Contributions
    7

    Default Re: Aftersales Automatic Trigger (Mailbeez) Issue

    it is the value of the field "sender name". you can edit this value, when you configure the settings of the module. it is an input field in the reight column.

    cord

 

 

Similar Threads

  1. v151 Express Checkout Automatic Account Creation issue
    By leione in forum PayPal Express Checkout support
    Replies: 7
    Last Post: 22 Jan 2016, 12:16 AM
  2. Automatic image output issue
    By Emanresu in forum Setting Up Categories, Products, Attributes
    Replies: 3
    Last Post: 28 Feb 2009, 08:07 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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR