Guest Posted May 9, 2009 Share 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. Quote Link to comment Share on other sites More sharing options...
germ Posted May 9, 2009 Share 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: Quote 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 > Link to comment Share on other sites More sharing options...
spooks Posted May 9, 2009 Share 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: Quote 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. Link to comment Share on other sites More sharing options...
Guest Posted May 9, 2009 Share 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 Quote Link to comment Share on other sites More sharing options...
spooks Posted May 9, 2009 Share 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); } Quote 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. Link to comment Share on other sites More sharing options...
Guest Posted October 11, 2009 Share 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. 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.