sql error with workflow notification to specified users

More
10 years 4 months ago #48195 by esinet
Hello,
I've got this error with workflow notification when i'm using username (in my case, Super User is totosuper)
It's ok when i'm using number of id

1084 : 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 DISTINCT email FROM lkihp_users WHERE id IN (totosuper,totovalidateur,)

I hope you'll understand my request ...
Thanks

Joomla 3.9.14 /3.6.5 FLEXIcontent v 3.3.1.6

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

More
10 years 4 months ago #48197 by micker
hello
joomla and flexicontent version ?
error in witch page ?

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

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

More
10 years 4 months ago #48203 by esinet
Sorry ...
joomla 3.3.1
flexicontent version 2.1.3 r1857
what page ?
I've got this message when a author create a article and ask for editing ...

Joomla 3.9.14 /3.6.5 FLEXIcontent v 3.3.1.6

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

More
10 years 4 months ago #48211 by ggppdk
Hello

it looks like that in configuration you have enter an extra comma at the end of the username list

totosuper,totovalidateur,

correct would be:
totosuper,totovalidateur


-- check the usenames configuation in component parameters, type parameters and/or category parameters,

where you have added the above

Regards


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

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

More
10 years 4 months ago #48232 by esinet
Hello,
In the same case, with only one notification, without comma, i've got an error sql :
1054 Unknown column 'dane' in 'where clause' SQL=SELECT DISTINCT email FROM editice_users WHERE id IN (dane)

And the author can ask a validation if the user id is a number ...

Joomla 3.9.14 /3.6.5 FLEXIcontent v 3.3.1.6

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

More
10 years 4 months ago #48234 by ggppdk
Hello

hhmm, the username is handled as if it is numeric, (aka a user id)

will have to test/fix this locally, you may post a reminder in a few days,

Regards


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

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

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.538 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline