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

[AfterHouR]

Oh ok. Thanks for the quick response, I have now removed them :)

[DeeL]

Can you tell me if it is possible to print out all the orders in a specified period but to have one order per page? I can see that I can print the orders during a specified time frame but it wants to just put as many to a page as will fit.

Thanks for your help!

[Sharon J]

Hello Diva,

I am having major issues with the install. I am using zen cart 1.51, php 5.3, mysql 5.0.91-log. Super Orders v.4.0 downloaded from the plug in section latest mod Dec 12, 2012. This is a clean install, I have not added any other mods that touch the files in Super Orders, so I had no need to merge. As per the instructions, I had planned on using Edit Orders and Ty package Tracker, so I went ahead and installed them first, checking my site after each to make sure they had installed correctly.

I did not load the COWOA files. After the install, I was able to log into my admin for just a moment, then when I clicked a link, I received a 500 error. Could not access my admin or front-end of my site. After FTP'ing my logs, I had the errors in the fpdf.php file listed a few posts back. After correcting that file, I am able to access my admin, but front end is still down,and I notice that now instead of my url in the address bar taking me to main page , it is trying to take me to a login page-index.php?main_page=login. My error logs are as follows:

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

As far as the first error is concerned, I do have /public_html/cache/zc_d6616cb5f4c2cb55d422ea67feb723b0.sql, Also, I do not have a prefix on my db, as I thought at first when I saw the zc_ that maybe it was erring looking for a zc_ prefix.

This are the offending lines from the first and second errors listed in the log for cache.php

function sql_cache_read($zf_query) {
    global $db;
    $zp_cache_name = $this->cache_generate_cache_name($zf_query);
    switch (SQL_CACHE_METHOD) {
      case 'file':
      $zp_fa = file(DIR_FS_SQL_CACHE . '/' . $zp_cache_name . '.sql');   (this is my line 149)
      $zp_result_array = unserialize(implode('', $zp_fa));
      return $zp_result_array;
      break;
      case 'database':
      $sql = "select * from " . TABLE_DB_CACHE . " where cache_entry_name = '" . $zp_cache_name . "'";
      $zp_cache_result = $db->Execute($sql);
      $zp_result_array = unserialize(base64_decode($zp_cache_result->fields['cache_data']));
      return $zp_result_array;
      break;
      case 'memory':
      return true;
      break;
      case 'none':
      default:
      return true;
      break; 

Here is my query_factory.php

global $zc_cache;
    if ($zf_limit) {
      $zf_sql = $zf_sql . ' LIMIT ' . $zf_limit;
    }
    $this->zf_sql = $zf_sql;
    if ( $zf_cache AND $zc_cache->sql_cache_exists($zf_sql, $zf_cachetime) ) {
      $obj = new queryFactoryResult;
      $obj->cursor = 0;
      $obj->is_cached = true;
      $obj->sql_query = $zf_sql;
      $zp_result_array = $zc_cache->sql_cache_read($zf_sql);
      $obj->result = $zp_result_array;
      if (sizeof($zp_result_array) > 0 ) {
        $obj->EOF = false;
        while (list($key, $value) = each($zp_result_array[0])) {   (this is my line 153)
          $obj->fields[$key] = $value;
        }
        return $obj;
      } else {
        $obj->EOF = true; 

Thank you so much for your help.

Sharon

[DivaVocals]

Hello Diva,

I am having major issues with the install. I am using zen cart 1.51, php 5.3, mysql 5.0.91-log. Super Orders v.4.0 downloaded from the plug in section latest mod Dec 12, 2012. This is a clean install, I have not added any other mods that touch the files in Super Orders, so I had no need to merge. As per the instructions, I had planned on using Edit Orders and Ty package Tracker, so I went ahead and installed them first, checking my site after each to make sure they had installed correctly.

I did not load the COWOA files. After the install, I was able to log into my admin for just a moment, then when I clicked a link, I received a 500 error. Could not access my admin or front-end of my site. After FTP'ing my logs, I had the errors in the fpdf.php file listed a few posts back. After correcting that file, I am able to access my admin, but front end is still down,and I notice that now instead of my url in the address bar taking me to main page , it is trying to take me to a login page-index.php?main_page=login. My error logs are as follows:

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

As far as the first error is concerned, I do have /public_html/cache/zc_d6616cb5f4c2cb55d422ea67feb723b0.sql, Also, I do not have a prefix on my db, as I thought at first when I saw the zc_ that maybe it was erring looking for a zc_ prefix.

This are the offending lines from the first and second errors listed in the log for cache.php

function sql_cache_read($zf_query) {
    global $db;
    $zp_cache_name = $this->cache_generate_cache_name($zf_query);
    switch (SQL_CACHE_METHOD) {
      case 'file':
      $zp_fa = file(DIR_FS_SQL_CACHE . '/' . $zp_cache_name . '.sql');   (this is my line 149)
      $zp_result_array = unserialize(implode('', $zp_fa));
      return $zp_result_array;
      break;
      case 'database':
      $sql = "select * from " . TABLE_DB_CACHE . " where cache_entry_name = '" . $zp_cache_name . "'";
      $zp_cache_result = $db->Execute($sql);
      $zp_result_array = unserialize(base64_decode($zp_cache_result->fields['cache_data']));
      return $zp_result_array;
      break;
      case 'memory':
      return true;
      break;
      case 'none':
      default:
      return true;
      break; 

Here is my query_factory.php

global $zc_cache;
    if ($zf_limit) {
      $zf_sql = $zf_sql . ' LIMIT ' . $zf_limit;
    }
    $this->zf_sql = $zf_sql;
    if ( $zf_cache AND $zc_cache->sql_cache_exists($zf_sql, $zf_cachetime) ) {
      $obj = new queryFactoryResult;
      $obj->cursor = 0;
      $obj->is_cached = true;
      $obj->sql_query = $zf_sql;
      $zp_result_array = $zc_cache->sql_cache_read($zf_sql);
      $obj->result = $zp_result_array;
      if (sizeof($zp_result_array) > 0 ) {
        $obj->EOF = false;
        while (list($key, $value) = each($zp_result_array[0])) {   (this is my line 153)
          $obj->fields[$key] = $value;
        }
        return $obj;
      } else {
        $obj->EOF = true; 

Thank you so much for your help.

Sharon

Honestly I have no clue what the cause of these errors are.. NONE of these files are part of the SO fileset..

[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?

[DivaVocals]

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..

[lhungil]

...
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 :)

[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!

[DivaVocals]

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..

[Sharon J]

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