jrodch Posted January 9, 2012 Share Posted January 9, 2012 I recently moved my CubeCart store to another server. Everything seems to be working except the search feature. When I type in a search I get an error saying "Error reporting is disabled in the database class. Please enable to debug." I don't see where I can turn on error reporting. I'm currently on Host Gator. The site is www.ebbesquaredrains.com. Thanks! Quote Link to comment Share on other sites More sharing options...
jrodch Posted January 9, 2012 Author Share Posted January 9, 2012 Update: The error_log file pointed me to the viewCat.inc.php file. The line it's point to says: "$matchString = sprintf("MATCH (%s) AGAINST(%s%s)", implode(',', $indexes), $db->mySQLsafe($_REQUEST['searchStr']), $mode);" I hope this helps. Thanks Quote Link to comment Share on other sites More sharing options...
bsmither Posted January 9, 2012 Share Posted January 9, 2012 Would you verify the exact version of CC you are using? The closest line of code I found in that file for CC4.4.6 is: $matchString = sprintf('MATCH (%s) AGAINST(%s IN BOOLEAN MODE)', implode(',', $indexes), $db->mySQLsafe($terms)); In your code, I see the issue where two '%s' sequences are not separated by a space. This could be your problem. Quote Link to comment Share on other sites More sharing options...
jrodch Posted January 9, 2012 Author Share Posted January 9, 2012 bsmither: Thanks for the reply. I'm running 4.3.7. I tried putting a space between the two %s, with the same result.The error from error_log is [09-Jan-2012 07:44:21] PHP Warning: implode() [<a href='function.implode'>function.implode</a>]: Invalid arguments passed in /home/ebbe2011/public_html/includes/content/viewCat.inc.php on line 178 Quote Link to comment Share on other sites More sharing options...
bsmither Posted January 9, 2012 Share Posted January 9, 2012 Ok, I have a copy of 4.3.8, so please, from 4.3.7, report back with the statement in viewCat.inc.php found here (around line 131): $indexes = $db->getFulltextIndex('inventory', 'I'); //array('inventory', 'inv_lang')); if (!empty($_REQUEST['priceMin'])... if (!empty($_REQUEST['priceMax'])... The $indexes line gets a list of all table columns declared as a fulltext searchable index. But I see a problem with getFulltextIndex(). I need to see what your statement for 4.3.7 looks like. There is also another change in the code between 4.3.8 and 4.4.6 that apparently fixes another issue. We can discuss that later. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.