Quote from: BobRay at Oct 13, 2010, 04:14 PM
I’m about out of ideas. maybe someone else can help. I have no clue how the tables got named that way unless there’s something strange about the server or MySQL configuration. MODx just prepends the table_prefix to the standard table names (user, site_content, system_settings, etc.).
You could try exporting the CentOS DB, dropping the problem tables from the problem install, and importing the DB from the CentOs install. Then run Setup in upgrade mode.
Hi, I am sorry I still am not seeing what you are saying is unusual about the table names:
mysql> use modx
Database changed
mysql> show tables;
+---------------------------------+
| Tables_in_modx |
+---------------------------------+
| modx_access_actiondom |
| modx_access_actions |
| modx_access_category |
| modx_access_context |
| modx_access_elements |
| modx_access_menus |
| modx_access_permissions |
| modx_access_policies |
| modx_access_resource_groups |
| modx_access_resources |
| modx_access_templatevars |
| modx_actiondom |
| modx_actions |
| modx_active_users |
| modx_categories |
| modx_categories_closure |
| modx_content_type |
| modx_context |
| modx_context_resource |
| modx_context_setting |
| modx_document_groups |
| modx_documentgroup_names |
| modx_element_property_sets |
| modx_event_log |
| modx_keyword_xref |
| modx_lexicon_entries |
| modx_manager_log |
| modx_member_groups |
| modx_membergroup_names |
| modx_menus |
| modx_namespaces |
| modx_property_set |
| modx_register_messages |
| modx_register_queues |
| modx_register_topics |
| modx_session |
| modx_site_content |
| modx_site_content_metatags |
| modx_site_htmlsnippets |
| modx_site_keywords |
| modx_site_metatags |
| modx_site_plugin_events |
| modx_site_plugins |
| modx_site_snippets |
| modx_site_templates |
| modx_site_tmplvar_access |
| modx_site_tmplvar_contentvalues |
| modx_site_tmplvar_templates |
| modx_site_tmplvars |
| modx_system_eventnames |
| modx_system_settings |
| modx_transport_packages |
| modx_transport_providers |
| modx_user_attributes |
| modx_user_group_roles |
| modx_user_messages |
| modx_user_roles |
| modx_user_settings |
| modx_users |
| modx_workspaces |
+---------------------------------+
60 rows in set (0.00 sec)
the table names are all normal in the database....
☆ A M B ☆
