Search does not work correctly or do not work
1) all work ok
2) (particular) does not work
3) (company) does not work
Although the previous version of the theme to work all ok

@ RSN
working on this site

https://mercado24.ro/
2) - OK
3) not sure about option private (particular)...

@rsn
I believe you have updated in way that you modified just few files.
Please replace all theme files and try again.

Hey. so on your website[/i]]website, this search does not work
http://veronika.mb-themes.com/search/cookieAction,done/sOrder,dt_pub_date/iOrderType,desc/sCompany,1
check on your site please

and is a previous version of the author himself wrote on this site mercado24

@rsn
Thank you, it seems problem was caused by order of conditions in theme functions.

Go to oc-content/themes/veronika/functions.php

Find function:
mb_filter_extend
Replace it with:
function mb_filter_extend() {
  // SEARCH - ALL - INDIVIDUAL - COMPANY TYPE
  Search::newInstance()->addJoinTable( 'pk_i_id', DB_TABLE_PREFIX.'t_item_veronika', DB_TABLE_PREFIX.'t_item.pk_i_id = '.DB_TABLE_PREFIX.'t_item_veronika.fk_i_item_id', 'LEFT OUTER' ) ; // Mod

  // SEARCH - TRANSACTION
  if(Params::getParam('sTransaction') <> '') {
    Search::newInstance()->addConditions(sprintf("%st_item_veronika.i_transaction = %d", DB_TABLE_PREFIX, Params::getParam('sTransaction')));
  }


  // SEARCH - CONDITION
  if(Params::getParam('sCondition') <> '') {
    Search::newInstance()->addConditions(sprintf("%st_item_veronika.i_condition = %d", DB_TABLE_PREFIX, Params::getParam('sCondition')));
  }


  // SEARCH - PERIOD
  if(Params::getParam('sPeriod') <> '') {
    $date_from = date('Y-m-d', strtotime(' -' . Params::getParam('sPeriod') . ' day', time()));
   
    Search::newInstance()->addConditions(sprintf('cast(%st_item.dt_pub_date as date) > "%s"', DB_TABLE_PREFIX, $date_from));
  }


  // SEARCH - COMPANY
  if(Params::getParam('sCompany') <> '' and Params::getParam('sCompany') <> null) {
    Search::newInstance()->addJoinTable( 'pk_i_id', DB_TABLE_PREFIX.'t_user', DB_TABLE_PREFIX.'t_item.fk_i_user_id = '.DB_TABLE_PREFIX.'t_user.pk_i_id', 'LEFT OUTER' ) ; // Mod

    if(Params::getParam('sCompany') == 1) {
      Search::newInstance()->addConditions(sprintf("%st_user.b_company = 1", DB_TABLE_PREFIX));
    } else {
      Search::newInstance()->addConditions(sprintf("coalesce(%st_user.b_company, 0) <> 1", DB_TABLE_PREFIX));
    }
  }
}


Is this will be updated in new upgraded release?

@Ivanko
Yes, it seems problem was that left outer join was before inner join that could cause mess in SQL (even it looked ok when I checked that)

I have the same issue, BELOW is my code, can you please advise what exactly needs replaced?? thanks!!


function mb_filter_extend() {
  // SEARCH - ALL - INDIVIDUAL - COMPANY TYPE
  if(Params::getParam('sCompany') <> '' and Params::getParam('sCompany') <> null) {
    Search::newInstance()->addJoinTable( 'pk_i_id', DB_TABLE_PREFIX.'t_user', DB_TABLE_PREFIX.'t_item.fk_i_user_id = '.DB_TABLE_PREFIX.'t_user.pk_i_id', 'LEFT OUTER' ) ; // Mod

    if(Params::getParam('sCompany') == 1) {
      Search::newInstance()->addConditions(sprintf("%st_user.b_company = 1", DB_TABLE_PREFIX));
    } else {
      Search::newInstance()->addConditions(sprintf("coalesce(%st_user.b_company, 0) <> 1", DB_TABLE_PREFIX, DB_TABLE_PREFIX));
    }
  }


  Search::newInstance()->addJoinTable( 'pk_i_id', DB_TABLE_PREFIX.'t_item_veronika', DB_TABLE_PREFIX.'t_item.pk_i_id = '.DB_TABLE_PREFIX.'t_item_veronika.fk_i_item_id', 'LEFT OUTER' ) ; // Mod

  // SEARCH - TRANSACTION
  if(Params::getParam('sTransaction') <> '') {
    Search::newInstance()->addConditions(sprintf("%st_item_veronika.i_transaction = %d", DB_TABLE_PREFIX, Params::getParam('sTransaction')));
  }


  // SEARCH - CONDITION
  if(Params::getParam('sCondition') <> '') {
    Search::newInstance()->addConditions(sprintf("%st_item_veronika.i_condition = %d", DB_TABLE_PREFIX, Params::getParam('sCondition')));
  }


  // SEARCH - PERIOD
  if(Params::getParam('sPeriod') <> '') {
    $date_from = date('Y-m-d', strtotime(' -' . Params::getParam('sPeriod') . ' day', time()));
   
    Search::newInstance()->addConditions(sprintf('cast(%st_item.dt_pub_date as date) > "%s"', DB_TABLE_PREFIX, $date_from));
  }
}

osc_add_hook('search_conditions', 'mb_filter_extend');


@bobyrou

The bug was fixed in latest version of theme.

thanks, I will apply the update.

If I use the repaired code, the problem will not be solved completely.

On my domain http://suprbazar.cz/search

If I use the filter combination on the left (transaction, condition, price, with foto, Etc.) and a filter at the top (private and company ads) Nothing is found.

How do I fix this problem?

@R3sidento
It usually happen if you have first installed theme with older version. There was database structure change.

Try this:
http://forums.mb-themes.com/veronika-osclass-responsive-theme/i-can't-see-any-listing-after-update/msg5878/#msg5878

Note that for attributes new tables are used and therefore it will erase existing inputs of Transaction, Status, ...