16
Support / Re: Address format edit doesn't work
« on: October 15, 2014, 11:08:43 PM »to solve it quick just replace file public_html/storefront/model/account/address.php by attached
Replaced, problem solved.
Thanks so much !
News:
AbanteCart v1.4.1 is released.
Show Posts
Replaced, problem solved.
Thanks so much !
17
Support / Re: Address format edit doesn't work ---update
« on: October 12, 2014, 06:04:55 PM »
After test again and again, I fund:
If checkout as registered customer, the address format does not change as set in Localization-Countries.
If checkout as guest, the address in confirmation e-mail is just in the correct format.
Any idea about this?
If checkout as registered customer, the address format does not change as set in Localization-Countries.
If checkout as guest, the address in confirmation e-mail is just in the correct format.
Any idea about this?
18
Support / Re: Address format edit doesn't work
« on: October 11, 2014, 02:18:11 PM »
Any suggestions? Tried many times, the address format doesn't change, the same as no format settings.
Is there something need to be done in C_panel? (permission?), please help if you know any information of this issue.
Thanks.
Is there something need to be done in C_panel? (permission?), please help if you know any information of this issue.
Thanks.
19
Support / Address format edit doesn't work --- Solved !
« on: October 08, 2014, 10:56:38 PM »
New fresh installation of V1.1.9, the default US address format is already there, I added Canada address format as the same:
{firstname} {lastname}
{company}
{address_1}
{address_2}
{city}, {zone} {postcode}
{country}
But in the address on order confirmation e-mails from both country, zone is moved to the next line, how to fix this ?
First Name Last Name
company
address_1
address_2
city postcode
zone
country
I searched here and found another post mentioned this, but didn't see a solution. I cleared cache, still doesn't work. It worked for me when I use V1.1.5.
{firstname} {lastname}
{company}
{address_1}
{address_2}
{city}, {zone} {postcode}
{country}
But in the address on order confirmation e-mails from both country, zone is moved to the next line, how to fix this ?
First Name Last Name
company
address_1
address_2
city postcode
zone
country
I searched here and found another post mentioned this, but didn't see a solution. I cleared cache, still doesn't work. It worked for me when I use V1.1.5.
20
Support / Re: Block can not delete
« on: October 02, 2014, 08:19:19 PM »Hi guys,
I am having the same problems as the user mentioned above and even with or without the blocks being used in the layout I get the same error of "Can't delete because this block is in use. Please visit Layout section."
How was this error resolved? I am using a new install of 1.1.9 (September 2014)
Regards,
Shane
Originally I posted this issue from version 1.1.2, never resolved. I had to make it blank and invisible.
21
General Support / Re: Upgrade problem: Store Front can not open, Control Panel Errors
« on: October 02, 2014, 06:29:42 PM »
Thanks for your reply. I'm not familiar with this, can you please tell me how to do? Really appreciate that.
You need to check sql update files for tax_rate table
If you run that script the error will go away.
22
General Support / Upgrade problem: Store Front can not open, Control Panel Errors
« on: October 01, 2014, 11:03:11 PM »
Store has been working fine for long time with version 1.1.5, starting from Sep.24, both customer and I can not receive e-mail notification, after searching here, I contacted HostPaPa, and was told php version was upgraded recently, and suggested upgrade my AbanteCart.
I upgraded from 1.1.5 to 1.1.6,.... until the latest 1.1.9, every time it shows successful. So I even didn't check it was working or not. After all upgrade done, I found I can not open my web store, I got " 500 Internal Server Error"
Login to control Panel, when I click the following tabs, got " 500 Internal Server Error"
Design-Content
System
System-Setting
System-Localization-Zones
Click the following tabs, got empty result
System-Localization-countries:
Tax Classes:
Error Log repetitive message:
2014-09-30 2:42:02 - database error: AbanteCart core v.1.1.9 Error: Unknown column 'tr.description' in 'field list'<br />Error No: 1054<br />SELECT tr.tax_class_id,
tr.rate AS rate, tr.rate_prefix AS rate_prefix,
tr.threshold_condition AS threshold_condition, tr.threshold AS threshold,
CASE WHEN tr.description='' THEN tc.title ELSE tr.description END as description,
tr.priority
FROM ab_tax_rates tr
LEFT JOIN ab_tax_classes tc ON tc.tax_class_id = tr.tax_class_id
WHERE (tr.zone_id = '0' OR tr.zone_id = '0')
AND tr.location_id in (SELECT z2l.location_id
FROM ab_zones_to_locations z2l, ab_locations l
WHERE z2l.location_id = l.location_id and z2l.zone_id = '0')
ORDER BY tr.priority ASC in <b>/home/leaf5503/public_html/store/core/database/mysql.php</b> on line
Place cursor on Setting tab, show unusual menu as shown in attached.
Tried to restore 1.1.5 manual backup by dump file, got the same 500 error.
Please help. Thanks!
I upgraded from 1.1.5 to 1.1.6,.... until the latest 1.1.9, every time it shows successful. So I even didn't check it was working or not. After all upgrade done, I found I can not open my web store, I got " 500 Internal Server Error"
Login to control Panel, when I click the following tabs, got " 500 Internal Server Error"
Design-Content
System
System-Setting
System-Localization-Zones
Click the following tabs, got empty result
System-Localization-countries:
Tax Classes:
Error Log repetitive message:
2014-09-30 2:42:02 - database error: AbanteCart core v.1.1.9 Error: Unknown column 'tr.description' in 'field list'<br />Error No: 1054<br />SELECT tr.tax_class_id,
tr.rate AS rate, tr.rate_prefix AS rate_prefix,
tr.threshold_condition AS threshold_condition, tr.threshold AS threshold,
CASE WHEN tr.description='' THEN tc.title ELSE tr.description END as description,
tr.priority
FROM ab_tax_rates tr
LEFT JOIN ab_tax_classes tc ON tc.tax_class_id = tr.tax_class_id
WHERE (tr.zone_id = '0' OR tr.zone_id = '0')
AND tr.location_id in (SELECT z2l.location_id
FROM ab_zones_to_locations z2l, ab_locations l
WHERE z2l.location_id = l.location_id and z2l.zone_id = '0')
ORDER BY tr.priority ASC in <b>/home/leaf5503/public_html/store/core/database/mysql.php</b> on line
Place cursor on Setting tab, show unusual menu as shown in attached.
Tried to restore 1.1.5 manual backup by dump file, got the same 500 error.
Please help. Thanks!
24
Support / Re: Block can not delete
« on: March 30, 2013, 08:59:37 PM »
Thanks for your reply. I updated to the newest version(1.1.4), still can not remove those 2 blocks or add new block. Now I have to make the block blank to show nothing on the page.
25
Support / Block can not delete
« on: March 29, 2013, 08:08:26 AM »
I created a new html block and added to checkout page, below the cart content block. After click "save", I see this block doesn't show on storefront cart page. I added again the same html blcok below the fist one by clicking "+" button, and click "save", then I see something wrong, on storfront cart page, I see two blocks there, but on conrtol panel Layout section, it shows "None".
Now I can not change it, even I choose " None", or choose any other block, on storefront cart page the 2 blocks are still there.
I try to turn this block off on "Block" section, it says:
"Can't change status because this block is not in use. Please visit Layout section. "
I try to delete this block, it says
"Can't delete because this block is in use. Please visit Layout section. "
Can any one help with this? ( Version 1.1.2 )
Thanks!
Now I can not change it, even I choose " None", or choose any other block, on storefront cart page the 2 blocks are still there.
I try to turn this block off on "Block" section, it says:
"Can't change status because this block is not in use. Please visit Layout section. "
I try to delete this block, it says
"Can't delete because this block is in use. Please visit Layout section. "
Can any one help with this? ( Version 1.1.2 )
Thanks!
26
General Support / Re: How to modify order detail form?
« on: March 03, 2013, 06:13:38 AM »
Ok, got it.
/storefront/view/default/template/mail/order_confirm.tpl
/storefront/view/default/template/mail/order_confirm.tpl
27
General Support / Re: How to modify order detail form?
« on: February 20, 2013, 04:30:21 PM »
Sorry, was not able to come back to see. Thanks so much for your answer!
But my question is for the receipt received through e-mail. I mean, when customer place an order, both customer and I will receive a notice with order detail, include order ID, date, address etc. and a form with 5 columns:
|Product | Model | Price | Quantity | Total |
The "product" column is small, and the "Model" column is very wide. I don't need "Model" column, but need a wide column for "Product" to show product name and options.
Can you please again let me know how to do with this ?
Thank you!
But my question is for the receipt received through e-mail. I mean, when customer place an order, both customer and I will receive a notice with order detail, include order ID, date, address etc. and a form with 5 columns:
|Product | Model | Price | Quantity | Total |
The "product" column is small, and the "Model" column is very wide. I don't need "Model" column, but need a wide column for "Product" to show product name and options.
Can you please again let me know how to do with this ?
Thank you!
28
General Support / How to modify order detail form?
« on: February 16, 2013, 05:38:04 PM »
There are 5 columns in the default order detail form: Product/Model/ Price/ Quantity/ Total
For the products I'm selling, I don't need Model column, but need more space to show product name and options, how to remove or add a column and how to modify the width of a column?
Thanks.
For the products I'm selling, I don't need Model column, but need more space to show product name and options, how to remove or add a column and how to modify the width of a column?
Thanks.
29
General Support / Re: Inserting a static banner
« on: January 01, 2013, 10:10:17 AM »Well,
why do this all .Just download the image edit it .ftp to the directory where the older image is and replace it its done .Have a look at mine here lynxdealerstore.com
PS : Certain Things In this Script Are Worrying me a lot
Thanks! Much easier, didn't think of that.
30
General Support / Re: Inserting a static banner
« on: January 01, 2013, 09:47:13 AM »I think this was addressed in 1.1.1
Wrong ,
even in 1.1.2 its there man .We just get a thumbnail
Yes, I use 1.1.2 and have the same problem with IE9, for any html block.
My way to solve this problem: System--Setting--Appearance--
Product List Width & Product List Height: temporarily change to the size of the picture you're going to upload.
By doing this, when you edit the block and insert picture, you may still see a thumbnail. Choose Cancel and insert picture again, now you can find your picture in resource liberary, choose the picture and done!
Don't forget to change back Product List Width & Product List Height.
Hope this problem can be really resolved in a future version.