× Help Forum English

MySQL ERROR

Début
Précédent
1
Suivant
Fin

Zappu
Auteur du sujet
Membre junior

Plus d'informations

il y a 11 ans 9 mois #8757 par Zappu

MySQL ERROR a été créé par Zappu

Bevor I will move on with the migration from JEVENTS to iCagenda

A little error while savin the category : 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 1 SQL=SELECT alias from u42jy_categories WHERE id =

and also while saving an event:
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 1 SQL=SELECT `name`, `username`, `email` FROM `u42jy_users` WHERE `id`=

Any solution available? I am running under Joomla v.3.3.6 and iCagend v 3.4.0.1
vg
Zappu

Connexion ou Créer un compte pour participer à la conversation.

Lyr!C
Administrateur
Lead Developer

Plus d'informations

il y a 11 ans 9 mois - il y a 11 ans 9 mois #8770 par Lyr!C

Réponse de Lyr!C sur le sujet MySQL ERROR

Hello,

Could you give me the type and version of your sql ?

~~Is it mySql or else?~~ sorry, stupid question, you are on mySql :whistle:

Do you have access to phpAdmin, and do you have created category and/or events already ?

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) .