Welcome, Guest
Username: Password: Remember me

TOPIC: After update: 1064 - You have an error in your SQL

After update: 1064 - You have an error in your SQL 8 years 5 months ago #2785

  • ZenD
  • ZenD's Avatar
  • OFFLINE
  • New Member
  • Posts: 3
  • Karma: 0
Hello,

I updated my joomla site to 3.4.5 from the previous 3.4 version. Since that time, our images does not appear in JO Facebook Gallery.

The error message is something like this:

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=DELETE FROM xdata_jofbpt_photo WHERE fb_photo_id != '' AND album_id=29 AND fb_photo_id NOT IN()

What shall I do to solve it?

BR,
ZenD
The administrator has disabled public write access.

After update: 1064 - You have an error in your SQL 8 years 5 months ago #2787

  • Super User
  • Super User's Avatar
  • OFFLINE
  • Administrator
  • Posts: 3519
  • Thank you received: 278
  • Karma: 65
Hello ZenD
I think problem because your Facebook access token in your site is change. So please help me delete all albums and account in component and create new account and connect to your Facebook and get the albums again and check it
Best regards
Bach Pham
The administrator has disabled public write access.
The following user(s) said Thank You: ZenD
Time to create page: 0.048 seconds