Joomla 5 Mitteilung

Wir freuen uns mitteilen zu können, dass seit dem 29. Januar 2024 alle unsere Joomla Erweiterungen mit Joomla 5 kompatible sind.

Für alle die gerade noch von Joomla 3 auf 4 aktualisieren: Anleitungen für die Joomla 4 Migration gibt es hier:

Es gibt nun auch eine eigenständige Dokumentation für Visforms für Joomla 4 und für Visforms auf Joomla 5

Forum

Visforms Subscription Inhaber können in unserem Forum Fragen stellen. Bitte mit dem entsprechenden Benutzer anmelden.
Jeder kann lesend auf das Forum zugreifen.

Bitte stellen Sie nur 1 Frage pro Thema.

invalid session token below sql statement

Mehr
4 Jahre 4 Monate her #6373 von 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

Mehr
4 Jahre 4 Monate her #6374 von Administrator AV
Administrator AV antwortete auf 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

:idea: I recommend you the new and up-to-date documentation for Joomla 4:
docs.joomla-5.visforms.vi-solutions.de/en/docs/
Most of this also applies retrospectively to Joomla 3.
Please only ask 1 question per topic :-).

:idea: Ich empfehle Dir die neue und aktuelle Dokumentation für Joomla 4:
docs.joomla-5.visforms.vi-solutions.de/docs/
Das meiste gilt rückwirkend auch für Joomla 3.
Bitte immer nur 1 Frage pro Thema stellen :-).

Mehr
4 Jahre 4 Monate her #6383 von 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

Mehr
4 Jahre 4 Monate her #6384 von Administrator AV
Administrator AV antwortete auf 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 contact@vi-solutions.de
Regards,
Aicha

:idea: I recommend you the new and up-to-date documentation for Joomla 4:
docs.joomla-5.visforms.vi-solutions.de/en/docs/
Most of this also applies retrospectively to Joomla 3.
Please only ask 1 question per topic :-).

:idea: Ich empfehle Dir die neue und aktuelle Dokumentation für Joomla 4:
docs.joomla-5.visforms.vi-solutions.de/docs/
Das meiste gilt rückwirkend auch für Joomla 3.
Bitte immer nur 1 Frage pro Thema stellen :-).

Mehr
4 Jahre 4 Monate her #6385 von Tomy
Fantastic!!!

i just sent you the details!!

Thank you Aicha!!

Mehr
4 Jahre 4 Monate her #6386 von Administrator AV
Administrator AV antwortete auf 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

:idea: I recommend you the new and up-to-date documentation for Joomla 4:
docs.joomla-5.visforms.vi-solutions.de/en/docs/
Most of this also applies retrospectively to Joomla 3.
Please only ask 1 question per topic :-).

:idea: Ich empfehle Dir die neue und aktuelle Dokumentation für Joomla 4:
docs.joomla-5.visforms.vi-solutions.de/docs/
Das meiste gilt rückwirkend auch für Joomla 3.
Bitte immer nur 1 Frage pro Thema stellen :-).

Moderatoren: Administrator AVAdministrator IV
Powered by Kunena Forum