Export Shipping & Order Information

[Doodlebuckets]

Hello! I installed this for a customer's website and she's been using it and doing fine until recently when we now get this in the file that is produced when we do an export:

Please help!

Any answer on this? Please...

[econcepts]

Argh... those stupid e-mail notifications don't work for some reason.. Anyway, is the company bug also fixed in the new version? (the bug I noticed a few pages ago)

Still thanks for the very nice mod!

I thought that was corrected, but I'll look to make sure it is in this new version.

[econcepts]

Any answer on this? Please...

Here are some links that might help you resolve this. My question would be

1) Have they upgraded to a different version of MySQL, and if so what version?

2) Did they install any other mods that affect any of the tables this mod pulls from? It could be that one of them changed the table collation?

Here are the links to look at:

http://bugs.mysql.com/bug.php?id=20123

http://www.vbulletin.com/forum/showt...ations-problem


http://www.google.com/search?hl=en&s...&aq=f&oq=&aqi=



Let me know answers to the above to see if we can narrow down what caused it.

[Briann]

I assume that it wasn't corrected jet, because (at least in the downloads section) there's not a version dated later than my post.

Just a note

This is not meant unfriendly, but just want to help.
Really, this mod is great!

[econcepts]

Ok no problem! I'll put that in this next release (working on it now).

I was working on it anyhow as I just customized it for one of my members at my site to work better with PayPal.

I'm hoping to have this new version up in these forums here within the week.

I've got 3 items (which include 2 bug fixes) that will be included in the new release.

Later versions are slated to revamp a few portions and provide more export file options (XML, etc...)

But that is later.

[stecrox]

Eric

I have downloaded the Mod, Suits one of my needs perfectly, However when I ran it the Delivery Company Name column was empty. This is a slight problem as this is required as we deliver to some Blue Chip corps.

Any help would be appreciated??

[Briann]

http://www.zen-cart.com/forum/showpo...0&postcount=99

This may be what you're looking for. The bug isn't fixed yet in the release (Eric is working on it).

[econcepts]

Yes, I have been working on the next release and that has this bug fix in it. Will shoot for having it available at weeks end here.

Will post to the board when ready.

[Doodlebuckets]

Here are some links that might help you resolve this. My question would be

1) Have they upgraded to a different version of MySQL, and if so what version?

2) Did they install any other mods that affect any of the tables this mod pulls from? It could be that one of them changed the table collation?

Here are the links to look at:

http://bugs.mysql.com/bug.php?id=20123

http://www.vbulletin.com/forum/showt...ations-problem


http://www.google.com/search?hl=en&safe=off&rlz=1G1GGLQ_ENUS271&q=1267+Illegal+mix+of+collations+(lati n1_general_ci%2CIMPLICIT)+and+(latin1_swedish_ci%2CIMPLICIT)+for+operation&aq=f& oq=&aqi=



Let me know answers to the above to see if we can narrow down what caused it.

Sorry, I never got an email saying you had replied to this. No mods were added, I am the only one working on the site. I'll look at the links. It had worked for months and then all of the sudden not.

[econcepts]

Sorry, I never got an email saying you had replied to this. No mods were added, I am the only one working on the site. I'll look at the links. It had worked for months and then all of the sudden not.

No problem. Yes, under the circumstances I listed in my response (if that is indeed the case) then it would work for months (or years) up until MySQL was altered (by possible upgrade, host changes, other means sometimes outside your control.)

Take a look at those links and let me know if they help. It seems as though the answer is in the collation of the tables.