Jump to content

[Resolved] System Error Log File: [catalogue.class.php] Line: [1715]


Tomasz

Recommended Posts

When we updated 6.0.12 to the new 6.1.0 and when log in the admin i have some error log.

Before it dosent hapend.

File: [catalogue.class.php] Line: [1715] "SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name fulltext '%Mk5%' OR I.description fulltext '%Mk5%' OR I.product_code fulltext '%Mk5%') LIMIT 12 OFFSET 0 " - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'fulltext '%Mk5%' OR I.description fulltext '%Mk5%' OR I.product_code fulltext '%' at line 1
     

File: [catalogue.class.php] Line: [1715] "SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name fulltext '%Gti%' OR I.description fulltext '%Gti%' OR I.product_code fulltext '%Gti%') LIMIT 12 OFFSET 0 " - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'fulltext '%Gti%' OR I.description fulltext '%Gti%' OR I.product_code fulltext '%' at line 1

And more errors.

I try to update to 6.1.1 and cant. I use automaticy upgrade and manual -> dont work.

How i can fix this problem?

Thanks a lot 

Best regard

Tomasz

 

   
     
Link to comment
Share on other sites

Thx for help.

I need change in classes/catalogue.class.php this line:
 

return $this->searchCatalogue($original_search_data, 1, $per_page, 'like');
                    }

                } else {
                    $this->_sort_by_relevance = false;
                    $rlike = '';
                    if (!empty($search_data['keywords'])) {

to:

 						return $this->searchCatalogue($original_search_data, 1, $per_page, 'RLIKE');
 					}
 				} else {
					$search_mode = in_array($search_mode, array('RLIKE','LIKE')) ? $search_mode : 'RLIKE'
					$search_mode = in_array($search_mode, array('RLIKE','LIKE')) ? $search_mode : 'RLIKE';
 					$this->_sort_by_relevance = false;
 					$like = '';
 					if (!empty($search_data['keywords'])) {
 

Correct?

Link to comment
Share on other sites

OK i need add this:

return $this->searchCatalogue($original_search_data, 1, $per_page, 'RLIKE');
}
} else {
$search_mode = in_array($search_mode, array('RLIKE','LIKE')) ? $search_mode : 'RLIKE';
$this->_sort_by_relevance = false;
$like = '';
if (!empty($search_data['keywords'])) {

Done

Thx for help

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...