New v154 having Admin glitch on orders.php page

[BlackOrchidCouture]

Hi, my store is on a fresh install of v154, and I went with a whole new template so I didn't bring over my old custom folders from my previous store. When I had my site on a test domain everything was working, but now that I have gone live with it there are some glitches.

The one I'm trying to figure out right now is that when I'm in my Admin, when I click edit on a customer's order (order.php), it shows about the top third of the page, and everything below the credit card info is blank. There is a warning at the top: WARNING: An Error occurred, please refresh the page and try again. Refreshing doesn't change anything.

Any ideas? Thanks!

[BlackOrchidCouture]

Btw, I looked in my logs folder and I have NO debug files, so I don't think that's working either. My logs file is writeable. Is there a place to turn debugging on and off?

[stevesh]

Maybe a DB access problem:

https://www.zen-cart.com/content.php...-and-try-again

[BlackOrchidCouture]

Hi stevesh, thanks, yeah I saw that page which is what made me try to look at my debug files and realize there were none. I guess I'm just confused as to why I could see/edit my orders when the store wasn't live, then I just moved the files into the correct place in my hosting (and changed the configure files of course), and now there is the error. Other things with my database are working fine.

If I could just get debug log files, that would be helpful! I tried following the directions on the enable strict error reporting page, but that didn't show anything, so I undid that.

[mc12345678]

Confirm that your includes/configure.php and admin/includes/configure.php files both point to the correct logs folder. May help to post them, obscurring your database password and if your admin directory is identified to hide it as well.

Differences, what are the php versions between the two "sites"?

[stevesh]

Did you try the alternative error reporting at the end of the tutorial?

[BlackOrchidCouture]

Ok, here are my two configure files. As for the difference between the php for the test and live site, they are on the same server, so it was just that they were in different subdirectories. But the php on my hosting is 5.4.38. Thanks!

// Define the webserver and path parameters
// HTTP_SERVER is your Main webserver: eg-http://www.your_domain.com
// HTTPS_SERVER is your Secure webserver: eg-https://www.your_domain.com
define('HTTP_SERVER', 'http://www.blackorchidcouture.com');
define('HTTPS_SERVER', 'https://www.blackorchidcouture.com');

// Use secure webserver for checkout procedure?
define('ENABLE_SSL', 'true');

// NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes!
// * DIR_WS_* = Webserver directories (virtual/URL)
// these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder)
define('DIR_WS_CATALOG', '/store/');
define('DIR_WS_HTTPS_CATALOG', '/store/');

define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_INCLUDES', 'includes/');
define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
define('DIR_WS_DOWNLOAD_PUBLIC', DIR_WS_CATALOG . 'pub/');
define('DIR_WS_TEMPLATES', DIR_WS_INCLUDES . 'templates/');

// * DIR_FS_* = Filesystem directories (local/physical)
//the following path is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/
define('DIR_FS_CATALOG', '/home/private/public_html/store/');

//the following path is a COMPLETE path to the /logs/ folder  eg: /var/www/vhost/accountname/public_html/store/logs ... and no trailing slash
define('DIR_FS_LOGS', DIR_FS_CATALOG . '/home/private/public_html/store/logs');

define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');
define('DIR_WS_UPLOADS', DIR_WS_IMAGES . 'uploads/');
define('DIR_FS_UPLOADS', DIR_FS_CATALOG . DIR_WS_UPLOADS);
define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/');

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', ''); // prefix for database table names -- preferred to be left empty
define('DB_CHARSET', 'utf8');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'private');
define('DB_SERVER_PASSWORD', 'private');
define('DB_DATABASE', 'private');

// 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', 'database');
define('DIR_FS_SQL_CACHE', '/home/private/public_html/store/cache');

* WE RECOMMEND THAT YOU USE SSL PROTECTION FOR YOUR ENTIRE ADMIN:
 * To do that, make sure you use a "https:" URL for BOTH the HTTP_SERVER and HTTPS_SERVER entries:
 */
  define('HTTP_SERVER', 'https://www.blackorchidcouture.com');
  define('HTTPS_SERVER', 'https://www.blackorchidcouture.com');
  define('HTTP_CATALOG_SERVER', 'http://www.blackorchidcouture.com');
  define('HTTPS_CATALOG_SERVER', 'https://www.blackorchidcouture.com');

  // secure webserver for admin?  Valid choices are 'true' or 'false' (including quotes).
  define('ENABLE_SSL_ADMIN', 'true');

  // secure webserver for storefront?  Valid choices are 'true' or 'false' (including quotes).
  define('ENABLE_SSL_CATALOG', 'false');


  define('DIR_WS_ADMIN', preg_replace('#^' . str_replace('-', '\-', zen_parse_url(HTTP_SERVER, '/path')) . '#', '', dirname($_SERVER['SCRIPT_NAME'])) . '/');
  define('DIR_WS_CATALOG', '/store/');
  define('DIR_WS_HTTPS_ADMIN', preg_replace('#^' . str_replace('-', '\-', zen_parse_url(HTTPS_SERVER, '/path')) . '#', '', dirname($_SERVER['SCRIPT_NAME'])) . '/');
  define('DIR_WS_HTTPS_CATALOG', '/store/');

// NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes!
// * DIR_WS_* = Webserver directories (virtual/URL)
  // these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder)
  define('DIR_WS_IMAGES', 'images/');
  define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
  define('DIR_WS_CATALOG_IMAGES', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'images/');
  define('DIR_WS_CATALOG_TEMPLATE', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'includes/templates/');
  define('DIR_WS_INCLUDES', 'includes/');
  define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
  define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
  define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
  define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
  define('DIR_WS_CATALOG_LANGUAGES', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'includes/languages/');

// * DIR_FS_* = Filesystem directories (local/physical)
  define('DIR_FS_ADMIN', preg_replace('#.includes$#', '', realpath(dirname(__FILE__) . '/../') . '/'));

  define('DIR_FS_CATALOG', '/home/private/public_html/store/');

  //the following path is a COMPLETE path to the /logs/ folder  eg: /var/www/vhost/accountname/public_html/store/logs ... and no trailing slash
  define('DIR_FS_LOGS', DIR_FS_CATALOG . '/home/private/public_html/store/logs');

  define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');
  define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');
  define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');
  define('DIR_FS_CATALOG_TEMPLATES', DIR_FS_CATALOG . 'includes/templates/');
  define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');
  define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/');
  define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');

// define our database connection
  define('DB_TYPE', 'mysql');
  define('DB_PREFIX', '');
  define('DB_CHARSET', 'utf8');
  define('DB_SERVER', 'localhost');
  define('DB_SERVER_USERNAME', 'private');
  define('DB_SERVER_PASSWORD', 'private');
  define('DB_DATABASE', 'private');

  // 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', 'database');
  define('DIR_FS_SQL_CACHE', '/home/private/public_html/store/cache');

[lat9]

Ok, here are my two configure files. As for the difference between the php for the test and live site, they are on the same server, so it was just that they were in different subdirectories. But the php on my hosting is 5.4.38. Thanks!

// Define the webserver and path parameters
// HTTP_SERVER is your Main webserver: eg-http://www.your_domain.com
// HTTPS_SERVER is your Secure webserver: eg-https://www.your_domain.com
define('HTTP_SERVER', 'http://www.blackorchidcouture.com');
define('HTTPS_SERVER', 'https://www.blackorchidcouture.com');

// Use secure webserver for checkout procedure?
define('ENABLE_SSL', 'true');

// NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes!
// * DIR_WS_* = Webserver directories (virtual/URL)
// these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder)
define('DIR_WS_CATALOG', '/store/');
define('DIR_WS_HTTPS_CATALOG', '/store/');

define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_INCLUDES', 'includes/');
define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
define('DIR_WS_DOWNLOAD_PUBLIC', DIR_WS_CATALOG . 'pub/');
define('DIR_WS_TEMPLATES', DIR_WS_INCLUDES . 'templates/');

// * DIR_FS_* = Filesystem directories (local/physical)
//the following path is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/
define('DIR_FS_CATALOG', '/home/private/public_html/store/');

//the following path is a COMPLETE path to the /logs/ folder  eg: /var/www/vhost/accountname/public_html/store/logs ... and no trailing slash
define('DIR_FS_LOGS', DIR_FS_CATALOG . '/home/private/public_html/store/logs');

define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');
define('DIR_WS_UPLOADS', DIR_WS_IMAGES . 'uploads/');
define('DIR_FS_UPLOADS', DIR_FS_CATALOG . DIR_WS_UPLOADS);
define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/');

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', ''); // prefix for database table names -- preferred to be left empty
define('DB_CHARSET', 'utf8');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'private');
define('DB_SERVER_PASSWORD', 'private');
define('DB_DATABASE', 'private');

// 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', 'database');
define('DIR_FS_SQL_CACHE', '/home/private/public_html/store/cache');

* WE RECOMMEND THAT YOU USE SSL PROTECTION FOR YOUR ENTIRE ADMIN:
 * To do that, make sure you use a "https:" URL for BOTH the HTTP_SERVER and HTTPS_SERVER entries:
 */
  define('HTTP_SERVER', 'https://www.blackorchidcouture.com');
  define('HTTPS_SERVER', 'https://www.blackorchidcouture.com');
  define('HTTP_CATALOG_SERVER', 'http://www.blackorchidcouture.com');
  define('HTTPS_CATALOG_SERVER', 'https://www.blackorchidcouture.com');

  // secure webserver for admin?  Valid choices are 'true' or 'false' (including quotes).
  define('ENABLE_SSL_ADMIN', 'true');

  // secure webserver for storefront?  Valid choices are 'true' or 'false' (including quotes).
  define('ENABLE_SSL_CATALOG', 'false');


  define('DIR_WS_ADMIN', preg_replace('#^' . str_replace('-', '\-', zen_parse_url(HTTP_SERVER, '/path')) . '#', '', dirname($_SERVER['SCRIPT_NAME'])) . '/');
  define('DIR_WS_CATALOG', '/store/');
  define('DIR_WS_HTTPS_ADMIN', preg_replace('#^' . str_replace('-', '\-', zen_parse_url(HTTPS_SERVER, '/path')) . '#', '', dirname($_SERVER['SCRIPT_NAME'])) . '/');
  define('DIR_WS_HTTPS_CATALOG', '/store/');

// NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes!
// * DIR_WS_* = Webserver directories (virtual/URL)
  // these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder)
  define('DIR_WS_IMAGES', 'images/');
  define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
  define('DIR_WS_CATALOG_IMAGES', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'images/');
  define('DIR_WS_CATALOG_TEMPLATE', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'includes/templates/');
  define('DIR_WS_INCLUDES', 'includes/');
  define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
  define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
  define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
  define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
  define('DIR_WS_CATALOG_LANGUAGES', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'includes/languages/');

// * DIR_FS_* = Filesystem directories (local/physical)
  define('DIR_FS_ADMIN', preg_replace('#.includes$#', '', realpath(dirname(__FILE__) . '/../') . '/'));

  define('DIR_FS_CATALOG', '/home/private/public_html/store/');

  //the following path is a COMPLETE path to the /logs/ folder  eg: /var/www/vhost/accountname/public_html/store/logs ... and no trailing slash
  define('DIR_FS_LOGS', DIR_FS_CATALOG . '/home/private/public_html/store/logs');

  define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');
  define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');
  define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');
  define('DIR_FS_CATALOG_TEMPLATES', DIR_FS_CATALOG . 'includes/templates/');
  define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');
  define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/');
  define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');

// define our database connection
  define('DB_TYPE', 'mysql');
  define('DB_PREFIX', '');
  define('DB_CHARSET', 'utf8');
  define('DB_SERVER', 'localhost');
  define('DB_SERVER_USERNAME', 'private');
  define('DB_SERVER_PASSWORD', 'private');
  define('DB_DATABASE', 'private');

  // 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', 'database');
  define('DIR_FS_SQL_CACHE', '/home/private/public_html/store/cache');

The DIR_FS_LOGS path should not have DIR_FS_CATALOG pre-pended; remove the bits above that I've highlighted and you'll start seeing those myDEBUG*.log files!

[BlackOrchidCouture]

Woohoo! You're right, I'm getting my debug files now! Thanks! Very curious as to why I had that in there, I guess I could have copied my configure files from my old store....

So, tried to figure out the issue myself, and I did figure out from the debug file that for some reason my table for my credit card processor isn't being found, but I verified that it IS in my database, and it IS named correctly in the table define file. Plus, I've had a sale with the payment processor since the store went live, and that transaction is listed in the table. So, it can access the table for a transaction, just not to look at the order in my admin.

Here's the debug file:

[21-Apr-2015 07:16:37 America/Los_Angeles] PHP Fatal error:  1146:Table 'private.TABLE_BRAINTREE' doesn't exist :: SELECT * FROM TABLE_BRAINTREE 
			WHERE order_id = 313
			AND parent_txn_id = ''
			LIMIT 1 ==> (as called by) /home/private/public_html/store/includes/modules/payment/braintree_api.php on line 721 <== in /home/private/public_html/store/includes/classes/db/mysql/query_factory.php on line 155

And here is where my table name is defined, and I verified that this is the correct name in my database:

<?php
	define('TABLE_BRAINTREE', DB_PREFIX . 'braintree');

Any ideas? Thanks!!!!

[mc12345678]

The DIR_FS_LOGS path should not have DIR_FS_CATALOG pre-pended; remove the bits above that I've highlighted and you'll start seeing those myDEBUG*.log files!

Woohoo! You're right, I'm getting my debug files now! Thanks! Very curious as to why I had that in there, I guess I could have copied my configure files from my old store....

So, tried to figure out the issue myself, and I did figure out from the debug file that for some reason my table for my credit card processor isn't being found, but I verified that it IS in my database, and it IS named correctly in the table define file. Plus, I've had a sale with the payment processor since the store went live, and that transaction is listed in the table. So, it can access the table for a transaction, just not to look at the order in my admin.

Here's the debug file:

[21-Apr-2015 07:16:37 America/Los_Angeles] PHP Fatal error:  1146:Table 'private.TABLE_BRAINTREE' doesn't exist :: SELECT * FROM TABLE_BRAINTREE 
			WHERE order_id = 313
			AND parent_txn_id = ''
			LIMIT 1 ==> (as called by) /home/private/public_html/store/includes/modules/payment/braintree_api.php on line 721 <== in /home/private/public_html/store/includes/classes/db/mysql/query_factory.php on line 155

And here is where my table name is defined, and I verified that this is the correct name in my database:

<?php
	define('TABLE_BRAINTREE', DB_PREFIX . 'braintree');

Any ideas? Thanks!!!!

It's kind of a one or the other, either have the DIR_FS_CATALOG and only append logs, or have the full path without the constant. The path identified simply did not exist...