× Help Forum English

Submit Event in Frontend - Error 1064

Inizio
Indietro
1
Avanti
Fine

retoturnverein
Autore della discussione
New Member

Di più

9 Anni 4 Mesi fa - 9 Anni 3 Mesi fa #10943 da retoturnverein

Submit Event in Frontend - Error 1064 è stato creato da retoturnverein

Submitting an event from the front-end doesn't work, I get always this error:

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 ui.username AS username, ui.email AS email, ui.password AS passw, ui.block AS block, ui.activation AS activation FROM #__users AS ui WHERE ui.id IN ()

I tried different Browsers. My iCagenda version is 3.5.11, Joomla 3.4.3

Any idea?
Reto

Ultima Modifica 9 Anni 3 Mesi fa da Lyr!C.

Si prega Accedi o Crea un account a partecipare alla conversazione.

Lyr!C
Administrator
Lead Developer

Di più

9 Anni 3 Mesi fa #10980 da Lyr!C

Risposta da Lyr!C al topic Submit Event in Frontend - Error 1064

Hello,

Is it possible to do a test online, as this sql error is from Joomla com_users, so i wonder why you could have such an issue with the iCagenda submit form...
Maybe a third party extension having this issue, and loading on form submit event (plugin events of Joomla core api)

Thank you,
Best Regards,
Cyril

Latest version : iCagenda 3.9.8
We recommend every user to keep iCagenda updated.
Don't forget to have your Joomla!™ up-to-date!

Do you like iCagenda?
I would appreciate if you could take 5 minutes to post a review on JED (Joomla Extensions Directory) .

Si prega Accedi o Crea un account a partecipare alla conversazione.

retoturnverein
Autore della discussione
New Member

Di più

9 Anni 3 Mesi fa #11011 da retoturnverein

Risposta da retoturnverein al topic Submit Event in Frontend - Error 1064

Hi Cyril,

shure we can test. How will you do that, what kind of access do you need?

Best Regads,
Reto

Si prega Accedi o Crea un account a partecipare alla conversazione.

Lyr!C
Administrator
Lead Developer

Di più

9 Anni 3 Mesi fa #11019 da Lyr!C

Risposta da Lyr!C al topic Submit Event in Frontend - Error 1064

retoturnverein ha scritto: Hi Cyril,

shure we can test. How will you do that, what kind of access do you need?

Best Regads,
Reto

Hello,

Just a link to the frontend submit an event form. ;-)

So that i could process the form (for example with username Cyril) and see the error message, and check if possible, why...

Regards,
Cyril

Si prega Accedi o Crea un account a partecipare alla conversazione.

retoturnverein
Autore della discussione
New Member

Di più

9 Anni 3 Mesi fa #11029 da retoturnverein

Risposta da retoturnverein al topic Submit Event in Frontend - Error 1064

Hi Cyril

I got the error, it was an insufficient access right. the resolution over access groups in Joomla didn't work, so I added each required user group in the options dialogue.

Thank you anyway
Best Regads,
Reto

Si prega Accedi o Crea un account a partecipare alla conversazione.

Lyr!C
Administrator
Lead Developer

Di più

9 Anni 3 Mesi fa #11038 da Lyr!C

Risposta da Lyr!C al topic Submit Event in Frontend - Error 1064

Hi Reto,

I got the error, it was an insufficient access right. the resolution over access groups in Joomla didn't work, so I added each required user group in the options dialogue.

Do you mean it was maybe a Joomla bug ?
Does this one occures with lastest Joomla 3.4.4 ?

Best Regards,
Cyril