Super Orders v4.0 Support Thread for ZC v1.5.x

Diva, do you know if it possible to print one order per page from within Super Orders or do I need to find another module top offer this functionality?

DeeL:

Diva, do you know if it possible to print one order per page from within Super Orders or do I need to find another module top offer this functionality?
It's always worked this way.. You'll need to explain (in detail) what you are doing if you get a different result..

Sharon J:

...

1. 04-Feb-2013 15:24:39 UTC] PHP Warning: file(//*///public_html/cache/zc_d6616cb5f4c2cb55d422ea67feb723b0.sql): failed to open stream: No such file or directory in /**//**/*public_html/includes/classes/cache.php on line 149

2. [04-Feb-2013 15:24:39 UTC] PHP Warning: implode(): Invalid arguments passed in //*//*/public_html/includes/classes/cache.php on line 150

3.[04-Feb-2013 15:24:39 UTC] PHP Warning: Variable passed to each() is not an array or object in //*///public_html/includes/classes/db/mysql/query_factory.php on line 153
...
It may be the user your web server is running as does not have access to read the cached SQL responses (used when the Zen Cart SQL Cache is enabled and set to "file"). The "file" SQL Cache method is deprecated and may be removed from future versions. Issues with reading / writing these can often be fixed by removing the "cached" SQL responses (zc_.sql) from the cache folder.

There is an update for Zen Cart 1.5.0/1.5.1 to "mysql/query_factory.php" to address safer handling of cached requests. Using the changes (technically in testing) along with deleting any old cached responses may help :)

Hello! I have recently had my webmaster install Super Orders and love the batch form print and updating features. What I am looking for at the moment is a detailed report to export to excel regarding my sales for the past year so I can do my taxes. If anyone knows how to go about getting this done, I would be elated (my bookkeeper is on me HARD about this now!)

Thanks for your help!

Schtickler:

Hello! I have recently had my webmaster install Super Orders and love the batch form print and updating features. What I am looking for at the moment is a detailed report to export to excel regarding my sales for the past year so I can do my taxes. If anyone knows how to go about getting this done, I would be elated (my bookkeeper is on me HARD about this now!)

Thanks for your help!

Not a Super Orders feature.. You will need to post your question in a new thread..

lhungil:

It may be the user your web server is running as does not have access to read the cached SQL responses (used when the Zen Cart SQL Cache is enabled and set to "file"). The "file" SQL Cache method is deprecated and may be removed from future versions. Issues with reading / writing these can often be fixed by removing the "cached" SQL responses (zc_*.sql) from the cache folder.

There is an update for Zen Cart 1.5.0/1.5.1 to "mysql/query_factory.php" to address safer handling of cached requests. Using the changes (technically in testing) along with deleting any old cached responses may help :)

Hello lhungil,

I followed the steps referenced in the link that you posted. The results were white screen on both front end and admin. I did notice, however, that the url to the front end no longer was trying to re-direct me to login. It generated a log file with the query_factory.php error same as above, except referencing line 545. I then followed the link in that thread that was posted by Wilt. I copied the complete code to my query file. With that, I was able to get back into my admin, but the front-end was white paging out, once again re-directing me to the login page according to the url. I have double-checked that the zc_ file being referenced in earlier logs was deleted, and not being recreated. I now have no new error logs being created to give me a clue as to where to look.

I do not have any uri re-writers installed. It seems to me, and I could be way off base, but I am thinking as you said, that somewhere there is a permission restriction not allowing me to call files.

Since this happened after installing Super Orders, the only thing that I can think of at this point, is that SO has a feature on restricting admins from certain pages, that somehow, that has totally locked everyone out. If Diva would please post which file does this (grants and restricts permissions) and possibly what I should be looking for, that would be most excellent.

I don't know if you would like me to move this to another forum or pm you since I'm not 100% sure it is SO related and don't want to go off topic., ...I am 100% certain it happened immediately after installing Super Orders...

At this point, if I can't find a solution in a suitable amount of time, I will try and remove SO and replace overwritten files with my originals and see if that fixes the issue. Though I would really like to know the cause because not only would I like to use SO, but would like to prevent this happening again or if if does happen, would like to know the fix..

Thank you,

Sharon

Sharon J:

Hello lhungil,

I followed the steps referenced in the link that you posted. The results were white screen on both front end and admin. I did notice, however, that the url to the front end no longer was trying to re-direct me to login. It generated a log file with the query_factory.php error same as above, except referencing line 545. I then followed the link in that thread that was posted by Wilt. I copied the complete code to my query file. With that, I was able to get back into my admin, but the front-end was white paging out, once again re-directing me to the login page according to the url. I have double-checked that the zc_ file being referenced in earlier logs was deleted, and not being recreated. I now have no new error logs being created to give me a clue as to where to look.

I do not have any uri re-writers installed. It seems to me, and I could be way off base, but I am thinking as you said, that somewhere there is a permission restriction not allowing me to call files.

Since this happened after installing Super Orders, the only thing that I can think of at this point, is that SO has a feature on restricting admins from certain pages, that somehow, that has totally locked everyone out. If Diva would please post which file does this (grants and restricts permissions) and possibly what I should be looking for, that would be most excellent.

I don't know if you would like me to move this to another forum or pm you since I'm not 100% sure it is SO related and don't want to go off topic., ...I am 100% certain it happened immediately after installing Super Orders...

At this point, if I can't find a solution in a suitable amount of time, I will try and remove SO and replace overwritten files with my originals and see if that fixes the issue. Though I would really like to know the cause because not only would I like to use SO, but would like to prevent this happening again or if if does happen, would like to know the fix..

Thank you,

Sharon
There is nothing special about any of the Super Orders files which grants or restricts permissions. The entire Super Orders module is just an enhanced version of the default Zen Cart order management functions with some UI modifications to "pretty up" the admin area..

Since you are the only person to report such an issue it means I would have no way to replicate it, and that leads me to the conclusion that this is something unique to your hosting setup/store setup.

To lhungil's point earlier point the SQL_CACHE_METHOD is defined in the configure.php file:

includes/configure.php

  // The next 2 "defines" are for SQL cache support.
  // For SQL_CACHE_METHOD, you can select from:  none, database, or file
  // If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache 
  // or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
  // ie: /path/to/your/webspace/public_html/zen/cache   -- leave no trailing slash  
  define('SQL_CACHE_METHOD', 'file'); 
  define('DIR_FS_SQL_CACHE', '/home2/overthe4/public_html/clientLaserdiscVault/cache');

// EOF

and in YOUR_ADMIN/includes/configure.php

  // The next 2 "defines" are for SQL cache support.
  // For SQL_CACHE_METHOD, you can select from:  none, database, or file
  // If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache 
  // or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
  // ie: /path/to/your/webspace/public_html/zen/cache   -- leave no trailing slash  
  define('SQL_CACHE_METHOD', 'file'); 
  define('DIR_FS_SQL_CACHE', '/home/laserdis/public_html/cache');

if your configure.php files look like this, then you might try changing the SQL_CACHE_METHOD define to

  define('SQL_CACHE_METHOD', 'none');

Again, none of this is really related to Super Orders (otherwise others would have reported the very same issue) suggest rolling back to a vanilla store, update the query_factory.php file by using the one that's in the Ultimate SEO package and then if your SQL_CACHE_METHOD is set to "file" make the changes I suggest above.. Once you get the errors worked out, try installing Super Orders again..

Sharon J:

... I followed the steps referenced in the link that you posted. The results were white screen on both front end and admin. ...
Make sure you cleared out the .sql files AFTER you made the changes to query_factory.

Sharon J:

...It seems to me, and I could be way off base, but I am thinking as you said, that somewhere there is a permission restriction not allowing me to call files. ...
While possible, it would point to an issue with the configuration on your web server. This will not be related to SO or Zen Cart.

DivaVocals:

... the SQL_CACHE_METHOD is defined in the configure.php file:

includes/configure.php

// The next 2 "defines" are for SQL cache support.
// For SQL_CACHE_METHOD, you can select from: none, database, or file
// If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache
// or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
// ie: /path/to/your/webspace/public_html/zen/cache -- leave no trailing slash
define('SQL_CACHE_METHOD', 'file');
define('DIR_FS_SQL_CACHE', '/home2/overthe4/public_html/clientLaserdiscVault/cache');

// EOF

> 
> and in YOUR_ADMIN/includes/configure.php
> ```
  // The next 2 "defines" are for SQL cache support.
  // For SQL_CACHE_METHOD, you can select from:  none, database, or file
  // If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache 
  // or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
  // ie: /path/to/your/webspace/public_html/zen/cache   -- leave no trailing slash  
  define('SQL_CACHE_METHOD', 'file'); 
  define('DIR_FS_SQL_CACHE', '/home/laserdis/public_html/cache');

if your configure.php files look like this, then you might try changing the SQL_CACHE_METHOD define to

define('SQL_CACHE_METHOD', 'none');

Yes, please try this (and delete the cached sql responses). The Zen Cart team has hinted on the forums the 'file' method is going away. You may want to switch to using 'database' or 'none'. Unless you have done some heavy modification to the core of Zen Cart or have very high (thousands of hits per hour), you will probably not see a huge performance impact from using 'file' or 'database'. You can probably just use 'none' to disable the SQL Cache.

> **DivaVocals:**
>
> ... suggest rolling back to a vanilla store, update the query_factory.php file by using the one that's in the Ultimate SEO package as it will give us a better idea if the problem is with something in the SQL Cache ...
Yup. Based upon the logs, I doubt this is a problem caused by this module (unless a merge went wrong in the installation process).

Rolling back to Zen Cart stock would be a good start just to be safe. There is an already merged copy of the necessary fixes to the SQL Cache (file: query_cache.php) included with "Ultimate SEO URLs". You can grab and install the updated file if you need to use the SQL Cache (most Zen Cart 1.5.1 installations work well with the SQL Cache disabled).

[QUOTE=Sharon J;1183720I don't know if you would like me to move this to another forum or pm you since I'm not 100% sure it is SO related and don't want to go off topic., ...I am 100% certain it happened immediately after installing Super Orders...[/QUOTE]

DivaVocals:

Again, none of this is really related to Super Orders (otherwise others would have reported the very same issue) suggest rolling back to a vanilla store, update the query_factory.php file by using the one that's in the Ultimate SEO package and then if your SQL_CACHE_METHOD is set to "file" make the changes I suggest above.. Once you get the errors worked out, try installing Super Orders again..Must add this, any issues NOT related to Super Orders really should be moved to a separate thread.

DivaVocals:

It's always worked this way.. You'll need to explain (in detail) what you are doing if you get a different result..

Sorry my mistake. I was assuming from teh print preview it was going to put one order after another rather than one per page.

Any how. I printed it and I have another small issue which I am sure will be a relatively simple fix, if you know what your're doing with the code (and I don't). Earlier today I 'commented out ' the address fields part when customers register. They still have to enter their first and last name, phone number and email. However, when I print an order that was order with a test customer account, that I created after not requiring address fields during registration, under "Sold To" it is blank. It doesn't even have the customers name. All products are set to virtual as the site is for people to pre-order produce they will pick up on pick up day. Hence the reason I did not require addresses when they registered.

Thanks in advance!

DeeL:

Sorry my mistake. I was assuming from teh print preview it was going to put one order after another rather than one per page.

Any how. I printed it and I have another small issue which I am sure will be a relatively simple fix, if you know what your're doing with the code (and I don't). Earlier today I 'commented out ' the address fields part when customers register. They still have to enter their first and last name, phone number and email. However, when I print an order that was order with a test customer account, that I created after not requiring address fields during registration, under "Sold To" it is blank. It doesn't even have the customers name. All products are set to virtual as the site is for people to pre-order produce they will pick up on pick up day. Hence the reason I did not require addresses when they registered.

Thanks in advance!

it's not a direct answer to your question but I think this mod does what you're looking to do
http://www.zen-cart.com/downloads.php?do=file&id=1465

picandnix:

it's not a direct answer to your question but I think this mod does what you're looking to do
http://www.zen-cart.com/downloads.php?do=file&id=1465

I already have that installed and I think that is causing issues with something else. By having that installed I can't use multiple store pick up locations.

DeeL:

I already have that installed and I think that is causing issues with something else. By having that installed I can't use multiple store pick up locations.
Super Orders uses modified versions of the default Zen Cart order management pages. This issue you are having actually doesn't sound like a Super Orders issue at all, and I wouldn't be able to offer any useful information for modifications you made to overlapping files from another module. It sounds to me that your modifications from the other module are the real issue, and it might be best if you posted an inquiry on the support page for the "Minimum Customer Account Information" module..

Thanks, I am going to have a go at removing MCAI and see how that goes. Fingers crossed...

DeeL:

Thanks, I am going to have a go at removing MCAI and see how that goes. Fingers crossed...
Well before you do that, at least post on the support thread for the "Minimum Customer Account Information" module. lat9 (the author) is generally VERY knowledgable and helpful.. Let him know you are merging with Super Orders modified files and he should be able to help you get it all straightened out.. Good luck..

I have a new install, latest Super Orders on a 1.5.1 store: www.ncwheatmontanacoop.com

I have uploaded the base and core files in the right places and had logged into the admin. Autoinstaller will not run. Please help...

Doodlebuckets:

I have a new install, latest Super Orders on a 1.5.1 store: www.ncwheatmontanacoop.com

I have uploaded the base and core files in the right places and had logged into the admin. Autoinstaller will not run. Please help...

Really need more details than "Autoinstaller will not run".. Since we tested this extensively before releasing we can't help you based JUST on the information you provided thus far..

What happens?? Are there error logs?? Error messages??

Details will help us help you..

DivaVocals:

Really need more details than "Autoinstaller will not run".. Since we tested this extensively before releasing we can't help you based JUST on the information you provided thus far..

What happens?? Are there error logs?? Error messages??

Details will help us help you..

Not sure what else to tell you. The SQL doesn't execute when I click on a link in the admin and it doesn't install. I have rechecked that all the files are in the right place. This is a brand new install. What other types of detail would be helpful? No error messages, nothing happens. Thanks, Amy

Doodlebuckets:

Not sure what else to tell you. The SQL doesn't execute when I click on a link in the admin and it doesn't install. I have rechecked that all the files are in the right place. This is a brand new install. What other types of detail would be helpful? No error messages, nothing happens. Thanks, Amy

I'm having the same issue, installed 3 times yesterday, no luck. Going to try again today on a different host/server setup.

I'm using ZC 1.5.1, SO 4_0_5_final on a WinXP sp3 sandbox with Apache 2.2.6 PHP 5.2.6 and MySql 5.0

First attempt to install I got a blank screen and found errors in the logs something to the affect of
"unexpected " . " found in....fpdf.php line 1047. The line is "ini_set('magic_quotes_runtime', .$mqr);" I removed the "." since magic quotes will accept a 0 (and from the same code on line 1329). Did a restore and re-install and I got an onscreen "warning, error.. refresh and try again". These turned out to be SQL errors from the auto loader, something about the string is too long to fit the field. I took the SQL from the error message and put it directly into “MySQL Query Browser” and it worked just fine.

Sorry to be so vague WRT the errors but I did this yesterday and did not write them down.
I believe the first problem is fixed in FPDF v1.6, going to find that today and see. I believe the second issue is caused by the PHP-MySQL interface and these are usually a version mis-match or configuration error (honestly I don’t know what versions I have) AND/OR a previously installed mod that I/we don't have yet. My sandbox has been running un-modified for about 6 years and this is not the first ZC module I have found that will not install on my sandbox but works just fine on my host (linux not windows) and works just fine on the developers system. I’m going to try getting fpdf 1.6 and then install on my host and see what happens there. I really don't believe this is a SO issue, just another case of too many host/server/php/sql combinations in the world. I’ll let you know what I find out today.

Meanwhile: - Any chance you have a .sql file so I don't have to dig the queries it out of the code??

CaptCuervo:

I'm having the same issue, installed 3 times yesterday, no luck. Going to try again today on a different host/server setup.

I'm using ZC 1.5.1, SO 4_0_5_final on a WinXP sp3 sandbox with Apache 2.2.6 PHP 5.2.6 and MySql 5.0

First attempt to install I got a blank screen and found errors in the logs something to the affect of
"unexpected " . " found in....fpdf.php line 1047. The line is "ini_set('magic_quotes_runtime', .$mqr);" I removed the "." since magic quotes will accept a 0 (and from the same code on line 1329). Did a restore and re-install and I got an onscreen "warning, error.. refresh and try again". These turned out to be SQL errors from the auto loader, something about the string is too long to fit the field. I took the SQL from the error message and put it directly into “MySQL Query Browser” and it worked just fine.

Sorry to be so vague WRT the errors but I did this yesterday and did not write them down.
I believe the first problem is fixed in FPDF v1.6, going to find that today and see. I believe the second issue is caused by the PHP-MySQL interface and these are usually a version mis-match or configuration error (honestly I don’t know what versions I have) AND/OR a previously installed mod that I/we don't have yet. My sandbox has been running un-modified for about 6 years and this is not the first ZC module I have found that will not install on my sandbox but works just fine on my host (linux not windows) and works just fine on the developers system. I’m going to try getting fpdf 1.6 and then install on my host and see what happens there. I really don't believe this is a SO issue, just another case of too many host/server/php/sql combinations in the world. I’ll let you know what I find out today.

Meanwhile: - Any chance you have a .sql file so I don't have to dig the queries it out of the code??Updating the version of FPDF isn't a SIMPLE matter of downloading the lastest version and replacing the one in SO.. (which is why I've not attempted this update) The magicquote errors fix is posted in this thread.. (search fpdf.php)

And yes.. The issue with the auto-installer not running is a sever configuration error.. It has everything to do with the host configuration setup..