Welcome, Guest
Username: Password: Remember me

TOPIC: SQL Error after Upate Joomla 3.4.1

SQL Error after Upate Joomla 3.4.1 9 years 3 weeks ago #1848

In the Admin when click "Manager photo in Album"
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 vdtp_jofbpt_photo WHERE fb_photo_id != '' AND album_id=33 AND fb_photo_id NOT IN()

In Frontend when open an album:
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 vdtp_jofbpt_photo WHERE fb_photo_id != '' AND album_id=41 AND fb_photo_id NOT IN()

Any idea?

Thanks for help
The administrator has disabled public write access.

SQL Error after Upate Joomla 3.4.1 9 years 3 weeks ago #1849

  • Super User
  • Super User's Avatar
  • OFFLINE
  • Administrator
  • Posts: 3519
  • Thank you received: 278
  • Karma: 65
Hello
Problem because your facebook access token have been changed. Problem changed access token when you use facebook app for other extension. Now you need delete old account and all albums. and create new account and connect again.
Note:
- You only use one facebook app for one extension in one site
- You need only connect facebook once
Best regards
Bach Pham
The administrator has disabled public write access.
Time to create page: 0.046 seconds