Anytime I click "checkout" regardless of what is in my cart I get the following:
Error: Unknown column 'unit' in 'where clause'
Error No: 1054
select weight_class_id from weight_class where unit = 'lb'
PLEASE HELP!!!
Version 1.4.8
Yes sir, twice.
Worth noting, I have upgraded with each of the last 4 or 5 releases. I think it was fine until I got to 1.4.7, I didn't notice it was broke for a while. This is why I did the 1.4.8 upgrade, I thought it would fix it.
One other thing if you don't mind, take a look at https://atsdiagnostic.com. This store is setup to require a logged in user to see prices. However, under latest I get a little dash or underscore I think from the "specials" system. The problem is that you can click and add stuff to the cart which will show the price anyway.
Worth noting, I have upgraded with each of the last 4 or 5 releases. I think it was fine until I got to 1.4.7, I didn't notice it was broke for a while. This is why I did the 1.4.8 upgrade, I thought it would fix it.
One other thing if you don't mind, take a look at https://atsdiagnostic.com. This store is setup to require a logged in user to see prices. However, under latest I get a little dash or underscore I think from the "specials" system. The problem is that you can click and add stuff to the cart which will show the price anyway.
Could it be the UPS module I bought from you? Maybe I should update that?
Update...
I updated the UPS modlue (Q) and now I have a different problem, click checkout and my page is just F'd! The layout is all over the place. Plus I get this error:
Notice: Undefined index: iso_code_2 in /home/www/atsdiagnostic.com/catalog/model/shipping/upsxml.php on line 136
Update...
I updated the UPS modlue (Q) and now I have a different problem, click checkout and my page is just F'd! The layout is all over the place. Plus I get this error:
Notice: Undefined index: iso_code_2 in /home/www/atsdiagnostic.com/catalog/model/shipping/upsxml.php on line 136
Ok, I got it now. Just had to update settings. It says my UserID/Password is wrong now which is weird because it wouldn't have changed, but I can probably figure this out too. Thanks for your suggestion! How about the issue with latest_home have price links when it should not?
Ok, just FYI, I put the same data from your UPS shipping module settings into the built-in one and that one works fine. I guess I will just discontinue the Q version, please don't take that personally, your stuff is great. I just need help with my last issue regarding that latest_home module. Thanks a bunch.
Pulled this from latest_home.tpl, this doesn't work correctly. I think that if(!products[$j]['special']) is validating as false everytime. Or, in other words, it exists everytime.
Actually, $display_price must be true even when it should be false. Any ideas?
Code: Select all
<?php if ($display_price) { ?>
<?php if (!$products[$j]['special']) { ?>
<span style="color: #900; font-weight: bold;"><?php echo $products[$j]['price']; ?></span>
<?php } else { ?>
<span style="color: #900; font-weight: bold; text-decoration: line-through;"><?php echo $products[$j]['price']; ?></span> <span style="color: #F00;"><?php echo $products[$j]['special']; ?></span>
<?php } ?>
<?php } ?>
It's line 26:
<a class="button_add_small" href="<?php echo $products[$j]['add']; ?>" title="<?php echo $button_add_to_cart; ?>" > </a>
Remove the space and the problem goes away. I think I will move the whole statement into the If Then structure and change the space to Add to cart. Thanks.
<a class="button_add_small" href="<?php echo $products[$j]['add']; ?>" title="<?php echo $button_add_to_cart; ?>" > </a>
Remove the space and the problem goes away. I think I will move the whole statement into the If Then structure and change the space to Add to cart. Thanks.
Do you have a country selected in your main settings area under the Local tab? The error means that you have no country selected in both the system settings and no country selected in the ups settings. That's the only way this message gets returned. But those are both required fields so I have no idea how you did it. Try the latest version.. it does a check for the country existenceGrrrr wrote:Notice: Undefined index: iso_code_2 in /home/www/atsdiagnostic.com/catalog/model/shipping/upsxml.php on line 136
It's probably just my fault somehow.
Who is online
Users browsing this forum: No registered users and 43 guests