Offical OpenCart v1.5.0 RC2 Bug Thread

[Daniel]

Looks like you removed the Invoice number based on prefix which means this bug from 1.4.x is back and people cannot reset their Invoice id.

There are numerous bug and issue reports on this:
viewtopic.php?f=20&t=27323
viewtopic.php?f=10&t=7767&start=120#p80511
viewtopic.php?f=161&t=24368&p=120789&hilit=invoice+prefix#p120789
viewtopic.php?f=20&t=14542&hilit=invoice+prefix
viewtopic.php?f=161&t=12655&p=62284&hilit=invoice+prefix#p62284
viewtopic.php?f=31&t=26586&p=131956
viewtopic.php?f=161&t=16053&p=81039&hilit=invoice+prefix#p81039

Another person who used a similar method that I used and got it working correctly:
viewtopic.php?f=10&t=7767&start=120#p85177

This was the link that had the fix explained better:
viewtopic.php?f=20&t=24497#p140739

But somehow that thread has mysteriously disappeared.

So now the old broken invoice system is back in. And I'm seeing many of my fixes from 1.4.x are being removed. So either you are not merging the existing changes because you don't understand svn or you are just deleting all the fixes I made because you don't agree with them or understand them. Last I checked, people weren't complaining about these fixes in 1.4.9.x, but if you want to wait for the same mistakes to have to be uncovered again, go ahead. Just because you don't understand a bug fix I made doesn't mean you should remove it.

People in some countries need to be able to reset their invoice id based on fiscal year or calendar year or just for test purposes. Without the fix I gave and we discussed, there is no way to do that.

ok i just added the invoice number fix. did not notice the WHERE statement when I looked at the 1.4.9.x code in the past.

[i2Paq]

Wauw, at the speed the issues with RC2 are fixed I just downloaded the SVN to stay up-to-date

Great work Daniel for fixing and sharp looking Qphoria!

[hawkey]

Hello

Testing affiliate system with latest SVN 304 and found some problems.

2. Missing INSERT to affiliate_transaction on checkout. Affiliate ID is assigned to order only => system does not count provisions. There is not any INSERT to affiliate_transaction on frontend, is it in progress?

just fixed this.

I have just released RC2. Please use this thread for bugs now:

viewtopic.php?f=162&t=32488

Thanks for quick fix.
And my second point? Storing affiliate transactions is not done yet?

[jaggy]

When trying to copy the products in the admin panel, I get errors like below.

Code: Select all

Error: Duplicate entry '28-50' for key 'PRIMARY'
Error No: 1062
INSERT INTO product_related SET product_id = '28', related_id = '50'

Code: Select all

Error: Duplicate entry '48-51' for key 'PRIMARY'
Error No: 1062
INSERT INTO product_related SET product_id = '48', related_id = '51'

Code: Select all

Error: Duplicate entry '48-52' for key 'PRIMARY'
Error No: 1062
INSERT INTO product_related SET product_id = '48', related_id = '52'

and so on....

it should be fixed with the code from the svn i have just done. can not tell though because i can not replicate this problem.

can we compare your current product_related with ours?

this is sql snippets from install/opencart.sql

Code: Select all

DROP TABLE IF EXISTS `oc_product_related`;
CREATE TABLE `oc_product_related` (
  `product_id` int(11) NOT NULL,
  `related_id` int(11) NOT NULL,
  PRIMARY KEY (`product_id`,`related_id`),
  KEY `product_id` (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

which will give those error, even with your current fix. http://code.google.com/p/opencart/sourc ... roduct.php

i tried to remove and recreate index and then problem disappears -- even with the previous revisions

Code: Select all

alter table product_related drop primary key, add index(product_id,related_id)

[mgxtreme]

HI

Not sure if the MySQL fix is still needed from RC1 but just done a fresh install and get the following error at the top of the main shop page

Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in C:\wamp\www\opencart15rc2\system\database\mysql.php on line 54

It also appears on every page you visit and the layout of the shop has been lost and is all to the left of the screen

[jaggy]

HI

Not sure if the MySQL fix is still needed from RC1 but just done a fresh install and get the following error at the top of the main shop page

Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in C:\wamp\www\opencart15rc2\system\database\mysql.php on line 54

It also appears on every page you visit and the layout of the shop has been lost and is all to the left of the screen

set


set php.ini not to display "Warning" and "Notice" @see http://php.net/manual/en/errorfunc.configuration.php

[celestial]

The footer still with problems, when you click an empty option of the menu the footer expand all the wide screen and begin at the left side, when you click a option with value the footer is Ok

[jaggy]

The footer still with problems, when you click an empty option of the menu the footer expand all the wide screen and begin at the left side, when you click a option with value the footer is Ok

can you provide some steps how to replicate? screenshots would be nice.

[Daniel]

HI

Not sure if the MySQL fix is still needed from RC1 but just done a fresh install and get the following error at the top of the main shop page

Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in C:\wamp\www\opencart15rc2\system\database\mysql.php on line 54

It also appears on every page you visit and the layout of the shop has been lost and is all to the left of the screen

set php.ini not to display "Warning" and "Notice" @see http://php.net/manual/en/errorfunc.configuration.php

I don;t want them to do that because it needs investigating. telling people to switch off error reporting is not help me.

[Daniel]

The footer still with problems, when you click an empty option of the menu the footer expand all the wide screen and begin at the left side, when you click a option with value the footer is Ok

which option and which menu?

the admin?

what page?

[Daniel]

When trying to copy the products in the admin panel, I get errors like below.

Code: Select all

Error: Duplicate entry '28-50' for key 'PRIMARY'
Error No: 1062
INSERT INTO product_related SET product_id = '28', related_id = '50'

Code: Select all

Error: Duplicate entry '48-51' for key 'PRIMARY'
Error No: 1062
INSERT INTO product_related SET product_id = '48', related_id = '51'

Code: Select all

Error: Duplicate entry '48-52' for key 'PRIMARY'
Error No: 1062
INSERT INTO product_related SET product_id = '48', related_id = '52'

and so on....

it should be fixed with the code from the svn i have just done. can not tell though because i can not replicate this problem.

can we compare your current product_related with ours?

this is sql snippets from install/opencart.sql

Code: Select all

DROP TABLE IF EXISTS `oc_product_related`;
CREATE TABLE `oc_product_related` (
  `product_id` int(11) NOT NULL,
  `related_id` int(11) NOT NULL,
  PRIMARY KEY (`product_id`,`related_id`),
  KEY `product_id` (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

which will give those error, even with your current fix. http://code.google.com/p/opencart/sourc ... roduct.php

i tried to remove and recreate index and then problem disappears -- even with the previous revisions

Code: Select all

alter table product_related drop primary key, add index(product_id,related_id)

clear all the product_related table. maybe some old data. again though this does not happen to me.

[celestial]

In Frontend menu tested with ie8 and ff4

footer01.jpg (33.35 KiB) Viewed 1857 times

footer02.jpg (29.4 KiB) Viewed 1857 times

[karlpers]

Great look of the new category menu in header!
I found some bugs, I dont know if they are local or applys for everyone..,

1. I cant add more then 1 item in cart
2. When I try to use a coupon code (1111) - my shopping cart drops out and the items are removed from cart. The same thing happends with voucher/try to estimate shipping & tax
3. My cart drops when I try to click on Checkout - Shopping cart wents empty

just happens to you. do u have a link? or is it localhost?

also sounds like your session directory is not writable.not opencart related.

Well, which directory is the session directory? I did just install it on webshop365.se/150

[amdev]

Code: Select all

Notice: Undefined index: top in C:\AppServ\www\15rc2\admin\model\catalog\category.php on line 4Warning: Cannot modify header information - headers already sent by (output started at C:\AppServ\www\15rc2\admin\index.php:75) in C:\AppServ\www\15rc2\system\engine\controller.php on line 28Warning: Cannot modify header information - headers already sent by (output started at C:\AppServ\www\15rc2\admin\index.php:75) in C:\AppServ\www\15rc2\system\engine\controller.php on line 29

When i create a new category and don't check a checkbox the top menu bar.
Then I replace CheckBox to Radio Button.

Code: Select all

        <tr>
          <td><?php echo $entry_top; ?></td>
          <td><?php if ($top == 1) { ?>
            <input type="radio" name="top" value="1" checked="checked" />
            <?php echo $text_yes; ?>
            <input type="radio" name="top" value="0" />
            <?php echo $text_no; ?>
            <?php } else { ?>
            <input type="radio" name="top" value="1" />
            <?php echo $text_yes; ?>
            <input type="radio" name="top" value="0" checked="checked" />
            <?php echo $text_no; ?>
            <?php } ?></td>
        </tr>


and add

Code: Select all

   $this->data['text_yes'] = $this->language->get('text_yes');
      $this->data['text_no'] = $this->language->get('text_no');


in a controller. It work fine.

[Daniel]

Hello

Testing affiliate system with latest SVN 304 and found some problems.

2. Missing INSERT to affiliate_transaction on checkout. Affiliate ID is assigned to order only => system does not count provisions. There is not any INSERT to affiliate_transaction on frontend, is it in progress?

just fixed this.

I have just released RC2. Please use this thread for bugs now:

viewtopic.php?f=162&t=32488

Thanks for quick fix.
And my second point? Storing affiliate transactions is not done yet?

you do this manually from the admin > orders. there is a icon you click to add their transaction. maybe i need to make it a bit clearer and add it to the order list page.

same with reward points.

[Daniel]

Great look of the new category menu in header!
I found some bugs, I dont know if they are local or applys for everyone..,

1. I cant add more then 1 item in cart
2. When I try to use a coupon code (1111) - my shopping cart drops out and the items are removed from cart. The same thing happends with voucher/try to estimate shipping & tax
3. My cart drops when I try to click on Checkout - Shopping cart wents empty

just happens to you. do u have a link? or is it localhost?

also sounds like your session directory is not writable.not opencart related.

Well, which directory is the session directory? I did just install it on webshop365.se/150

you problem is your using a shared ssl certifacte.

you can not do this. even prestashop won't allow this. session can not be transferred over multiple domains.

[Daniel]

In Frontend menu tested with ie8 and ff4

footer01.jpg

footer02.jpg

I can not replicate this.

are you sure you did not add an unclosed tag to the category description.

[Daniel]

I'm going to start IE6 fixes.

[leewan]

I updated open cart 1.4.9.4 to this v1.5.0 RC2 and received this

on the admin page
Error: Unknown column 'store_id' in 'where clause'
Error No: 1054
SELECT * FROM setting WHERE store_id = '0'

and this on the homepage

Error: Unknown column 'store_id' in 'where clause'
Error No: 1054
SELECT * FROM setting WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC

How to fix that

[helenmarie]

I think i found a bug? I have done a fresh install to test it out.

Everything adds to the cart fine from the category page except for the Apple Monitor 30" which has a special price applied to it, and when you click Add to cart it redirects you to the product page and doesnt add it to your cart?

EDIT: Is this happening because it has product options attached to it? If so, should it read 'Product Detail's as opposed to 'Add To Cart'?