Access denied for user 'epiz_**********'@'192.168.%' to database 'epiz_********_stock'

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:

Use phpmyadmin and make query thwre

The reason you see this error is because your user doesn’t have permissions to use CREATE TEMPORARY TABLE. This is by design, because free hosting websites do not have the ability to create temporary database tables.

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.