Nope, sorry.alex1 wrote:Thanks. Is there a list of 1.5.2 new features we can take a look at?i2Paq wrote: From what I see it will take another 2 weeks to get 1.5.2 finished. Then it needs a test-run to get the bugs out and hopefully we get a "stable" 1.5.2.1 release a week or 2 after the test-run.
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
I have a problem with the category module, i'm using the latest version of OpenCart.
There are three levels of categories and some are working and others not.
Level 1: domain.com/index.php?route=product/category&path=69
Working great
Level 2: domain.com/index.php?route=product/category&path=69_59
not working, SQL Error
Code: Select all
Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
Error No: 1064
SELECT COUNT(*) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM product_to_category p2c WHERE ) in /home/user/domains/domain.com/public_html/system/database/mysql.php on line 49
Working great
Can someone give advice what to do?
This doesn't happen on a standard install, something like this would have been picked up earlier if it was - have you modified your cart at all?frankspin wrote:Hello Guys,
I have a problem with the category module, i'm using the latest version of OpenCart.
There are three levels of categories and some are working and others not.
Level 1: domain.com/index.php?route=product/category&path=69
Working great
Level 2: domain.com/index.php?route=product/category&path=69_59
not working, SQL Error
Level 3: domain.com/index.php?route=product/category&path=69_59_60Code: Select all
Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 Error No: 1064 SELECT COUNT(*) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM product_to_category p2c WHERE ) in /home/user/domains/domain.com/public_html/system/database/mysql.php on line 49
Working great
Can someone give advice what to do?
I love opencart... You set up your shop, make it work and instead of bugfix release you get totally new version with more crawling bugs to catch. And when you think you have caught all of the bugs, new version comes and you have to start over Do you try to keep people busy testing code instead of making sales?i2Paq wrote:robster wrote:The SVN has all the bug-fixes for the current official 1.5.1.3 zip. The problem is that the SVN also contains new and unfinished code, so it is useless.
The bugs found in the 1.5.1.3 zip download are only updated in the SVN.
Please be so kind and release bug free version 1.5.1.4 before moving to 1.5.2.
There is an agreement that 1.5.2 will be released and then there will be 1.5.2.1 which should fix ALL the bugs found in 1.5.2.Simplicity wrote:I love opencart... You set up your shop, make it work and instead of bugfix release you get totally new version with more crawling bugs to catch. And when you think you have caught all of the bugs, new version comes and you have to start over Do you try to keep people busy testing code instead of making sales?
Please be so kind and release bug free version 1.5.1.4 before moving to 1.5.2.
That said, don't hold your breathe......
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
At some point I will need to surf through SVN and pick at least some fixes while avoiding code with new experimental functions.
admin/model/catalog/product.php:
Code: Select all
$product_data = $this->cache->get('product.' . (int)$this->config->get('config_language_id'));
if (!$product_data) {
$product_data = ......;
$this->cache->set('product.' . (int)$this->config->get('config_language_id'), $product_data);
}
Code: Select all
$product_data = $this->cache->get('product.' . (int)$this->config->get('config_language_id') . '.' . (int)$this->config->get('config_store_id') . '.' . (int)$customer_group_id . '.' . $cache);
if (!$product_data) {
$product_data = .......;
$this->cache->set('product.' . (int)$this->config->get('config_language_id') . '.' . (int)$this->config->get('config_store_id') . '.' . (int)$customer_group_id . '.' . $cache, $product_data);
}
I suggest this bugfix:
admin/model/catalog/product.php:
Code: Select all
$product_data = $this->cache->get('admin_product.' . (int)$this->config->get('config_language_id'));
if (!$product_data) {
$product_data = ......;
$this->cache->set('admin_product.' . (int)$this->config->get('config_language_id'), $product_data);
}
Attachments
VQmod XML file with bugfix for product query cache
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I've looked (echo $reply) and got this:Daniel wrote:i'll look into this.adwordsvouchersshop wrote:I also saw this errors when i access the index.php?route=checkout/confirm of any store, including demo.opencart.com.
Have a look: http://demo.opencart.com/index.php?rout ... ut/confirm. I also get them on my store.
Code: Select all
Notice: Undefined variable: payment_address in /home/opencart/public_html/demo/catalog/controller/checkout/confirm.php on line 120Notice: Undefined variable: payment_address in /home/opencart/public_html/demo/catalog/controller/checkout/confirm.php on line 121Notice: Undefined variable: payment_address in /home/opencart/public_html/demo/catalog/controller/checkout/confirm.php on line 122Notice: Undefined variable: payment_address in /home/opencart/public_html/demo/catalog/controller/checkout/confirm.php on line 123Notice: Undefined variable: payment_address in /home/opencart/public_html/demo/catalog/controller/checkout/confirm.php on line 124Notice: Undefined variable: payment_address in /home/opencart/public_html/demo/catalog/controller/checkout/confirm.php on line 125Notice: Undefined variable: payment_address in /home/opencart/public_html/demo/catalog/controller/checkout/confirm.php on line 126Notice: Undefined variable: payment_address in /home/opencart/public_html/demo/catalog/controller/checkout/confirm.php on line 127Notice: Undefined variable: payment_address in /home/opencart/public_html/demo/catalog/controller/checkout/confirm.php on line 128Notice: Undefined variable: payment_address in /home/opencart/public_html/demo/catalog/controller/checkout/confirm.php on line 129Notice: Undefined variable: payment_address in /home/opencart/public_html/demo/catalog/controller/checkout/confirm.php on line 130Notice: Undefined variable: payment_address in /home/opencart/public_html/demo/catalog/controller/checkout/confirm.php on line 131Notice: Undefined variable: payment_address in /home/opencart/public_html/demo/catalog/controller/checkout/confirm.php on line 185Notice: Undefined variable: payment_address in /home/opencart/public_html/demo/catalog/controller/checkout/confirm.php on line 185Notice: Undefined index: comment in /home/opencart/public_html/demo/catalog/controller/checkout/confirm.php on line 259Notice: Undefined index: customer_id in /home/opencart/public_html/demo/catalog/model/checkout/order.php on line 4Notice: Undefined index: customer_group_id in /home/opencart/public_html/demo/catalog/model/checkout/order.php on line 4Notice: Undefined index: firstname in /home/opencart/public_html/demo/catalog/model/checkout/order.php on line 4Notice: Undefined index: lastname in /home/opencart/public_html/demo/catalog/model/checkout/order.php on line 4Notice: Undefined index: email in /home/opencart/public_html/demo/catalog/model/checkout/order.php on line 4Notice: Undefined index: telephone in /home/opencart/public_html/demo/catalog/model/checkout/order.php on line 4Notice: Undefined index: fax in /home/opencart/public_html/demo/catalog/model/checkout/order.php on line 4Notice: Undefined index: payment_method in /home/opencart/public_html/demo/catalog/controller/checkout/confirm.php on line 358Error: Could not load controller payment/!
Code: Select all
552 Blocked, unknown email address in envelope-sender or From header. http://somehost.com/?from=gusto@mailinator.com&sender=gusto@mailinator.com Notice: Error: DATA not accepted from server! in /.../web/system/library/mail.php on line 389
I've used the contact form which ended wit this error. It is possible, that all the guys are runnig into it.
Perhaps it would be better to have a normal error message display instead of notification?
Kind Regards, SelfMan
In method getCustomers it should include the missing sort data for the 'c.approved' field:
Code: Select all
public function getCustomers($data = array()) {
......
$sort_data = array(
'name',
'c.email',
'customer_group',
'c.status',
'c.approved',
'c.ip',
'c.date_added'
);
......
}
In method getTotalCustomers it should include the missing 'filter_ip':
Code: Select all
public function getTotalCustomers($data = array()) {
.....
if (isset($data['filter_ip']) && !is_null($data['filter_ip'])) {
$implode[] = "customer_id IN (SELECT customer_id FROM " . DB_PREFIX . "customer_ip WHERE ip = '" . $this->db->escape($data['filter_ip']) . "')";
}
.....
}
Attachments
Bug fixes for admin/model/sale/customer.php
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Not a bug. If the product requires shipping and no shipping method is enabled, you can't proceed through the checkout. Therefore, the system does do a check.OpenCart plugins wrote:If you disable shipping for a product that belongs to a tax class that has taxes based on shipping opencart adds the tax to the cost of the product. So it should check that whether shipping is allowed or not for the product before adding taxes based on shipping.
If the product belongs to a tax class (regardless of whether it requires shipping or not), then tax will be added. If you don't want a "shipping tax" applied to a product that doesn't require shipping, don't allocate the tax class that is intended for your shipping method to the product. Create a new tax class for those products.
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!
supplyer tels me that it is problem in opencart not in his module... can you help ?
2011-12-02 13:37:23 - PHP Notice: Error: Could not load library json! in /domains/najceneje.eu/public_html/system/engine/loader.php on line 23
Thnx!
Opencart 1.5.1.3 does not use the old system/library/json.php anymore, just the standard PHP json_encode and json_decode functions. What payment module are you using? Looks like your payment module hasn't been upgraded to 1.5.1.3.romeo2k wrote:I get this error with payment module...
supplyer tels me that it is problem in opencart not in his module... can you help ?
2011-12-02 13:37:23 - PHP Notice: Error: Could not load library json! in /domains/najceneje.eu/public_html/system/engine/loader.php on line 23
Thnx!
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
i'am using some lovenian Bankart module from spletnisistemi.si... they told me they upgrade, i have some problems wiht title allredy.... code used in 1.4.x... so i just want to have conformation that it is the module error not my stores couse i made some costumization allredy but others payment modules works (paypal, mooneybookers...)
Thnx
Yet if a product belongs to a tax class which has taxes based on payment address the tax is not automatically added. It's only included when the buyer enters his address AND his address is within the geographical region where the tax is supposed to be applied. So why are shipping taxes on non-shipping products applied by default when payment address based taxes aren't? It is a bug.fido-x wrote:Not a bug. If the product requires shipping and no shipping method is enabled, you can't proceed through the checkout. Therefore, the system does do a check.OpenCart plugins wrote:If you disable shipping for a product that belongs to a tax class that has taxes based on shipping opencart adds the tax to the cost of the product. So it should check that whether shipping is allowed or not for the product before adding taxes based on shipping.
If the product belongs to a tax class (regardless of whether it requires shipping or not), then tax will be added.
JNeuhoff wrote:There are 2 bugs in the admin/model/sale/customer.php:
In method getCustomers it should include the missing sort data for the 'c.approved' field:
Code: Select all
public function getCustomers($data = array()) { ...... $sort_data = array( 'name', 'c.email', 'customer_group', 'c.status', 'c.approved', 'c.ip', 'c.date_added' ); ...... }
In method getTotalCustomers it should include the missing 'filter_ip':
Code: Select all
public function getTotalCustomers($data = array()) { ..... if (isset($data['filter_ip']) && !is_null($data['filter_ip'])) { $implode[] = "customer_id IN (SELECT customer_id FROM " . DB_PREFIX . "customer_ip WHERE ip = '" . $this->db->escape($data['filter_ip']) . "')"; } ..... }
ok done.
OpenCart®
Project Owner & Developer.
Users browsing this forum: No registered users and 40 guests