2. PHPRunner General questions
  3. [SOLVED]  simple search error in phprunner 10.4 with lookup
This topic is locked
[SOLVED]

 simple search error in phprunner 10.4 with lookup

 		8/25/2020 11:13:25 AM
PHPRunner General questions
ffrinai author

Hi,

i have 2 simple tables (10.3.1-MariaDB , PHP: 7.2.12 , phprunner enterprise 10.4 build 35647 x64)
Table1

id (int)(pk)

idcodet1 varchar(64)

fieldt1_1 varchar(50)

fieldt1_2 varchar(50)

fieldt1_3 varchar(50)
Table2

idcodet2 varchar(64) (pk)

desct2 varchar(50)
in add/edit the field idcodet1 have a lookup on table2 with link field idcodet1=idcodet2

when in list page i try a simple search i obtain a server error


this are the details


all fields are included in "include into all fields Search"


but if i remove the idcodet1 in "include into all fields Search"


the simple search works without errors but the idcodet1 values can't be searched!.
the same little project works always fine in phprunner 10.3 (Enterprise build 34865 x64)

also if all fields are included in "include into all fields Search".
is there a solution?

Thanks

Fabio
woodey2002 8/25/2020

Have you tried in a earlier build of 10.4?
Cheers,

J
ffrinai author 8/25/2020



Have you tried in a earlier build of 10.4?
Cheers,

J


Yes since 29/05/2020,

But in every build of 10.4 was the same

Fabio
J
 		jacques 8/25/2020



Yes since 29/05/2020,

But in every build of 10.4 was the same

Fabio


I experienced the same problem

I always use the latest build
my solution:
remove all the search fields in All Field Search

select some again
and my problems where solved.
ffrinai author 8/26/2020



I experienced the same problem

I always use the latest build
my solution:
remove all the search fields in All Field Search

select some again
and my problems where solved.


I try to uncheck all fields in "Include into all fields Search" for both tables,

rebuild the project, verified no errors (no search perform),

now i check the only field idcodet1 of table1 (the lookup field) in "Include into all fields Search"

rebuild and this is the complete error detail


thanks

Fabio
mbintex 8/26/2020

Having the same experience.
Search on foreign key fields creates this error.
Upload a demo to Sergey and demonstrate the bug. He is quick in eliminating these things.
mbintex 8/29/2020

This bug is fixed in build 35672.
Myr0n 9/1/2020

One thing you can do is to copy the SQL that is showing you in the Technical information and tried if works in you phpmyadmin because its seems that your join is not working.
ffrinai author 10/6/2020

The problem is in mariadb 10.3.1.

I try the simple search query
SELECT DISTINCT azqag1br62 FROM ( SELECT table1.id, table1.idcodet1, table1.fieldt1_1, table1.fieldt1_2, table1.fieldt1_3, table2.desct2, a5ja6ehryu.aoowhc17hp AS azqag1br62 FROM table1 LEFT OUTER JOIN table2 ON table1.idcodet1 = table2.idcodet2 LEFT JOIN (SELECT idcodet2 AS az3hot8dmd,MIN( ajs8sqc20s ) AS aoowhc17hp FROM ( SELECT idcodet2, desct2, concat(idcodet2,' - ',desct2) AS ajs8sqc20s FROM table2 ) a GROUP BY idcodet2) a5ja6ehryu ON az3hot8dmd = table1.idcodet1 WHERE ( ( ( upper(a5ja6ehryu.aoowhc17hp) like upper('%a%') ) ) ) ) a limit 0, 10
with others versions of mariadb and mysql and it works fine. Only in mariadb 10.3.1 it crash!

So i decided to install xampp 7.3.5 (apache 2.4.39 [win64], php 7.3.5, mariadb 10.1.39) as seen in the phprunner 10.4 manual.

Now phprunner 10.4 works fine.

Fabio