Phew! Glad (and sorry) to see this thread already exists...I thought I was losing my mind.
Been experiencing the same issue here, running on a local testing server Apache/2.0.59 (Win32), PHP 5.2.0, MySQL 5.0.27-community-nt...
However, when I clear my cookies/etc, I still don’t get the tab.
* Let me try in IE 7 and after a browser restart *
Interesting... Neither worked... confirming valid permissions now...
Hmm... I
don’t see:
new_chunk, edit_chunk, save_chunk and delete_chunk fields in modx_user_roles table
Here’s the modx_user_roles DDL
Table Create Table
--------------- -------------------------------------------------------------------------------------------------------------------
modx_user_roles CREATE TABLE `modx_user_roles` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`description` varchar(255) NOT NULL default '',
`frames` int(1) NOT NULL default '0',
`home` int(1) NOT NULL default '0',
`view_document` int(1) NOT NULL default '0',
`new_document` int(1) NOT NULL default '0',
`save_document` int(1) NOT NULL default '0',
`publish_document` int(1) NOT NULL default '0',
`delete_document` int(1) NOT NULL default '0',
`action_ok` int(1) NOT NULL default '0',
`logout` int(1) NOT NULL default '0',
`help` int(1) NOT NULL default '0',
`messages` int(1) NOT NULL default '0',
`new_user` int(1) NOT NULL default '0',
`edit_user` int(1) NOT NULL default '0',
`logs` int(1) NOT NULL default '0',
`edit_parser` int(1) NOT NULL default '0',
`save_parser` int(1) NOT NULL default '0',
`edit_template` int(1) NOT NULL default '0',
`settings` int(1) NOT NULL default '0',
`credits` int(1) NOT NULL default '0',
`new_template` int(1) NOT NULL default '0',
`save_template` int(1) NOT NULL default '0',
`delete_template` int(1) NOT NULL default '0',
`edit_snippet` int(1) NOT NULL default '0',
`new_snippet` int(1) NOT NULL default '0',
`save_snippet` int(1) NOT NULL default '0',
`delete_snippet` int(1) NOT NULL default '0',
`empty_cache` int(1) NOT NULL default '0',
`edit_document` int(1) NOT NULL default '0',
`change_password` int(1) NOT NULL default '0',
`error_dialog` int(1) NOT NULL default '0',
`about` int(1) NOT NULL default '0',
`file_manager` int(1) NOT NULL default '0',
`save_user` int(1) NOT NULL default '0',
`delete_user` int(1) NOT NULL default '0',
`save_password` int(11) NOT NULL default '0',
`edit_role` int(1) NOT NULL default '0',
`save_role` int(1) NOT NULL default '0',
`delete_role` int(1) NOT NULL default '0',
`new_role` int(1) NOT NULL default '0',
`access_permissions` int(1) NOT NULL default '0',
`bk_manager` int(1) NOT NULL default '0',
`new_plugin` int(1) NOT NULL default '0',
`edit_plugin` int(1) NOT NULL default '0',
`save_plugin` int(1) NOT NULL default '0',
`delete_plugin` int(1) NOT NULL default '0',
`new_module` int(1) NOT NULL default '0',
`edit_module` int(1) NOT NULL default '0',
`save_module` int(1) NOT NULL default '0',
`delete_module` int(1) NOT NULL default '0',
`exec_module` int(1) NOT NULL default '0',
`view_eventlog` int(1) NOT NULL default '0',
`delete_eventlog` int(1) NOT NULL default '0',
`manage_metatags` int(1) NOT NULL default '0' COMMENT 'manage site meta tags and keywords',
`edit_doc_metatags` int(1) NOT NULL default '0' COMMENT 'edit document meta tags and keywords',
`new_web_user` int(1) NOT NULL default '0',
`edit_web_user` int(1) NOT NULL default '0',
`save_web_user` int(1) NOT NULL default '0',
`delete_web_user` int(1) NOT NULL default '0',
`web_access_permissions` int(1) NOT NULL default '0',
`view_unpublished` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COMMENT='Contains information describing the user roles.'
I checked the
setup.sql
and the "chunk" column declarations DO exist:
CREATE TABLE IF NOT EXISTS `{PREFIX}user_roles` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`description` varchar(255) NOT NULL default '',
`frames` int(1) NOT NULL default '0',
`home` int(1) NOT NULL default '0',
`view_document` int(1) NOT NULL default '0',
`new_document` int(1) NOT NULL default '0',
`save_document` int(1) NOT NULL default '0',
`publish_document` int(1) NOT NULL default '0',
`delete_document` int(1) NOT NULL default '0',
`action_ok` int(1) NOT NULL default '0',
`logout` int(1) NOT NULL default '0',
`help` int(1) NOT NULL default '0',
`messages` int(1) NOT NULL default '0',
`new_user` int(1) NOT NULL default '0',
`edit_user` int(1) NOT NULL default '0',
`logs` int(1) NOT NULL default '0',
`edit_parser` int(1) NOT NULL default '0',
`save_parser` int(1) NOT NULL default '0',
`edit_template` int(1) NOT NULL default '0',
`settings` int(1) NOT NULL default '0',
`credits` int(1) NOT NULL default '0',
`new_template` int(1) NOT NULL default '0',
`save_template` int(1) NOT NULL default '0',
`delete_template` int(1) NOT NULL default '0',
`edit_snippet` int(1) NOT NULL default '0',
`new_snippet` int(1) NOT NULL default '0',
`save_snippet` int(1) NOT NULL default '0',
`delete_snippet` int(1) NOT NULL default '0',
`edit_chunk` int(1) NOT NULL default '0',
`new_chunk` int(1) NOT NULL default '0',
`save_chunk` int(1) NOT NULL default '0',
`delete_chunk` int(1) NOT NULL default '0',
`empty_cache` int(1) NOT NULL default '0',
`edit_document` int(1) NOT NULL default '0',
`change_password` int(1) NOT NULL default '0',
`error_dialog` int(1) NOT NULL default '0',
`about` int(1) NOT NULL default '0',
`file_manager` int(1) NOT NULL default '0',
`save_user` int(1) NOT NULL default '0',
`delete_user` int(1) NOT NULL default '0',
`save_password` int(11) NOT NULL default '0',
`edit_role` int(1) NOT NULL default '0',
`save_role` int(1) NOT NULL default '0',
`delete_role` int(1) NOT NULL default '0',
`new_role` int(1) NOT NULL default '0',
`access_permissions` int(1) NOT NULL default '0',
`bk_manager` int(1) NOT NULL DEFAULT 0,
`new_plugin` int(1) NOT NULL DEFAULT 0,
`edit_plugin` int(1) NOT NULL DEFAULT 0,
`save_plugin` int(1) NOT NULL DEFAULT 0,
`delete_plugin` int(1) NOT NULL DEFAULT 0,
`new_module` int(1) NOT NULL DEFAULT 0,
`edit_module` int(1) NOT NULL DEFAULT 0,
`save_module` int(1) NOT NULL DEFAULT 0,
`delete_module` int(1) NOT NULL DEFAULT 0,
`exec_module` int(1) NOT NULL DEFAULT 0,
`view_eventlog` int(1) NOT NULL DEFAULT 0,
`delete_eventlog` int(1) NOT NULL DEFAULT 0,
`manage_metatags` int(1) NOT NULL DEFAULT 0 COMMENT 'manage site meta tags and keywords',
`edit_doc_metatags` int(1) NOT NULL DEFAULT 0 COMMENT 'edit document meta tags and keywords' ,
`new_web_user` int(1) NOT NULL default '0',
`edit_web_user` int(1) NOT NULL default '0',
`save_web_user` int(1) NOT NULL default '0',
`delete_web_user` int(1) NOT NULL default '0',
`web_access_permissions` int(1) NOT NULL default '0',
`view_unpublished` int(1) NOT NULL default '0',
`import_static` int(1) NOT NULL default '0',
`export_static` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='Contains information describing the user roles.';
however, I wonder if the update ADD COLUMN statements are getting ran?
ALTER TABLE `{PREFIX}user_roles`
ADD COLUMN `new_chunk` int(1) NOT NULL DEFAULT '0' AFTER `delete_snippet`,
ADD COLUMN `edit_chunk` int(1) NOT NULL DEFAULT '0' AFTER `new_chunk`,
ADD COLUMN `save_chunk` int(1) NOT NULL DEFAULT '0' AFTER `edit_chunk`,
ADD COLUMN `delete_chunk` int(1) NOT NULL DEFAULT '0' AFTER `save_chunk`;
Regardless, I had to run the above SQL (and set everything to ’1’, of course) to fix for me... Odd how that’d somehow drop off, but I can possibly supply another clue:
I CREATED this local testing version via the SQL Backup Utility. Could it be that the Backup process somehow lost reference to the *_chunk columns? (or worse, even more?)
Well, according to my backup.sql, sure looks like it:
#
# Table structure for table `modx_user_roles`
#
DROP TABLE IF EXISTS `modx_user_roles`;
CREATE TABLE `modx_user_roles` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`description` varchar(255) NOT NULL default '',
`frames` int(1) NOT NULL default '0',
`home` int(1) NOT NULL default '0',
`view_document` int(1) NOT NULL default '0',
`new_document` int(1) NOT NULL default '0',
`save_document` int(1) NOT NULL default '0',
`publish_document` int(1) NOT NULL default '0',
`delete_document` int(1) NOT NULL default '0',
`action_ok` int(1) NOT NULL default '0',
`logout` int(1) NOT NULL default '0',
`help` int(1) NOT NULL default '0',
`messages` int(1) NOT NULL default '0',
`new_user` int(1) NOT NULL default '0',
`edit_user` int(1) NOT NULL default '0',
`logs` int(1) NOT NULL default '0',
`edit_parser` int(1) NOT NULL default '0',
`save_parser` int(1) NOT NULL default '0',
`edit_template` int(1) NOT NULL default '0',
`settings` int(1) NOT NULL default '0',
`credits` int(1) NOT NULL default '0',
`new_template` int(1) NOT NULL default '0',
`save_template` int(1) NOT NULL default '0',
`delete_template` int(1) NOT NULL default '0',
`edit_snippet` int(1) NOT NULL default '0',
`new_snippet` int(1) NOT NULL default '0',
`save_snippet` int(1) NOT NULL default '0',
`delete_snippet` int(1) NOT NULL default '0',
`empty_cache` int(1) NOT NULL default '0',
`edit_document` int(1) NOT NULL default '0',
`change_password` int(1) NOT NULL default '0',
`error_dialog` int(1) NOT NULL default '0',
`about` int(1) NOT NULL default '0',
`file_manager` int(1) NOT NULL default '0',
`save_user` int(1) NOT NULL default '0',
`delete_user` int(1) NOT NULL default '0',
`save_password` int(11) NOT NULL default '0',
`edit_role` int(1) NOT NULL default '0',
`save_role` int(1) NOT NULL default '0',
`delete_role` int(1) NOT NULL default '0',
`new_role` int(1) NOT NULL default '0',
`access_permissions` int(1) NOT NULL default '0',
`bk_manager` int(1) NOT NULL default '0',
`new_plugin` int(1) NOT NULL default '0',
`edit_plugin` int(1) NOT NULL default '0',
`save_plugin` int(1) NOT NULL default '0',
`delete_plugin` int(1) NOT NULL default '0',
`new_module` int(1) NOT NULL default '0',
`edit_module` int(1) NOT NULL default '0',
`save_module` int(1) NOT NULL default '0',
`delete_module` int(1) NOT NULL default '0',
`exec_module` int(1) NOT NULL default '0',
`view_eventlog` int(1) NOT NULL default '0',
`delete_eventlog` int(1) NOT NULL default '0',
`manage_metatags` int(1) NOT NULL default '0' COMMENT 'manage site meta tags and keywords',
`edit_doc_metatags` int(1) NOT NULL default '0' COMMENT 'edit document meta tags and keywords',
`new_web_user` int(1) NOT NULL default '0',
`edit_web_user` int(1) NOT NULL default '0',
`save_web_user` int(1) NOT NULL default '0',
`delete_web_user` int(1) NOT NULL default '0',
`web_access_permissions` int(1) NOT NULL default '0',
`view_unpublished` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COMMENT='Contains information describing the user roles.';
Uh oh!
I just tried Backing Up again (selecting ALL tables + DROP TABLE statements) and sure enough the columns are missing in even the most recent Backup .SQL file creation. However, I can see the CHUNKS tab on the Remote server, only the *_chunk columns don’t exist on the Remote SQL DB either

Very odd...
I have ran MODx Installer Updates on the remote box, and all I can say is that it appears these columns dropped off somehow. Therefore, this traveled back down through the backup utility and into my local testing box. At this point, I’m not suggesting the Backup manager is broke, or anything else in particular... May need to keep our eyes open for this one...