OpenCart Community

Johnathan wrote:

i2Paq wrote:I cannot find the

Code: Select all

LEFT JOIN " . DB_PREFIX . "option o ON

on that file you mention.

There's no LEFT JOIN bug in that file, it's all UPDATEs, SELECTs, INSERTs, and DELETEs. Try searching for this instead:

Code: Select all

DB_PREFIX . "option 

DB_PREFIX . "option 

DB_PREFIX . "option o ON 

JAY6390 wrote:@Norman - Just download the files in the first post that Q has made for the MySQL patches. They will contain them (you can diff those and the old ones if you really want to see the changes

JAY6390 wrote:I'm using FF4, and cannot replicate your problem :S

JAY6390 wrote:Actually, this does happen, but only if you click remove before saving, so the problem lies in the remove button JS code added when the new module gets added. Change

Code: Select all

	html += '    <td class="left"><a onclick="$(\'#module-row\'' + module_row + '\').remove();" class="button"><span>Remove</span></a></td>';

to

Code: Select all

	html += '    <td class="left"><a onclick="$(\'#module-row' + module_row + '\').remove();" class="button"><span>Remove</span></a></td>';

JAY6390 wrote:Actually, this does happen, but only if you click remove before saving, so the problem lies in the remove button JS code added when the new module gets added. Change

Code: Select all

	html += '    <td class="left"><a onclick="$(\'#module-row\'' + module_row + '\').remove();" class="button"><span>Remove</span></a></td>';

to

Code: Select all

	html += '    <td class="left"><a onclick="$(\'#module-row' + module_row + '\').remove();" class="button"><span>Remove</span></a></td>';

matt1982 wrote:First off well done guys cracking update!

I have noticed something I am not 100% sure about on the options side of things.

I created by own Option group called size which had Small Medium and Large.

I then went to assign this to a iMac which was already in the system.

I set the small to have 0 in the quantity and to subtract stock, medium had 10 and large had 15.

Now on the product page it lists all the sizes. I tried adding a small to the cart which succeeded and it was only at checkout when it told me that they were out of stock.

To me this seems wrong, I believe that the "small" shouldn't have even appeared in the list. Am I the only person who thinks this way. Or should say "Out of Stock" in the options next to it. rather than going all the way through to the shopping cart to find out.

I couldn't see this in the list and I suppose it is not really a bug but thought I would post any way.

Also have you ever considered using some specialist bug tracking software for the project. It seems quite hard to keep track within the forum.