SimpleCart editing resource category returns blank page

Hey there,

I have SimpleCart installed and when I try to edit one of the categories under resources I end up on a blank page. I can create a new category and when I do I get the pop-up interface where I can edit said resource but once I hit save and try to edit it again -> blank page.

All other resources or chunks, snippets, etc. work totally fine.

Here’s what I’ve tried so far (without success):

  • clearing cache and cookies
  • reinstalling SimpleCart
  • uninstalling all other extras (and I don’t have TinyMCE which seemed to cause similar problems in the past)
  • rerunning modx setup

Worth noting might be that when I uninstall SimpleCart I get a few errors

Could not load class: scCategoryResource from mysql.sccategoryresource.
scCategoryResource::loadCollection() is not a valid static method.
PHP warning: Invalid argument supplied for foreach()
Could not load class: scProductResource from mysql.scproductresource.
scProductResource::loadCollection() is not a valid static method.
PHP warning: Invalid argument supplied for foreach()
 
Could not load class: scCategoryResource from mysql.sccategoryresource.
Could not load class: scProductResource from mysql.scproductresource.
Could not load class: scCategoryResource from mysql.sccategoryresource.
Could not load class: scProductResource from mysql.scproductresource.
Could not load class: scCategoryResource from mysql.sccategoryresource.
Could not load class: scProductResource from mysql.scproductresource.
Could not load class: scCategoryResource from mysql.sccategoryresource.
Could not load class: scProductResource from mysql.scproductresource.

My setup:

I hope someone can help me with this, not sure what else I could do here.
Maybe the error-log helps? I don’t know really how to interpret those outputs.

Thanks alot in advance!

Could you check your PHP error logs for any messages? And also, just in case it’s not server but client side, your browser developer tools for any errors?

So the server shows a 500 error: GET /manager/?a=resource/update&id=37 HTTP/1.0

The dev console doesn’t show anything, but like I said I get a totally blank page after clicking on a category resource. I’m on Firefox btw.

If it’s a 500 error we’ll need to look at the php error log :slight_smile:

Well, as it turns out PHP errors were disabled and because I wanted to do something now I’ve setup a completely new install of modx because I’m afraid something went wrong during the upgrade process to MODX 2.6.5 a few months ago. (Also I enabled PHP error logging now).

Good news is I can edit the category resources now! :wink:

Maybe bad news is a bunch of errors during the install of SimpleCart:

/** MODX Console Output ** 

[...]

Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_currencies' doesn't exist
)


Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_currencies' doesn't exist
)


Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_currencies' doesn't exist
)


Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_taxes' doesn't exist
)


Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_productsmeta' doesn't exist
)


Error 42S02 executing statement:
INSERT INTO `vn_simplecart_productsmeta` (`resource`, `code`, `price`, `special_price`) VALUES (4, 'A123456', '12.95', '0')
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_productsmeta' doesn't exist
)


Creating resource Product A (scProductResource): successfully created

Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_currencies' doesn't exist
)


Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_currencies' doesn't exist
)


Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_taxes' doesn't exist
)


Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_productsmeta' doesn't exist
)


Error 42S02 executing statement:
INSERT INTO `vn_simplecart_productsmeta` (`resource`, `code`, `price`, `special_price`) VALUES (5, 'B789456111', '49.95', '0')
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_productsmeta' doesn't exist
)


Creating resource Product B (scProductResource): successfully created

Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_currencies' doesn't exist
)


Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_currencies' doesn't exist
)


Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_taxes' doesn't exist
)


Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_productsmeta' doesn't exist
)


Error 42S02 executing statement:
INSERT INTO `vn_simplecart_productsmeta` (`resource`, `code`, `price`, `special_price`) VALUES (6, 'CC7894566', '24.95', '0')
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_productsmeta' doesn't exist
)


Creating resource Product C (scProductResource): successfully created

Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_currencies' doesn't exist
)


Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_currencies' doesn't exist
)


Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_taxes' doesn't exist
)


Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_productsmeta' doesn't exist
)


Error 42S02 executing statement:
INSERT INTO `vn_simplecart_productsmeta` (`resource`, `code`, `price`, `special_price`) VALUES (7, 'D3214577', '129.95', '0')
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_productsmeta' doesn't exist
)


Creating resource Product D (scProductResource): successfully created

Creating resource Category 1 (scCategoryResource): successfully created

Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_currencies' doesn't exist
)


Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_currencies' doesn't exist
)


Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_currencies' doesn't exist
)


Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_taxes' doesn't exist
)


Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_productsmeta' doesn't exist
)


Error 42S02 executing statement:
INSERT INTO `vn_simplecart_productsmeta` (`resource`, `code`, `price`, `special_price`) VALUES (9, 'E123456', '22.95', '0')
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_productsmeta' doesn't exist
)


Creating resource Product E (scProductResource): successfully created

Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_currencies' doesn't exist
)


Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_currencies' doesn't exist
)


Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_taxes' doesn't exist
)


Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_productsmeta' doesn't exist
)


Error 42S02 executing statement:
INSERT INTO `vn_simplecart_productsmeta` (`resource`, `code`, `price`, `special_price`) VALUES (10, 'F78945611F', '49.95', '0')
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_productsmeta' doesn't exist
)


Creating resource Product F (scProductResource): successfully created

Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_currencies' doesn't exist
)


Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_currencies' doesn't exist
)


Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_taxes' doesn't exist
)


Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_productsmeta' doesn't exist
)


Error 42S02 executing statement:
INSERT INTO `vn_simplecart_productsmeta` (`resource`, `code`, `price`, `special_price`) VALUES (11, 'G6477844G', '1164.95', '0')
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_productsmeta' doesn't exist
)


Creating resource Product G (scProductResource): successfully created

Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_currencies' doesn't exist
)


Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_currencies' doesn't exist
)


Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_taxes' doesn't exist
)


Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_productsmeta' doesn't exist
)


Error 42S02 executing statement:
INSERT INTO `vn_simplecart_productsmeta` (`resource`, `code`, `price`, `special_price`) VALUES (12, 'H1HH2H334', '12129', '0')
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'k57992_vibernation.vn_simplecart_productsmeta' doesn't exist
)

[...]

Successfully installed package simplecart-2.5.1-pl

Will these errors make problems in the future?

Might want to do a reinstall of SimpleCart (just the reinstall button - no need to uninstall/install) to make sure things got created properly. If you still get any issues in a reinstall that’s worth looking into.

Glad you can edit categories again though!

1 Like

Yes, no errors this time. Thanks alot! :blush: