Page 1 of 13
Post any OpenCart 1.4.7 Bugs here!
Posted: Sun Apr 11, 2010 2:38 pm
by Qphoria
Please post any Bugs or Issues related to the OpenCart 1.4.7 released on 10 April 2010 here.
Confirmed bugs + fixes
Specials bug:
Fix
Terms & Conditions click error in thickbox:
Fix
If AJAX is turned off in a cart module: in the cart, after clicking continue shopping button you get "product not found".
Fix
Coupon not taking correct discount off:
Fix
Admin Country, Zone, and Download hard coded limit & pagination issues:
Fix
Options duplicate error:
Fix
Missing Shipping message at checkout:
Fix
2 different TAX-classes using the same state:
Fix
Low Ordering Fee module does not calculate the Tax on checkout:
Fix
Specials block and setting the quantity:
Fix
UPS Dom Element error
Fix
Re: Post any OpenCart 1.4.7 Bugs here!
Posted: Sun Apr 11, 2010 3:22 pm
by dramony
Hi Q,
I tried 1.4.7.
UPS Error:
Unknown: Object of class DOMElement could not be converted to string in C:\Program Files\xampp\htdocs\cart147\catalog\model\shipping\ups.php on line 218
Fatal error: Call to a member function getElementsByTagName() on a non-object in C:\Program Files\xampp\htdocs\cart147\catalog\model\shipping\ups.php on line 220
Also, is there a way where users can get the correct list of codes of origin state/province/country and postal codes so that everyone can refer to it?
Thanks!
Re: Post any OpenCart 1.4.7 Bugs here!
Posted: Sun Apr 11, 2010 6:25 pm
by dramony
On the Delivery Information >>> Checkout >Shipping
Re: Post any OpenCart 1.4.7 Bugs here!
Posted: Sun Apr 11, 2010 10:07 pm
by crazymaster
Code: Select all
Warning: mysql_connect() [function.mysql-connect]: Too many connections in /home/crazymas/public_html/AUTOCOLORTUNING.COM/system/database/mysql.php on line 6
Error: Could not make a database connection using crazymas_autocol@localhost
Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in /home/crazymas/public_html/AUTOCOLORTUNING.COM/system/database/mysql.php on line 66
What may be the problem?
I just made new installattion, and i imported the categories tables from my old 1.4.6 database
I am getting this message
Re: Post any OpenCart 1.4.7 Bugs here!
Posted: Sun Apr 11, 2010 10:52 pm
by rph
i2Paq wrote:allenshea wrote:This is clean install, with EXPORT/IMPORT module.
The problem isn't in System -> Settings -> Option:,
If I set in 48 items, the SPECIAL OFFER can show all items in one page, but if I set it in 16 or 20, I still only got one page, where is the code limited my SPECIAL ITEMS.
Confirmed, it is a bug on the Specials page.
We have to wait on Q for this.
Just a guess but go to System->Settings->Option and see if Default Items per Page (Catalog) has been set.
Q set up a nice new system which allows users to control the items per page now.
EDIT: Actually looks like this is caused by:
/catalog/model/catalog/product.php
public function getTotalProductSpecials
Code: Select all
if (isset($query->row['total'])) {
return $query->num_rows;
} else {
return 0;
}
Try
Code: Select all
if ($query->num_rows) {
return $query->num_rows;
} else {
return 0;
}
Re: Post any OpenCart 1.4.7 Bugs here!
Posted: Mon Apr 12, 2010 12:13 am
by Qphoria
Ok. For those with Upgrade Script issues. I found the bug. I had a typo. I've replaced it in the main zip. Redownload and just replace these files in your store root
install/upgrade.php
install/upgrade.sql
and rerun the upgrade script.
Re: Post any OpenCart 1.4.7 Bugs here!
Posted: Mon Apr 12, 2010 1:41 am
by MisoM
Hi,
It is now OK, thanks.
Re: Post any OpenCart 1.4.7 Bugs here!
Posted: Mon Apr 12, 2010 1:47 am
by Philm
When attempting to save a product after editing I get the following database error:
Error: Unknown column 'language_id' in 'field list'
Error No: 1054
INSERT INTO product_tags SET product_id = '30', language_id = '1', tag = 'test'
I've gone from 1.4.6 to 1.4.7 using the automatic upgrade script - it said it was successful when upgrading and showed no errors.
Thanks for your help & advice,
Phil
Guest Checkout problem
Posted: Mon Apr 12, 2010 3:21 am
by muflon
My friend noticed wrong behaviour in route=checkout/guest_step_3
There are two addresses Shiping and Payment and under each address there is a link to change this address. If I change Shipping address I change Payment address too. I think that this is wrong. Payment and Shipping can be different. This should be fixed.
Great relase btw.
Re: Post any OpenCart 1.4.7 Bugs here!
Posted: Mon Apr 12, 2010 5:15 am
by gavin m
Not sure if it's a bug or something wrong with my configuration.
Am I supposed to do some configuration for the file upload? It just sits there with the whirly icon going round and round when I try and upload something. Plus, it doesn't show any images in the browser, and no sub folders of 'image'.
My images file permissions is set to 755.
Have I missed something?
Re: Guest Checkout problem
Posted: Mon Apr 12, 2010 5:56 am
by Qphoria
muflon wrote:My friend noticed wrong behaviour in route=checkout/guest_step_3
There are two addresses Shiping and Payment and under each address there is a link to change this address. If I change Shipping address I change Payment address too. I think that this is wrong. Payment and Shipping can be different. This should be fixed.
Great relase btw.
This has always been there. Guest Checkout only supports 1 address at this time. This hasn't change with 1.4.7. Perhaps in 1.4.8 or later we can add separate addresses.
Re: Post any OpenCart 1.4.7 Bugs here!
Posted: Mon Apr 12, 2010 5:59 am
by Qphoria
Philm wrote:When attempting to save a product after editing I get the following database error:
Error: Unknown column 'language_id' in 'field list'
Error No: 1054
INSERT INTO product_tags SET product_id = '30', language_id = '1', tag = 'test'
I've gone from 1.4.6 to 1.4.7 using the automatic upgrade script - it said it was successful when upgrading and showed no errors.
Thanks for your help & advice,
Phil
That's not really possible. The table just wouldn't exist which would result in a different error. There's no way for the code to only partially create a table
Re: Post any OpenCart 1.4.7 Bugs here!
Posted: Mon Apr 12, 2010 6:00 am
by Qphoria
MisoM wrote:If I try edit some products and If i have try save it I have got following error:
Notice: Undefined index: weight_class_id in /www/sites/0/site3280/public_html/test/admin/model/catalog/product.php on line 98Notice: Undefined index: length_class_id in /www/sites/0/site3280/public_html/test/admin/model/catalog/product.php on line 98Warning: Cannot modify header information - headers already sent by (output started at /www/sites/0/site3280/public_html/test/admin/index.php:69) in /www/sites/0/site3280/public_html/test/system/engine/controller.php on line 27
system was upgradet from 1.3.2
if I try Add new weight class I got following error (I click in menu system - localization - weight class):
Error: Column 'title' in order clause is ambiguous
Error No: 1052
SELECT * FROM weight_class wc LEFT JOIN weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1' ORDER BY title ASC LIMIT 0,20
This was fixed in the latest version a few hours ago, right after the fix for the store not found. (redownload and replace only the upgrade.php and upgrade.sql files in the install and re-run the upgrade)
Re: Post any OpenCart 1.4.7 Bugs here!
Posted: Mon Apr 12, 2010 6:30 am
by vimal
When I ran the upgrade routine on clean intall it worked fine..
When I use my real database to convert it I got the errors below. I have swedish as the only language in this shop
Any idea how to fix it?
Notice: Constant HTTP_SERVER already defined in C:\Server\xampp\htdocs\oc132\index.php on line 51
Notice: Constant HTTP_IMAGE already defined in C:\Server\xampp\htdocs\oc132\index.php on line 52
Notice: Constant HTTPS_SERVER already defined in C:\Server\xampp\htdocs\oc132\index.php on line 58
Notice: Constant HTTPS_IMAGE already defined in C:\Server\xampp\htdocs\oc132\index.php on line 59
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at C:\Server\xampp\htdocs\oc132\index.php:51) in C:\Server\xampp\htdocs\oc132\system\library\session.php on line 11
Fatal error: Call to undefined method Language::getCode() in C:\Server\xampp\htdocs\oc132\catalog\controller\module\yourbox.php on line 5
Re: Post any OpenCart 1.4.7 Bugs here!
Posted: Mon Apr 12, 2010 7:14 am
by OCyvon2
Qphoria wrote:OCyvon2 wrote:I get this error:
Notice: Use of undefined constant VERSION - assumed 'VERSION' in \admin\controller\common\footer.php on line 6
You didn't upload some files. There is a new system/startup.php file that doesn't appear to be updated
I downloaded the files from Daniel - Changes Only patch attached - and uploaded this files. So only the admin files.
Re: Post any OpenCart 1.4.7 Bugs here!
Posted: Mon Apr 12, 2010 7:17 am
by santossg
Qphoria wrote:Ok. For those with Upgrade Script issues. I found the bug. I had a typo. I've replaced it in the main zip. Redownload and just replace these files in your store root
install/upgrade.php
install/upgrade.sql
and rerun the upgrade script.
Solved. It´s OK now.
Thanks Q
Re: Post any OpenCart 1.4.7 Bugs here!
Posted: Mon Apr 12, 2010 7:20 am
by Qphoria
vimal wrote:When I ran the upgrade routine on clean intall it worked fine..
When I use my real database to convert it I got the errors below. I have swedish as the only language in this shop
Any idea how to fix it?
Notice: Constant HTTP_SERVER already defined in C:\Server\xampp\htdocs\oc132\index.php on line 51
Notice: Constant HTTP_IMAGE already defined in C:\Server\xampp\htdocs\oc132\index.php on line 52
Notice: Constant HTTPS_SERVER already defined in C:\Server\xampp\htdocs\oc132\index.php on line 58
Notice: Constant HTTPS_IMAGE already defined in C:\Server\xampp\htdocs\oc132\index.php on line 59
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at C:\Server\xampp\htdocs\oc132\index.php:51) in C:\Server\xampp\htdocs\oc132\system\library\session.php on line 11
Fatal error: Call to undefined method Language::getCode() in C:\Server\xampp\htdocs\oc132\catalog\controller\module\yourbox.php on line 5
You need to read the upgrade.txt file
Re: Post any OpenCart 1.4.7 Bugs here!
Posted: Mon Apr 12, 2010 9:11 am
by JasonSGN
The order confirmation email has the date formatted as day/month/year even though I changed the format to month/day/year in the admin and catalog english.php file. The order update email does display the date as month/day/year. This was working correctly in 1.4.6.
Re: Post any OpenCart 1.4.7 Bugs here!
Posted: Mon Apr 12, 2010 9:26 am
by Qphoria
There were no changes to the emails or dates
Re: Post any OpenCart 1.4.7 Bugs here!
Posted: Mon Apr 12, 2010 11:00 am
by Qphoria
allenshea wrote:
I've tried your code, but looks it doesn't work. I only can get one page
Find /catalog/model/catalog/product.php
public function getTotalProductSpecials
Code: Select all
if (isset($query->row['total'])) {
return $query->num_rows;
} else {
return 0;
}
Change it to this:
Code: Select all
if (isset($query->row['total'])) {
return $query->row['total'];
} else {
return 0;
}