Joomla Templates Club 406,261 posts

[victortopper Friend victortopperJoin date: May 2008Posts: 495Downloads:27Uploads:172 Thanks: 23 Thanked: 2 times in 1 posts]

#662588

Hi,

I wanted to create contacts but I have this message

“Registration failed with the following error: You have an error in your SQL syntax; check the manual That corresponds to your MySQL server version of for the right syntax to use near ‘AND` sha1_hash` =’ a4d2462b2cb395e64605398bca49023feef51fdd ‘LIMIT 0, 1 ‘at line 3 SQL = SELECT * FROM “ WHERE tp6b3_ucm_history` ucm_item_id` = 1 AND “ sha1_hash` ucm_type_id` = AND =’ a4d2462b2cb395e64605398bca49023feef51fdd ‘LIMIT 0, 1 “

[victortopper Friend victortopperJoin date: May 2008Posts: 495Downloads:27Uploads:172 Thanks: 23 Thanked: 2 times in 1 posts]

#662788

The error occurs when I have ‘Activer l’historique’ (Save Versions) set to yes. Why do I need to set to ‘Non’ to save?

[Adam M Moderator Adam MJoin date: May 2014Posts: 5159Downloads:33Uploads:66 Thanks: 95 Thanked: 1271 times in 1235 posts]

#662928

Hi @victortopper,

Did you get the problem while creating new user in front-end of in back-end ?

[Adam M Moderator Adam MJoin date: May 2014Posts: 5159Downloads:33Uploads:66 Thanks: 95 Thanked: 1271 times in 1235 posts]

#745948

Hi @victortopper,

Did you get the problem while creating new user in front-end of in back-end ?

[victortopper Friend victortopperJoin date: May 2008Posts: 495Downloads:27Uploads:172 Thanks: 23 Thanked: 2 times in 1 posts]

#662937

Yes by making a backup created user I have this error message

“” Registration failed with error The Following: You have an error in your SQL syntax; check the manual That corresponds to your MySQL server version of of the right syntax to for use near ‘AND` hash` sha1 =’ a4d2462b2cb395e64605398bca49023feef51fdd ‘LIMIT 0, 1’ at line 3 SQL = SELECT * FROM `WHERE 1 = tp6b3_ucm_history` ucm_item_id` “ sha1_hash` ucm_type_id` AND = AND = ‘a4d2462b2cb395e64605398bca49023feef51fdd’ LIMIT 0, 1 ”

when I disable “‘Enable historic” I can create the user and correctly suavegader

[victortopper Friend victortopperJoin date: May 2008Posts: 495Downloads:27Uploads:172 Thanks: 23 Thanked: 2 times in 1 posts]

#745957

Yes by making a backup created user I have this error message

“” Registration failed with error The Following: You have an error in your SQL syntax; check the manual That corresponds to your MySQL server version of of the right syntax to for use near ‘AND` hash` sha1 =’ a4d2462b2cb395e64605398bca49023feef51fdd ‘LIMIT 0, 1’ at line 3 SQL = SELECT * FROM `WHERE 1 = tp6b3_ucm_history` ucm_item_id` “ sha1_hash` ucm_type_id` AND = AND = ‘a4d2462b2cb395e64605398bca49023feef51fdd’ LIMIT 0, 1 ”

when I disable “‘Enable historic” I can create the user and correctly suavegader

[timtecsa Friend timtecsaJoin date: October 2009Posts: 1382Downloads:86Uploads:327 Thanks: 197 Thanked: 132 times in 34 posts]

#663028

Back-end. I tested it for Victor and got same error. Didn’t try from front-end.

[timtecsa Friend timtecsaJoin date: October 2009Posts: 1382Downloads:86Uploads:327 Thanks: 197 Thanked: 132 times in 34 posts]

#745972

Back-end. I tested it for Victor and got same error. Didn’t try from front-end.

[Adam M Moderator Adam MJoin date: May 2014Posts: 5159Downloads:33Uploads:66 Thanks: 95 Thanked: 1271 times in 1235 posts]

#663818

Hi @victortopper, @timtecsa,

Let me discuss with our development team about this matter and I will reply back shortly, please stay tuned.

[Adam M Moderator Adam MJoin date: May 2014Posts: 5159Downloads:33Uploads:66 Thanks: 95 Thanked: 1271 times in 1235 posts]

#746155

Hi @victortopper, @timtecsa,

Let me discuss with our development team about this matter and I will reply back shortly, please stay tuned.

[Adam M Moderator Adam MJoin date: May 2014Posts: 5159Downloads:33Uploads:66 Thanks: 95 Thanked: 1271 times in 1235 posts]

#664210

Hi @victortopper, @timtecsa,

Just got a reply from development team about this matter but we couldn’t reproduce the problem at our end. Could you please provide your site url and temporary admin account via private reply so I can investigate the issue ?

[Adam M Moderator Adam MJoin date: May 2014Posts: 5159Downloads:33Uploads:66 Thanks: 95 Thanked: 1271 times in 1235 posts]

#746250

Hi @victortopper, @timtecsa,

Just got a reply from development team about this matter but we couldn’t reproduce the problem at our end. Could you please provide your site url and temporary admin account via private reply so I can investigate the issue ?

[Author]

Posts