OpenCart 1.5.1 Bug Thread

lbf wrote:

Daniel wrote:next version maybe 1.5.1.1

Have the problems been solved yet?

I'm looking forward to 1.5.1.1

Xellz wrote:Is it a bug or a feature?

After completed order with affiliate code and one successful commission all next orders also receive commission. As i understand, it should work only for one order unless person clicks an affiliate link again.

Tried on FF5.0

SXGuy wrote:

Xellz wrote:Is it a bug or a feature?

After completed order with affiliate code and one successful commission all next orders also receive commission. As i understand, it should work only for one order unless person clicks an affiliate link again.

Tried on FF5.0

Quick way to check is to copy the product add to cart link and see if its including an affiliate id on the end.

Also, make sure you are not trying to checkout with the same details as the affiliate account you created.
I know it sounds silly, but some people test accounts using the same details and it can mess things up.

Xellz wrote:

SXGuy wrote:

Xellz wrote:Is it a bug or a feature?

After completed order with affiliate code and one successful commission all next orders also receive commission. As i understand, it should work only for one order unless person clicks an affiliate link again.

Tried on FF5.0

Quick way to check is to copy the product add to cart link and see if its including an affiliate id on the end.

Also, make sure you are not trying to checkout with the same details as the affiliate account you created.
I know it sounds silly, but some people test accounts using the same details and it can mess things up.

I deleted all cookies from opencart, entered url with affiliate code, registered new account with unique information and completed order. Just in case restarted browser, logged in with previously created user and completed one more order. Both orders had affiliate commission. Sorry, don't get how i can copy 'add to cart' link from product page, can't save link or copy it to clipboard At least url in browser doesn't include any tracking codes.

Only after deleting tracking cookie commission is absent from order.

Xsecrets wrote: That is pretty much how all affiliate systems work. The affiliate gets credit for all sales till the cookies expires.

bo4man wrote:I have problems with "Use SEO URL's"

I installed fresh version of opencart 1.5.1 before that i not had any problems with SEO URL's (i mean old versions of opencart).... so the problem is not from my hosting company i guess ?

See this:
http://mmashop.bg/desktops

Regards !

Blnukem wrote:Did a fresh install today on Linux server got error:

Notice: Undefined index: Tables_in_DomainName in /home/folder/public_html/DomainName.com/admin/model/tool/backup.php on line 22

in System -> Backup Restore

crazypetfood wrote:I have just uploaded the new version 1.5.1.0 to my site and used the standard setup including db.

If i recall Daniel said to export the 1.5.0.5 db and import it (sorry if i got this wrong)

I get the following errors:

Error: Unknown column 'subtract' in 'field list'
Error No: 1054
INSERT INTO `oc_order_product` (`order_product_id`, `order_id`, `product_id`, `name`, `model`, `price`, `total`, `tax`, `quantity`, `subtract`) VALUES ('21', '12', '119', 'Autarky Adult 15Kg ', 'Single', '18.8700', '37.7400', '0.0000', '2', '0')

when using the admin restore

or when using my hostign sql import

Error

SQL query:

INSERT INTO `oc_order_product` ( `order_product_id` , `order_id` , `product_id` , `name` , `model` , `price` , `total` , `tax` , `quantity` , `subtract` )
VALUES (
'21', '12', '119', 'Autarky Adult 15Kg ', 'Single', '18.8700', '37.7400', '0.0000', '2', '0'
);

MySQL said: Documentation
#1054 - Unknown column 'subtract' in 'field list'

I also get errors for manufacturer, measurement_class and other fields, i tried unticking and backing them up in admin and restoring them, still loads of sql errors..... Do you already know about this??

whats your db prefix?

Daniel wrote:

crazypetfood wrote:I have just uploaded the new version 1.5.1.0 to my site and used the standard setup including db.

If i recall Daniel said to export the 1.5.0.5 db and import it (sorry if i got this wrong)

I get the following errors:

Error: Unknown column 'subtract' in 'field list'
Error No: 1054
INSERT INTO `oc_order_product` (`order_product_id`, `order_id`, `product_id`, `name`, `model`, `price`, `total`, `tax`, `quantity`, `subtract`) VALUES ('21', '12', '119', 'Autarky Adult 15Kg ', 'Single', '18.8700', '37.7400', '0.0000', '2', '0')

when using the admin restore

or when using my hostign sql import

Error

SQL query:

INSERT INTO `oc_order_product` ( `order_product_id` , `order_id` , `product_id` , `name` , `model` , `price` , `total` , `tax` , `quantity` , `subtract` )
VALUES (
'21', '12', '119', 'Autarky Adult 15Kg ', 'Single', '18.8700', '37.7400', '0.0000', '2', '0'
);

MySQL said: Documentation
#1054 - Unknown column 'subtract' in 'field list'

I also get errors for manufacturer, measurement_class and other fields, i tried unticking and backing them up in admin and restoring them, still loads of sql errors..... Do you already know about this??

i have no idea how this has happened if your going from 1.5.0 > 1.5.1.

resave the settings in the admin but the subtract frield should still be there.

CREATE TABLE `oc_order_product` (
  `order_product_id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_bin NOT NULL,
  `model` varchar(24) COLLATE utf8_bin NOT NULL,
  `quantity` int(4) NOT NULL,
  `price` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `total` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `tax` decimal(15,4) NOT NULL DEFAULT '0.0000',
  PRIMARY KEY (`order_product_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

fido-x wrote:The "subtract" field is in the product table, not the order_product table.

$this->db->query("INSERT INTO " . DB_PREFIX . "order_product SET order_id = '" . (int)$order_id . "', product_id = '" . (int)$product['product_id'] . "', name = '" . $this->db->escape($product['name']) . "', model = '" . $this->db->escape($product['model']) . "', quantity = '" . (int)$product['quantity'] . "', price = '" . (float)$product['price'] . "', total = '" . (float)$product['total'] . "', tax = '" . (float)$product['tax'] . "'");