Jump to content
Sign in to follow this  
rickeyl

Reviews Contribution

Recommended Posts

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

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

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

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

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

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×