Forums / All Other Contributions/Addons / Aftersales Automatic Trigger (Mailbeez) Issue

Aftersales Automatic Trigger (Mailbeez) Issue

Locked

Started by darkmarauder on 29 Oct 2010, 10:31 AM · Views: 1,200

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
29 Oct 2010, 10:31 AM
#1
darkmarauder avatar

darkmarauder

New Zenner

Join Date:
Feb 2010
Location:
Northants, England
Posts:
83
Plugin Contributions:
0

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

29 Oct 2010, 10:38 AM
#2
mailbeez avatar

mailbeez

Zen Follower

Join Date:
Jun 2010
Location:
Copenhagen, Danmark
Posts:
479
Plugin Contributions:
2

Re: Aftersales Automatic Trigger (Mailbeez) Issue

darkmarauder:

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

29 Oct 2010, 12:06 PM
#3
darkmarauder avatar

darkmarauder

New Zenner

Join Date:
Feb 2010
Location:
Northants, England
Posts:
83
Plugin Contributions:
0

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.

Brendon's Computers - For All Your PC Needs

30 Oct 2010, 6:30 PM
#4
mailbeez avatar

mailbeez

Zen Follower

Join Date:
Jun 2010
Location:
Copenhagen, Danmark
Posts:
479
Plugin Contributions:
2

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