lbf wrote:Have the problems been solved yet?Daniel wrote:next version maybe 1.5.1.1
I'm looking forward to 1.5.1.1
you can look on the svn there is a css fix.
http://code.google.com/p/opencart/source/detail?r=493
lbf wrote:Have the problems been solved yet?Daniel wrote:next version maybe 1.5.1.1
I'm looking forward to 1.5.1.1
OpenCart®
Project Owner & Developer.
Quick way to check is to copy the product add to cart link and see if its including an affiliate id on the end.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
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.SXGuy wrote:Quick way to check is to copy the product add to cart link and see if its including an affiliate id on the end.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
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.
That is pretty much how all affiliate systems work. The affiliate gets credit for all sales till the cookies expires.Xellz wrote: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.SXGuy wrote:Quick way to check is to copy the product add to cart link and see if its including an affiliate id on the end.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
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.
Only after deleting tracking cookie commission is absent from order.
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
Thanks, now this clarifies everything.Xsecrets wrote: That is pretty much how all affiliate systems work. The affiliate gets credit for all sales till the cookies expires.
Did you rename you htaccess.txt to .htaccess ??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
OpenCart®
Project Owner & Developer.
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??
OpenCart®
Project Owner & Developer.
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.
Code: Select all
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;
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!
According to the error though it is looking for the "subtract" field in the order_product table. I ran into the same problem when trying to migrate but I just edited the backup.sql file and removed that data by hand.fido-x wrote:The "subtract" field is in the product table, not the order_product table.
Code: Select all
$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'] . "'");
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!
As you can see, there is no "subtract" in the query.$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'] . "'");
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!
Users browsing this forum: No registered users and 83 guests