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

[DivaVocals]

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

[lhungil]

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

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

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

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

[DivaVocals]

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

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.

[DeeL]

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!

[picandnix]

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

[DeeL]

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.

[DivaVocals]

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

[DeeL]

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

[DivaVocals]

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

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