Product not found

[prof3ta]

Im having a problem with a store im moving to a new server. Every product i click on leads to a "product not found" page.

The problem seems to be in my product_info.php, where the result of the following query is equal to zero:

 

$product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");

 

And this is because the value of (int)$HTTP_GET_VARS['products_id'] is simply empty.

 

Any ideas guys????

[Jan Zonjee]

And this is because the value of (int)$HTTP_GET_VARS['products_id'] is simply empty.

REGISTER_LONG_ARRAYS is off in php.ini? This is an old store that hasn't got the update added to make the store work when register_globals is off?

[prof3ta]

REGISTER_LONG_ARRAYS is off in php.ini? This is an old store that hasn't got the update added to make the store work when register_globals is off?

 

 

Thank you for answering.

 

Its a pretty old store, dont know how old exactly, Im just taking over what the previous webmaster left unfinished.

 

in php.ini

 

register_globals = On

register_long_arrays = Off

 

Is this right?

Il play around with those 2 variables and see what happens.

[Jan Zonjee]

Thank you for answering.

in php.ini

 

register_globals = On

register_long_arrays = Off

 

Is this right?

If it is an old store they definitely need to be set to On both. For the server to "see" those new settings I think the webserver needs to be restarted...

[prof3ta]

If it is an old store they definitely need to be set to On both. For the server to "see" those new settings I think the webserver needs to be restarted...

 

Sir you are a gentleman and a scholar.

 

Both turned on and webserver restarted, store is working properly now.

 

You have no idea how much I appreciate your help.

[wtbman]

Sir you are a gentleman and a scholar.

 

Both turned on and webserver restarted, store is working properly now.

 

You have no idea how much I appreciate your help.

 

Ditto that! I have been playing around with this for months (kind of sidestepping actually) but my "old" server finally crashed so I was forced to the "new" server. Changed REGISTER_LONG_ARRAYS to on and SHABAM it all works!

 

p.s. Thanks google!