problem in product section

Resolved problem in product section

Issue

Amr
Product Sale and Cost Price
Tuesday, November 01 2022, 07:55 AM
Subscribe via email

after i setup the product i got this problem when i click in products section
Notice: Undefined index: cost_price in /home/jofast/storage/modification/admin/controller/catalog/product.php on line 375Notice: Undefined index: profit_amount in /home/jofast/storage/modification/admin/controller/catalog/product.php on line 376Notice: Undefined index: profit_percentage in /home/jofast/storage/modification/admin/controller/catalog/product.php on line 377Notice: Undefined index: cost_price in /home/jofast/storage/modification/admin/controller/catalog/product.php on line 375Notice: Undefined index: profit_amount in /home/jofast/storage/modification/admin/controller/catalog/product.php on line 376Notice: Undefined index: profit_percentage in /home/jofast/storage/modification/admin/controller/catalog/product.php on line 377

when i try to edit a product i get a white page when i click on save button

Comment

There are no comments made yet.

Add Comment

Accepted Answer

Dennis Buijs Accepted Answer

Votes

Hi

Issue solved. This is a small bug in OC 3.0.3.7 in the database connection, file system/library/db/mysqli.php at line 15.
Is
$this->connection->query("SET SESSION sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION'"

;
Must be
$this->connection->query("SET SESSION sql_mode = 'NO_ZERO_IN_DATE,NO_ENGINE_SUBSTITUTION'"

;

I have change it and now all needed cost_price field are available.
If you would look at this file in OC 3.0.3.8 you we see the correct code, so in 3.0.3.8 it is fixed in OpenCart.

Best regards
Dennis

Comment

There are no comments made yet.

Add Comment

Responses (3)

Dennis Buijs Accepted Answer

Votes

Hi

Sorry to hear that, that is not how it should be.
Can you add in the tab 'Site Details' the login of you website, I will fix it straight away.

Best regards
Dennis

Comment

There are no comments made yet.

Add Comment