Clean installi2Paq wrote:I cannot reproduce this.MaxxTechz-Erick wrote:Hi wen i go to
System>Localisation>Taxes>Tax Classes
i get and cant edit tax classes :/
Notice: Error: Unknown column 'title' in 'order clause'
Error No: 1054
SELECT * FROM techno2_tax_class ORDER BY title ASC LIMIT 0,20 in /home/techno2/public_html/opencart/system/database/mysql.php on line 49
Clean install or upgrade?
I cannot reproduce this.MaxxTechz-Erick wrote:Clean installi2Paq wrote:I cannot reproduce this.MaxxTechz-Erick wrote:Hi wen i go to
System>Localisation>Taxes>Tax Classes
i get and cant edit tax classes :/
Notice: Error: Unknown column 'title' in 'order clause'
Error No: 1054
SELECT * FROM techno2_tax_class ORDER BY title ASC LIMIT 0,20 in /home/techno2/public_html/opencart/system/database/mysql.php on line 49
Clean install or upgrade?
Did you tried a new install?
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
Unable to reproduce your error. There clearly is a 'title' field in the 'tax_class' table, hence it would appear that your database is corrupted. Not a bug.MaxxTechz-Erick wrote:Hi wen i go to
System>Localisation>Taxes>Tax Classes
i get and cant edit tax classes :/
Notice: Error: Unknown column 'title' in 'order clause'
Error No: 1054
SELECT * FROM techno2_tax_class ORDER BY title ASC LIMIT 0,20 in /home/techno2/public_html/opencart/system/database/mysql.php on line 49
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Account was not created via admin.i2Paq wrote:Maansy wrote:today i saw this error on top of the product page:
Notice: Undefined index: country_id in /home/xxxx/public_html/opencartstuff.com/system/library/tax.php on line 17
Notice: Undefined index: zone_id in /home/xxxx/public_html/opencartstuff.com/system/library/tax.php on line 17
Notice: Undefined index: country_id in /home/xxxx/public_html/opencartstuff.com/system/library/tax.php on line 31
Notice: Undefined index: zone_id in /home/xxxx/public_html/opencartstuff.com/system/library/tax.php on line 31
knowing i have tax turned off for all products
opencart v1.5.1.3.1 fresh copy + vqmods (but nothing for tax system)
any clue?
I have seen this to!
I was working on a store from a Dutch owner and there it was!
Plus some more.
Code: Select all
Notice: Undefined index: country_id in /home/deb52024/domains/horlogevoorjou.nl/public_html/system/library/tax.php on line 23Notice: Undefined index: zone_id in /home/deb52024/domains/horlogevoorjou.nl/public_html/system/library/tax.php on line 23
I think it has to do with rights on folders and files or an incorrect server setup/Code: Select all
Warning: Cannot modify header information - headers already sent by (output started at /home/deb52024/domains/horlogevoorjou.nl/public_html/index.php:100) in /home/deb52024/domains/horlogevoorjou.nl/public_html/system/engine/controller.php on line 28Warning: Cannot modify header information - headers already sent by (output started at /home/deb52024/domains/horlogevoorjou.nl/public_html/index.php:100) in /home/deb52024/domains/horlogevoorjou.nl/public_html/system/engine/controller.php on line 29
This because I have no such issues on my server/installs[/s]
BUG!
When a customer has NO address in his/her account this error will occur during checkout etc.!
Instead there should be a message saying: "no order/shipping address".
Probably an account created via the Admin.
Make also sure your GEO-zones, VAT and Shipping zones etc. are setup correctly or you will have another issue that checkout will not proceed AFTER step 3 with that same account.
All product are for downloading so no shipping required.
Tax is disabled also for products.
If a customer has a missing required field, I assume it won't go for the next step. Would that create an error in the error log?
ALL Templates :: 1.5.1+ Templates :: 50%-75% PRICE DROP ONLY at OpencartStuff.com
It is like I say it is. I see these errors in my log only at that time.Maansy wrote: Account was not created via admin.
All product are for downloading so no shipping required.
Tax is disabled also for products.
If a customer has a missing required field, I assume it won't go for the next step. Would that create an error in the error log?
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
i2Paq , can we apply this SVN fix on 1.5.1.3 ? Where do I find it?OpenCart 1.5.1.3 Bug Thread
Postby i2Paq » Tue Nov 08, 2011 9:15 pm
i2Paq wrote:BUG!
When a customer has NO address in his/her account this error will occur during checkout etc.!
Instead there should be a message saying: "no order/shipping address".
Probably an account created via the Admin.
Make also sure your GEO-zones, VAT and Shipping zones etc. are setup correctly or you will have another issue that checkout will not proceed AFTER step 3 with that same account.
I see that this is solved in the SVN 1.5.2!
NO! Not that I think.opencartrules wrote:i2Paq , can we apply this SVN fix on 1.5.1.3 ? Where do I find it?
The issue is that the SVN is not only full of BUG fixes but also unfinished work.
Even-tough we are told to "use the SVN" because it is "fixed in SVN" you get more issues then you want to solve.
We need to get a workable solution for this, wouldn't that be a dream come true?

Also, it could be an issue with the upgrade script according to Xsecrets.
It seems it does not convert the customers accounts completely/correctly.
See: Undefined index: country_id in tax.php
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
if $json['redirect'] sets above this line, then redirect will lost
i would only like to update svn when new features are finished but some take quite a while to finish.
OpenCart®
Project Owner & Developer.
you get this on smtp option:
Code: Select all
Notice: Error: DATA not accepted from server! in C:\xampp\htdocs\private\system\library\mail.php on line 388
http://forum.opencart.com/viewtopic.php?f=20&t=45585
...some things are never ment to be...
Is there away to bypass and have a drop down menu show like in 1.4.9.3.
This is a new install of 1.5.1.3 with vqmods.
Thanks


I don't know if it is a bug with my site or with 1.5.1.3.1 in general and I have searched this entire message thread to see if anyone else has the same issue.
I am getting duplicated products showing up when I go to a category. I have only created the product once in admin yet it shows up more than once with some products on pages 1 and 2 in the same category

Any help would be great, to view this problem see: http://www.pandorasjewellerybox.co.uk/C ... 0Bracelets
Thanks in advance,
Phil
Did you set a sort-order number per product?Phil wrote:Hi,
I don't know if it is a bug with my site or with 1.5.1.3.1 in general and I have searched this entire message thread to see if anyone else has the same issue.
I am getting duplicated products showing up when I go to a category. I have only created the product once in admin yet it shows up more than once with some products on pages 1 and 2 in the same category
Any help would be great, to view this problem see: http://www.pandorasjewellerybox.co.uk/C ... 0Bracelets
Thanks in advance,
Phil
2nd page repeat items
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
No I haven't set a sort order for each product, Firstly I have never had to do it in any of the previous versions of OpenCart and as mentioned in the thread that you referred to,
"having to set order for lots of products is a pain and if you remove, add etc. more products it becomes unmanageable since you can't see sort order in products view in Admin, so you'd have to open details for every single one to see what's going on.."
Our stock changes on a very regular basis.
It is a sort of BUG, you can follow the solution in the topic a link to.Phil wrote:Thanks for getting back to me,
No I haven't set a sort order for each product, Firstly I have never had to do it in any of the previous versions of OpenCart and as mentioned in the thread that you referred to,
"having to set order for lots of products is a pain and if you remove, add etc. more products it becomes unmanageable since you can't see sort order in products view in Admin, so you'd have to open details for every single one to see what's going on.."
Our stock changes on a very regular basis.
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
not true.ciprianrpp wrote:the mail class is incompatible with latest version of php 5.3.8
you get this on smtp option:
please see:Code: Select all
Notice: Error: DATA not accepted from server! in C:\xampp\htdocs\private\system\library\mail.php on line 388
http://forum.opencart.com/viewtopic.php?f=20&t=45585
try playing with your settings.
OpenCart®
Project Owner & Developer.
YES, true (test yourself)Daniel wrote:not true.ciprianrpp wrote:the mail class is incompatible with latest version of php 5.3.8
you get this on smtp option:
please see:Code: Select all
Notice: Error: DATA not accepted from server! in C:\xampp\htdocs\private\system\library\mail.php on line 388
http://forum.opencart.com/viewtopic.php?f=20&t=45585
try playing with your settings.
tested now with 2 live hostings:
1st dedicate hosting centos with php 5.3.8 (returns same error)
2nd shared hosting ubuntu with php 5.3.2 (WORKS FINE)
Same settings, same OC instalation, same everything except the php version!
and what settings you reffer to? are the same on all
...some things are never ment to be...
try the code from the svn.
http://code.google.com/p/opencart/sourc ... y/mail.php
replace the code in your mail file.
tell me if it helps.
OpenCart®
Project Owner & Developer.
I've already found your bug.Daniel wrote:could it be cent os has a problem?
try the code from the svn.
http://code.google.com/p/opencart/sourc ... y/mail.php
replace the code in your mail file.
tell me if it helps.
the OC 1.5.1.3 mail.php file (located in system/library/):
Code: Select all
$header .= 'Content-Type: multipart/related; boundary="' . $boundary . '"' . $this->newline;
Code: Select all
$header .= 'Content-Type: multipart/related; boundary="' . $boundary . '"' . $this->newline . $this->newline;
and thx Daniel for your time and for OC

...some things are never ment to be...
Users browsing this forum: No registered users and 15 guests