andy1984uk
05-31-2005, 02:47 PM
Hi. Hopefully someone can point me in the right direction. I've uploaded the files to my host and im in the installation process. Ive entered my sql username, path and password and now im on step 6 which it says is now going to populate the database... i get the following error message... can anyone help please?
We are now going to populate the database.
ERROR - CREATE TABLE default_controlpanel ( controlpanel_version CHAR VARYING(15) NOT NULL , controlpanel_basepath CHAR VARYING(150) NOT NULL, controlpanel_baseurl CHAR VARYING(150) NOT NULL, controlpanel_admin_name CHAR VARYING(45) NOT NULL, controlpanel_admin_email CHAR VARYING(45) NOT NULL, controlpanel_site_title CHAR VARYING(45) NOT NULL, controlpanel_company_name CHAR VARYING(45), controlpanel_company_location CHAR VARYING(45), controlpanel_company_logo CHAR VARYING(45), controlpanel_phpmyadmin CHAR VARYING(45), controlpanel_manage_index_permissions INT2 NOT NULL, controlpanel_url_style INT2 NOT NULL, controlpanel_template CHAR VARYING(45) NOT NULL, controlpanel_admin_template CHAR VARYING(45) NOT NULL, controlpanel_listing_template CHAR VARYING(45) NOT NULL, controlpanel_search_result_template CHAR VARYING(45) NOT NULL, controlpanel_lang CHAR(2) NOT NULL, controlpanel_listings_per_page INT4 NOT NULL, controlpanel_num_featured_listings INT4 NOT NULL, controlpanel_add_linefeeds INT2 NOT NULL, controlpanel_strip_html INT2 NOT NULL, controlpanel_allowed_html_tags CHAR VARYING(45) NOT NULL, controlpanel_money_sign CHAR VARYING(20) NOT NULL, controlpanel_show_no_photo INT2 NOT NULL, controlpanel_number_format_style INT4 NOT NULL, controlpanel_money_format INT4 NOT NULL, controlpanel_date_format INT4 NOT NULL, controlpanel_max_listings_uploads INT4 NOT NULL, controlpanel_max_listings_upload_size INT4 NOT NULL, controlpanel_max_listings_upload_width INT4 NOT NULL, controlpanel_max_user_uploads INT4 NOT NULL, controlpanel_max_user_upload_size INT4 NOT NULL, controlpanel_max_user_upload_width INT4 NOT NULL, controlpanel_max_vtour_uploads INT4 NOT NULL, controlpanel_max_vtour_upload_size INT4 NOT NULL, controlpanel_max_vtour_upload_width INT4 NOT NULL, controlpanel_allowed_upload_extensions CHAR VARYING(45) NOT NULL, controlpanel_make_thumbnail INT2 NOT NULL, controlpanel_thumbnail_width INT4 NOT NULL, controlpanel_gd_version INT2 NOT NULL, controlpanel_thumbnail_prog CHAR VARYING(20) NOT NULL, controlpanel_path_to_imagemagick CHAR VARYING(255) NOT NULL, controlpanel_resize_img INT2 NOT NULL, controlpanel_jpeg_quality INT2 NOT NULL, controlpanel_use_expiration INT2 NOT NULL, controlpanel_days_until_listings_expire INT4 NOT NULL, controlpanel_allow_member_signup INT2 NOT NULL, controlpanel_allow_agent_signup INT2 NOT NULL, controlpanel_agent_default_active INT2 NOT NULL, controlpanel_agent_default_admin INT2 NOT NULL, controlpanel_agent_default_feature INT2 NOT NULL, controlpanel_agent_default_moderate INT2 NOT NULL, controlpanel_agent_default_logview INT2 NOT NULL, controlpanel_agent_default_editforms INT2 NOT NULL, controlpanel_agent_default_canchangeexpirations INT2 NOT NULL, controlpanel_agent_default_editpages INT2 NOT NULL, controlpanel_agent_default_havevtours INT2 NOT NULL, controlpanel_agent_default_num_listings INT2 NOT NULL, controlpanel_rental_step INT4 NOT NULL, controlpanel_max_rental_price INT4 NOT NULL, controlpanel_min_rental_price INT4 NOT NULL, controlpanel_moderate_agents INT2 NOT NULL, controlpanel_moderate_members INT2 NOT NULL, controlpanel_moderate_listings INT2 NOT NULL, controlpanel_email_notification_of_new_users INT2 NOT NULL, controlpanel_email_notification_of_new_listings INT2 NOT NULL, controlpanel_allowed_upload_types CHAR VARYING(95) NOT NULL, controlpanel_configured_langs CHAR VARYING(100) NOT NULL, controlpanel_email_users_notification_of_new_listi ngs INT2 NOT NULL, controlpanel_configured_show_count INT2 NOT NULL, controlpanel_map_type CHAR VARYING(45) NOT NULL, controlpanel_map_address CHAR VARYING(45) NOT NULL, controlpanel_map_city CHAR VARYING(45) NOT NULL, controlpanel_map_state CHAR VARYING(45) NOT NULL, controlpanel_map_zip CHAR VARYING(45) NOT NULL, controlpanel_wysiwyg_editor CHAR VARYING(45) NOT NULL, controlpanel_wysiwyg_execute_php INT4 NOT NULL, PRIMARY KEY(controlpanel_version) );
We are now going to populate the database.
ERROR - CREATE TABLE default_controlpanel ( controlpanel_version CHAR VARYING(15) NOT NULL , controlpanel_basepath CHAR VARYING(150) NOT NULL, controlpanel_baseurl CHAR VARYING(150) NOT NULL, controlpanel_admin_name CHAR VARYING(45) NOT NULL, controlpanel_admin_email CHAR VARYING(45) NOT NULL, controlpanel_site_title CHAR VARYING(45) NOT NULL, controlpanel_company_name CHAR VARYING(45), controlpanel_company_location CHAR VARYING(45), controlpanel_company_logo CHAR VARYING(45), controlpanel_phpmyadmin CHAR VARYING(45), controlpanel_manage_index_permissions INT2 NOT NULL, controlpanel_url_style INT2 NOT NULL, controlpanel_template CHAR VARYING(45) NOT NULL, controlpanel_admin_template CHAR VARYING(45) NOT NULL, controlpanel_listing_template CHAR VARYING(45) NOT NULL, controlpanel_search_result_template CHAR VARYING(45) NOT NULL, controlpanel_lang CHAR(2) NOT NULL, controlpanel_listings_per_page INT4 NOT NULL, controlpanel_num_featured_listings INT4 NOT NULL, controlpanel_add_linefeeds INT2 NOT NULL, controlpanel_strip_html INT2 NOT NULL, controlpanel_allowed_html_tags CHAR VARYING(45) NOT NULL, controlpanel_money_sign CHAR VARYING(20) NOT NULL, controlpanel_show_no_photo INT2 NOT NULL, controlpanel_number_format_style INT4 NOT NULL, controlpanel_money_format INT4 NOT NULL, controlpanel_date_format INT4 NOT NULL, controlpanel_max_listings_uploads INT4 NOT NULL, controlpanel_max_listings_upload_size INT4 NOT NULL, controlpanel_max_listings_upload_width INT4 NOT NULL, controlpanel_max_user_uploads INT4 NOT NULL, controlpanel_max_user_upload_size INT4 NOT NULL, controlpanel_max_user_upload_width INT4 NOT NULL, controlpanel_max_vtour_uploads INT4 NOT NULL, controlpanel_max_vtour_upload_size INT4 NOT NULL, controlpanel_max_vtour_upload_width INT4 NOT NULL, controlpanel_allowed_upload_extensions CHAR VARYING(45) NOT NULL, controlpanel_make_thumbnail INT2 NOT NULL, controlpanel_thumbnail_width INT4 NOT NULL, controlpanel_gd_version INT2 NOT NULL, controlpanel_thumbnail_prog CHAR VARYING(20) NOT NULL, controlpanel_path_to_imagemagick CHAR VARYING(255) NOT NULL, controlpanel_resize_img INT2 NOT NULL, controlpanel_jpeg_quality INT2 NOT NULL, controlpanel_use_expiration INT2 NOT NULL, controlpanel_days_until_listings_expire INT4 NOT NULL, controlpanel_allow_member_signup INT2 NOT NULL, controlpanel_allow_agent_signup INT2 NOT NULL, controlpanel_agent_default_active INT2 NOT NULL, controlpanel_agent_default_admin INT2 NOT NULL, controlpanel_agent_default_feature INT2 NOT NULL, controlpanel_agent_default_moderate INT2 NOT NULL, controlpanel_agent_default_logview INT2 NOT NULL, controlpanel_agent_default_editforms INT2 NOT NULL, controlpanel_agent_default_canchangeexpirations INT2 NOT NULL, controlpanel_agent_default_editpages INT2 NOT NULL, controlpanel_agent_default_havevtours INT2 NOT NULL, controlpanel_agent_default_num_listings INT2 NOT NULL, controlpanel_rental_step INT4 NOT NULL, controlpanel_max_rental_price INT4 NOT NULL, controlpanel_min_rental_price INT4 NOT NULL, controlpanel_moderate_agents INT2 NOT NULL, controlpanel_moderate_members INT2 NOT NULL, controlpanel_moderate_listings INT2 NOT NULL, controlpanel_email_notification_of_new_users INT2 NOT NULL, controlpanel_email_notification_of_new_listings INT2 NOT NULL, controlpanel_allowed_upload_types CHAR VARYING(95) NOT NULL, controlpanel_configured_langs CHAR VARYING(100) NOT NULL, controlpanel_email_users_notification_of_new_listi ngs INT2 NOT NULL, controlpanel_configured_show_count INT2 NOT NULL, controlpanel_map_type CHAR VARYING(45) NOT NULL, controlpanel_map_address CHAR VARYING(45) NOT NULL, controlpanel_map_city CHAR VARYING(45) NOT NULL, controlpanel_map_state CHAR VARYING(45) NOT NULL, controlpanel_map_zip CHAR VARYING(45) NOT NULL, controlpanel_wysiwyg_editor CHAR VARYING(45) NOT NULL, controlpanel_wysiwyg_execute_php INT4 NOT NULL, PRIMARY KEY(controlpanel_version) );