Error after installing and clicking member account

[xseption]

I updated the osc version using previous version's databases. I had a trial customer try to log in and she got this:

 

When i tried to access my account this appeared.

 

1054 - Unknown column 's.public_flag' in 'where clause'

 

select count(*) as total from orders o, orders_status s where o.customers_id = '62' and o.orders_status = s.orders_status_id and s.language_id = '1' and s.public_flag = '1'

 

[TEP STOP]

 

I have seen many posts in this forum about this error but not mine:

1054 - Unknown column 'p.products_id' in 'on clause'

 

It's a different 1054 error -- Can some one help?

 

Thanks!

 

~ edd

[FIMBLE]

I updated the osc version using previous version's databases. I had a trial customer try to log in and she got this:

 

 

 

I have seen many posts in this forum about this error but not mine:

 

 

It's a different 1054 error -- Can some one help?

 

Thanks!

 

~ edd

 

 

Hiya

download the attached file to your database with phpmyadmin or similar will be ok after

Nic

[xseption]

Hiya

download the attached file to your database with phpmyadmin or similar will be ok after

Nic

 

thanks! I will give it a try!

 

~ edd

[FIMBLE]

thanks! I will give it a try!

 

~ edd

 

Hello,

Here it is

 

 

alter table orders_status add public_flag int DEFAULT '1';

alter table orders_status add downloads_flag int DEFAULT '0';

 

 

 

Nic

[xseption]

Hello,

Here it is

 

alter table orders_status add public_flag int DEFAULT '1';

alter table orders_status add downloads_flag int DEFAULT '0';

 

Nic

Done!

 

Now I get the other 1054 error :

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select count(p.products_id) as total from products_description pd, products p left

join manufacturers m on p.manufacturers_id = m.manufacturers_id,

products_to_categories p2c left join specials s on p.products_id =

s.products_id where p.products_status = '1' and p.products_id =

p2c.products_id and pd.products_id = p2c.products_id and pd.language_id =

'1' and p2c.categories_id = '33'

 

A solution?

 

Thanks!

 

~ edd

[FIMBLE]

Hiya,

Use this

 

http://www.oscommerce.com/community/contributions,4654

 

Regards

Nic

[xseption]

Hiya,

Use this

 

http://www.oscommerce.com/community/contributions,4654

 

Regards

Nic

I looked at that but it says to replace code that does not match the code I have. I have not altered any code whatsoever, yet it does not match. For example, to match the code in advanced_search_result.php

 

It says to look for:

$from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c";

 

But all I find is this:

$from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id";

 

Can you help?

 

~ edd

[FIMBLE]

I do not have that line in mine either, you still getting the error, Index.php should be ok now, or is it?

[FIMBLE]

Try looking in this one

 

http://www.oscommerce.com/forums/index.php?showtopic=230304

 

There are a few suggestions you could try

[xseption]

Try looking in this one

 

http://www.oscommerce.com/forums/index.php?showtopic=230304

 

There are a few suggestions you could try

 

I will check it out, but yes I have type of problem with my index.php file inthat what I am supposed to replace is not "exactly" in my file.

 

thanks!

 

~ edd