sql select statement

I still have an error on the sql runtime test.
I'm try select id as value, F57 as label from #__visforms_6 order by F57
and select id as value, F57 as label from jo33_visforms_6 order by F57
and select id as value, F57 as label from #__visforms_6 limit 10

f57 is a text data

and always was error...
when I try to save with error it's stuck.. and field is still as a normal text.
what can be wrong??

Hello skidowitz,

in one of my test forms having multiple SQL fields, I just added a new SQL-field to reproduce your situation.
It does work fine on my Joomla 4 instance.

Please have look to my specific SQL statement:
vi-solutions.de/forum-uploads/sql-statem...orm_sql-field-10.png

I can not find something basically wrong in your statements.

What does the error message in the field configuration read?
Have you tried the statement with the final complete table name in a SQL management tool like MySqlAdmin?
What does the error message read in MySqlAdmin?

A statement with the final complete table name looks like this:
Best Regards, Ingmar

in phpMyAdmin everything is ok.
I'm using joomla 3.10
I'm try even  

SELECT '1' as value, 'test1' as label
                      SELECT '1' as label, 'test1' as value
                      SELECT 'test' as label, '1' as value screenshoot:
ibb.co/f1hFPbn

Please help ,.,.

"What does the error message in the field configuration read?"
Where it is on visform in joomla 3 ???
 

Hello skidowitz,

it also works on Joomla 3.10.

Joomla 9.10 field configuration with 1 fixed option: vi-solutions.de/forum-uploads/sql-statem...-field_1-options.png

Joomla 9.10 field configuration with 2 fixed options: vi-solutions.de/forum-uploads/sql-statem...-field_2-options.png

It is very important that there are no tabs or newlines throughout the SQL statement. Otherwise an error occurs.

In earlier versions, at least line breaks were allowed between the select parts, i.e. immediately before the 'union select':
vi-solutions.de/de/support/forum/19-joom...rfach-verzahlen#8157
(use a translation tool like Google Translate)

But that is no longer possible.
No tabs or newlines in the whole SQL statement, which means the whole textarea.

In the best case, the error message only gives the line number in which the error occurs.
Since it is always exactly 1 line, the error message is not particularly meaningful.

Hope this helps!

Best regards, Ingmar

I found a solution. The vfbase installation was probably incomplete and not all modules were running. After turn on all visform modul's, joomla 3.10 crashed. It turned out that:
libraries/visolutions/tcpdf/tcpdf.php
not exsist.
After manualy extract from vfbase_j3.9.0_3.0.4.zip into libries the Joomla start's and sql select work fine.

ps.
It is strange that the visform did not show that some module was not working. And everything else worked fine and showed no problems.

Hello skidowitz,

I'm glad you found a solution and Visforms is working fine!

An incomplete or faulty installation is of course very annoying.
Checking the installation for completeness after going through it is a good tip that we want to follow up on.

I created an issue for this and added it to the development list:
Issue VF-641 - Installation: Forum: Check completeness and integrity of the install process
After a future release that contains this point, you will be informed about it directly here in the topic.

At least the completeness (all files and directories) and the integrity (hash of each file) of the completed installation can be checked.
The functionality of individual modules is a bit more difficult to determine and is initially left out.
However, I think that the purely static test already covers a large number of situations.

Incidentally, when working with Joomla 4, the installation often aborts for me, much more often than was the case with Joomla 3.
But the Visforms installation is the same every time.
I just install it again and then it worked in all cases so far.

Greetings, Ingmar