photo

Anonymous

shared this problem
6 years ago

Employees Involved

photo

PIV Support

Admin

Statistics

3
Comments
713
Views

Relates to

Share

3
votes

Help needed with install!

When i install open realty and he wants to make de database ill get this error:

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_company_name CHAR VARYING(45), controlpanel_company_location CHAR VARYING(45), controlpanel_company_logo CHAR VARYING(45), 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_agent_template CHAR VARYING(45) NOT NULL,

etc.

Can somebody pleas help me?

Add Comment

Comments (3)

photo Employee
0

What do you get if you run that failed SQL query through PHPmyAdmin or whatever you use to manage your mySQL databases?

Is this a 100% new install, or have you tried it before and had to start over?

Have you verified that your DB user has "all" DB permissions set when you created it?

photo
0

I have a similar error and yes I have checked to make sure the user has all DB permissions. I tried to install it once and the user did not have permissions and I realized there was an error with the password I used. I went back and changed the password to remove a $ and now I have this error:

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_company_name CHAR VARYING(45), controlpanel_company_location CHAR VARYING(45), controlpanel_company_logo CHAR VARYING(45), 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_agent_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_listings_upload_height 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_user_upload_height 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_edit_site_config INT2 NOT NULL, controlpanel_agent_default_edit_member_template INT2 NOT NULL, controlpanel_agent_default_edit_agent_template INT2 NOT NULL, controlpanel_agent_default_edit_listing_template 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_agent_default_can_export_listings INT2 NOT NULL, controlpanel_agent_default_edit_all_users INT2 NOT NULL, controlpanel_agent_default_edit_all_listings INT2 NOT NULL, controlpanel_agent_default_edit_property_classes INT2 NOT NULL, controlpanel_moderate_agents INT2 NOT NULL, controlpanel_moderate_members INT2 NOT NULL, controlpanel_moderate_listings INT2 NOT NULL, controlpanel_export_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_listings 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_address2 CHAR VARYING(45) NOT NULL, controlpanel_map_address3 CHAR VARYING(45) NOT NULL, controlpanel_map_address4 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_map_country CHAR VARYING(45) NOT NULL, controlpanel_wysiwyg_execute_php INT4 NOT NULL, controlpanel_number_decimals_number_fields INT2 NOT NULL, controlpanel_number_decimals_price_fields INT2 NOT NULL, controlpanel_automatic_update_check INT2 NOT NULL, controlpanel_search_sortby CHAR VARYING(45) NOT NULL, controlpanel_search_sorttype CHAR VARYING(45) NOT NULL, controlpanel_show_listedby_admin INT2 NOT NULL, controlpanel_show_next_prev_listing_page INT2 NOT NULL, controlpanel_seo_default_description TEXT NOT NULL, controlpanel_seo_default_keywords TEXT NOT NULL, controlpanel_seo_listing_description TEXT NOT NULL, controlpanel_seo_listing_keywords TEXT NOT NULL, controlpanel_seo_default_title TEXT NOT NULL, controlpanel_seo_listing_title TEXT NOT NULL, controlpanel_template_listing_sections TEXT NOT NULL, controlpanel_vtour_template CHAR VARYING(45) NOT NULL, controlpanel_vtour_width CHAR VARYING(45) NOT NULL, controlpanel_vtour_height CHAR VARYING(45) NOT NULL, controlpanel_vt_popup_width CHAR VARYING(45) NOT NULL, controlpanel_vt_popup_height CHAR VARYING(45) NOT NULL, controlpanel_vtour_fov CHAR VARYING(45) NOT NULL, controlpanel_zero_price INT2 NOT NULL, controlpanel_vcard_phone CHAR VARYING(45) NOT NULL, controlpanel_vcard_fax CHAR VARYING(45) NOT NULL, controlpanel_vcard_mobile CHAR VARYING(45) NOT NULL, controlpanel_vcard_address CHAR VARYING(45) NOT NULL, controlpanel_vcard_city CHAR VARYING(45) NOT NULL, controlpanel_vcard_state CHAR VARYING(45) NOT NULL, controlpanel_vcard_zip CHAR VARYING(45) NOT NULL, controlpanel_vcard_country CHAR VARYING(45) NOT NULL, controlpanel_vcard_notes CHAR VARYING(45) NOT NULL, controlpanel_vcard_url CHAR VARYING(45) NOT NULL, controlpanel_email_information_to_new_users INT2 NOT NULL, controlpanel_demo_mode INT2 NOT NULL, controlpanel_max_search_results INT4 NOT NULL, controlpanel_feature_list_separator CHAR VARYING(45) NOT NULL, controlpanel_search_list_separator CHAR VARYING(45) NOT NULL, controlpanel_rss_title_featured CHAR VARYING(45) NOT NULL, controlpanel_rss_desc_featured CHAR VARYING(255) NOT NULL, controlpanel_rss_listingdesc_featured TEXT NOT NULL, controlpanel_rss_title_lastmodified CHAR VARYING(45) NOT NULL, controlpanel_rss_desc_lastmodified CHAR VARYING(255) NOT NULL, controlpanel_rss_listingdesc_lastmodified TEXT NOT NULL, controlpanel_rss_limit_lastmodified INT4 NOT NULL, controlpanel_thumbnail_height INT4 NOT NULL, controlpanel_resize_thumb_by CHAR VARYING(20) NOT NULL, controlpanel_resize_by CHAR VARYING(20) NOT NULL, controlpanel_charset VARCHAR( 15 ) NOT NULL, controlpanel_wysiwyg_show_edit INT2 NOT NULL, controlpanel_textarea_short_chars INT4 NOT NULL, controlpanel_main_image_display_by CHAR VARYING(20) NOT NULL, controlpanel_main_image_width INT4 NOT NULL, controlpanel_main_image_height INT4 NOT NULL, controlpanel_number_columns INT4 NOT NULL, controlpanel_rss_limit_featured INT4 NOT NULL, controlpanel_force_decimals INT2 NOT NULL, controlpanel_icon_image_width INT4 NOT NULL, controlpanel_icon_image_height INT4 NOT NULL, controlpanel_max_listings_file_uploads INT4 NOT NULL, controlpanel_max_listings_file_upload_size INT4 NOT NULL, controlpanel_allowed_file_upload_extensions CHAR VARYING(255) NOT NULL, controlpanel_show_file_icon INT(2) NOT NULL, controlpanel_show_file_size INT(2) NOT NULL, controlpanel_file_display_option CHAR VARYING(20) NOT NULL, controlpanel_include_senders_ip INT(2) NOT NULL, controlpanel_agent_default_havefiles INT(2) NOT NULL, controlpanel_agent_default_haveuserfiles INT(2) NOT NULL, controlpanel_max_users_file_uploads INT4 NOT NULL, controlpanel_max_users_file_upload_size INT4 NOT NULL, controlpanel_show_notes_field INT2 NOT NULL, controlpanel_disable_referrer_check INT2 NOT NULL, controlpanel_seo_url_seperator CHAR VARYING(20) NOT NULL, controlpanel_search_step_max INT4 NOT NULL, controlpanel_special_search_sortby CHAR VARYING(45) NOT NULL, controlpanel_special_search_sorttype CHAR VARYING(45) NOT NULL, controlpanel_price_field CHAR VARYING(45) NOT NULL, controlpanel_users_per_page INT4 NOT NULL, controlpanel_show_admin_on_agent_list INT2 NOT NULL, controlpanel_agent_default_num_featuredlistings INT4 NOT NULL, controlpanel_use_signup_image_verification INT2 NOT NULL, controlpanel_site_email CHAR VARYING(45) NOT NULL, controlpanel_mbstring_enabled INT2 NOT NULL, controlpanel_require_email_verification INT2 NOT NULL, controlpanel_blog_requires_moderation INT2 NOT NULL, controlpanel_maintenance_mode INT2 NOT NULL, controlpanel_notification_last_timestamp TIMESTAMP NOT NULL DEFAULT now(), controlpanel_notify_listings_template CHAR VARYING(45) NOT NULL, controlpanel_twitter_auth LONGTEXT NULL, controlpanel_twitter_new_listings INT(1) NOT NULL DEFAULT 0, controlpanel_twitter_update_listings INT(1) NOT NULL DEFAULT 0, controlpanel_twitter_new_blog INT(1) NOT NULL DEFAULT 0, controlpanel_blog_pingback_urls LONGTEXT NULL, controlpanel_blogs_per_page INT4 NOT NULL DEFAULT 10, controlpanel_allow_pingbacks INT(1) NOT NULL DEFAULT 1, controlpanel_send_url_pingbacks INT(1) NOT NULL DEFAULT 1, controlpanel_send_service_pingbacks INT(1) NOT NULL DEFAULT 1, controlpanel_timezone CHAR VARYING(45) NOT NULL default 'America/New_York', controlpanel_default_page CHAR VARYING(45) NOT NULL default 'wysiwyg_page', controlpanel_banned_domains_signup LONGTEXT NULL, controlpanel_banned_ips_signup LONGTEXT NULL, controlpanel_banned_ips_site LONGTEXT NULL, controlpanel_rss_title_blogposts CHAR VARYING(45) NOT NULL, controlpanel_rss_desc_blogposts CHAR VARYING(255) NOT NULL, controlpanel_rss_title_blogcomments CHAR VARYING(45) NOT NULL, controlpanel_rss_desc_blogcomments CHAR VARYING(255) NOT NULL, controlpanel_phpmailer INT2 NOT NULL DEFAULT 0, controlpanel_mailserver CHAR VARYING(255) NULL, controlpanel_mailport INT4 NOT NULL DEFAULT 25, controlpanel_mailuser CHAR VARYING(255) NULL, controlpanel_mailpass CHAR VARYING(255) NULL, controlpanel_agent_default_canManageAddons INT4 NOT NULL, controlpanel_agent_default_blogUserType INT4 NOT NULL, controlpanel_agent_default_edit_all_leads INT2 NOT NULL, controlpanel_agent_default_edit_lead_template INT2 NOT NULL, controlpanel_enable_tracking INT2 NOT NULL, controlpanel_enable_tracking_crawlers INT2 NOT NULL, controlpanel_show_agent_no_photo INT2 NOT NULL, controlpanel_template_lead_sections TEXT NOT NULL, controlpanel_apikey CHAR VARYING(255) NOT NULL, controlpanel_allow_template_change INT2 NOT NULL, controlpanel_allow_language_change INT2 NOT NULL, controlpanel_listingimages_slideshow_group_thumb INT4 NOT NULL, controlpanel_admin_listing_per_page INT4 NOT NULL, controlpanel_mobile_template CHAR VARYING(45) NOT NULL, controlpanel_captcha_system CHAR VARYING(45) NOT NULL, controlpanel_floor_agent CHAR VARYING(255) NULL, controlpanel_floor_agent_last INT4 NULL, controlpanel_contact_template CHAR VARYING(45) NOT NULL, PRIMARY KEY(controlpanel_version) ) CHARACTER SET utf8 COLLATE utf8_unicode_ci;

Please advise if I am better off deleting everything and starting from scratch with a password that does not contain a charachter.

Thanks!

photo Employee
0

mySQL definitely does not like the $ character in a password.

Sounds like you got partially through an install, and are trying to re-install over a DB that is not empty.

Delete the contents of your DB and re-install.

Leave Comment

photo

Attach files...

The file must be a jpg, gif, png, bmp, ico, pdf, doc, rtf, txt, zip or rar no more than 20M