28 | 03 | 2024
Main menu
Login/Logout
 
Contacts
Реклама
Our button

Блог Ecolora

Код:

<a href="http://www.ecolora.com" target="_blank" rel="nothing" title="Ecolora.com"><img alt="Ecolora.com" height="31" src="http://www.ecolora.com/images/ecoloracom.gif" width="88" /></a>
Who's online

We have 69 guests and no members online

Лента новостей

Newsletter
Welcome, Guest
Username: Password: Remember me
Component and plugin for musical sites / Компонент для музыкальных сайтов и улучшенная версия плагина MP3 Browser

TOPIC: SOLVED: Commedia throwing SQL Error 1064

SOLVED: Commedia throwing SQL Error 1064 8 years 7 months ago #7169

  • todd.harrison
  • todd.harrison's Avatar
  • Offline
  • Новый участник
  • Posts: 4
  • Karma: 0
Hi Guys,

We've had Commedia running on a site of ours for better part of a year, but over the last week, the site has started throwing SQL errors :sick: :
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 3 SQL=SELECT GROUP_ID FROM QYIZ0_USER_USERGROUP_MAP AS UUM WHERE UUM.USER_ID=0 AND GROUP_ID IN()

URL: www.bflchurch.org/worship/sermons

The only thing that has changed on the site is that we went in to the Commedia plugin settings to enable the downloading of the mp3 files. Commedia worked brilliantly before this, but after we enabled downloads, we got the SQL error and it won't resolve itself, even after turning off downloads.

Any help you could give would be most appreciated. I can of course give you SU/FTP access to the site should that be necessary.

Thank you!!

Todd
Last Edit: 8 years 7 months ago by todd.harrison.
The administrator has disabled public write access.

Commedia throwing SQL Error 1064 8 years 7 months ago #7170

  • admin
  • admin's Avatar
  • Offline
  • Администратор
  • Posts: 465
  • Thank you received: 40
  • Karma: 19
Hello, Todd,

First Could Your install latest version (just sended to You) on the current version on Your site and don't forget to open Commedia settings and set up download options again and save settings?

Then show me results. Hope it helps.
The administrator has disabled public write access.
The following user(s) said Thank You: todd.harrison

Commedia throwing SQL Error 1064 8 years 7 months ago #7172

  • todd.harrison
  • todd.harrison's Avatar
  • Offline
  • Новый участник
  • Posts: 4
  • Karma: 0
Thank you so much!!!!

That's worked perfectly.

www.bflchurch.org/worship/sermons

And thank you again for such fantastic support. I've already recommended your component to several of my colleagues, so hopefully you'll get a few more sales shortly.

Thanks again!

Todd
The administrator has disabled public write access.

Commedia throwing SQL Error 1064 8 years 7 months ago #7173

  • admin
  • admin's Avatar
  • Offline
  • Администратор
  • Posts: 465
  • Thank you received: 40
  • Karma: 19
Thank You for Your recomendations and for using Commedia. :)
The administrator has disabled public write access.
Time to create page: 0.075 seconds
for children older than 12 years