SimpleCart editing resource category returns blank page


(Corvin Roelofsen) #1

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!


(Mark Hamstra) #2

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?


(Corvin Roelofsen) #3

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.


(Mark Hamstra) #4

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


(Corvin Roelofsen) #5

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?


(Mark Hamstra) #6

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!


(Corvin Roelofsen) #7

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