Forum support

We provide good documentation for our free Joomla! extensions, including online documentatation directly in the administraton interface. If you need further individuel help with our free Joomla! extensions, you can subscribe for our payed support forum. Please apply for the paid forum support here and log in with the user id of the user with whom you have purchased the forum support.

Forum Support is free as long as you have an active Visforms Subscription or an active Subscription for the Bootstrap Carousel. Please just log in with your subscription user id.

Read-only use of the forums is free for everybody.

Topic-icon invalid session token below sql statement

More
10 months 4 weeks ago #6373 by Tomy
Hello,

Good news is i have forms running and found the sql statements.

Once I test it I keep bumping into :

"Sorry, the request could not be performed due to a invalid Session Token"

So the sql statement i see is accurate. i don't understand what a session token implies. Would you mind shedding light on how i might resolve this issue?

Thank you


Tom

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

More
10 months 4 weeks ago #6374 by Administrator
Replied by Administrator on topic invalid session token below sql statement
Hi Tom,

I would need a much more detailed description when and where exactly you run into this problem. (Frontend, Adminstration, if frontend how is the form published (Menu, modul, plugin), is there any cache enabled, do you use the reload option of the sql field, do you have any plugins on your website that might effect the session cookie setting (some Joomla Cookie Consent plugins do such a thing).....)

Regards,
Aicha

-- Visforms Developer --
Always consult our documentations before asking a question on our forum, the answer is most probably there. :)
Bitte konsultiere immer zuerst unsere Dokumentationen bevor du eine Frage im Forum stellst, die Antwort ist bestimmt da. :)
Enjoy Joomla!

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

More
10 months 3 weeks ago #6383 by Tomy
Dear Aicha,

Thank you for the reply.

I have been trying out your suggestions and i am still hitting a wall.

So what I have now is : in my form, in the field - basic options - i have chosen select sql where i have added my sql select statement in the right bottom hand corner. I have made the reload able to no. I tested the select sql statement out and still get a reply "Sorry, the request could not be performed due to a invalid Session Token".

So, I went to the plugins and got rid of any additional cookie plugins from third parties.

I made sure all the access levels are the same and I have all the forms and data are on display.

Now I have the privacy consent plugin disabled to as a base line to identify how to get the sql query to work.

I know it doesn't work because I am constantly double checking the display in the front and the only filtering that comes out is "Choose a value".

I know I may sound annoying with all these issues but I am confident this will work. I have come this far and my business will benefit immensely if I can get this to work. Please Help.

Thank you

Tom

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

More
10 months 3 weeks ago #6384 by Administrator
Replied by Administrator on topic invalid session token below sql statement
Hi Tom,
could you give me access to the administration (as super user) and to the form.
If so, please send login data to This email address is being protected from spambots. You need JavaScript enabled to view it.
Regards,
Aicha

-- Visforms Developer --
Always consult our documentations before asking a question on our forum, the answer is most probably there. :)
Bitte konsultiere immer zuerst unsere Dokumentationen bevor du eine Frage im Forum stellst, die Antwort ist bestimmt da. :)
Enjoy Joomla!

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

More
10 months 3 weeks ago #6385 by Tomy
Fantastic!!!

i just sent you the details!!

Thank you Aicha!!

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

More
10 months 3 weeks ago #6386 by Administrator
Replied by Administrator on topic invalid session token below sql statement
Hi Tom,

you got the SQL Statement completely wrong.

You are writing an SQL Statement against the database.
You have to use the field names from the database which are not identical to the form field names and you have to use the database table name which is not identical to the form name.
If the Sql Statements uses values which are submitted with a visforms form then the database field name is the character F directly followed by the form field id, which you can retrieve from the field list.
For example F13 (for the field with the id 13)
The database table name consists of the Joomla! table prefix (or the Joomla! table prefix placeholder which is #_) an underscore the word "visforms" another underscore and the form id.
For example jos_visforms_3 or #__visforms_3 for data submitted with the form with the id 3

Further on you have to use the "as label" and "as value" in the sql Statement.
So the correct sql Statement is

SELECT F13 as label, F14 as value FROM jos9q_visforms_4;

It is also important that you do not have line breaks or in the statement.

Hopefully this will make it a bit clearer to you how this works and will enable you to write other working sql statements for "sql" fields.

I think the "invalid session token" message just was a result of the completely wrong sql statement....

Regards,
Aicha

-- Visforms Developer --
Always consult our documentations before asking a question on our forum, the answer is most probably there. :)
Bitte konsultiere immer zuerst unsere Dokumentationen bevor du eine Frage im Forum stellst, die Antwort ist bestimmt da. :)
Enjoy Joomla!

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

Moderators: Administrator