My website URL is:http://watania.rf.gd/inventory/public/reports/detailed_receivings/2019-03-09/2019-03-09/all/all/0
**What I’m seeing is: A Database Error Occurred
Error Number: 1044
Access denied for user ‘epiz_*'@‘192.168.%’ to database 'epiz__stock’
CREATE TEMPORARY TABLE IF NOT EXISTS ospos_receivings_items_temp (INDEX(receiving_date), INDEX(receiving_time), INDEX(receiving_id)) ( SELECT MAX(DATE(receiving_time)) AS receiving_date, MAX(receiving_time) AS receiving_time, receivings_items.receiving_id, MAX(comment) AS comment, MAX(item_location) AS item_location, MAX(reference) AS reference, MAX(payment_type) AS payment_type, MAX(employee_id) AS employee_id, items.item_id, MAX(receivings.supplier_id) AS supplier_id, MAX(quantity_purchased) AS quantity_purchased, MAX(receivings_items.receiving_quantity) AS receiving_quantity, MAX(item_cost_price) AS item_cost_price, MAX(item_unit_price) AS item_unit_price, MAX(discount) AS discount, discount_type as discount_type, receivings_items.line, MAX(serialnumber) AS serialnumber, MAX(receivings_items.description) AS description, MAX(CASE WHEN receivings_items.discount_type = 0 THEN item_unit_price * quantity_purchased * receivings_items.receiving_quantity - item_unit_price * quantity_purchased * receivings_items.receiving_quantity * discount / 100 ELSE item_unit_price * quantity_purchased * receivings_items.receiving_quantity - discount END) AS subtotal, MAX(CASE WHEN receivings_items.discount_type = 0 THEN item_unit_price * quantity_purchased * receivings_items.receiving_quantity - item_unit_price * quantity_purchased * receivings_items.receiving_quantity * discount / 100 ELSE item_unit_price * quantity_purchased * receivings_items.receiving_quantity - discount END) AS total, MAX((CASE WHEN receivings_items.discount_type = 0 THEN item_unit_price * quantity_purchased * receivings_items.receiving_quantity - item_unit_price * quantity_purchased * receivings_items.receiving_quantity * discount / 100 ELSE item_unit_price * quantity_purchased * receivings_items.receiving_quantity - discount END) - (item_cost_price * quantity_purchased)) AS profit, MAX(item_cost_price * quantity_purchased * receivings_items.receiving_quantity ) AS cost FROM ospos_receivings_items AS receivings_items INNER JOIN ospos_receivings AS receivings ON receivings_items.receiving_id = receivings.receiving_id INNER JOIN ospos_items AS items ON receivings_items.item_id = items.item_id WHERE DATE(receiving_time) BETWEEN ‘2019-03-09’ AND ‘2019-03-09’ GROUP BY receivings_items.receiving_id, items.item_id, receivings_items.line )
Filename: models/Receiving.php
Line Number: 287
I’m using this software:
Additional information: