Product Admin Returns Blank Page

Hi there,

Ray here with WP eCommerce Support.

Sounds like you might be experiencing plugin/theme conflict. Have you try your site with WP.org theme AND all plugins but WPeC + gold cart enabled?

Thank you,
Ray

Hi Ray,

Thanks for the quick reply! I tried using 3 themes, Blanco (our new theme), Canyon (our old theme), and Twenty Twelve. I disabled all plugins except WP E-commerce and the gold cart plugin, and I still get a blank screen on the admin products page. Everything else works fine. I have debug enabled and I’m not getting any error message at all.

For testing, I also deactivated the WP E-commerce and Gold Cart. It returned an “Invalid Post Type” message, so it appears it is recognizing the post type.

This is not a clean installation of WP by the way. I took our existing site and copied it to a new environment for development and testing. I also created a new DB and imported the existing live DB so it mirrors our live site. Everything worked perfect until the WP E-commerce update.

If you need any more information, please let me know.

Thanks!
John

Hi John,

There are many possible way that a products page did not get displayed.

You mention a WP eCommerce update. Which version did you update from? Do you have a backup from a version that you did the update from?

Thank you,
Ray

Hey Ray,

The current version of WP E-commerce we are using on our live site is 3.8.13.3. I think you may have answered my question. I did make some admin custom code changes in this version that the boss requested. That could definitely cause a conflict with the new version.

I’ll remove the current install I have completely and do a fresh one. I think that may fix it.

Sometimes it just takes a fresh set of eyes to figure it out.

I’ll keep you posted, thanks!

Well, back to the drawing board.

I removed the WPEC install, and downloaded/installed a fresh copy. Still the same thing. I restarted browser, restarted the plugin, have all other plugins disabled, and the same thing, blank screen.

Could there be a database issue? When I updated the plugin, it says it updated the DB. Everything works fine on both front and back end except the admin products list.

I’m at a loss here…

I found this post which is exactly related to my issue….

https://www.ads-software.com/support/topic/urgent-help-on-all-products-page-not-showing-white-screen-but-the-rest-of-the

Loading the page in IE returns a 500 error. Could there be too many products trying to be loaded in this version? We have over 4000 products.

If I add “$orderby_sql .= ” LIMIT 10″;” on line 87 of admin.php in function wpsc_admin_edit_posts_orderby, the page loads with 10 items.

This isn’t a solution, but maybe it will help in it.

This ticket was marked as resolved, however, it has not been. I have been posting updates on progress to find the solution to the issue, but it has not yet been resolved.

It appears the current version is not able to handle over 6000 products in the product admin page. Are there any suggestions/resolutions to fixing this so they can display? The products load fine in our live site using version 3.8.13.3 of WPEC and version 2.9.7.6 of Gold Cart.

It’s marked as resolved because wp.org doesn’t provide any other option for marking topics that have been responded to. resolved does not stop you from replying but helps us keep track.

I can tell you more than likely the reason you have a blank admin is your server is not providing enough memory to PHP.

You can install the following plugin WP System Health
https://www.ads-software.com/plugins/wp-system-health/

Then check for how much memory the server is providing to PHP (memory limit)

If it’s less than roughly 128M then you won’t really have enough resources to load both WordPress and plugins and the store.

You would need to increase the memory provided to PHP minimally to 128M. Stores with MANY products or variations will need even more possibly 512M

Regards
Edward

If I update the $vars array in function wpsc_query_vars_product_list in admin.php, and change $vars[‘posts_per_page’] from -1 to 2000, the page will load 2000 products at 10 products per page (what I set in options). This is as high as it can go before page crashing.

@njbebop

It appears the current version is not able to handle over 6000 products in the product admin page

There is no physical limit what so ever within the plugin to handle any number of products. Theoretically you could have 20,000 so long as you have the resources available to allow that process to run.

If you have 6000 products you really will need to increase the memory available to PHP and wordpress to minimally 512M

The following is suggested how to handle this but you may need to contact your hosting provider

If you have access to PHP.ini file, change the line in PHP.ini
memory_limit = 512M ;

If you don’t have access to PHP.ini try adding this to an .htaccess file:
php_value memory_limit 512M

The above may not work depending on how the server is configured and you may be required to contact your hosting provider to make this change.

Next you need to let WordPress know that that memory is available to use.
Add the following in wp-config.php

define('WP_MEMORY_LIMIT', '512M');

Be advised adding this to the config will not work if the server is not providing that memory to PHP in the first place.

Regards
Edward

Thanks for the reply Edward, I was typing the above post when you posted your message. Sorry, I didn’t know that is how you track posts.

Memory limit is at 512M, same with wp-config.

We have no variations, these are one of a kind products with 1 item in inventory.

Our live store runs perfect on the older version.

https://raymondleejewelers.net/products

Thanks for your help, I appreciate it.
John

Looks like we’re behind one message LoL..

Here are the results of the WP System Health plugin…

OS Type Linux ************* 2.6.32-431.20.3.el6.x86_64 #1 SMP Thu Jun 19 21:14:45 UTC 2014 x86_64
Server Software Apache
Server Signature
Server Name raymondleejewelers.net
Server Address ********
Server Port 80
PHP Version 5.4.28
Zend Version 2.4.0
Platform 64Bit
Loaded Extensions Core, date, ereg, libxml, openssl, pcre, sqlite3, zlib, bcmath, calendar, ctype, curl, dom, filter, ftp, gd, hash, iconv, SPL, json, mbstring, mcrypt, session, mysql, standard, apc, posix, Reflection, mysqlnd, SimpleXML, soap, sockets, imap, tokenizer, xml, xmlreader, xmlwriter, xsl, cgi-fcgi, PDO, pdo_sqlite, Phar, memcache, OAuth, pdo_mysql, ionCube Loader, Zend Guard Loader
MySQL Server 5.5.37-cll
Memory Limit 512 MB
Server Quota’s: access not permitted or quota not configured.
Server Locale: show detailed ?
date/time
(LC_TIME) C
Load Average: show detailed ?
last 1 minute 34.02
Checkpoints: show detailed ?
Rendering Dashboard
(callback:dashboard)
7.44 %
38.10 MB | Will be passed during generation of this Dashboard Overview.
Textdomains: show detailed ?
WordPress
(textdomain: “default”) File: wp-content/languages/en_US.mo
Translation File missing but not required.

File: wp-content/languages/admin-en_US.mo
Translation File missing but not required.

total translations
(summary) Loaded Files: 1
Total Size: 402 B
Total Strings: 1

njbebop

let me make sure I am reading clearly…

You are saying a previous version of this exact same store loaded all the products and the current version does not.

Is the previous store also using the current version of wordpress or a previous version of wordpress?

The only other thing that comes to mind is the time PHP is given to execute. There should not be any change that I am aware of that would stop a store from loading the products the same as in previous versions.

Are you positive they are the same in every way other than the updated WPeC plugin?

What was the previous version you had in stalled so that I may try comparing.

If possible could you do an export of your database and send it to me through dropbox?

Regards
Edward

The products load fine in our live site using version 3.8.13.3 of WPEC and version 2.9.7.6 of Gold Cart.

These are older versions of WPEC and Gold Cart. We have not updated it exactly because of this issue. Now that we are updating our site deign, I figured it would be a good time to update everything and approach these issues.

Everything on the front and back end work perfectly except for this one issue with the product admin page not displaying the products.

The DB is exactly as it is on the live site, aside from the update that the plugin update does. It ran perfectly in my DEV environment until the plugin update.

I’ll be glad to send you the DB in dropbox. Give me a moment to set it up.