Community Forums

by **i2Paq** » Mon Feb 27, 2012 5:04 pm

In addition to: OpenCart 1.5.2 Testers Wanted

In: catalog\language\english\english.php

Twice found: $_['button_reorder'] = 'Reorder';

by **i2Paq** » Mon Feb 27, 2012 6:02 pm

Adding a product to an existing order gives:

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 'order SET firstname = 'Norman', lastname = 'in \'t Veldt', email = 'nintveldt@ho' at line 1 Error No: 1064 UPDATE order SET firstname = 'Norman', lastname = 'in \'t Veldt', email = '******@hotmail.com', telephone = '0224-', fax = '', shipping_firstname = 'Norman', shipping_lastname = 'in \'t Veldt', shipping_company = '', shipping_address_1 = 'Tlpnln 12', shipping_address_2 = '', shipping_city = 'Wnkl', shipping_postcode = '1731WC', shipping_country = 'Netherlands', shipping_country_id = '150', shipping_zone = 'Noord Holland', shipping_zone_id = '2336', shipping_address_format = '', shipping_method = 'Vaste verzendkosten per bestelling', shipping_code = 'flat.flat', payment_firstname = 'Norman', payment_lastname = 'in \'t Veldt', payment_company = '', payment_address_1 = 'Tlpnln 12', payment_address_2 = '', payment_city = 'Wnkl', payment_postcode = '1731WC', payment_country = 'Netherlands', payment_country_id = '150', payment_zone = 'Noord Holland', payment_zone_id = '2336', payment_address_format = '', payment_method = 'Onder rembours', payment_code = 'cod', comment = '', order_status_id = '1', affiliate_id = '0', date_modified = NOW() WHERE order_id = '1' in /var/www/vhosts/cupofcoffee.nl/subdomains/152/httpdocs/system/database/mysql.php on line 48

by **Daniel** » Mon Feb 27, 2012 6:20 pm

button problem fixed.looking at the order problem now.

by **Daniel** » Mon Feb 27, 2012 6:49 pm

ok order problem fixed please redownload.

by **Qphoria** » Mon Feb 27, 2012 6:53 pm

the new ip blacklist controller isn't checked for Top Admin by default in the users groups so it gets permission denied
Not really a big deal, but I'm sure we'll get 50 threads about "Permission Denied"

by **Qphoria** » Mon Feb 27, 2012 7:31 pm

The admin/config.php file is the one from your test setup, not empty.

by **i2Paq** » Mon Feb 27, 2012 7:46 pm

Qphoria wrote:The admin/config.php file is the one from your test setup, not empty.

Yep, I see.

by **JAY6390** » Mon Feb 27, 2012 10:22 pm

Lines 129 and 228 of
admin/model/sale/order.php
need the order table to have backticks around them also (and I've done a grep on all files, they're the only two)

by **JAY6390** » Mon Feb 27, 2012 10:31 pm

in fact, a quick regex replace can put backticks around every single table name throughout the files. (1055 replaces over 112 files). Includes LEFT JOINS etc. If you want a copy of the latest svn (861) with all of them, just give me a shout. takes two minutes using grep on regexbuddy

by **Ulf** » Mon Feb 27, 2012 11:45 pm

In products form mini cart total field be not updated after purchase unless I first press F5.

upload\catalog\view\theme\default\template\product\product.tpl
//$('#cart-total').html(json['total']);
should be
$('#mini-cart-total').html(json['total']);

by **Daniel** » Mon Feb 27, 2012 11:54 pm

Ulf wrote:In products form mini cart total field be not updated after purchase unless I first press F5.

upload\catalog\view\theme\default\template\product\product.tpl
//$('#cart-total').html(json['total']);
should be
$('#mini-cart-total').html(json['total']);

ok just fixed.

by **amdev** » Tue Feb 28, 2012 1:06 am

colorbox not work when checkout and new register.

Thanks for hardwork!!!

by **Daniel** » Tue Feb 28, 2012 8:08 am

ok just fixed the colorbox issue.

by **bigboss** » Wed Feb 29, 2012 1:18 am

-upgrade script has sql error.
-can't find order edit button in backend admin.
-noway to reduce the cash/credit (transaction) in the order total.
-can't retrieve payment and shipping options in create or edit order.

by **Ebenezer18** » Wed Feb 29, 2012 1:54 am

looking at the order problem now.

by **Qphoria** » Wed Feb 29, 2012 2:00 am

bigboss wrote:-upgrade script has sql error.

ok i'll take a look

by **amdev** » Wed Feb 29, 2012 3:48 am

Shopping Cart not update.
Add product to a cart and go to shopping cart page.
Click at mini cart of header and remove some product.
Product removed from mini cart but in a shopping cart page still have product.

Thanks.

by **Daniel** » Wed Feb 29, 2012 4:29 am

bigboss wrote:-can't find order edit button in backend admin.

you need to set the edit time int he settings.

bigboss wrote:-noway to reduce the cash/credit (transaction) in the order total.

neither is there a way in the front end.

bigboss wrote:-can't retrieve payment and shipping options in create or edit order.

you have to update the update totals first then choose a shipping or payment method.

by **Killerj** » Wed Feb 29, 2012 5:07 am

amdev wrote:Shopping Cart not update.
Add product to a cart and go to shopping cart page.
Click at mini cart of header and remove some product.
Product removed from mini cart but in a shopping cart page still have product.

Thanks.

I don't understand the problem. Even if it exists in the shopping cart page, You won't be able to check out. It would show the cart empty.

by **amdev** » Wed Feb 29, 2012 5:40 am

Killerj wrote:
amdev wrote:Shopping Cart not update.
Add product to a cart and go to shopping cart page.
Click at mini cart of header and remove some product.
Product removed from mini cart but in a shopping cart page still have product.

Thanks.

I don't understand the problem. Even if it exists in the shopping cart page, You won't be able to check out. It would show the cart empty.

Yes, but this page should be refresh or do something to clear cart content.