Hi,
I have made a customization where I include a “LEFT OUTER JOIN” clause for listings so that the “linked to business” info can be included here.
This is working nicely now but I needed to make a small change to one of the plugin files:
/geodir_location_manager/geodir_location_hooks_actions.php
The table was not specified for the “post_locations” column in the query which caused “ambiguous” -SQL error. I wanted to ask if the table has not been specified for a purpose or if perhaps this could be updated in an upcoming release?
Here´s what I did, around line 1640:
$table_spec = ”;
if ($p_table != ”) {$table_spec = $p_table . “.”;}
else if ($table != ”) {$table_spec = $table . “.”;}
…I then included the $table_spec -variable when constructing the query
” AND ” . $table_spec . “post_locations LIKE”
Thanks!