New installation using a previous database

[chrisp83]

Hello,

 

I have just installed a new installation of OSCommerce purchased from Template Monster. The site was running the version available for download on this site previously.

 

I installed the new version in a different directoy and created a new mysql database. Using mysql, I restored the database for the new version from a backup created from the previous installation. Everything seems to work fine, all products, orders, etc are there. The only issue is that some of the pages are not working as they should. Check out this link:

 

http://hs-cc.org/catalog/specials.php

 

Please help!!

 

Chris

[Guest]

Hello,

 

I have just installed a new installation of OSCommerce purchased from Template Monster. The site was running the version available for download on this site previously.

 

I installed the new version in a different directoy and created a new mysql database. Using mysql, I restored the database for the new version from a backup created from the previous installation. Everything seems to work fine, all products, orders, etc are there. The only issue is that some of the pages are not working as they should. Check out this link:

 

http://hs-cc.org/catalog/specials.php

 

Please help!!

 

Chris

 

 

its asking me for a user name and password to view any of the files aftert hs-cc.org/catalog/

 

can you fix that problem so I can see the errors?

[itsdame1]

its asking me for a user name and password to view any of the files aftert hs-cc.org/catalog/

 

can you fix that problem so I can see the errors?

 

yes it is asking for username and password, basically if you have cpanel for a beckend, just take the password off the directory in the backend, and then you should be able to see this site ;)_

[aZORAble]

Is the error anything like this:

 

1064 - You have an error in your SQL syntax......

??

 

if so,

 

In admin/includes/classes open split_page_results.php

 

find:

 

$offset = ($max_rows_per_page * ($current_page_number - 1));
$sql_query .= " limit " . $offset . ", " . $max_rows_per_page;

 

and replace it with:

 

$offset = ($max_rows_per_page * ($current_page_number - 1));
if ($offset < 0)
{
$offset = 0;
}
$sql_query .= " limit " . $offset . ", " . $max_rows_per_page;

 

 

Hope this helps, cant see your error, but just thought I'd post this cos it's quite common.

[chrisp83]

Hello,

 

Thank you all for replying. IIS has IUSER Account turned off. THat is the error message that I am getting. I replaced the code and still the same thing!

 

Thanks,

Chris

 

 

Is the error anything like this:

 

1064 - You have an error in your SQL syntax......

??

 

if so,

 

In admin/includes/classes open split_page_results.php

 

find:

 

$offset = ($max_rows_per_page * ($current_page_number - 1));
$sql_query .= " limit " . $offset . ", " . $max_rows_per_page;

 

and replace it with:

 

$offset = ($max_rows_per_page * ($current_page_number - 1));
if ($offset < 0)
{
$offset = 0;
}
$sql_query .= " limit " . $offset . ", " . $max_rows_per_page;

Hope this helps, cant see your error, but just thought I'd post this cos it's quite common.