OLD Super Orders 2.0 (See v3.0 thread instead)

[grace83]

Anyone?

I'm having some trouble installing. I've uploaded all the files, but am having issues with the SQL file. I tried uploading hte file through ZC's "install SQL Patches", but got an error. When I tried uploading the file again, this is what I got:

"1062 Duplicate entry 'CA' for key 2
in:
[INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'CA', 'Cash');]
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."


How do I fix this? I'm not all that familiar with SQL, I could really use some help!

[davewest]

Anyone?

This is a common SQL error when you create a table then try to create the same table once more. Error shows due to a attempt to create a table or key with the same name. The tables may already exist. I would use phpmyadmin to check the table out or see if Super Orders is working before trying the fix below. More then likely the tables are good and you don't need to fix anything.

You have some options here...
1, Fix the table in phpmyadmin by dropping or adding the data that is missing, or drop the table and start over again.
2, Replace the database with your backup and try it again.
3, rewrite the sql file to do the drop and replace for you.

I like # 3 myself. You should have this added to your tables when you do a backup anyway, make life much easer.

open the sql file in note pad or any simple text editor. At the top of each table you will see 'CREATE TABLE' with a table name like this.. CREATE TABLE so_payment_types (

you need to change this line and add a line ..
DROP TABLE IF EXISTS `so_payment_types`;
CREATE TABLE IF NOT EXISTS `so_payment_types` (

What the two commands do! the first DROP TABLE IF EXIST table name, this deletes the table if it finds it, which is needed in order to replace it. Next line, CREATE TABLE IF NOT EXISTS table name, this one builds the table after deleting it, or creates it if it's not there.

This deletes the table and rebuilds it... basically anything that was in it will be GONE! Back up your table... As said thought out this site.... BACK it UP..

Once you made your edits for each table name, and back up your database... you can copy and paste into Admin>>Tools>>Install SQL Patches and run it. This will rebuild the tables for this mod.

[kuroi]

@grace83

As davewest says, the error message that you have posted is to be expected when you re-run the script. Clearly it has at least partially succeeded. His suggestions to clear down that file and re-load it are accurate, and I'd probably do that myself. However, I doubt that it will solve your problem.

The reason for this is that that error upon re-run is showing us that the so_payments_types table got created and populated. So that's not actually where your underlying problem is.

To know what and where that problem occurred we would need to know what your original error was - the one that caused you to re-run the script.

You've probably forgotten it. If so, then to investigate you need to do the following.

1. Use phpMyAdmin (or similar) to check if the extra fields (at the top of the SQL file) have been added to the orders table and if they have delete these insertions.
2. Add drop table if exists statements for all five new tables as explained by davewest.
3. Check your Admin to see if the new Super Orders settings fields are showing up in your Configuration menu (or you could check the configuration table in phpMyAdmin) and if they are there delete these statements from the SQL file.

If the orders or configure tables didn't have the extra fields, then that's probably where your problem lies. Otherwise re-run the SQl file are directed by davewest, and if any errors occur, make a note of them and post them exactly as they appear back here.

[kzdhcster]

Thank you very muc for the contribution. but the installation is reallly confused to me

[kzdhcster]

Thank you very muc for the contribution. but the installation is reallly confused to me. hope can get a easier installation way next vertion.

[brettw]

Hi All,

A quick question I have been using super orders now for around 4 weeks and its a great timesaver and thanks to the contributer who created and maintains it.

My problem is that when you select an orders details and then tick the notify customer option it always comes up with a cross and never a tick no matter what I do. Below is a screenshot of an order however I ensure that I selected the tick box to notify the customer.


The emails seem to be getting through however It would be great to get this working also.

Cheers

Brett
http://www.eastcoasthobbies.com.au

[brettw]

Ok I think I found the answer to the above here
http://www.zen-cart.com/forum/showpo...&postcount=971

Can someone please verify that this is the correct change.

Thanks :+)

Brett

[brettw]

Never mind I tested it on the test site first and it worked.

Cheers

Brett

[fright-rags]

When I go into the batch status update and pull up the order I want to change the status of, the comments box is really small...like one character wide and 5 characters tall. So I can't even see anything I type into it. How do I change that? I looked at the batch_status_update.php file was unsure as to what values to change. Any ideas?

[brettw]

Hi All,

Todays small cosmetic problem of mine..

I have a module installed for Australia Post which adds two images for the shipping type. The first is the Australia post image which shows up fine however the second is the type of shipping i.e parcel post, airmail etc.

The first image is showing up fine on the main "Super Orders" page and in all the other places where you see shipping however the second image is not showing up at all.

I have figured out that it is coming from the following code in for example the super_packingslip.php

<td class="main"><strong><?php echo ENTRY_SHIPPING_METHOD; ?></strong></td>
<td class="main"><?php echo $shipping_method; ?></td>

However am unsure where to go from here.

Any help would be great.

Cheers

Brett