Two couple of -hopefully- simple problems

[gmantzar]

I am trying to get my version of OS Commerce stable before making any more changes but have two issues. :oops: Any help appreciated...

 

a) FROM THE ADMIN:

When I check the ORDERS sub menu I get:

--------

1146 - Table 'moni_shop.TABLE_ORDERS_TOTAL' doesn't exist

select count(*) as total from orders o left join TABLE_ORDERS_TOTAL ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and s.orders_status_id = '1' and ot.class = 'ot_total'

---------

I know I have a table called ORDERS_TOTAL. (not TABLE_ORDERS_TOTAL). Is the ORDERS_TOTAL what it is looking for?

In any case, I was looking for the list of standard tables (as it was not me who installed the shop in the first instance) but could not find it. So.. does the problem ring any bells and anyone has the link with the list of tables (I did look in the support site but could not find it so please help)

 

B) The other problem is in the banner manager. When I select it I get:

 

Fatal error: Cannot redeclare html_graph() (previously declared in /usr/local/psa/home/vhosts/monastiri.com/httpdocs/admin/includes/functions/html_graphs.php:18) in /usr/local/psa/home/vhosts/monastiri.com/httpdocs/admin/includes/functions/html_graphs.php on line 18

 

But if you notice the file and line is the same... Any hints?

 

Thank you in advance,

 

Gregory.