Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2010
    Location
    Northants, England
    Posts
    88
    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.
    Brendon's Computers - For All Your PC Needs

  2. #2
    Join Date
    Jun 2010
    Location
    Copenhagen, Danmark
    Posts
    373
    Plugin Contributions
    6

    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
    88
    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
    373
    Plugin Contributions
    6

    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. Mailbeez After Sales Modules
    By sunflowertami in forum All Other Contributions/Addons
    Replies: 756
    Last Post: 29 Apr 2013, 01:36 PM
  2. html Emails Using MailBeez
    By Bruce1952 in forum All Other Contributions/Addons
    Replies: 5
    Last Post: 22 Aug 2010, 04:33 AM
  3. Aftersales Email Module: Review Reminder
    By BeautyHealth.com.cy in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 27 Jul 2010, 12:00 AM
  4. Aftersales Email Module not wroking
    By samar777 in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 25 Jul 2010, 03:57 PM
  5. 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
  •