Thread

Does anyone know why this would happen on a new install? Databse created and tested.

New Install 2.1.0
PHP 5.2.13
MySQL version 4.1.22-standard
Apache version 2.2.15

A Database Error Occurred
Error Number: 1146

Table ‘shelby_cms.sites’ doesn’t exist

UPDATE `sites` SET `site_system_preferences` = ‘YTo5MTp7czoxMDoic2l0ZV9pbmRleCI7czo5OiJp .....etc etc etc….’ WHERE `site_id` = 1

________________________________
So, I checked the datbase.

Checking Database
shelby_cms is now being checked.

shelby_cms.exp_accessories OK shelby_cms.exp_actions OK shelby_cms.exp_captcha OK shelby_cms.exp_categories OK shelby_cms.exp_category_field_data OK shelby_cms.exp_category_fields OK shelby_cms.exp_category_groups OK shelby_cms.exp_category_posts OK shelby_cms.exp_channel_data OK shelby_cms.exp_channel_entries_autosave OK shelby_cms.exp_channel_fields OK shelby_cms.exp_channel_member_groups OK shelby_cms.exp_channel_titles OK shelby_cms.exp_channels OK shelby_cms.exp_cp_log OK shelby_cms.exp_cp_search_index OK shelby_cms.exp_email_cache OK shelby_cms.exp_email_cache_mg OK shelby_cms.exp_email_cache_ml OK shelby_cms.exp_email_console_cache OK shelby_cms.exp_entry_ping_status OK shelby_cms.exp_entry_versioning OK shelby_cms.exp_extensions OK shelby_cms.exp_field_formatting OK shelby_cms.exp_field_groups OK shelby_cms.exp_fieldtypes OK shelby_cms.exp_global_variables OK shelby_cms.exp_html_buttons OK shelby_cms.exp_layout_publish OK shelby_cms.exp_member_bulletin_board OK shelby_cms.exp_member_data OK shelby_cms.exp_member_fields OK shelby_cms.exp_member_groups OK shelby_cms.exp_member_homepage OK shelby_cms.exp_member_search OK shelby_cms.exp_members OK shelby_cms.exp_message_attachments OK shelby_cms.exp_message_copies OK shelby_cms.exp_message_data OK shelby_cms.exp_message_folders OK shelby_cms.exp_message_listed OK shelby_cms.exp_module_member_groups OK shelby_cms.exp_modules OK shelby_cms.exp_online_users OK shelby_cms.exp_password_lockout OK shelby_cms.exp_ping_servers OK shelby_cms.exp_relationships OK shelby_cms.exp_reset_password OK shelby_cms.exp_revision_tracker OK shelby_cms.exp_security_hashes OK shelby_cms.exp_sessions OK shelby_cms.exp_sites OK shelby_cms.exp_snippets OK shelby_cms.exp_specialty_templates OK shelby_cms.exp_stats OK shelby_cms.exp_status_groups OK shelby_cms.exp_status_no_access OK shelby_cms.exp_statuses OK shelby_cms.exp_template_groups OK shelby_cms.exp_template_member_groups OK shelby_cms.exp_template_no_access OK shelby_cms.exp_templates OK shelby_cms.exp_throttle OK shelby_cms.exp_upload_no_access OK shelby_cms.exp_upload_prefs OK

I CAN NOT ACCESS THE CONTROL PANEL!!!

Also, I checked config.php and database.php and found both to be blank.

After looking through some of the scripts, it appears that the table was never created by the install process.

In your case it should be creating shelby_cms.exp_sites, though I don’t see why it’d leave off the prefix in this case. Are you able to complete a default install (that is, with the standard ‘exp_’ table prefix?

You are absolutley correct. The ‘exp_’ table prefix works. During the install, I cleared the field which is what caused the problem.

Thanks

Thanks for the update, Larry. Don’t hesitate to post again with further questions.