× Help Forum English

Submit Event in Frontend - Error 1064

Start
Prev
1
Next
End

retoturnverein
Topic Author
New Member

9 years 4 months ago - 9 years 3 months ago #10943 by retoturnverein

Submit Event in Frontend - Error 1064 was created by 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

Last edit: 9 years 3 months ago by Lyr!C.

Please Log in or Create an account to join the conversation.

Lyr!C
Administrator
Lead Developer

9 years 3 months ago #10980 by Lyr!C

Replied by Lyr!C on 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) .

Please Log in or Create an account to join the conversation.

retoturnverein
Topic Author
New Member

9 years 3 months ago #11011 by retoturnverein

Replied by retoturnverein on 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

Please Log in or Create an account to join the conversation.

Lyr!C
Administrator
Lead Developer

9 years 3 months ago #11019 by Lyr!C

Replied by Lyr!C on topic Submit Event in Frontend - Error 1064

retoturnverein wrote: 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

Please Log in or Create an account to join the conversation.

retoturnverein
Topic Author
New Member

9 years 3 months ago #11029 by retoturnverein

Replied by retoturnverein on 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

Please Log in or Create an account to join the conversation.

Lyr!C
Administrator
Lead Developer

9 years 3 months ago #11038 by Lyr!C

Replied by Lyr!C on 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