Post by bader rashed » Wed Jan 26, 2011 7:30 am

i2Paq wrote:
bader rashed wrote:helloo ..

ive got problem when i add new product

i got this message :

Error: Duplicate entry '63-2' for key 1
Error No: 1062
INSERT INTO product_description SET product_id = '63', language_id = '2', name = 'hhh', meta_keywords = '', meta_description = '', description = ''


how can i fix it ?
Make sure your meta-keywords are unique.
i make sure :(

but not fixed

Newbie

Posts

Joined
Tue Dec 21, 2010 5:15 am

Post by bull5-i » Sat Jan 29, 2011 7:11 pm

I've just noticed a problem with the Image upload with the CKEDITOR. Example case is with the product description field.

Everything works if you only have one CKEDITOR instance (this is the case for only single language shops). If you, however, have a multilanguage shop, thus you have several CKEDITOR instances in the prodcut edit form, then only the first CKEDITOR works for image upload. All other instances open up the file manager, but when you double click on the image you want to add, nothing happens. The file manager window stays open and no info gets sent to the CKEDITOR image insert window.

I noticed that the callback function has a hard coded 1 in the filemanager template as the first parameter. Shouldn't there be the CKEditorFuncNum that is the GET parameter for the filemanager. If I changed this to the CKEditorFuncNum parameter then the image name gets sent back to CKEDITOR image insert window, but the filemanager window will still not close and image will not be added.

I don't think that this is a browser problem. Checked with FF 3.6 and IE 8. It probably is some kind of scripting problem with the filemanager (probably javascript issue).

It's really annoying, because I can't add images for other languages.

|V|355 \/\/17|-| 7}{3 |3357, ... [you know the rest]

Commercial mods: New! Questions & Answers PRO - Admin Quick Edit PRO - Product Downloads PRO - Custom Product Tab PRO - New! Product Quick Edit Plus

All mods & extensions by me


Active Member

Posts

Joined
Tue Jan 11, 2011 8:49 pm

Post by philbydevil » Sun Jan 30, 2011 10:40 am

Not sure if this is a bug, but I had to change line 21 in catalog/controller/error/not_found.php

from:

Code: Select all

'text'      => $this->language->get('text_error'),
to:

Code: Select all

'text'      => $this->language->get('heading_title'),
otherwise my breadcrumbs' text would blow out over two lines with the full error text.

If you keep the text_error in the language file as default then it isn't a problem/bug. But if you change it to a longer sentence then you start to have problems.

I heart cmd-f, cmd-c, cmd-v, cmd-z + vQmod.
My favourite page...
v1.5.4.1


User avatar
Active Member

Posts

Joined
Fri Dec 03, 2010 5:20 am

Post by Qphoria » Sun Jan 30, 2011 10:56 am

bull5-i wrote:I've just noticed a problem with the Image upload with the CKEDITOR. Example case is with the product description field.

Everything works if you only have one CKEDITOR instance (this is the case for only single language shops). If you, however, have a multilanguage shop, thus you have several CKEDITOR instances in the prodcut edit form, then only the first CKEDITOR works for image upload.
This is a known CKEDITOR issue, not opencart related. We will update to the latest version in 1.5.x but cant guarantee they fixed it

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by bader rashed » Mon Jan 31, 2011 11:13 am

bader rashed wrote:
i2Paq wrote:
bader rashed wrote:helloo ..

ive got problem when i add new product

i got this message :

Error: Duplicate entry '63-2' for key 1
Error No: 1062
INSERT INTO product_description SET product_id = '63', language_id = '2', name = 'hhh', meta_keywords = '', meta_description = '', description = ''


how can i fix it ?
Make sure your meta-keywords are unique.
i make sure :(

but not fixed

Newbie

Posts

Joined
Tue Dec 21, 2010 5:15 am

Post by anreig » Tue Feb 01, 2011 6:24 am

It's possible no works on 1.4.9.2 and 1.4.9.3 the ajax on history order status when it's notify?Thanks

Newbie

Posts

Joined
Sun Dec 26, 2010 4:12 am

Post by Daniel » Thu Feb 03, 2011 2:44 am

cashman9 wrote:
julugu wrote:Hello,

Everyday I get a lot of errors like these:

2011-01-19 19:08:21 - PHP Warning: session_start() [<a href='function.session-start'>function.session-start</a>]: Cannot send session cache limiter - headers already sent (output started at /home/julugu/public_html/index.php:48) in /home/julugu/public_html/system/library/session.php on line 11

2011-01-19 19:08:22 - PHP Notice: Undefined index: HTTP_HOST in /home/julugu/public_html/index.php on line 173

2011-01-19 19:08:22 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/julugu/public_html/index.php:48) in /home/julugu/public_html/index.php on line 173

2011-01-20 8:36:06 - PHP Warning: unlink(/home/julugu/public_html/system/cache/cache.category.38.2.0.1295512099) [<a href='function.unlink'>function.unlink</a>]: No such file or directory in /home/julugu/public_html/system/library/cache.php on line 14

I know they are Warnings but I don't want them in the log.

Thanks

I also get those errors daily and I don't know how to fix it.
check if there are any spaces after ?> or possibly your session direcotry does not ahve the correct permissions.

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by JAY6390 » Thu Feb 03, 2011 2:54 am

"Undefined index: HTTP_HOST"
That's not an opencart problem, that's a server problem. Perhaps you're not using apache. headers sent could be the cause of spaces before the <?php or just another error outputting causing a chain reaction. The most common error I get is the cache deletion one which I don't seem to be able to work out. Even with checking if the file exists before deletion somehow manages to get the issue, but well, it's not a massive concern. customers don't see the errors and no web app is going to be perfect...

Image


User avatar
Guru Member

Posts

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

Post by mike_jandreau » Mon Feb 07, 2011 1:24 am

I looked through the whole thread, but didn't see this listed (or anywhere else on the forums), my apologies if I overlooked it.

When sorting by price, the sorting seems to not take special prices into account, and is sorting on the original price, which is deceiving, and could be confusing for customers.

I checked and it looks like it's the same case with older versions, as well. Just wanted to bring it up, so it can be investigated for a future release.

New member

Posts

Joined
Mon Jul 26, 2010 1:38 am

Post by jefferymoore83 » Thu Feb 10, 2011 7:50 am

I think I have found a bug in 1.4.9.3. When I edit a manufacturer, I get the following error:

Warning: Invalid argument supplied for foreach() in /wwwroot/store/admin/model/catalog/manufacturer.php on line 35
Warning: Cannot modify header information - headers already sent by (output started at /wwwroot/store/admin/index.php:72) in /wwwroot/store/system/engine/controller.php on line 27

I can prevent the error by deselecting the default store but if I do this I remove the manufacturer from the store and this is of course not what I want. It appears a variable is supposed to be an array but it's instead been coerced into the string value "Array". I have been trying to debug it but my barely above newbie PHP skills have failed me for the moment. Anyone on here know how to fix it? Manufacturer functionality is important for my client so I really need to get it working correctly!


Posts

Joined
Thu Feb 10, 2011 7:43 am

Post by JAY6390 » Thu Feb 10, 2011 7:58 am

I don't get this error. What browser are you using?

Image


User avatar
Guru Member

Posts

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

Post by jefferymoore83 » Thu Feb 10, 2011 8:02 am

Firefox Mac 3.5.10. This doesn't seem like a browser related issue but of course I could be wrong.


Posts

Joined
Thu Feb 10, 2011 7:43 am

Post by bberman » Thu Feb 10, 2011 8:32 am

When i am typing in the option fild the box to the left shrinks.

For every one space typed in either the option or the option value "name" field the box to the left that has your option tree shrinks in size by one space. If you type 15 characters the box to the left compleatly goes away. Is there any fix for this?

Thanks

Newbie

Posts

Joined
Thu Feb 10, 2011 5:02 am

Post by Qphoria » Thu Feb 10, 2011 8:41 am

bberman wrote:When i am typing in the option fild the box to the left shrinks.

For every one space typed in either the option or the option value "name" field the box to the left that has your option tree shrinks in size by one space. If you type 15 characters the box to the left compleatly goes away. Is there any fix for this?

Thanks
Ya, dont use IE :)
Options will be diff in 1.5.x anyway

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by JAY6390 » Thu Feb 10, 2011 6:56 pm

jefferymoore83 wrote:Firefox Mac 3.5.10. This doesn't seem like a browser related issue but of course I could be wrong.
Hi Jeffery. I agree that it's likely not a browser issue, but it's possible. OK are you using apache as your web server?
The reason I ask is some servers parse [] differently. There is an easy fix for this. You just need to edit the file

Code: Select all

/admin/view/template/catalog/manufacturer_form.tpl
Find this

Code: Select all

              <?php foreach ($stores as $store) { ?>
              <?php $class = ($class == 'even' ? 'odd' : 'even'); ?>
              <div class="<?php echo $class; ?>">
                <?php if (in_array($store['store_id'], $manufacturer_store)) { ?>
                <input type="checkbox" name="manufacturer_store[]" value="<?php echo $store['store_id']; ?>" checked="checked" />
                <?php echo $store['name']; ?>
                <?php } else { ?>
                <input type="checkbox" name="manufacturer_store[]" value="<?php echo $store['store_id']; ?>" />
                <?php echo $store['name']; ?>
                <?php } ?>
              </div>
              <?php } ?>
and change it to

Code: Select all

              <?php foreach ($stores as $store) { ?>
              <?php $class = ($class == 'even' ? 'odd' : 'even'); ?>
              <div class="<?php echo $class; ?>">
                <?php if (in_array($store['store_id'], $manufacturer_store)) { ?>
                <input type="checkbox" name="manufacturer_store[<?php echo $store['store_id']; ?>]" value="<?php echo $store['store_id']; ?>" checked="checked" />
                <?php echo $store['name']; ?>
                <?php } else { ?>
                <input type="checkbox" name="manufacturer_store[<?php echo $store['store_id']; ?>]" value="<?php echo $store['store_id']; ?>" />
                <?php echo $store['name']; ?>
                <?php } ?>
              </div>
              <?php } ?>
Also find this code a little above the last code

Code: Select all

                <?php if (in_array(0, $manufacturer_store)) { ?>
                <input type="checkbox" name="manufacturer_store[]" value="0" checked="checked" />
                <?php echo $text_default; ?>
                <?php } else { ?>
                <input type="checkbox" name="manufacturer_store[]" value="0" />
                <?php echo $text_default; ?>
                <?php } ?>
and change it to

Code: Select all

                <?php if (in_array(0, $manufacturer_store)) { ?>
                <input type="checkbox" name="manufacturer_store[0]" value="0" checked="checked" />
                <?php echo $text_default; ?>
                <?php } else { ?>
                <input type="checkbox" name="manufacturer_store[0]" value="0" />
                <?php echo $text_default; ?>
                <?php } ?>
That will give each manufacturer_store a unique key (the store id)

Image


User avatar
Guru Member

Posts

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

Post by jefferymoore83 » Fri Feb 11, 2011 3:30 am

Jay,

Thanks so much, this immediately fixed the issue. I had never noticed form elements with [] in their names before this. I am not sure I understand why, but it now does work. To answer your question, I am using Apache. It is a part of the MAMP package if you are familiar. I was looking for a version number but couldn't find one (for Apache). My MAMP is the Pro version, 1.9.4. Maybe this functionality can be tweaked to work with both interpretations of []? Sounds like a good fix for the next minor release version.. :)

Thanks again, so much!

-Jeff


Posts

Joined
Thu Feb 10, 2011 7:43 am

Post by JAY6390 » Fri Feb 11, 2011 3:33 am

No problem Jeff. It's likely to be either apache or the Mac version of Firefox (although can't see that being different to the Windows 7 version in many ways)
Glad it got it fixed, and perhaps this is something for the devs to take a look into for future compatibility :)

Image


User avatar
Guru Member

Posts

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

Post by Qphoria » Fri Feb 11, 2011 3:51 am

I've never heard of an issue with [] before to be honest. It is interesting tho.

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by JAY6390 » Fri Feb 11, 2011 4:01 am

I've only seen it a couple of times to be honest, never actually noticed a trend as to why it happens, and for the effort of adding a unique key I always do so

Image


User avatar
Guru Member

Posts

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

Post by mostek » Thu Feb 17, 2011 4:54 pm

I have a problem with Opencart - Version 1.4.9.2 and 1.4.9.2

When I use polish national characters in search field - there are no results. When I search without polish national character everything is ok - search works great.

Have you got any idea how to fix it?

Thank you for help in advance.

Pete

Newbie

Posts

Joined
Wed Feb 16, 2011 7:20 pm
Who is online

Users browsing this forum: Bing [Bot] and 10 guests