I tried moving my install of ospos from my old computer to a new computer, and I get an error whenever I try to run a report:
Error Number: 1044
Accès refusé pour l'utilisateur: 'ospos'@'@localhost'. Base 'ospos'
CREATE TEMPORARY TABLE ospos_sales_items_temp (SELECT date(sale_time) as sale_date, ospos_sales_items.sale_id, comment,payment_type, customer_id, employee_id, ospos_items.item_id, supplier_id, quantity_purchased, item_cost_price, item_unit_price, SUM(percent) as item_tax_percent, discount_percent, (item_unit_pricequantity_purchased-item_unit_pricequantity_purchaseddiscount_percent/100) as subtotal, ospos_sales_items.line as line, serialnumber, ospos_sales_items.description as description, ROUND((item_unit_pricequantity_purchased-item_unit_pricequantity_purchaseddiscount_percent/100)(1+(SUM(percent)/100)),2) as total, ROUND((item_unit_pricequantity_purchased-item_unit_pricequantity_purchaseddiscount_percent/100)(SUM(percent)/100),2) as tax, (item_unit_pricequantity_purchased-item_unit_pricequantity_purchaseddiscount_percent/100) - (item_cost_price*quantity_purchased) as profit FROM ospos_sales_items INNER JOIN ospos_sales ON ospos_sales_items.sale_id=ospos_sales.sale_id INNER JOIN ospos_items ON ospos_sales_items.item_id=ospos_items.item_id LEFT OUTER JOIN ospos_suppliers ON ospos_items.supplier_id=ospos_suppliers.person_id LEFT OUTER JOIN ospos_sales_items_taxes ON ospos_sales_items.sale_id=ospos_sales_items_taxes.sale_id and ospos_sales_items.item_id=ospos_sales_items_taxes.item_id and ospos_sales_items.line=ospos_sales_items_taxes.line GROUP BY sale_id, item_id, line)
Filename: C:\wamp\www\system\database\DB_driver.php
Line Number: 330
