× Help Forum English

Submit Event in Frontend - Error 1064

Inizio
Indietro
1
Avanti
Fine

retoturnverein
Autore della discussione
Junior Member

Di più

11 Anni 1 Mese fa - 11 Anni 1 Mese 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 11 Anni 1 Mese fa da Lyr!C.

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

Lyr!C
Administrator
Lead Developer

Di più

11 Anni 1 Mese 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 4.0.17 Joomla! 4 > Joomla! 6
We recommend every user to keep iCagenda updated.
Support for iCagenda version 3.9 (the final version compatible with Joomla 3) ended on October 13, 2026
Extended security support for the iCagenda PRO 3.9 version until October 13, 2027 (to benefit from this extended support, you must have a Pro subscription: www.joomlic.com/extensions/icagenda)
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
Junior Member

Di più

11 Anni 1 Mese 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ù

11 Anni 1 Mese 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
Junior Member

Di più

11 Anni 1 Mese 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ù

11 Anni 1 Mese 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