rickeyl 0 Posted May 9, 2009 When I try to open the admin/reveiws.php, I get this error: Warning: Division by zero in /home/*******/public_html/catalog/admin/includes/classes/split_page_results.php on line 33 1064 - 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 '-0, MAX_SEARCH_RESULTS_ADMIN' at line 1 If someone could tell me how to fix this, I would be greatful. Share this post Link to post Share on other sites
germ 233 Posted May 9, 2009 In your /admin/includes/configure.php try adding this: define('MAX_SEARCH_RESULTS_ADMIN', '20'); Read my signature about making backups. You break it - you bought it. :blush: If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there > Share this post Link to post Share on other sites
spooks 79 Posted May 9, 2009 Germ is correct, it seems I missed an instruction off the install, I'm surprised this aint come up b4, I'll post correction soon. :blush: Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. Share this post Link to post Share on other sites
rickeyl 0 Posted May 9, 2009 That got the first error taken care of but now there is another: Fatal error: Call to undefined function tep_noslash_string() in /home/*******/public_html/catalog/admin/reviews.php on line 542 Share this post Link to post Share on other sites
spooks 79 Posted May 9, 2009 oops, yes another boo boo in admin/includes/functions/general.php add b4 the final ?> // Remove / from text function tep_noslash_string($string) { $search = array(chr(92),chr(47)); return str_replace($search,'',$string); } Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. Share this post Link to post Share on other sites
catmac 0 Posted October 11, 2009 I was getting the same error--but found that logging into the store admin and setting under "configuration"-"maximum values"-"new reviews" to a number other then the install figure of zero solved the error. Share this post Link to post Share on other sites
