[NOT-CB] Impossible to Confirm user

Ricoray
OFFLINE
Posts: 2
Thanks: 0
Karma: 0

9 years 6 months ago - 9 years 6 months ago #280745 by Ricoray

[NOT-CB] Impossible to Confirm user was created by Ricoray

Hello,

I've issue to confirm user, here is the error message that it returne me :

Code:

Impossible de confirmé l'489 de la ligne car: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 SQL=UPDATE IGNORE `#__jnews_subscribers` SET `name` = 'name' , `email` = 'name@mailprovider.com' , `receive_html` = 1 , `confirmed` = 1 , `timezone` = '00:00:00' , `language_iso` = 'eng' , `blacklist` = 0 WHERE `id` =

(Of course, I've changed the name and email adress of the user)

I'm no that good in SQL but it seems pretty obvious that it tries to add the user in the table "jnews_subscribers" but I don't want that...

Does anyone know an easy way to avoid that ?

Thank you in advance.

Ps1 : If it's easier to correct the problem by keeping the addition of the user in jnews, I'm willing to choose this solution
Ps2 : Sorry for my english

Last edit: 9 years 6 months ago by nant.

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

nant
OFFLINE
Posts: 12339
Thanks: 1467
Karma: 877

9 years 6 months ago #280767 by nant

Replied by nant on topic Impossible to Confirm user

Nothing to do with CB - you must have something jnews related that is causing this.
Suggest you contact the jnews devs for help.

--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting

Visit my CB Profile - Send me a Private Message (PM)

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

Ricoray
OFFLINE
Posts: 2
Thanks: 0
Karma: 0