×

info

Dear guests,
You are currently on the old forum we kept as a knowledge base. You will find the new community forum here
Welcome, Guest
Username: Password: Remember me
Keyword
Please report any bugs or errors here.

TOPIC: Error while previewing message

Error while previewing message 6 years 2 months ago #72676

  • Anonymous user
  • Ch3vr0n's Avatar
  • Posts: 6
  • Karma: 0
Created first sms message, clicked preview and was greeted by the following

An error has occurred

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 '' at line 1 SQL=SELECT * FROM ov2dp_hikashop_order JOIN ov2dp_hikashop_user ON user_id = order_user_id WHERE user_cms_id =

i ran extension manager > manage > database > repair but no effect
Please log in to post a reply

Error while previewing message 6 years 2 months ago #72681

  • Alexandre
  • Alexandre's Avatar
  • Posts: 2462
  • Karma: 67
Hi,

Could you please disable the Hikashop plugin for AcySMS and let me know if the problem disappears ?
You can disable the plugin directly from the AcySMS configuration page.
Last Edit: 6 years 2 months ago by Alexandre.
Please log in to post a reply

Error while previewing message 6 years 2 months ago #72686

  • Anonymous user
  • Ch3vr0n's Avatar
  • Posts: 6
  • Karma: 0
Confirmed.

What works:

* Preview opens
* Test sending works
* Send button works adds message to queue

What does not work

* the message itself

both in preview as in actual message the following is sent
Dag {hikashop:address_firstname}

Uw webhosting gegevens voor order met bestelnummer {hikashop:order_id} zijn verzonden.

Dank voor uw bestelling.

sitename

(ignore the language, its dutch). The problem is that the variables are obviously not filled in.

Does this mean a problem with hikashop, acySMS or just the plugin for hikashop. As that would be the use i've found for it. To send out sms on order shipments

I've also noticed that the times displayed under "last cron" are off by 2 hours too few compared to server time and times used in other components where they are shown correctly
Please log in to post a reply

Error while previewing message 6 years 2 months ago #72687

  • Alexandre
  • Alexandre's Avatar
  • Posts: 2462
  • Karma: 67
Hi,

Could you please send me a temporary access to your website at This email address is being protected from spambots. You need JavaScript enabled to view it. ?
I will install the new beta version of AcySMS which contains the patch for the Hikashop plugin.
Please define "AcySMS hikashop plugin" as subject.
Please log in to post a reply

Error while previewing message 6 years 2 months ago #72689

  • Anonymous user
  • Ch3vr0n's Avatar
  • Posts: 6
  • Karma: 0
account details sent
Please log in to post a reply

Error while previewing message 6 years 2 months ago #72719

  • Alexandre
  • Alexandre's Avatar
  • Posts: 2462
  • Karma: 67
For information :

Problem solved and online package updated :)
Please log in to post a reply

Error while previewing message 6 years 2 months ago #72739

  • Anonymous user
  • Ch3vr0n's Avatar
  • Posts: 6
  • Karma: 0
Thanks for the quick fix :)
Please log in to post a reply
Time to create page: 0.053 seconds
Powered by Kunena Forum