I understand.. I was just kidding anyway.. I already knew your answer to the question.. but just in case you might say yes I had to ask..:PQuote:
Originally Posted by philip_clarke
:laugh::laugh:Quote:
Originally Posted by philip_clarke
Printable View
I understand.. I was just kidding anyway.. I already knew your answer to the question.. but just in case you might say yes I had to ask..:PQuote:
Originally Posted by philip_clarke
:laugh::laugh:Quote:
Originally Posted by philip_clarke
Right,
So in summary..as a web storeowner, not a SQL,PHP, progger..... Forget about Zencart and buy a paid solution like cs-cart?
This question should probably be posed elsewhere lest we clutter this thread with off topic discussions.. If you really want some good feedback on this topic, I'd re-post this in "General Questions" or "The Zen Pub". :smile:Quote:
Originally Posted by remoteone
Hi all.
I'm use Super orders with old 1.3.7 system
After database removing to another server Super order show empty page
Show only first line :
Order Details - # some is number Jump to Order: here some number - this line is normal..
And after that - empty... to footer...
I remove database to better server... if I use normal orders.php file link - I can see order details..
But can not see order details with super-orders.php
No changes in files ... and I dont know where can I search problem 8(
Please help
How can i uninstall this?
Manually reverse all the steps you too to install.. If you made any edits to core files, you will have to manually remove those too.. There is no "uninstall" for Super Orders..Quote:
Originally Posted by CnTGifts
DivaVocals is correct. You have to reverse exactly the steps in the install readme file, including deleting files, modifying the orders.php, and removing SQL DB entries. Tedious and time consuming, but not necessarily hard. I just did this once I found out this mod is not being supported anymore.
wow removing the mysql will be hard i dont have a clue baout how to get that to reverse
Honestly while the original author is not around Super Orders as it stands is still a useful add-on.. If you follow the install instructions, it works just fine..Quote:
Originally Posted by tcustomgolf
Super Orders is not perfect, but it is perfectly functional. ALL of my clients are happily using it. The shortcomings I see in Super Orders are NOTHING my clients have noticed or requested fixes for.
None of my clients use the bulk features.. Most don’t bother with updating the payment so the order shows as "paid" with a zero balance -- the confirmation from their payment processors is enough for all of them so they see no need to do the extra work to "show" the order is paid in Super Orders
The rest of the items on the list I posted earlier in this thread are not showstoppers.. The items on my requirements list are merely things I saw the app could use based on my experience in software development and QA. Even if none of my suggested fixes are implemented Super Order is still a very functional and USEFUL application, and I will continue to use it.
To my im findinf it just over kill, and the majority of it is stuff ill never use
And that's fine.. It's not for everyone..Quote:
Originally Posted by CnTGifts
My post was was simply addressing the concerns expressed by tcustomgolf over the mod not having a participating/supporting mod author.. The point I was trying to make there is that though there is no active mod author, Super Orders is still a useful functional mod for anyone interested in using it.. (if that's not you.. cool...:cool:)
Anyone have the instructions to reverse the mysql isntall for this?
You can safely ignore the SQL removal - it only adds some tables and a few fields into existing tables that won't be used by anything once you remove SO.
If you're really concerned about having the extra stuff around, I could put something together that you can use at your own risk :P
I agree with DivaVocals - I love the mod, I get a lot of use out of it, we use the batch forms printing and batch status updating regularly to process orders and mail out tickets. It's taken a little php coding to get the paypal payments entered so that the balance due shows $0, and so we can filter orders by shipment type, but it was worth it for me.
**Nods in agreement**Quote:
Originally Posted by carlvt88
Question regarding the bolded section.. If I recall correctly, you posted your code to do this in this thread correct??
Re paypal payments - Yes I did, another user posted an alternate approach also. I took the approach of intercepting the paypal transaction and adding it to the payments. The other approach was to look at paypal transactions when generating the report.
For the shipment filtering, I didn't post it. It's a bit more spread out - basically duplicating other filters but it affects several files in several locations. Seemed too messy, but I could probably dig that out if there's general interest. Shouldn't be too tough, as I use svn for all development.
Agree with all...a great mod for sure, and though it was a bit of overkill for me to use, the most important was that since the author has decided not to support it any longer, then what if further versions of Zencart render it obsolete. There could quite possibly be changes in zencart that could break super orders in the future.
My point being, that I like to keep my zencart, and the mods I use, current and like to see continuous development of the mods with new features, and with changes that will keep them current with each new zencart iteration.
And as DivaVocals says, it is not for everyone, but still very functional and useful.
At a minimum, just delete the tables it creates to keep your database free of unnecessary stuff, make it smaller, faster, etc.Quote:
Originally Posted by carlvt88
The super.orders_sql.sql file in the mods download shows what tables it creates. Go into your phpmyadmin of your host (if on a unix/linux host), load up your Zencart database and drop those tables.
If you are referring to Zen Cart 2.0, NONE of the current Zen Cart add-ons will be compatible with ver 2.0. Every add-on availble now will have to be re-written for ver 2.0.Quote:
Originally Posted by tcustomgolf
As for Super Orders: Until recently, the version available since Oct 2007 (rev 46) was written specifically for ver 1.3.7 of Zen Cart.
Version: 2.0 (rev 46)
Zen Cart™ Version: v1.3.7
Update added on Oct 20 2007
Rev 46 or Super Orders ran (still runs) fine for anyone using it with ver 1.3.8a of ZenCart. Further proof of this can be found in the MANY add-ons written by popular Zen Cart developers who include super_order.php files in their CURRENT add-ons to accomodate those store owners who use Super Orders..
The CURRENT version of Super Orders made only a small minor change to Super Orders..
My point is that as far as stability and compatiblity, Super Orders is both stable and compatible. Most of what you see posted in this support thread isn't about either one of these issues. Most of what's posted in this thread are basic setup questions and folks posting ways to improve Super Orders..
Compare this to Google Checkout, WordPress on Zen, or other mods that have no real owner/developer and are far from stable or even fully functional mods REGARDLESS as to what version of Zen Cart you use..
Fair enough, but not all mods necessarily need continuous development to work with current versions of Zen Cart.. (at least if we're only talking about ver 1.3.x) Changes to the 1.3.x version of Zen Cart would not necessarily render an add-on unusable or obsolete or even in need of an update.. There are LOTS of stable mods that have had almost NO changes made to them and they all still work as they should through a few 1.3.x changes.. Depends on how the mod was built and if changes to the core code files will have an adverse affect on the mod.. Personally this is why I keep a test store up to test changes to mods and Zen Cart to help me to decide which changes I will incorporate for my clients..Quote:
Originally Posted by tcustomgolf
Again different strokes.. But this is why I personally like to read an entire support thread before jumping into any mod. I read the Super Orders thread before I ever installed and tested it on my test store and realized that though the original developer isn't active here, the community certainly IS active here.. Unlike the afore mentioned mods, I saw that NONE of the posts were about a lack of functionality or even a mod that failed to work.. The posts in this thread are mostly about a mod that could use some improvements (and MANY have posted excellent solutions for improving Super Orders) but which mainly does exactly what is says it will do.. But it ain't for everyone..
Diva,
Not sure why you think I am trashing Super Orders in your first point, never did. I totally agree with you, and believe Super Orders is one of the most function rich mods out there, simply amazing what he has done with it, and yes, still works like a charm and extremely stable.
As for point 2, I think it is fair to tell a newbie that a mod is no longer being supported by the original developer, who for the most part, will be the most knowledgeable person for support issues and development going forward, which again leads to my preference that I would rather have a fully supported mod on my site. Just my preference....no one has to act on it.
Not sure why you think I think this since I never made any direct statement to this effect at all... :smile:
It sure is fair to tell this to a newbie.. I'm pretty sure I didn't try to imply that we should keep this a secret now did I??:laugh::laugh: In fact it's probably more fair to say that with ANY open source solution there is always the risk that support may disappear in the blink of an eye for not only mods, but apps as well..Quote:
Originally Posted by tcustomgolf
as for the second part of your statement, there are plenty of apps that are being supported or lead by someone other that the original developer.. So IMHO, it's not simply a matter of whether or not it's the original developer supporting it or a new developer, but stability and functionality should also be factored in.. As you have stated.. this is MY preference/approach.. Not everyone will agree.. I do hope it's still okay to have discussions on different approaches to site dev.. right??
Quote:
Originally Posted by tcustomgolf
Hi,
I just clicked on Batch Status Update, did a search, and then it asked me to login again. So I logged in and then clicked on a link and it asked me to log in again. So I logged in again and clicked on a link and it asked me to log in ...again.
So now I'm stuck and I don't know what to do. :unsure: I can't click on anything in admin without it asking me to log in again.
Please help!!!! :cry:
Sabre
It's likely that a file is missing in your install.. Try re-installing Super Orders and see if that corrects the issue.Quote:
Originally Posted by MoonCow
Wow! That was a fast reply, thanks. :smile:Quote:
Originally Posted by DivaVocals
Ok, I re-uploaded all the files again (overwriting the other ones), but I've still got the same problem. :dontgetit
Earlier today, I renamed the admin folder - could this have anything to do with it?
Sabre
Renaming admin is pretty easy - just update the config files. One problem that keeps biting me is the existance of backup files in my directories (e.g. blablabl.php.bak residing in the includes/classes or extra functions directories).
Only if you did not make sure to copy any Super Orders admin files from the Super Orders admin folder to your newly renamed admin folder.. Sounds like your renamed admin folder does not have Super Orders admin files.Quote:
Originally Posted by MoonCow
Is there a way to put UPS Shipping methods into Super Orders?
Right now it only says UPS but not Ground, Overnight Etc....
And it doesn't say it on the invoice either.
So its quite difficult for the shipping person to back and forth to Orders and Superorders to figure out how to ship an item.
The fix to this has been posted a few times in this thread.. Search this thread for "detailed shipping"..Quote:
Originally Posted by milobloom
BTW you should follow the instructions in the readme file for hiding the default orders.php. Less confusion for the back office staff, and order management is being handled in a consistent manner..
Zen Cart 1.3.8a
Patch: 1::
Database Patch Level: 1.3.8
I cannot amend customer invoices which are sent automatically at checkout, for single purchases not too much of a problem but for multiple purchases the shipping adds up, I can amend the shipping in Super Orders but the customer still receives the auto invoice with a link to "detailed invoice" not much use really, as I prefer to send an adjusted invoice manually is there any way (apart from blocking sent emails) I can access the invoice before it is sent, I am sure that buyers are not going to pay excessive shipping and hope that I will refund, I managed to intercept a buyer yesterday and sent him the revised shipping but I cannot do so every time;
Shipping is set to zone rates at present
Have you already gone through other methods of getting the right numbers before checkout - for example, using the Table rate shipping module which can use different rates based on either weight, item count, or total cost? Or you could make a new shipping module based on your needs, maybe different table-rates per zone, but it seems like you'd want to intercept this before final checkout.
Hi Carl, Thanks, I sell scale models all different weights and sizes, I also like to make a slight reduction the the total price, I have managed to avoid Paypal direct elsewhere but have to use it on zencart, I really do need as you say to amend the invoice before it is sent but using IPN the buyer fills his cart (hopefully) and then checks out, it does not seem possible to intercept, With say 5 items the shipping could total €40,00 on top of the model cost, I can refund as I did last week as I knew the buyer
KR Brian
DOn't want to get too far off topic for this support thread, but Carl is right.. The shipping calculations should be aaccurate when the sale is finished.. Super Orders won't help you with that.. It sounds like you need a different shipping module. One which is designed for products with different rates for shipping.. You might want to give this module a looksee:Quote:
Originally Posted by expat
http://dev.ceon.net/web/zen-cart/advshipper
Thanks Diva, I will have a look tomorrow, I buy from a retailer who has the same set up as ZC, each models s&h is added up, sometimes!! they correct manually, not an easy problem to solve, stopping the buying success email would help I can then send my own
brian
Hello dears.
I installed super orders and IH2, all work fine except when my customers ordered 4 or more products , the images of the products are not shown in packing slip.
However, if there order 3 or lesser products, the products image will be shown.
ANYONE CAN HELP ME ON THIS ISSUE?
THANKS!!!
This was intentional. If you want to change it, it's in admin/super_packingslip.php:
$display_images is effectively a boolean. You can change the limit to something bigger, or hard-code $display_images to always be true.Code:// Add product images if there are 3 or less products on order
if (sizeof($order->products) < 4) {
$display_images = 1;
}
else {
$display_images = 0;
}
Thanks for this.. Would be nice if this was an admin configurable option. Though I'm not sure I understand the logic behind the default option..:laugh::laugh: (three seems abitrary:laugh::laugh:) Though this is not an issue for my clients (most don't use the packing slips for whatever reason), knowing that this is how the code is structured is a good piece of information..
Carl can ya help out a code challenged girl.. What would I replace this code with if I simply wanted a images true or false option. Would I simply replace this:
with this:Code:// Add product images if there are 3 or less products on order
if (sizeof($order->products) < 4) {
$display_images = 1;
}
else {
$display_images = 0;
}
Code:// Turn product images on or off on packing list
$display_images = false;
Quote:
Originally Posted by carlvt88
Yep - that should do it. I was thinking it would be a neat homework assignment for me to figure out how to put it in the admin controls, maybe someday.
I actually think Frank had a good idea by setting it at 3. The stock packing slip doesn't have any pictures. This gives you a picture if you only have a couple of items, but doesn't waste a lot of paper if you have many items on the order. But of course, what worked for his client may not work for another - that's why we're here :cool: A larger value might work better than hard-coding a true value.
Hi,
i installed super orders in sub directroy in root but cant see any menu link in customer even i did all changes in code as in readme file ..And even try ti open super_orders.php directly its not working for me...can anyone tell what is the reason?
Thanks for the confirmation!!! I'm currently in the process of securing a developer to fix a few of the Super Orders quirks for me, along with some nice to haves I think would nice to include. Still working on the spec and securing a developer, but hopefully this will come to be.. Perhaps I'll add this to my spec.. I'd like to share it with the community when finished.. Not sure yet if I can share it with the community.. (I really want to believe me..) The client is paying for the changes, and he may not be okay with me sharing code that he has paid for.. Once we really get this in the works, I'll ask him to consider the idea..Quote:
Originally Posted by carlvt88
This makes sense.. Personally I just wanted to shut off the packing slip images.. (and now thanks to you I know how to!:smartalec:) IMO it's a nice to have, but ultimately adds no real value to the packing list.. (JMHO) As you pointed out the default pack list doesn't have them, then there is the issue with the packing list images printing out distorted looking.Quote:
Originally Posted by carlvt88
Very true.. that's this would probably be a good candidate to include as an admin configurable item..Quote:
Originally Posted by carlvt88
Explain this.. It sounds like you have installed it incorrectly..Quote:
Originally Posted by SameeraRehman87
http://www.zen-cart.com/forum/images/smilies/smile.gif
Suggestion: insert or allow for insertion of BarCodes and Data Matrix image - a two-dimensional matrix barcode on tickets or printed receipts. Just a thought.
Great idea!!! Will you be contributing a new version of Super Orders with this feature??:smile:Quote:
Originally Posted by jlr1
Hey BlindSide I have installed SP 2 but "sales report" does not appear under Reports. Any clues
Zen 1.3.8
No upgrade
Addons - Where did you hear about us, Captcha, Confirm email
No Customization
Thank you
Help, I just installed Super Orders with version 1.3.8 of Zen Cart.
The module seems to be working fine, but when a customer checkout out, on the last page they are asked to "Comfirm Your Order" once the button is clicked, they get an Internal Error Message 500, Misconfiguration error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Anybody have any idea what causes this and how to fix it?
This is what I've done, I copied the file to a catalog directory, which I realized later that it was wrong. I ran the SQL patch from the admin tools.
The I noticed it was in the config area but no where else. The I realized I copy the files to the wrong place and then copied then to the 'admin' and 'includes' directory. then all the reports are showing up. I just need to know what is causing the checkout error. this is going to scare my customers.
This question may have been covered previously so please forgive me if it already has. When you edit a order with super orders can it recalculate the shipping charges. For example if you add an item to the order then the shipping will be different. Any thoughts on how to do this?
Not part of the current version of Super Orders. You can manually edit the order, manually re-calculate the shipping and manually edit the order to reflect the new shipping. You will still need to send your customer an invoice and collect the money for the increased shipping NONE of which Super Orders will automate for you.Quote:
Originally Posted by stealth768
LOVE the Super Orders contribution.
I only have one issue so far.
When I click to send an email to a customer through Customers>Super Orders, FCKEditor is not loading even though it's shown in the drop down as my default editor, as it is for everything else.
"Note: You are using TEXT only email. If you would like to send HTML you need to enable "use MIME HTML" under Email Options"
What do I need to edit or enable for FCKEditor to function with this mod?
Thank you.
This isn't a Super Orders issue.. Super Orders only re-directs you to the mail.php feature in Zen Cart. You need to search the forum for a solution or post a new question in a seperate thread..Quote:
Originally Posted by jabbawest
Really, you're sure?Quote:
Originally Posted by DivaVocals
For ME this issue only applies to the Super Orders mod since it is the only mod I have that the FCKEditor has not integrated with.
I'm SO sorry I DID NOT post the FACT that I DID do a search of the entire Community/Forums for something related to this issue.
Maybe you could point me in the right direction instead of chiding me for not doing a thorough enough search??
DivaVocals
Posts: 1,116
jabbawest
Posts: 12
http://sterlingleafjewelry.com/images/smiley-bow.gif
I think that you are misunderstanding DivaVocals' intent here. You're not being chided, just guided.Quote:
Originally Posted by jabbawest
She probably doesn't know the specific answer (I don't either, it's fairly specific) but she believes that you're looking in the wrong place and has stepped in to try to help you to avoid wasting time going down a blind alley, when the answer most likely is to be found elsewhere.
Thank you! Kuroi, you are a gentleman!:yes:
Quote:
Originally Posted by kuroi
Jabba,
I'm POSITIVE about this. If you look at the URL of the link you are taken to, the mail.php is a standard ZenCart feature. The default orders.php takes you to the exact same URL. So if there is an issue from the mail.php page, that would indicate that the issue lies elsewhere.
and honestly instead of assuming that my response to you was based ONLY on the number of posts you have in this forum (which makes NO DIFF to me BTW), you could simply ASK me to verify/clarify my response. Instead you chose to write this response here and then back it up with a private message to me.. WHY?? You wanna talk about bad form?? This is bad form, and TOTALLY unecessary..
I suggested a search for an answer since OFTEN answers to issues can be found that way..
I suggested posting a new thread so you could get some actual assistance with your issue versus getting no closer to an answer by engaging in an "off-topic/flame" response in the Super Orders support thread..and since I know that "off-topic posts in support threads are generally frowned upon, I suggested creating new thread..
I'm not the only one here who would have suggested this, and these things were often suggested to me in my early days on this forum. So I pass on the suggestion to HELP others get along around here. Now, if you considered that "chiding", then really... you are reading far too much into my post, and blowing the INTENT of my post out of proportion.
I was TRYING to help... YOU over-reacted, plain and simple..:yes:
Quote:
Originally Posted by jabbawest
I shouldn't have to waste my time asking for clarification.Quote:
Originally Posted by DivaVocals
Early days huh?
When I saw someone asking for help in a support forum I would find a path for them, (and post it) or give them a direct and informative answer; not some vague, "you need to search harder" answer.
Sorry.
I hope we can end this soon. Feathers have been rustled - I hope intents have been clarified - can we move on?
I'm done and moving on.Quote:
Originally Posted by carlvt88
Seriously??? Jabba.. You are making an issue out of NOTHING here.. You need to ask for clarification when you CLEARLY have misunderstood my post.. (which you CLEARLY did) I tried to clear the air, and you seem to just want to be MAD.. If that's a waste of time, if you are still MAD even after that, then so be it.. :unsure:Quote:
Originally Posted by jabbawest
As Kuroi has pointed out THERE IS NO THREAD TO POINT YOU TO!!! I gave you a "direct and informative answer". You read MORE INTO IT and over reacted.. Now instead of wasting time HERE flaming me, post your issue/question in a separate thread so you can get an ACTUAL answer to your issue.. Your issue is not an issue with Super Orders.. (which I've said in all of my posts..)Quote:
Originally Posted by jabbawest
Oh I'm beyond done..:smile:Quote:
Originally Posted by carlvt88
So what module should i pick to do something about the current (horrific) interface of the orders?Quote:
Originally Posted by philip_clarke
All i need is do some reporting on payment methods, say an overview of all customers payed with paypal last month
we also really need multiple orders to be able to update the status at the same time.
there are other things we would like, but the above are becoming must-haves as orders per day are growing
thanks for any suggestions,
jeroen
Super Orders is a good module.. I'll admit it has a few quirky things that need to be fixed, but it's a good add-on which expands the default orders.php module.. I use it along with the Admin Notes add-on for my clients (I'll post a link for that once I get to work..), and that seems to be a good 1-2 punch for my clients.. As for reports, you might wanna head over to the Add-Ons section.. There's a few additional reports that you might find handle some of your reporting needs.. There's a sales and payment report if memory serves me that you might find useful..
Quote:
Originally Posted by nagelkruid
Thank you for the response,Quote:
Originally Posted by DivaVocals
I am running superorders in my test setup and i was lucky, it installed like a charm :smile:
I am hesitating to put it full blown in my liveshop because of a few reasons
1st - i don't get the logic behind the payment types option that it adds. why would i add payment types and what would i need to use it for
My customer allready pay with iDeal, (dutch bank transaction), paypal, or moneytransfer.
It is also very much pressing the purchase order method, which i installed and then disabled as i don't have a need for it.
I don't understand why this payment method should be part of this module?
2nd - i like the ability to select multiple orders and update their status, one of the 2 things we REALLY need. Is that working in the latest .47 revision as i have seen some issues with it, but i can't figure out what's fixed in which version.
3rd - are there any obvious things i should fix within this distribution that i should fix, i did spend about 4 hours on this threat trying to pin on fixes i need to make, but best i came up with is twisting some image height setting and thats about it.
I know there is something with PayPal ipn, which i use, but it is unclear to me what exactly it is and if it is allready fixed.
Appreciate any input you may have as i am very eager to use this module for the multi-update feature.
Thanks,
Jeroen
Often time add-ons are custom apps the author built for his client which they have packaged up and shared with the community.. Since it's custom software based on a specific client's specs, occasionally there are features that are specific to that particular clients needs. Such is the case with Super Orders. That said it is still a VERY useful app which is why many of us love and use it..
As for fixes, there are lots of posts in this thread which I'm afraid I don't have memorized.. Somewhere in this thread I posted some referential links to some of these posts.. You might wanna do a search through this thread for some of my posts to find those threads.. Also do a search in this thread for phillipclarke, carlvt88 and tophand's posts.. They always post very useful information here..
I just dug in and simply spent a day going through this thread and making the suggested fixes along the way. Also there are several suggested fixes in the readme file that I also took some time to go through and add to my Super Orders files.. HTH
Quote:
Originally Posted by nagelkruid
Thanks, i can see the potential, yes.Quote:
Originally Posted by DivaVocals
Are you using superorders to set multiple orders in different states at the same time?
Is it working and are customers notified?
Thank you,
Jeroen
Frankly none of my clients are using the batch order update feature.. they're all small boutique like shops.. so the volume is never that high on any given day for them to need this feature.. I've done testing on multiple orders, but all to the same client.. I can only assume it works since the one test client received the notifications..Quote:
Originally Posted by nagelkruid
That is one of my primary uses - setting dozens of orders to 'delivered' in one shot. I've also tweaked it so that if we change the status to 'willcall', an email is generated using a template in catalog/email with instructions on picking up tickets at the willcall desk.
We also use the batch invoice functionality. It's a little odd when you have many (>5) invoices at once since the browser is jammed with many frames, but it works well. Again, I tweaked it to align the mailing addresses to the window envelopes we use, and to add other event information at the end of the invoice.
Does this mean that it settles all the old orders, and for new orders we need to continue to manually settle and close the order?
Quote:
Originally Posted by philip_clarke
Thanks carl, thats exactly what i need.Quote:
Originally Posted by carlvt88
Is there any of you that knows or uses the data types.
I have played with it but i cant find the purpose. Only thing i can think of is that it may be used with the PO module and that you can select these data types for that module as the payment type once the order is paid?
As i will disable the PO option altogether, i think i can just make the payment type option, the cash report and the other report unavailable from the menu in the admin (as these will not be used/function anyway).
Just want to make sure that i wont break or miss out any cool options if i do so?
Thank you,
Jeroen
sort order = 999 is the default assigned to the ot_total class in the orders_total table. You can change the sort_order via admin in the menu under modules, but if you do, the above query will behave differently :cool:Quote:
Originally Posted by philip_clarke
while we are on the subject, why not add the dates to this as well:
andCode:update so_payments sp, orders_status_history osh set sp.date_posted = osh.date_added where sp.orders_id = osh.orders_id AND osh.orders_status_id = 1;
Note that the ordersatus id's represent 1= order accepted, and 3=order executed, which may different for others.Code:update so_payments sp, orders_status_history osh set sp.last_modified = osh.date_added where sp.orders_id = osh.orders_id AND osh.orders_status_id = 3;
when i execute these, i add the prefix for my tables and apply them via dbadmin as the sql patch tool has given me errors too often. Not sure if these will work in that tool.
Cheers,
Jeroen
Then you may be the man to help me fix a long standing issue with Super Orders..:smile:Quote:
Originally Posted by carlvt88
I KNOW you've come up with a fix for this.. Would you be so kind as to share it with me???
- [FONT=Times New Roman]Batch Status Updating & Batch Printing throws errors when you search for orders using the following options:
= (equals)
< (less than)
Error messages:
[/FONT][FONT=Times New Roman]"1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''50' ORDER BY o.orders_id DESC' at line 4
in:
[SELECT o.orders_id, o.customers_id, o.customers_name, o.payment_method, o.date_purchased, o.order_total, s.orders_status_name FROM zen_orders o LEFT JOIN zen_orders_status s ON o.orders_status = s.orders_status_id WHERE s.language_id = '1' AND o.order_total '50' ORDER BY o.orders_id DESC]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields."
[/FONT][FONT=Times New Roman]"1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '== '13' ORDER BY o.orders_id DESC' at line 4
in:
[SELECT o.orders_id, o.customers_id, o.customers_name, o.payment_method, o.date_purchased, o.order_total, s.orders_status_name FROM zen_orders o LEFT JOIN zen_orders_status s ON o.orders_status = s.orders_status_id WHERE s.language_id = '1' AND o.order_total == '13' ORDER BY o.orders_id DESC]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields."[/FONT]
Philip wrote of this on page 125 of this thread - he's much more security conscous than I am but suggesed one fix. I'll try to look at that tonight, but I don't generally use those - I usually search by status code or shipment or payment method instead.
carl,Quote:
Originally Posted by carlvt88
can you please set me on the right track here, i would like to add papal IPN stuff in the correct places and even more i will want to report on paypal totals and paypal costs.
thanks,
Jeroen
I guess the right approach depends on your needs. I'm doing the store for myself so I can be a little less complete than if I were providing a store to someone else. Also, I don't know where your comfort level is in playing with the database or coding with PHP and/or SQL.
For the SO reports, I actually think that the approach of making the reports check the paypal history for transactions may be a safer and cleaner way than what I did, but I was already down a certain path. My method of catching IPN transactions as they come in and posting to the SO tables keeps the database complete, but one could argue that the same data is being held in two places which usually is frowned upon.
Some other things that bother me with my implementation is that I don't get correct coloring of refunds, and the transactions are labeled 'parent' instead of something more usable like 'refund'. Maybe I'll fix these in the report generation functions. But, even with some complex payment reversals and reversal denials, it captured everything correctly and I've used this for two years now.
I'm happy to share code, but I don't think it's robust or documented enough to post for general sharing.
Same is true for the paypal fees. I added the fees capability to the cash report (I believe that's part of the sales-report package). It too works, but I haven't extensively tested it and simply hacked it together in an evening for a proof of concept. Dinki posted an sql query that would provide a result, but not in a report format (see post 395).
Same here, one shop, the lady doing the sales and me doing the coding :wink:Quote:
Originally Posted by carlvt88
I didn't get that far yet, cash reports are not working and if i try to modify something in SO it pops me to the main page.Quote:
Originally Posted by carlvt88
Something to be fixed there, but this is not primary concern right now.
appreciate if you have anything useful i could use, but if it is in the cash reports i will probably have some fixing to do before i can put it to use in our shop...Quote:
Originally Posted by carlvt88
Cheers, i am actually looking and working at/with sales reports, originally coded by blindside and ammended by Ceon.Quote:
Originally Posted by carlvt88
That code comes close to what i need on the short term, which is an easy oversight of, say, sales over the past month with results for each order, orderid, total cost of order and paypal fee. then i want to export that in csv so i can easily import it in my bookkeeping program.
Jeroen
i finally got the guts to run the code. It date stamped all the 'Date Posted' to 11/30/1999 00:00:00. Is there a way to run a statement to change the dates to the actual date of which the payment was made?
Code:insert into so_payments (orders_id, payment_amount)
select orders_id, value from zen_orders_total zot where zot.sort_order=999;
I did that with the code in http://www.zen-cart.com/forum/showpo...postcount=1466Quote:
Originally Posted by mooomers
set the id in the first query to the status id that your orders get when they arrive in the shop.
Jeroen
Should be long standing indeed, as the = in the array is set as == which would never work in that statement.Quote:
Originally Posted by DivaVocals
The <= is probably not working, either because of browser issue or some cleaner stripping html tags.
To make it work you could do this, first rewrite the array in <admin folder>/super_batch_status.php:
now adjust the SQL query build to match the id's:Code:$ot_sign = array();
$ot_sign[] = array('id' => '1',
'text' => ' > ' . DROPDOWN_GREATER_THAN);
$ot_sign[] = array('id' => '2',
'text' => ' < ' . DROPDOWN_LESS_THAN);
$ot_sign[] = array('id' => '3',
'text' => ' = ' . DROPDOWN_EQUAL_TO);
finally, have a last look at these fields, as you will probably never use em while they're error free :cool:Code:if (isset($_GET['order_total']) && zen_not_null($_GET['order_total'])) {
if ($_GET['ot_sign'] == 3) { $sign_operator = '='; }
elseif ($_GET['ot_sign'] == 2) { $sign_operator = '<='; }
else { $sign_operator = '>='; }
$orders_query_raw .= " AND o.order_total " . $sign_operator . " '" . (int)$_GET['order_total'] . "'";
//$orders_query_raw .= " AND o.order_total " . $_GET['ot_sign'] . " '" . (int)$_GET['order_total'] . "'";
}
Jeroen
Wow!! Color me GRATEFUL!!!:clap: Gonna try and test this tonight..
Quote:
Originally Posted by nagelkruid
I never used ANY of the batch functions because they were buggy and not FULLY functional.. Color me picky, but I like for things to work in full not in part.. :laugh: I'd disclose the bug to my clients so they could avoid the error.. Since most of my clients run small boutiqueish type stores, they all never felt like it was something they needed so they all chose not to use it.. But hot dog.. Boy am I happy to see you show up..Quote:
Originally Posted by nagelkruid
So if I post up some of my other pet peeves/errors you help with those too???:smile:
haha, at least you are not afraid to ask, lol.Quote:
Originally Posted by DivaVocals
well, as i am a father with 3 young children, just picked up a bachelor study, have a busy 40+ hour job, running a webstore next to that and trying to write something commaseparated that will flow right in our bookkeeping program, and fully aware this open source stuff is only open to mad street dogs, i guess i'ld say shoot any pet peeves/errors you may have just as long as you don't expect anything in the short term :lamo:
I just wonder, did you ever consider a basic php course, because if these errors are bugging you so much, they are fairly easy to solve with some determination and a little idea what php is about...
Cheers,
Jeroen
Nope.. Not afraid to ask at all..:laugh: It's part of what makes me a pretty good Business Analyst.. PERSERVERENCE!!! Okay.. I'm not unreasonable at all.. if you are willing to help, I'm willing to accept, and willing to be patient since you you are under no obligation to help ANYONE just 'cause they asked..:smile: I get how the world of tech forums work.. :smile: No one is obligated.. It's all a volunteer activity..
Given it some thought.. Been on the fence about this for a while.. The real issue for me is time.. Got a busy day job, busy side gig, drag racing, auntie duties, etc.. Despite that, I've gotten by so far.. with a little resourcefulness.. :smile:But truthfully the things that really are over my head I'll research to death to find answers, and anything after that I've outsourced to those much smarter than me as needed.. Been trying to find someone to make changes to Super Orders for me.. Besides the errors/malfunctioning issues, there are some functional changes I'd personally like to see in Super Orders.. (somewhere in this thread I outlined them..)Quote:
Originally Posted by nagelkruid
Quote:
Originally Posted by nagelkruid
Okay.. so here goes... :smile: Two things:
Enter Payment function - If you check the "Notify the customer?" checkbox, the customer is notified. However, the "Status History" for the order indicates that the customer was not notified. Flag need to be fixed to accurately reflect the correct customer notification status.
and this
Batch Printing function - When no orders are selected, the error message should be a user friendly on-screen error message versus the very unfriendly message it shows now (which scares end-users): "Warning: Invalid argument supplied for foreach() in /home/content/o/v/e/USERNAME/html/FOLDERNAME/zentest1/admin/super_batch_forms.php on line 341
Error: No orders selected!"
Quote:
Originally Posted by nagelkruid
Those are pretty valid, thanks for letting me know as i didn't come accross these yet. I'll look at those.Quote:
Originally Posted by DivaVocals
Jeroen.
The notify the customer bug was fixed in version 47 of SO. If this isn't the issue or you can't upgrade, I could dig out the code...
Let me test this again..:smile:Quote:
Originally Posted by carlvt88
Okay.. So I just re-tested.. At first it didn't work.. Initially I had the exact same issue. (only opposite) When the the customer was not notified, the legend seemed to indicate that they had been..
I knew that the FEC add-on had code in it's super_orders.php file to correct the notification issue as well. So I was installing FEC anyway so I used Winmerge to merge the FEC code into the super_orders.php file. I grabbed the notification code from the FEC version of the super_orders.php file and replaced the rev 47 notify code, and it now works with the correct legend flags..
Not gonna do it now, but I'll have to go back and do a vanilla install of Zen and Super Orders to see what I did to break the Rev 47 super_orders.php file.
So just wanted to follow-up with my testing of these changes..
I applied these changes to not only the super_batch_status.php file, but the super_batch_forms.php as well.. It appears that this has fixed the SQL errors as well as the errors that would ocurr if you clicked the "Search" button on either the batch print or batch updates pages, when no order search criteria is entered.
I've been pounding away at it, and it works.. No more errors..
There is one small thing: Using the Order Totals "=(equals to)" option does not bring back any results no matter WHAT you type into the field.
Any thoughts?? Obviously, truly this is minor in the scheme of things..
Anyway, just wanted to say thanks.. This worked perfectly!:clap:
Now I am going to figure out once and for all why some of the Super Order form fields (particularly "textarea") act strange in IE.. another long standing pet peeve..:smile: Experimenting with this as we speak..
Quote:
Originally Posted by nagelkruid
So apparently this has been a long standing issue going back as far as November 2006 from what I can see.. I can't simply tell my clients to "use Firefox" as a solution.. Most won't, and I knew there had to be a REAL solution.. Searching through this support thread I got a hint of what the root cause of the issue might be. (http://www.zen-cart.com/forum/showpo...&postcount=289)Quote:
Originally Posted by DivaVocals
Turns out that it's related to an IE bug and how it interprets the display width for textarea elements. Apparently this bug affects IE 6 & &, but I can report that IE 8 is also affected by this bug. (whether you view the page in IE 8's very lame compatibility view or not)
I have a down and dirty fix for this which I will share the specifics on with the community when I get home and make the changes..
To summarize: The down and dirty the fix requires that both the super_batch_status.php file need to be modified so that the notification checkboxes appear below and not to the right of the comments field. My research indicates that if you wanted to retain the current layout for the notification checkboxes, then you would need to use containers with a width set to 100%. A quick look at the super_batch_status.php file tells me that this would probably require a re-write to this page to format things correctly (ie: going tableless). I'm gonna pass on this and go for the quick and dirty fix since it effectively resolves the immediate issue. Wanted to share my find with the forum.
Given the age of this issue.. I figured I wasn't the only one looking for the answer.. :smile:
Cool, i couldn't test with this as i have made a small amendment that will start both forms with the first option as the default (order taken) as those are the orders you will want to either print or do the update on and it saves an extra click.Quote:
Originally Posted by DivaVocals
However, when i click on print with no orders selected i will still get that error in the output screen. Should be easy to prevent with a little javascript when i get to it.
That is because the form is transferring any number you put in there to an int, which basicly renders this useless.Quote:
Originally Posted by DivaVocals
If you have or make an order that is exacly 1, or 2 or 5 dollars, then if you search for that order it will pop-up.
I was looking to do something like, if you put 10.15 in there, i will take the int +1 -1 and do a search for anything between 9 & 11, which could be more useful. and probably more what people expect when they but an amount in there.
Coding that up takes a bit more time.
You're welcome :smile:Quote:
Originally Posted by DivaVocals
Noticed that too, i bet you, it can be fixed somewhere in the cssQuote:
Originally Posted by DivaVocals
cheers,
Jeroen
Yep.. Just saw that this morning on the super_batch_forms.php page:Quote:
Originally Posted by nagelkruid
Interesting because when you click "Update on the super_batch_status.php page with no orders selected, you at least get a message ofQuote:
Warning: Invalid argument supplied for foreach() in /home/content/o/v/e/overthehill/html/zen138.overthehillweb.com/admin/super_batch_forms.php on line 349
Error: No orders selected!
IMO the two pages should have consistent behavior when no orders are selected. Gonna take a look and see if I can figure this out.. Would you be so geneous as to share your javascript solution?? Sounds better than what I have planned.. (Yep.. still not afraid to ASK!!:laugh::laugh:)Quote:
Error: No orders selected!
Yeah I figured as much.. I think I'm gonna comment the option out for now.. I don't think it would be missed..Quote:
Originally Posted by nagelkruid
A bit more than CSS.. See my post right above.. This is yet another of those lovely (stupid) IE bugs which affects IE versions 6, 7 & 8. Gotta down and dirty fix, but the real answer is that the super_batch_status.php & super_batch_forms.php should be re-done so that they are tableless. Gonna use my down and dirty method for now.. I may roll up my sleeves and have a real go at converting them to tableless pages this weekend..Quote:
Originally Posted by nagelkruid
Fixing textarea so it displays correctly in Internet Explorer (confirmed display bug in versions 6, 7, & 8 of IE)
So I took a look this morning.. Tackling making this page tableless is a quite a bit of work. (More than I want to do right now..:laugh:) So here's the down and dirty solution (this solution works in my testing.. your mileage may vary..):
First we have to move the checkboxes to their own row. Apparently IE renders textarea elements incorrectly if there are elements to the right of the textarea element (in this case it's the checkboxes). In admin/super_batch_status.php find this:
Replace with this:Code:<tr>
<td class="smallText" valign="top"><?php echo HEADING_ADD_COMMENTS; ?></td>
<td class="smallText"><?php echo zen_draw_textarea_field('comments', 'soft', '50', '4'); ?></td>
<td class="smallText" valign="center"><?php
echo zen_draw_checkbox_field('notify', 'on', false); echo ' ' . ENTRY_NOTIFY_CUSTOMER . '<br>';
echo zen_draw_checkbox_field('notify_comments', 'on', true); echo ' ' . ENTRY_NOTIFY_COMMENTS; ?><br /><br />
<input type="submit" value="<?php echo BUTTON_UPDATE_STATUS; ?>">
</td>
</tr>
Now we need add a new label for the checkboxes. Go to admin/includes/languages/english/super_batch_status.php under line 40 add this:Code:<tr>
<td class="smallText" valign="top"><?php echo HEADING_ADD_COMMENTS; ?></td>
<td class="smallText" colspan="2"><?php echo zen_draw_textarea_field('comments', 'soft', '50', '4'); ?></td>
</tr>
<tr>
<td class="smallText" valign="top"><?php echo HEADING_NOTIFICATION; ?></td>
<td class="smallText" colspan="2"><?php
echo zen_draw_checkbox_field('notify', 'on', false); echo ' ' . ENTRY_NOTIFY_CUSTOMER . '<br>';
echo zen_draw_checkbox_field('notify_comments', 'on', true); echo ' ' . ENTRY_NOTIFY_COMMENTS; ?><br /><br />
<input type="submit" value="<?php echo BUTTON_UPDATE_STATUS; ?>">
</td>
</tr>
Optionally you could make one small adjustment in your admin stylesheet (admin/includes/stylesheet.css) as follows:Code:define('HEADING_NOTIFICATION', 'Notification:');
Change this
To this:Code:textarea {
width: 80%;
}
Code:textarea {
width: 95%;
}
Quote:
Originally Posted by DivaVocals
i'm not sure i did it right, but it doesn't seem to work for me when doing this inside admin. :(Quote:
Originally Posted by nagelkruid
did you get an error ?Quote:
Originally Posted by mooomers
if so, what was the error message.
If you didn't get an error but it didn't work, you should check your order status number to be correct.
yep! this is the error i got after executing it:Quote:
Originally Posted by nagelkruid
Quote:
1146 Table 'yabycosm_zc1.orders_status_history' doesn't exist
in:
[UPDATE zen_so_payments sp, orders_status_history osh set sp.date_posted = osh.date_added where sp.orders_id = osh.orders_id AND osh.orders_status_id = 1;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Ah got it, you aren't allowed to do this via the SQL tool that is build into the admin, or at least that functionality is not build into it.Quote:
Originally Posted by mooomers
From the help file: UPDATE (just a single table)
So if you want these queries to run succesful, you will need to execute them directly via dbadmin if you have access to it.
Remember to add your table pre-fix to the 2 tablenames if you run it from there.
Cheers,
Jeroen
ok, hmm. does that mean no hope for me if i don't know how to do that? :ohmy:Quote:
Originally Posted by nagelkruid
textarea {Quote:
Originally Posted by DivaVocals
width:auto;
/*width: 80%;*/
}
seems to work without editing anything else in my shop.
You can also choose to add this only to super_stylesheet.css and not edit the stylesheet.css so it won't affect other areas of the site
Jeroen
don't know, what do you think?Quote:
Originally Posted by mooomers
Tried that and tested it, but that change alone does NOT work in IE versions 6, 7 or 8. Moving the checkboxes to a seperate row however did work.Quote:
Originally Posted by nagelkruid
I did some playing around and if this page was using a tableless layout then there would be NO issue whatsoever. (which is what the sources I found had to say about the real solution to this bug) I however, do not have the time to tackle that right now..
http://www.phoboslab.org/log/2007/10...-100-width-bug
From another source (http://msittig.wubi.org/test/ie-textarea.html):
Quote:
The solution is to add a <fieldset> tag around the comment box in your post template. Best to do it around the outside of the paragraph tags that surround the <textarea>. You can also use CSS to remove the border and padding from the <fieldset>.
Funny that it works for me.Quote:
Originally Posted by DivaVocals
It's an amazing browser isn't it :P
BTW just editing the superstylesheet will not fix it for the superbatch, only for the superorders page.
Did you try and play with setting the fieldsets & div's as mentioned in the links?
Seems like a nice way to deal with the problem?
The issue with the texarea display is only showing itself on the super_batch_status.php and my fix is directed at that page only. The textarea element on the super_orders.php order details pages displays just fine in IE (versions 6, 7 & 8). I'm sure it's structured slightly differently than the super_batch_status.php page and that might be why.. I didn't bother to compare the two to see exactly why the two pages display differently in IE.Quote:
Originally Posted by nagelkruid
Yes, I did a simple test to validate that this solution resolved the issue. However, as I've said, I believe the right way to do this would be to re-write the whole page and eliminate the tables altogether.. This is more work than I want to do at this time. :laugh:My down and dirty solution works fine.. I may tackle going tableless at some point in the future..Quote:
Originally Posted by nagelkruid
[FONT=Century Gothic]So I’ve been inspired by my good friend ckosloff (who recently did something similar with IH2) to submit a new version of Super Orders which includes a all of the fixes that have been posted in various threads throughout this support thread. To be clear, the intent of this exercise is not to re-write Super Orders (‘cause I certainly ain’t qualified for that!:laugh:). My intent is to bundle up all the various “fixes” for Super Orders that have been posted here and apply them to the Super Orders install files. This way folks won’t have to hunt through this support thread looking for 2-3 years worth of fixes and patches and painfully applying and testing them.[/FONT]
[FONT=Century Gothic]I am thinking that if I decide to tackle this little operation that the plan should also include cleaning up the readme just a little bit, along with the addition of an “Optional Edits” set of files. These files would contain files that include most of the edits outlined in the the “Optional Edits” section of the Super Orders readme as well as other a few additional optional edits that have been posted by other members here in this support thread. The changes I am planning on including in this version of Super Orders would be based on the following threads:[/FONT]
[FONT=Century Gothic]I’d love to hear any feedback from the community on this..[/FONT]
- [FONT=Century Gothic]http://www.zen-cart.com/forum/showpost.php?p=456907&postcount=720 [/FONT]
[FONT=Century Gothic]Items 1-5 are all various fixes which corrects the shipping display to show the full shipping description (carrier and shipping service) on the following files: super_packingslip.php, super_invoice.php, super_orders.php, and super_data_sheet.php. The default Zen Cart packingslip, invoice, orders, and datasheet all display the FULL shipping description while Super Orders has always used the short shipping descriptions. (It is likely that this is because this was a requirement of the client for whom this mod was originally built)[/FONT]- [FONT=Century Gothic]http://www.zen-cart.com/forum/showpost.php?p=474959&postcount=777[/FONT]
[FONT=Century Gothic]See Item #1 for description information[/FONT]- [FONT=Century Gothic]http://www.zen-cart.com/forum/showpost.php?p=495850&postcount=851[/FONT]
[FONT=Century Gothic]See Item #1 for description information[/FONT]- [FONT=Century Gothic]http://www.zen-cart.com/forum/showpost.php?p=495850&postcount=851[/FONT]
[FONT=Century Gothic]See Item #1 for description information[/FONT]- [FONT=Century Gothic]http://www.zen-cart.com/forum/showpost.php?p=495949&postcount=853 [/FONT]
[FONT=Century Gothic]See Item #1 for description information[/FONT]- [FONT=Century Gothic]http://www.zen-cart.com/forum/showpost.php?p=573887&postcount=1079 [/FONT]
[FONT=Century Gothic]For products with text attributes that include multiple lines and line breaks entered by the customer, the default Zen Cart Orders invoice prints out the text entered by the customer fine, and retains the multiple lines and line breaks entered by the customer. However, the Super Orders invoice, packing list, etc does not. This fix addresses that issue. Applied this fix to super_packingslip.php, super_invoice.php, super_orders.php, and super_data_sheet.php)[/FONT]- [FONT=Century Gothic]http://www.zen-cart.com/forum/showpost.php?p=621110&postcount=1126[/FONT]
[FONT=Century Gothic]Corrects an issue where Super Orders fails to update the "last modified date" when updating the order status using the batch status update function[/FONT]- [FONT=Century Gothic]http://www.zen-cart.com/forum/showpost.php?p=636329&postcount=1146 [/FONT]
[FONT=Century Gothic]Includes an optional edit for the default state of the "Notify Customer" checkbox (this should be included as an "Optional Edit")[/FONT]- [FONT=Century Gothic]http://www.zen-cart.com/forum/showpost.php?p=639013&postcount=1147[/FONT]
[FONT=Century Gothic]Addresses another error in Append Comments & Notify Customer as well as a clarification on how these features are SUPPOSED to work.[/FONT]- [FONT=Century Gothic]http://www.zen-cart.com/forum/showpost.php?p=734090&postcount=1316 [/FONT]
[FONT=Century Gothic]Fixes the issue with packing list images displaying distorted[/FONT]- [FONT=Century Gothic]http://www.zen-cart.com/forum/showpost.php?p=793720&postcount=1436[/FONT]
[FONT=Century Gothic]Options for how the number of images are displayed on packing list (this should be included as an "Optional Edit")[/FONT]- [FONT=Century Gothic]http://www.zen-cart.com/forum/showpost.php?p=803476&postcount=1474 [/FONT]
[FONT=Century Gothic]Fixes issue with Batch Status Updating & Batch Printing which throws errors when you search for orders using the following options: = equals) or < less than. As there is an issue with the = equals) option not working on decimal values (ie: $2.50), the = equals) option will be disabled from the dropdown and only the issue with the <less than option will be corrected.[/FONT]- [FONT=Century Gothic]http://www.zen-cart.com/forum/showpost.php?p=804899&postcount=1487[/FONT]
[FONT=Century Gothic]Fixes the textarea element on super_batch_status.php so it displays correctly in Internet Explorer. This is a bug with the way Internet Explorer displays textarea elements. Blindside the original author of this mod posted a hint regarding this issue here: ([/FONT][FONT=Verdana]http://www.zen-cart.com/forum/showpost.php?p=292293&postcount=289[/FONT][FONT=Century Gothic])[/FONT]
Excellent initiative, i didn't like reading the entire thread for my fixes, so if you can arrange it for others to skip that, that's great.Quote:
Originally Posted by DivaVocals
Before you upload it, let me rewrite the sql that comes with the install, unless you allready have it.
It should really be modified so the configuration id isn't hard coded to 28 (or is that allready fixed?)
I'll have an exam tomorrow, after that i may have some time to do the javascript for the print error, think those fixes should be nice to include as well.
Jeroen
You sooo rock!!!:clap: Nothing I'm undertaking does anything to the SQL that comes with the install, so I'm HAPPY to accept any and all help in this venture!! and the include of your javascript fix would be an AWESOME addition!!!Quote:
Originally Posted by nagelkruid
Here is an uninstall script for previous versions and versions up to 47.Quote:
Originally Posted by DivaVocals
The SQL install included inserts at a free configuration_group_id, and not the static 28. As an effect, the configuration_group_id may vary over installs so you need the new uninstall to properly delete it if you want to go back.
Cheers,
Jeroen