Error with Action Combobox

1,390 Posts

kongondo Reply #1, 17 years, 1 month ago

Hi,

Trying to add a rule..I click on the "action" field drop down menu and nothing loads. Isn’t it supposed to load the available actions so that I can select one?

cheers/k
----------
Apache 2.2
PHP 5.3
MySQL 5.1.37

Quote from: splittingred at Sep 03, 2009, 10:42 PM

Kogondo,

Yes, it is. Try force-refreshing your browser, and clear the browser-cache. If that doesn’t work, clear your site cache. If that doesn’t work...tell me if you get any errors in the console, and I’ll look at it in the morning.

Still doesn’t work. Here’s the error log (snipped - the errors are all in connectors/security/forms/rule.php and manager/index.php).

[2009-09-04 04:51:08] (ERROR @ /manager/index.php) Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'revosvn.modx_access_actiondom' doesn't exist
)

[2009-09-04 04:51:08] (ERROR @ /manager/index.php) Could not create table `modx_actiondom`
SQL: CREATE TABLE `modx_actiondom` (`id` INT(10) unsigned NOT NULL AUTO_INCREMENT,`action` INT(11) NOT NULL DEFAULT '0',`name` VARCHAR(255) NOT NULL DEFAULT '',`description` TEXT NULL,`xtype` VARCHAR(100) NOT NULL DEFAULT '',`container` VARCHAR(255) NOT NULL DEFAULT '',`rule` VARCHAR(100) NOT NULL DEFAULT '',`value` TEXT NOT NULL,`constraint` VARCHAR(255) NOT NULL DEFAULT '',`constraint_field` VARCHAR(100) NOT NULL DEFAULT '',`constraint_class` VARCHAR(100) NOT NULL DEFAULT '', PRIMARY KEY (`id`), INDEX `action` (`action`), INDEX `name` (`name`)) TYPE=MyISAM
ERROR: Array
(
    [0] => 42S01
    [1] => 1050
    [2] => Table 'modx_actiondom' already exists
)

[2009-09-04 04:51:08] (ERROR @ /manager/index.php) Error 42S01 attempting to create object container for class modActionDom:
Array
(
    [0] => 42S01
    [1] => 1050
    [2] => Table 'modx_actiondom' already exists
)

[2009-09-04 04:51:10] (ERROR @ /connectors/security/forms/rule.php) Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'revosvn.modx_access_actiondom' doesn't exist
)

cheers/k

Quote from: splittingred at Sep 03, 2009, 11:21 PM

Did you happen to rebuild the core transport zip and run setup upgrade?

Yep...I did

cheers/k

Wayfinder Lessons: The (almost) Complete Guide to Creating Menus in MODx Using Wayfinder

4,149 Posts

splittingred Reply #2, 17 years, 1 month ago

Quote from: kongondo at Sep 04, 2009, 04:42 AM

Yep...I did

cheers/k

Kogondo or BobRay,

Do you get any errors in the browser error console? What browser? FF or Safari? I can’t replicate this, and I don’t see why.

1. Can you check your DB and verify for me that modx_actions exists, and has records
2. Check if modx_actiondom exists (it will be empty)
3. Check if modx_access_actiondom exists

4. Go to: http://my/url/to/modx/connectors/system/action.php?action=getList when logged in to the manager and tell me what you see.

Thanks

shaun mccormick | bigcommerce mgr of software engineering, former modx co-architect | github | splittingred.com

24,544 Posts

BobRay Reply #3, 17 years, 1 month ago

Do you get any errors in the browser error console? NO
What browser? FF 3.5.2

1. Can you check your DB and verify for me that modx_actions exists, and has records YES
2. Check if modx_actiondom exists (it will be empty) YES
3. Check if modx_access_actiondom exists NO

4. Go to: http://my/url/to/modx/connectors/system/action.php?action=getList when logged in to the manager and tell me what you see.

({"total":"72","results":[{"id":0,"controller":"No Action"},{"id":5,"namespace":"core","parent":0,"controller":"core - browser\/index.php","haslayout":1,"lang_topics":"file","assets":""},{"id":6,"namespace":"core","parent":0,"controller":"core - context\/index.php","haslayout":1,"lang_topics":"context","assets":""},{"id":7,"namespace":"core","parent":6,"controller":"core - context\/create\/index.php","haslayout":1,"lang_topics":"context,setting","assets":""},{"id":8,"namespace":"core","parent":6,"controller":"core - context\/update.php","haslayout":1,"lang_topics":"context,setting","assets":""},{"id":9,"namespace":"core","parent":6,"controller":"core - context\/view.php","haslayout":1,"lang_topics":"context","assets":""},{"id":10,"namespace":"core","parent":0,"controller":"core - element\/index.php","haslayout":1,"lang_topics":"element","assets":""} etc.

Did I help you? Buy me a beer
Get my Book: MODX:The Official Guide
MODX info for everyone: http://bobsguides.com/modx.html
My MODX Extras
Bob's Guides is now hosted at A2 MODX Hosting

1,390 Posts

kongondo Reply #4, 17 years, 1 month ago

Do you get any errors in the browser error console? NO

What browser? FF 3.0

1. Can you check your DB and verify for me that modx_actions exists, and has records YES

2. Check if modx_actiondom exists (it will be empty) YES and it is empty

3. Check if modx_access_actiondom exists NO

4. Go to: http://my/url/to/modx/connectors/system/action.php?action=getList when logged in to the manager and tell me what you see.

Please see attached text file..(too many records wink

)

cheers/k

Wayfinder Lessons: The (almost) Complete Guide to Creating Menus in MODx Using Wayfinder

4,149 Posts

splittingred Reply #5, 17 years, 1 month ago

Ok, you’re definitely getting records. Make sure sure you’ve shift+reloaded that page. You’re getting the right data; I really think this is a JS cache error.

Can you attach your manager/assets/modext/widgets/core/modx.combo.js file?

Also post your manager/assets/modext/widgets/security/modx.grid.actiondom.js file.

shaun mccormick | bigcommerce mgr of software engineering, former modx co-architect | github | splittingred.com

1,390 Posts

kongondo Reply #6, 17 years, 1 month ago

Quote from: splittingred at Sep 04, 2009, 01:53 PM

Ok, you’re definitely getting records. Make sure sure you’ve shift+reloaded that page. You’re getting the right data; I really think this is a JS cache error.

Can you attach your manager/assets/modext/widgets/core/modx.combo.js file?

Also post your manager/assets/modext/widgets/security/modx.grid.actiondom.js file.

Here you go attached...

Btw, the other dropdowns are working fine...it’s just the action field one that’s not. It starts like its loading then its stop. I don’t have another supported browser to test in. I have checked in konqueror though and it is the same.

cheers/k

Wayfinder Lessons: The (almost) Complete Guide to Creating Menus in MODx Using Wayfinder

4,149 Posts

splittingred Reply #7, 17 years, 1 month ago

I went ahead and split this topic, fyi, since it was a bit offtopic.

kogondo, tbh, i’m not really sure what’s going on with your setup. It works perfectly fine with mine.

Edit: I just made a commit that *might* (might not) fix things in your setup. Let me know. I’m not optmistic.

There’s no browser errors in your error console?

shaun mccormick | bigcommerce mgr of software engineering, former modx co-architect | github | splittingred.com

1,390 Posts

kongondo Reply #8, 17 years, 1 month ago

No joy; no change sad

Also tested in ahem, Opera....Oh well, I’m sure a solution will come along, somewhere. What if I manually created the missing table? (modx_access_actiondom)

There are no browser errors related to this...just .css ones when logging into the manager.

e.g.

Warning: Unknown property 'zoom'.  Declaration dropped.
Source File: http://www.revosvn.local/manager/assets/ext3/resources/css/xtheme-gray-extend.css
Line: 102

cheers/k

Wayfinder Lessons: The (almost) Complete Guide to Creating Menus in MODx Using Wayfinder

4,149 Posts

splittingred Reply #9, 17 years, 1 month ago

Quote from: kongondo at Sep 04, 2009, 03:29 PM

No joy; no change Oh well, I’m sure a solution will come along, somewhere. What if I manually created the missing table? (modx_access_actiondom)

Working on a solution now; Jason was able to replicate this.

shaun mccormick | bigcommerce mgr of software engineering, former modx co-architect | github | splittingred.com

4,149 Posts

splittingred Reply #10, 17 years, 1 month ago

Okay, we’ve fixed it. You can update SVN to get the fix.

shaun mccormick | bigcommerce mgr of software engineering, former modx co-architect | github | splittingred.com