Skip to Content Skip to Menu

SQL Error : Impossible to create new CB Users

  • gtrennert
  • gtrennert
  • OFFLINE
  • Posts: 128
  • Thanks: 4
  • Karma: 0
9 years 6 months ago - 9 years 6 months ago #263662 by gtrennert
Hello
On Joomla! 3.4.1 & CB 2.0.8
I have a couple of MySQL fields ("CB MySQL Field" plugin installed)
and all worked very well
But then I tried to create a new user directly on backend (CB)
When I click on the "New" Button I get this error :

An error has occurred.
1064 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 m0knm_calcsignelem.element AS mysqlfield FROM m0knm_calcsignelem, m0knm_comprofiler WHERE cb_birthday <= enddate AND cb_birthday >= startdate AND m0knm_comprofiler.id =


If I take the SQL request as I see it in the error message its not complete because of the end :
... AND m0knm_comprofiler.id = is the id the thing that is missing ?

I don't understand : I'm creating a NEW user so as long as the user is not created, why does CB do a select before creation ? Can this be resolved ?

Could anybody help me on this ?
Last edit: 9 years 6 months ago by gtrennert.

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

  • gtrennert
  • gtrennert
  • OFFLINE
  • Posts: 128
  • Thanks: 4
  • Karma: 0
9 years 6 months ago #263666 by gtrennert
Replied by gtrennert on topic SQL Error : Impossible to create new CB Users
Sorry - I posted too fast :)
I should have posted in : General Plugins - MySQL Field Type Plugin

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

  • gtrennert
  • gtrennert
  • OFFLINE
  • Posts: 128
  • Thanks: 4
  • Karma: 0
9 years 6 months ago #263931 by gtrennert
Replied by gtrennert on topic SQL Error : Impossible to create new CB Users
Found the solution - in the forum dedicated to this plugin

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

Moderators: beatnantkrileon
Powered by Kunena Forum