Post by i2Paq » Tue Feb 28, 2012 1:04 am

In addition to: OpenCart 1.5.2 Testers Wanted

In: catalog\language\english\english.php

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

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

UPGRADE to 2.x: Contemplate before thou begins!

Our FREE search: Find your answer FAST!.

BUGs?: Known BUGS for All OC Versions.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by i2Paq » Tue Feb 28, 2012 2:02 am

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

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

UPGRADE to 2.x: Contemplate before thou begins!

Our FREE search: Find your answer FAST!.

BUGs?: Known BUGS for All OC Versions.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by Daniel » Tue Feb 28, 2012 2:20 am

button problem fixed.looking at the order problem now.

OpenCart®
Project Owner & Developer.
OpenCart commercial support now available!


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by Daniel » Tue Feb 28, 2012 2:49 am

ok order problem fixed please redownload.

OpenCart®
Project Owner & Developer.
OpenCart commercial support now available!


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by Qphoria » Tue Feb 28, 2012 2:53 am

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"

OpenCart 2.0.x Mod Update Info

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by Qphoria » Tue Feb 28, 2012 3:31 am

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

OpenCart 2.0.x Mod Update Info

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by i2Paq » Tue Feb 28, 2012 3:46 am

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

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

UPGRADE to 2.x: Contemplate before thou begins!

Our FREE search: Find your answer FAST!.

BUGs?: Known BUGS for All OC Versions.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by JAY6390 » Tue Feb 28, 2012 6:22 am

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)

ImageImageImage

SEO MEGA KIT PLUS - Get your site ranking higher in the search engines
Better Product SEO URL's - Perfectly structured product links
SEO URL's Route Editor PRO - Make ANY url on your site have clean keywords - even third party extensions (remove index.php)


Image


User avatar
Newbie

Posts

Joined
Wed May 26, 2010 11:47 pm
Location - United Kingdom

Post by JAY6390 » Tue Feb 28, 2012 6:31 am

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

ImageImageImage

SEO MEGA KIT PLUS - Get your site ranking higher in the search engines
Better Product SEO URL's - Perfectly structured product links
SEO URL's Route Editor PRO - Make ANY url on your site have clean keywords - even third party extensions (remove index.php)


Image


User avatar
Newbie

Posts

Joined
Wed May 26, 2010 11:47 pm
Location - United Kingdom

Post by Ulf » Tue Feb 28, 2012 7:45 am

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']);

Ulf
Newbie

Posts

Joined
Sat Oct 16, 2010 4:41 pm

Post by Daniel » Tue Feb 28, 2012 7:54 am

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.

OpenCart®
Project Owner & Developer.
OpenCart commercial support now available!


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

User avatar
Newbie

Posts

Joined
Fri Nov 27, 2009 3:40 pm
Location - Bangkok - Thailand

Post by Daniel » Tue Feb 28, 2012 4:08 pm

ok just fixed the colorbox issue.

OpenCart®
Project Owner & Developer.
OpenCart commercial support now available!


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by bigboss » Wed Feb 29, 2012 9: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.

Newbie

Posts

Joined
Sun Jul 25, 2010 10:35 am

Post by Ebenezer18 » Wed Feb 29, 2012 9:54 am

Imagelooking at the order problem now.

Newbie

Posts

Joined
Sun Feb 26, 2012 2:39 pm

Post by Qphoria » Wed Feb 29, 2012 10:00 am

bigboss wrote:-upgrade script has sql error.
ok i'll take a look

OpenCart 2.0.x Mod Update Info

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by amdev » Wed Feb 29, 2012 11: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.

ร้านค้าออนไลน์
OpenCart Thailand Support Forum
How to Upgrade oc1.5 to 2.0.1.1
Upgrading OpenCart From v.1.4 or v.1.5 to V.2.2 Step by step


User avatar
Newbie

Posts

Joined
Fri Nov 27, 2009 3:40 pm
Location - Bangkok - Thailand

Post by Daniel » Wed Feb 29, 2012 12:29 pm

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.

OpenCart®
Project Owner & Developer.
OpenCart commercial support now available!


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by Killerj » Wed Feb 29, 2012 1:07 pm

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.

Newbie

Posts

Joined
Wed Nov 04, 2009 10:04 am

Post by amdev » Wed Feb 29, 2012 1:40 pm

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.

ร้านค้าออนไลน์
OpenCart Thailand Support Forum
How to Upgrade oc1.5 to 2.0.1.1
Upgrading OpenCart From v.1.4 or v.1.5 to V.2.2 Step by step


User avatar
Newbie

Posts

Joined
Fri Nov 27, 2009 3:40 pm
Location - Bangkok - Thailand
Who is online

Users browsing this forum: No registered users and 4 guests