I have this problem as well - easiest way to combat it (without having to write code) is escape the apostrophe in the field by putting the \ before the apostrophe.
Printable View
Hi there, I have found a really odd bug, I cannot imagine what could be causing it. When I use the split packing slip feature, everything works great, the packing slips comes up with a checkmark beside the products I'm shipping and an x beside the products that aren't being shipped. Down at the bottom there is the legend where it shows the checkmark and x again and lets customers know what they mean. If I print the packing slip in black and white, it works fine. But if I print in color, which I always do, the checkmark and x in the legend don't show up at all, even though they're onscreen! They show up fine when printed in black & white! The checkmark and x beside the products show up fine in color. What on earth could be causing that? It's so bizarre!!! It's not a huge deal, but I always print in color because of my logo, and the legend at the bottom looks a little odd without the check and the x. Anyone have any insight on this?
Thanks!
Hello I am having some serious issues with this contribution:
First of all I attempted to install this contribution and followed the instructions exactly and still ran into problems with running the sql because it kept telling me that there were duplicate entries. So I decided not to install and had a full backup restored by my hosting company which should have put everything back to previous. However now I am getting these errors:
I have done a search for this on the forum and was only able to find references to this module. I was also unable to find a resolution that would suit my situation. Can someone please help me if they know what might be happening?Quote:
1054 Unknown column 'balance_due' in 'field list'
in:
[UPDATE orders SET balance_due = '8.8' WHERE orders_id = 32]
I am thinking that a fresh install of 1.3.7 might be necessary.
it's urgent
Thanks
OH and I haven't updated my signature yet so my version of zencart is 1.3.6.
Take a look at step 7 in the "REQUIRED FILE EDITS" section of the readme. The update script is displaying an older setup that this step replaces.
Obviously, you should ignore that instruction in the update script (like I said, that needs major work).
Yes, to all who reported apostrophe bugs, it's caused when you have magic quotes enabled. I have fixed this issue for the next release.
At first I was going to say that it was your print driver, but then I thought about it some more...
Make sure you color ink cartridge isn't empty... :laugh:
well then you came to the right place.
Stopping you right there. If you got dupe entry errors, that means the script was already run. If you're certain you didn't do it, then your host likely installed the mod for you. Just FYI...Quote:
First of all I attempted to install this contribution and followed the instructions exactly and still ran into problems with running the sql because it kept telling me that there were duplicate entries.
That is an SO-only function (which is why your searches ended up here); it's trying to update the balance of the order, and that only occurs in SO files. Are you sure you removed admin/super_orders.php, and are no longer using it?Quote:
So I decided not to install and had a full backup restored by my hosting company which should have put everything back to previous. However now I am getting these errors:Code:1054 Unknown column 'balance_due' in 'field list'
in:
[UPDATE orders SET balance_due = '8.8' WHERE orders_id = 32]
Nope, it's not empty :) Plus, if the color is empty it automatically prints color things in greyscale, but the check and the x aren't showing up at all, it's just completely blank where they should be. Everything else on the page is printing in color, including the checkmark and the x beside the products that were purchased. I printed it off several times and it was the same each time. Only the checkmark and the x at the very bottom on the right hand side don't print in color.
Okay then back to my original theory, which is some weird behavior on the part of your printer driver. You can print in B&W, which means everything is, in fact, reaching the printer. Things only go awry when you print in color. That problem's definitely occurring on the last leg of the trip (printer output).
Try updating the print driver, or reinstall the printer completely.
Well I did already try troubleshooting my printer, did the driver update and the other things the troubleshooter suggested, but there weren't any problems. I don't really see how it could be the printer when virtually everything else that should be in color is in color! I tried printing other documents and there were no issues, and everything else on the packing slip is in color, just not those two things, I don't know what else to check on my printer? This has got to be one of the most bizarre things I've come across so far!
Same here, that's just plain freaky. Do you have another net-connected PC with a color printer nearby that you could try from?
As soon as I wrote this reply my problems seemed to have been corrected. I'll be sure to update if there is another issue.