Forums / General Questions / New v154 having Admin glitch on orders.php page

New v154 having Admin glitch on orders.php page

Views: 1,313

Results 1 to 15 of 15
20 Apr 2015, 5:01 PM
#1
blackorchidcouture avatar

blackorchidcouture

Zen Follower

Join Date:
Apr 2010
Location:
Albuquerque, NM
Posts:
198
Plugin Contributions:
0

New v154 having Admin glitch on orders.php page

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!

20 Apr 2015, 8:13 PM
#2
blackorchidcouture avatar

blackorchidcouture

Zen Follower

Join Date:
Apr 2010
Location:
Albuquerque, NM
Posts:
198
Plugin Contributions:
0

Re: New v154 having Admin glitch on orders.php page

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?

21 Apr 2015, 2:35 AM
#4
blackorchidcouture avatar

blackorchidcouture

Zen Follower

Join Date:
Apr 2010
Location:
Albuquerque, NM
Posts:
198
Plugin Contributions:
0

Re: New v154 having Admin glitch on orders.php page

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.

21 Apr 2015, 9:53 AM
#5
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: New v154 having Admin glitch on orders.php page

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

ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...

21 Apr 2015, 1:20 PM
#6
stevesh avatar

stevesh

Black Belt

Join Date:
Feb 2005
Location:
Lansing, Michigan USA
Posts:
19,793
Plugin Contributions:
2

Re: New v154 having Admin glitch on orders.php page

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

21 Apr 2015, 1:20 PM
#7
blackorchidcouture avatar

blackorchidcouture

Zen Follower

Join Date:
Apr 2010
Location:
Albuquerque, NM
Posts:
198
Plugin Contributions:
0

Re: New v154 having Admin glitch on orders.php page

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');
21 Apr 2015, 2:12 PM
#8
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,116
Plugin Contributions:
56

Re: New v154 having Admin glitch on orders.php page

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', [B]DIR_FS_CATALOG .[/B] '/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', [B]DIR_FS_CATALOG . [/B]'/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!

21 Apr 2015, 2:40 PM
#9
blackorchidcouture avatar

blackorchidcouture

Zen Follower

Join Date:
Apr 2010
Location:
Albuquerque, NM
Posts:
198
Plugin Contributions:
0

Re: New v154 having Admin glitch on orders.php page

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

21 Apr 2015, 2:59 PM
#10
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: New v154 having Admin glitch on orders.php page

lat9:

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

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

ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...

21 Apr 2015, 3:06 PM
#11
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,116
Plugin Contributions:
56

Re: New v154 having Admin glitch on orders.php page

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

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!!!! The file where you've got TABLE_BRAINTREE defined, is that only on the store-side, e.g. /includes/extra_datafiles/braintree_stuff.php? If so, you'll need to copy that file to /YOUR_ADMIN/includes/extra_datafiles/braintree_stuff.php for it to be loaded on the admin side.
21 Apr 2015, 3:12 PM
#12
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: New v154 having Admin glitch on orders.php page

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

includes/modules/payment/braintree_api.php on line 721 should have a query. It looks like the constant TABLE_BRAINTREE is within the quotes of the sql instead of being substituted with your definition. Suggest posting the code slightly before to slightly after that line...

ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...

21 Apr 2015, 4:41 PM
#14
blackorchidcouture avatar

blackorchidcouture

Zen Follower

Join Date:
Apr 2010
Location:
Albuquerque, NM
Posts:
198
Plugin Contributions:
0

Re: New v154 having Admin glitch on orders.php page

I fixed my admin/orders issue! The Braintree plugin (my payment processor) creates a blank table named TABLE_BRAINTREE, but then uses the table named braintree. I've left that blank table before, but this time I decided to delete it because it is literally empty. But obviously it needs it there, I imported the table from my backup database, and my problem is fixed! Yaye!

Thanks for everyone's help with this!!!

21 Apr 2015, 4:56 PM
#15
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,116
Plugin Contributions:
56

Re: New v154 having Admin glitch on orders.php page

I'm glad you got it sorted out (and now you're getting the logs you should, too)!