Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offline
It's past support hour. We are taking some rest and will come back stronger tomorrow. Promise!
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Friday 1:12 am
Add a reply View Replies (7)

Resolved MySQL error

  1. emedia
    emedia
  2. Bug Report
  3. Friday, June 24 2016, 10:13 PM
I've been running EasyProfile along with OS Solutions EventsBooking for some time without issue. Currently running Joomla 3.5.1. Both systems are kept up to date (shortly after releases are available). Upon attempting to make a reservation through the frontend with EventsBooking I saw the error message related to JSN Users and then saw (on the backend) that updates were available for both components, hoping that running the most recent updates would solve the problem. Now they are both up to date, but I'm still seeing the same error.

Any ideas what might be causing this or how to correct it?

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 'WHERE id = 169' at line 2 SQL=UPDATE #__jsn_users WHERE id = 169
oo.

Thanks, Marc
Responses (7)
admin
admin Accepted Answer
Admin
Hi,
if this error come when user make a reservation then the problem is the integration. This integration is not developed by us, so we can't help you, keep in mind that we have not experience with EventsBooking so you need to contact integration developer.
Otherwise please post me your site details* and explain me how to reproduce this error.

* you can use the form below the reply in "Site Details" tab

NOTE: in the query "UPDATE #__jsn_users WHERE id = 169" missing attribute "SET field=value", so this query is not valid.
  1. more than a month ago
  2. Bug Report
  3. # 1
Tony85
Tony85 Accepted Answer
Basic
Content Protected
  1. more than a month ago
  2. Bug Report
  3. # 2
admin
admin Accepted Answer
Admin
Hi,
sorry for late reply, it's a weekend for us :D

As I said this is a problem of integration developed by EventsBooking team, you need to ask this to their support.
  1. more than a month ago
  2. Bug Report
  3. # 3
Tony85
Tony85 Accepted Answer
Basic
Content Protected
  1. more than a month ago
  2. Bug Report
  3. # 4
pat01
pat01 Accepted Answer
Pro
Hello

I already open a ticket on EB support, hoping they'll help me also this time


Did they solve the problem?

Thank you!
  1. more than a month ago
  2. Bug Report
  3. # 5
Tony85
Tony85 Accepted Answer
Basic
Content Protected
  1. more than a month ago
  2. Bug Report
  3. # 6
pat01
pat01 Accepted Answer
Pro
Hi Antonello

Great, thank you very much, works for me as well! :-)

Regards
Patrick
  1. more than a month ago
  2. Bug Report
  3. # 7
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.