Need help ASAP! please

[04JeepTJ]

Well, I have been so happy with OSCdox version of OSCommerce. I love it. I have a working shop with a lot of customized (look and feel) changes made. One day I noticed that the paypal IPN stuff was not working. When I clicked on it, it took me to admin login again and so when I would login it would refresh the login page.

So at the advice of another, I upgraded the paypal IPN stuff to 1.7 from oscommerce contrib. I had to do it manually even though I did not want to. Now, I notice I get a sql error saying a table does not exist.

I got a full site backup before I started, but the site owners have since added something like 200 products and descriptions. I can't get help at oscommerce.com for some reason so I was hoping you guys could help me out here. I am desperate. Please ask me questions and I will get whatever you need to help me solve this issue.

Currently this is the error I see on everypage towards the bottom:

1146 - Table 'dixiemm_shop.TABLE_PRODUCTS_XSELL' doesn't exist

select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, products_price from TABLE_PRODUCTS_XSELL xp, products p, products_description pd where xp.products_id = '510' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = '1' order by xp.products_id asc limit 6

[TEP STOP]

and

1146 - Table 'dixiemm_shop.TABLE_COUNTER' doesn't exist

select startdate, counter from TABLE_COUNTER

[TEP STOP]

MUCH AND MANY THANKS in advance.
Phil

[peteyg]

Did you happen to upgrade to the OSCmax version of oscommerce from the actual OScommerce version? Or did you just do a clean install of the OSCmax?

[04JeepTJ]

Thanks for the reply!

I started with fresh OS MAX 1.5. It was in opinion better than going with OSC MS2.2.

Thanks again.
Phil

[peteyg]

hmmm interesting....because the error is saying that the tables do not exist in your database structure which is odd if you did a fresh install. Are the products showing up?

[jonthewebb]

actually the error is not saying that.... it is saying there is no table named TABLE_COUNTER. it means there are some definitions missing in includes/database_tables.php, ie TABLE_PRODUCTS_XSELL and TABLE_COUNTER

eg:

define('TABLE_COUNTER', 'counter');



jon

[peteyg]

this is the code from xsell_products.php page
if ($HTTP_GET_VARS['products_id']) {
$xsell_query = tep_db_query("select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, products_price from " . TABLE_PRODUCTS_XSELL . " xp, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where xp.products_id = '" . $HTTP_GET_VARS['products_id'] . "' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_status = '1' order by xp.products_id asc limit " . MAX_DISPLAY_ALSO_PURCHASED);
$num_products_xsell = tep_db_num_rows($xsell_query);
So im thinking it could be code as a possibility, maybe the configuration of his database in the config file.

[jonthewebb]

The error is that the words "TABLE_PRODUCTS_XSELL" and "TABLE_COUNTER" are not defined in includes/database_tables.php.

The code you posted above includes these two constants as part of the query. When they are defined correctly, PHP understands "TABLE_PRODUCTS_XSELL" as being "products_xsell" which is the table name. When it is not defined, as in this case, it takes the literal value TABLE_PRODUCTS_XSELL which is not the actual name of the table!

So to fix it you need to go to includes/database_tables.php and add two entries for the missing tables. Also check for more missing entries. Or, incorrectly spelt entries.


jon

[04JeepTJ]

Thanks guys... I will try to do as you say. While I am a database programmer I am not a php programmer and it is little strange for me to follow. I have manged to get the site customized and working well until this happend.

I was thinking. I have a backup of before I did the upgrade to 1.7 but my client has already entered several products in the table db. If I were to restore, what tables have been touched by the addition of new products, categories, descriptions, etc.

Once that is done, we can investigate why I get the login screen when I click on the transactions or send test IPN links under Paypal IPN. Which is what the problem was in the first place. I should have known better than to try the upgrade. I know from experience, that trying to fix problems by upgrading usually results in upgraded problems. Thanks again folks for your help.

I have really been banging my head against this. Atleast a month before I posted here for help.

THANKS!!!

[kindred1]

Hello,I just clean installed MS2 on 2 seperate domains and Im also getting the error you mentioned:

"I get the login screen when I click on the transactions or send test IPN links under Paypal IPN."

It seems on non-SSL admin it works,but with SSL enabled in the admin area,it keeps going to the login screen.

I am on a shared SSL,so i changed the admin/includes/configure.php line:

define('HTTP_SERVER', 'http://mysite.com');

to 

define('HTTP_SERVER', 'https://rs124.mysecurehost.com/~myusername' );

and the Paypal IPN doesnt work.

Is that the correct way I should list the secure ssl url,or is it off?

[michael_s]

kindred1, most likely a cookie path / sessions issue. Try storing sessions in the database. That may solve the problem.