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

[philip_clarke]

I restored previous sql database and Uploaded the super_orders_sql.sql file. Got this error:

Still no "Store Phone" or "Store Fax".


Thanks Philip,
Well I'm not sure where to start with that, but I do want to be able to define "Store Phone" separately to the Store Address.
As it stands there is currently no STORE_FAX nor STORE_PHONE [configuration_key] after uploading the .sql.
Cheers

If you put the mouse over the menu that drops down when you are admin configuration, you'll see all these group_ids and configuration ids. These are how ZC would file the store_name, phone configuration bits. Somehow yours have gone wonky. The SQL should be able to bite into the correct menu from doing a lookup in your database, it should fill in the numbers (those missing integer values) and it should the execute the SQL. Would could run the sql manually through phpMyAdmin if your could get the correct numbers. Can't tell you what the numbers are, because with each installation of modules they change around a bit. I think yours are certainly well into the "changed" bit, so I couldn't guess.

Philip.

[DivaVocals]

Since most Mod's Ive installed seem to prefer the cut-n-paste code method, I default to using it to install SQL script by cut-n-paste the code using phpMyAdmin. Assuming the Mod's script has been written to be compatible, and not need correction.

And you will likely have the same kinds of problems with other mods doing this.. If you haven't consider yourself lucky.. Most of the SQL written for these mods would have NO IDEA what table prefix you've used when you created your database (you do NOT have to use "zen_"). From my understanding, the "Install SQL Patches" tool would make sure that the correct table prefix is used so that these SQL patches so that the correct tables are created or amended. If you are proficient with SQL, you could edit the SQL statements yourself and continue to use your phpMyAdmin..

[remoteone]

If you put the mouse over the menu that drops down when you are admin configuration, you'll see all these group_ids and configuration ids. These are how ZC would file the store_name, phone configuration bits. Somehow yours have gone wonky. The SQL should be able to bite into the correct menu from doing a lookup in your database, it should fill in the numbers (those missing integer values) and it should the execute the SQL. Would could run the sql manually through phpMyAdmin if your could get the correct numbers. Can't tell you what the numbers are, because with each installation of modules they change around a bit. I think yours are certainly well into the "changed" bit, so I couldn't guess.

Philip.

I'm not entirely sure what you mean Philip, but attached are a couple of screenshots. I think the sql upload is failing, and stopping at the first

INSERT INTO configuration VALUES ('', 'Store Fax', 'STORE_FAX', '', 'Enter the fax number for your store.......

at line 88, which means there's a whole bunch of other configuration VALUES not inserted.
If by "correct numbers" you mean the dBase Table _id numbers, I'm guessing this Mod' just will not work with a ZC that has other mod's already installed.
With my limited knowledge of SQL, I'm stumped.

[remoteone]

And you will likely have the same kinds of problems with other mods doing this.. If you haven't consider yourself lucky.. Most of the SQL written for these mods would have NO IDEA what table prefix you've used when you created your database (you do NOT have to use "zen_"). From my understanding, the "Install SQL Patches" tool would make sure that the correct table prefix is used so that these SQL patches so that the correct tables are created or amended. If you are proficient with SQL, you could edit the SQL statements yourself and continue to use your phpMyAdmin..

Hmm, I'm getting that old osCommerce sinking feeling again.
I have in the past had to change the prefix to get the sql script to run correctly.

[DivaVocals]

Hmm, I'm getting that old osCommerce sinking feeling again.
I have in the past had to change the prefix to get the sql script to run correctly.

To begin, while this app may have it's roots in OS Commerce, that's where the simialrity ENDS.. This is NOTHING like OS Commerce ,and you seemed to have missed my point.. So let me try again..

IF you use the Zen Admin tools for uploading SQL patches for your mods, you WILL NOT have issues with table prefixes.. However if you DO NOT want to use the Admin SQL tool, you will have to manually review and edit any mod's SQL files to make sure that the correct table prefix for YOUR store is in place..

[remoteone]

IF you use the Zen Admin tools for uploading SQL patches for your mods, you WILL NOT have issues with table prefixes.. However if you DO NOT want to use the Admin SQL tool, you will have to manually review and edit any mod's SQL files to make sure that the correct table prefix for YOUR store is in place..

Philip, Thanks for your help,
yep I got that, loud n clear a few posts back.
I started again with my pre-SuperOrders dB backup, then ran (uploaded) the .sql file using [Admin >>Install SQL patches] (SQL Query Executor).. .. It still does not show a row for STORE_FAX nor STORE_PHONE under [Configuration>>Mystore]. I'm just taking one step at a time. This step isnt working, I can only assume the other functionality may be in question.

Cheers

[Andy_GS]

I still have the exact same problems as i stated before.

regards

Andy.

[DivaVocals]

Philip, Thanks for your help,
yep I got that, loud n clear a few posts back.
I started again with my pre-SuperOrders dB backup, then ran (uploaded) the .sql file using [Admin >>Install SQL patches] (SQL Query Executor).. .. It still does not show a row for STORE_FAX nor STORE_PHONE under [Configuration>>Mystore].

Check your DB (using phpMyAdmin). If the other rows for the configuration table are there, the rows for the phone number and fax should show as well. If they don't simply add those fields yourself.. Not sure why they wouldn't be there.. I've never had any issues with the fields not being created when I run the Super Orders script.. Sometimes strange things happen..

I'm just taking one step at a time. This step isnt working, I can only assume the other functionality may be in question.

Cheers

Other aspects of this add-on work just fine.. There's a few functional feature enhancements I would request for this add-on, but otherwise I believe it's a highly useful add-on.. I started out using it for my test store to run it through it's paces. Now I install it for all of my clients.. My only suggestion is to make the changes necessary to correct the truncated short shipping display. These posts will help with that..

http://www.zen-cart.com/forum/showpo...&postcount=777
http://www.zen-cart.com/forum/showpo...&postcount=720
http://www.zen-cart.com/forum/showpo...&postcount=853
http://www.zen-cart.com/forum/showpo...postcount=1115

Good luck..

[philip_clarke]

To begin, while this app may have it's roots in OS Commerce, that's where the simialrity ENDS.

Especially since I got banned from OsCommerce for reporting security flaws, whereas here they were fixed, big difference in attitudes.

Philip.

[philip_clarke]

I'm not entirely sure what you mean Philip, but attached are a couple of screenshots.
With my limited knowledge of SQL, I'm stumped.

DivaVocals had a good idea, there the store phone or name or whatever it is called, find that in you phpMyAdmin database and slot the missing numbers (and db_prefix) into the query, that should then magically appear the missing bits int he right place without me have to try and explain thingys.