Results 1 to 4 of 4

Thread: SQL problem on installing upgrade

  1. #1
    Join Date
    Sep 2007
    Location
    Sydney, Australia
    Posts
    15

    Default SQL problem on installing upgrade

    Similar problem to bwill64 08-23-2007, 12:09 PM

    I am upgrading OR 1.1.5 to 2.4.1. All is fine until I get to Step 6 and the following:-

    Creating Property Class Tables
    Starting Property Class Conversion.
    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_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_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_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_editor 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_multiple_pclass_selection 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_use_email_image_verification INT2 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 DEFAULT '', 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 DEFAULT '', controlpanel_rss_limit_lastmodified INIT4 NOT NULL, PRIMARY KEY(controlpanel_version) );

    When I try to log into the front end (http://www.focusonlaw.info/) i get:-

    ERROR: SELECT * FROM default_controlpanel
    Warning: main() [function.main]: open_basedir restriction in effect. File(/include/misc.inc.php) is not within the allowed path(s): (/home/realty:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/realty/public_html/index.php on line 56

    Warning: main(/include/misc.inc.php) [function.main]: failed to open stream: Operation not permitted in /home/realty/public_html/index.php on line 56

    Fatal error: main() [function.require]: Failed opening required '/include/misc.inc.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/realty/public_html/index.php on line 56

    When I try to log into the back end (http://www.focusonlaw.info/admin) i get:-

    ERROR: SELECT * FROM default_controlpanel
    Warning: main() [function.main]: open_basedir restriction in effect. File(/include/language//lang.inc.php) is not within the allowed path(s): (/home/realty:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/realty/public_html/admin/index.php on line 52

    Warning: main(/include/language//lang.inc.php) [function.main]: failed to open stream: Operation not permitted in /home/realty/public_html/admin/index.php on line 52

    Warning: main() [function.main]: open_basedir restriction in effect. File(/include/language//lang.inc.php) is not within the allowed path(s): (/home/realty:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/realty/public_html/admin/index.php on line 52

    Warning: main(/include/language//lang.inc.php) [function.main]: failed to open stream: Operation not permitted in /home/realty/public_html/admin/index.php on line 52

    Warning: main() [function.include]: Failed opening '/include/language//lang.inc.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/realty/public_html/admin/index.php on line 52

    Warning: main() [function.main]: open_basedir restriction in effect. File(/include/login.inc.php) is not within the allowed path(s): (/home/realty:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/realty/public_html/admin/index.php on line 54

    Warning: main(/include/login.inc.php) [function.main]: failed to open stream: Operation not permitted in /home/realty/public_html/admin/index.php on line 54

    Fatal error: main() [function.require]: Failed opening required '/include/login.inc.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/realty/public_html/admin/index.php on line 54

    I tried the install a couple of times over and on different sites with the same problem. Can anyone help?

  2. #2
    Join Date
    May 2004
    Location
    Long Island, NY
    Age
    49
    Posts
    9,796

    Default Re: SQL problem on installing upgrade

    Try running the install query that is giving the error through phpmyadmin and see what the actual error is. The table cannot be created for some reason and that will be the fastest way to find out why.

  3. #3
    Join Date
    Sep 2007
    Location
    Sydney, Australia
    Posts
    15

    Default Re: SQL problem on installing upgrade

    My knowledge of mysql is zero and I do not understand what you mean by "running the install query that is giving the error through phpmyadmin". What is "the install query that is giving the error"?

    As a matter of interest I downloaded a copy of the updated database and uploaded it to a test site (www.cookbox.info) with a fresh install of OR 2.4.1 and the was the same but for the first line (ERROR: SELECT * FROM default_controlpanel) which was missing.

  4. #4
    Join Date
    Jul 2004
    Location
    Chile
    Posts
    95

    Smile Re: SQL problem on installing upgrade

    Quote Originally Posted by fritzula View Post
    My knowledge of mysql is zero and I do not understand what you mean by "running the install query that is giving the error through phpmyadmin". What is "the install query that is giving the error"?

    As a matter of interest I downloaded a copy of the updated database and uploaded it to a test site (www.cookbox.info) with a fresh install of OR 2.4.1 and the was the same but for the first line (ERROR: SELECT * FROM default_controlpanel) which was missing.
    Please send a PM... or email to cgaldam at gmail dot com

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •