Multi-store -> 1054 Sql Error In Admin

[brahms2]

Hi everyone,

 

Just manage to install the Multi-Store contribution which seems pretty cool...

I succeeded to do successful transactions from both stores... I can see them in the database.

Yet in admin I have these 2 problems....

 

If anyone has any idea how to get around this problem in Admin, when I click on Orders:

 

1054 - Unknown column 'o.orders_id' in 'on clause'

 

select distinct o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total, st.stores_name from orders o left join orders_total ot on (o.orders_id = ot.orders_id), stores st, orders_status s inner join orders_products op on (o.orders_id = op.orders_id) where o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' and o.orders_stores_id = st.stores_id and ( (o.orders_stores_id in(2,1)) OR (op.products_distributors_id = '0') ) group by o.orders_id order by o.orders_id DESC

 

 

Also I am getting a similar one when clicking on Catalog:

 

1054 - Unknown column 'c.categories_id' in 'on clause'

 

select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd LEFT JOIN categories_to_stores c2s ON c.categories_id = c2s.categories_id where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '0' and c2s.stores_id in(2,1) order by c.sort_order, cd.categories_name

 

 

Many thanks in advance for any suggestion...

 

Theodore :'(

[satish]

it has some additional contribs that take care of mysql five compatability.

 

Chek and use those fixes.

 

Satish

[brahms2]

Thanks Satish for the suggestion.

Will check this out!!!

Best

Theo

 

it has some additional contribs that take care of mysql five compatability.

 

Chek and use those fixes.

 

Satish