Medoo icon indicating copy to clipboard operation
Medoo copied to clipboard

Medoo::RAW with joined table under Version 2.x.x

Open rotkaepchen opened this issue 4 years ago • 2 comments

Hi all,

I have an issue to join tables and use Medoo::RAW as where. Database: Postgresql

Example: $join=array('[>]AdminSegmentTypes'=>['segment_types_id'=>'id']); $where="WHERE network.networkv4 <<= INET'$net' OR network.networkv6 <<= INET'$net'"; $result=$database->select($table,$join,$fields,Medoo2::raw($where) );

Error: Uncaught TypeError: Argument 5 passed to medoo2\Medoo2::selectContext() must be of the type array or null, object given, called in classes/medoo2/Medoo2.class.php on line 1593 and defined in classes/medoo2/Medoo2.class.php:1163 Stack trace: #0 classes/medoo2/Medoo2.class.php(1593): medoo2\Medoo2->selectContext('adminnetworksco...', Array, Array, Array, Object(medoo2\Raw)) #1 content/netmgmt/find_networks.php(88): medoo2\Medoo2->select('network...', Array, Array, Object(medoo2\Raw)) #2 {main} thrown in classes/medoo2/Medoo2.class.php on line 1163

If I use version 1.7.10 with the same command then it works.

regards

rotkaepchen avatar Aug 11 '21 06:08 rotkaepchen

I came here to report this issue, but found this already here, so I'll just add that I have the same problem. Thanks,

m-nienberg avatar Sep 26 '21 20:09 m-nienberg

@catfan Seems that deleting "array" at line 1168 fixes the problem.

fran-diaz avatar Oct 26 '21 06:10 fran-diaz