Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Upgrading didn't go so swell!

  1. #1
    Join Date
    Apr 2005
    Posts
    15

    Exclamation Upgrading didn't go so swell!

    I tried to upgrade my 1.5 to 2.0 and it went mostly okay but at the last step it puked up some errors populated tables.

    install/index.php?step=6 looks like:

    Notice: Undefined index: or_install_lang in /home/hscore/public_html/open_realty/install/index.php on line 425

    Warning: load_lang(/home/hscore/public_html/open_realty/install/lang//lang.inc.php): failed to open stream: No such file or directory in /home/hscore/public_html/open_realty/install/index.php on line 417

    Fatal error: load_lang(): Failed opening required '/home/hscore/public_html/open_realty/install/lang//lang.inc.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/hscore/public_html/open_realty/install/index.php on line 417

    Now when I try to configure, (http://localhost/open_realty/admin/i...tion=configure), I get:

    Notice: Undefined index: controlpanel_agent_default_num_listings in /home/hscore/public_html/open_realty/include/common.php on line 101

    Notice: Undefined index: controlpanel_wysiwyg_execute_php in /home/hscore/public_html/open_realty/include/common.php on line 121

    Warning: main(/home/hscore/public_html/open_realty/include/language//lang.inc.php): failed to open stream: No such file or directory in /home/hscore/public_html/open_realty/admin/index.php on line 60

    Warning: main(): Failed opening '/home/hscore/public_html/open_realty/include/language//lang.inc.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/hscore/public_html/open_realty/admin/index.php on line 60

    Basically, I replaced all the files from 1.5 with 2.0 and then ran the install. I did backup my database, and backed up the old 1.5 files, including config.php and images. Is it possible for me to fix this without having to load OR as a new install? I had a lot of properties and data listed I'd like to not have to reenter.

    Thanks guys. My testing of 2.0 is great. I love the new Search Engine Urls, and the xinha editor. Great job.

    con4mity

  2. #2
    Join Date
    Jun 2004
    Posts
    1,067

    Default

    Sounds like the session got lost durring hte install as the language was not set, so it was not able to complete. Try reloading your datbase backup and running the install again, if it doenst work PM me the URL so i cna look at it.

    Thanks

  3. #3
    Join Date
    Jul 2004
    Posts
    23

    Default Same problem

    I just tried to upgrade from 115 to 2 and got the same file not found for the language file. Tried to fix it myself, but no luck.

    Can this be fixed easily?


    Thanks

  4. #4
    Join Date
    Jul 2004
    Posts
    23

    Default same problem

    In case anyone else is having same prob, this is what I did.


    Deleted the database and tried a fresh install. Works fine.

  5. #5
    Join Date
    Jun 2004
    Posts
    1,067

    Default

    I found the problem with the upgrade script and have it fixed in SVN. I will get 2.0.1 built later today and up on the site.

  6. #6
    Join Date
    Apr 2005
    Posts
    15

    Default

    IXNAY this Message! I got the fix from SVN, going to try again!


    Giant, great, I'm looking forward to the fix. If you can post it to me any earlier I'd be happy to implement it myself. I did do as you suggested but received the same results.

    If you still want to look at the server let me know I can provide you access, though it is not a public site at the moment. I was doing this one of my test sites.

    Thanks in advance,
    Corey
    Last edited by con4mity; 05-19-2005 at 12:05 PM.

  7. #7
    Join Date
    Apr 2005
    Posts
    15

    Default

    Giant, I download the SVN, don't know if it was fixed or not, but now I get major errors:

    ERROR - ALTER TABLE default_activityLog RENAME default_en_activitylog
    ERROR - ALTER TABLE `default_en_activitylog` CHANGE `id` `activitylog_id` INT( 4 ) NOT NULL AUTO_INCREMENT
    ERROR - ALTER TABLE `default_en_activitylog` CHANGE `log_date` `activitylog_log_date` DATETIME NOT NULL
    ERROR - ALTER TABLE default_en_activitylog CHANGE `user` `userdb_id` INT( 4 ) NOT NULL
    ERROR - ALTER TABLE default_en_activitylog CHANGE `action` `activitylog_action` CHAR VARYING( 150 ) NOT NULL
    ERROR - ALTER TABLE default_en_activitylog CHANGE `ip_address` `activitylog_ip_address` CHAR VARYING( 15 ) NOT NULL
    ERROR - ALTER TABLE `default_en_activitylog` ADD PRIMARY KEY (`activitylog_id`)
    ERROR - ALTER TABLE `default_en_activitylog` DROP INDEX `id`
    ERROR - ALTER TABLE default_listingsDB RENAME default_en_listingsdb
    ERROR - ALTER TABLE `default_en_listingsdb` CHANGE `ID` `listingsdb_id` INT( 4 ) NOT NULL AUTO_INCREMENT
    ERROR - ALTER TABLE `default_en_listingsdb` CHANGE `user_ID` `userdb_id` INT( 4 ) NOT NULL
    ERROR - ALTER TABLE `default_en_listingsdb` CHANGE `Title` `listingsdb_title` CHAR VARYING( 80 ) NOT NULL
    ERROR - ALTER TABLE `default_en_listingsdb` CHANGE `expiration` `listingsdb_expiration` DATE NOT NULL
    ERROR - ALTER TABLE `default_en_listingsdb` CHANGE `notes` `listingsdb_notes` TEXT NOT NULL
    ERROR - ALTER TABLE `default_en_listingsdb` CHANGE `creation_date` `listingsdb_creation_date` DATE NOT NULL
    ERROR - ALTER TABLE `default_en_listingsdb` CHANGE `last_modified` `listingsdb_last_modified` TIMESTAMP NOT NULL
    ERROR - ALTER TABLE `default_en_listingsdb` CHANGE `hitcount` `listingsdb_hit_count` INT( 4 ) NOT NULL
    ERROR - ALTER TABLE `default_en_listingsdb` CHANGE `mlsimport` `listingsdb_mlsexport` CHAR( 3 ) NOT NULL
    ERROR - ALTER TABLE `default_en_listingsdb` CHANGE `active` `listingsdb_active` CHAR( 3 ) NOT NULL
    ERROR - ALTER TABLE `default_en_listingsdb` CHANGE `featured` `listingsdb_featured` CHAR( 3 ) NOT NULL
    ERROR - ALTER TABLE `default_en_listingsdb` DROP INDEX `ID_2`
    ERROR - ALTER TABLE `default_en_listingsdb` DROP INDEX `ID`
    ERROR - ALTER TABLE `default_en_listingsdb` DROP INDEX `idx_mlsimport`
    ERROR - ALTER TABLE default_listingsDBElements RENAME default_en_listingsdbelements
    ERROR - ALTER TABLE `default_en_listingsdbelements` CHANGE `ID` `listingsdbelements_id` INT( 4 ) NOT NULL AUTO_INCREMENT
    ERROR - ALTER TABLE `default_en_listingsdbelements` CHANGE `field_name` `listingsdbelements_field_name` CHAR VARYING( 20 ) NOT NULL
    ERROR - ALTER TABLE `default_en_listingsdbelements` CHANGE `field_value` `listingsdbelements_field_value` TEXT NOT NULL
    ERROR - ALTER TABLE `default_en_listingsdbelements` CHANGE `listing_id` `listingsdb_id` INT( 4 ) NOT NULL
    ERROR - ALTER TABLE `default_en_listingsdbelements` CHANGE `user_id` `userdb_id` INT( 4 ) NOT NULL
    ERROR - ALTER TABLE `default_en_listingsdbelements` DROP INDEX `ID`
    ERROR - ALTER TABLE `default_en_listingsdbelements` DROP INDEX `idx_listingid3`
    ERROR - ALTER TABLE default_listingsFormElements RENAME default_en_listingsformelements
    ERROR - ALTER TABLE `default_en_listingsformelements` CHANGE `ID` `listingsformelements_id` INT( 4 ) NOT NULL AUTO_INCREMENT
    ERROR - ALTER TABLE `default_en_listingsformelements` CHANGE `field_type` `listingsformelements_field_type` CHAR VARYING( 20 ) NOT NULL
    ERROR - ALTER TABLE `default_en_listingsformelements` CHANGE `field_name` `listingsformelements_field_name` CHAR VARYING( 20 ) NOT NULL
    ERROR - ALTER TABLE `default_en_listingsformelements` CHANGE `field_caption` `listingsformelements_field_caption` CHAR VARYING( 80 ) NOT NULL
    ERROR - ALTER TABLE `default_en_listingsformelements` CHANGE `default_text` `listingsformelements_default_text` TEXT NOT NULL
    ERROR - ALTER TABLE `default_en_listingsformelements` CHANGE `field_elements` `listingsformelements_field_elements` TEXT NOT NULL
    ERROR - ALTER TABLE `default_en_listingsformelements` CHANGE `rank` `listingsformelements_rank` INT( 4 ) NOT NULL
    ERROR - ALTER TABLE `default_en_listingsformelements` ADD `listingsformelements_search_rank` INT( 4 ) NOT NULL
    ERROR - ALTER TABLE `default_en_listingsformelements` ADD `listingsformelements_search_result_rank` INT( 4 ) NOT NULL
    ERROR - ALTER TABLE `default_en_listingsformelements` CHANGE `required` `listingsformelements_required` CHAR( 3 ) NOT NULL
    ERROR - ALTER TABLE `default_en_listingsformelements` CHANGE `location` `listingsformelements_location` CHAR VARYING( 15 ) NOT NULL
    ERROR - ALTER TABLE `default_en_listingsformelements` CHANGE `display_on_browse` `listingsformelements_display_on_browse` CHAR( 3 ) NOT NULL
    ERROR - ALTER TABLE `default_en_listingsformelements` CHANGE `searchable` `listingsformelements_searchable` INT( 4 ) NOT NULL
    ERROR - ALTER TABLE `default_en_listingsformelements` CHANGE `search_type` `listingsformelements_search_type` CHAR VARYING( 10 ) DEFAULT NULL
    ERROR - ALTER TABLE `default_en_listingsformelements` CHANGE `search_label` `listingsformelements_search_label` CHAR VARYING( 50 ) DEFAULT NULL
    ERROR - ALTER TABLE `default_en_listingsformelements` CHANGE `search_step` `listingsformelements_search_step` INT( 4 ) NOT NULL
    ERROR - ALTER TABLE `default_en_listingsformelements` CHANGE `display_priv` `listingsformelements_display_priv` INT(4) NOT NULL
    ERROR - ALTER TABLE `default_en_listingsformelements` DROP INDEX `idx_searchable`
    ERROR - ALTER TABLE default_listingsImages RENAME default_en_listingsimages
    ERROR - ALTER TABLE `default_en_listingsimages` CHANGE `ID` `listingsimages_id` INT( 4 ) NOT NULL AUTO_INCREMENT

  8. #8
    Join Date
    Apr 2005
    Posts
    15

    Default

    ERROR - ALTER TABLE `default_en_listingsimages` CHANGE `user_id` `userdb_id` INT( 4 ) NOT NULL
    ERROR - ALTER TABLE `default_en_listingsimages` CHANGE `caption` `listingsimages_caption` CHAR VARYING( 255 ) NOT NULL
    ERROR - ALTER TABLE `default_en_listingsimages` CHANGE `file_name` `listingsimages_file_name` CHAR VARYING( 80 ) NOT NULL
    ERROR - ALTER TABLE `default_en_listingsimages` CHANGE `thumb_file_name` `listingsimages_thumb_file_name` CHAR VARYING( 80 ) NOT NULL
    ERROR - ALTER TABLE `default_en_listingsimages` CHANGE `description` `listingsimages_description` TEXT NOT NULL
    ERROR - ALTER TABLE `default_en_listingsimages` CHANGE `listing_id` `listingsdb_id` INT( 4 ) NOT NULL
    ERROR - ALTER TABLE `default_en_listingsimages` CHANGE `rank` `listingsimages_rank` INT( 4 ) NOT NULL
    ERROR - ALTER TABLE `default_en_listingsimages` CHANGE `active` `listingsimages_active` CHAR( 3 ) NOT NULL
    ERROR - ALTER TABLE default_UserDB RENAME default_en_userdb
    ERROR - ALTER TABLE `default_en_userdb` CHANGE `ID` `userdb_id` INT( 4 ) NOT NULL AUTO_INCREMENT
    ERROR - ALTER TABLE `default_en_userdb` CHANGE `user_name` `userdb_user_name` CHAR VARYING( 80 ) NOT NULL
    ERROR - ALTER TABLE `default_en_userdb` CHANGE `emailAddress` `userdb_emailaddress` CHAR VARYING( 80 ) NOT NULL
    ERROR - ALTER TABLE `default_en_userdb` CHANGE `Comments` `userdb_comments` TEXT NOT NULL
    ERROR - ALTER TABLE `default_en_userdb` CHANGE `user_password` `userdb_user_password` CHAR VARYING( 50 ) NOT NULL
    ERROR - ALTER TABLE `default_en_userdb` CHANGE `isAdmin` `userdb_is_admin` CHAR( 3 ) NOT NULL
    ERROR - ALTER TABLE `default_en_userdb` CHANGE `canEditForms` `userdb_can_edit_forms` CHAR( 3 ) NOT NULL
    ERROR - ALTER TABLE `default_en_userdb` CHANGE `creation_date` `userdb_creation_date` DATE NOT NULL
    ERROR - ALTER TABLE `default_en_userdb` CHANGE `canFeatureListings` `userdb_can_feature_listings` CHAR( 3 ) NOT NULL
    ERROR - ALTER TABLE `default_en_userdb` CHANGE `canViewLogs` `userdb_can_view_logs` CHAR( 3 ) NOT NULL
    ERROR - ALTER TABLE `default_en_userdb` CHANGE `last_modified` `userdb_last_modified` TIMESTAMP
    ERROR - ALTER TABLE `default_en_userdb` CHANGE `hitcount` `userdb_hit_count` INT( 4 ) NOT NULL
    ERROR - ALTER TABLE `default_en_userdb` CHANGE `canModerate` `userdb_can_moderate` CHAR( 3 ) NOT NULL
    ERROR - ALTER TABLE `default_en_userdb` CHANGE `isAgent` `userdb_is_agent` CHAR( 3 ) NOT NULL
    ERROR - ALTER TABLE `default_en_userdb` CHANGE `active` `userdb_active` CHAR( 3 ) NOT NULL
    ERROR - ALTER TABLE `default_en_userdb` ADD `userdb_can_have_vtours` CHAR(3) NOT NULL
    ERROR - ALTER TABLE `default_en_userdb` ADD `userdb_limit_listings` INT4 NOT NULL
    ERROR - ALTER TABLE `default_en_userdb` DROP INDEX `ID`
    ERROR - ALTER TABLE `default_en_userdb` DROP INDEX `ID_2`
    ERROR - ALTER TABLE `default_en_userdb` ADD `userdb_can_edit_pages` CHAR( 3 ) NOT NULL AFTER `userdb_can_moderate` ;
    ERROR - ALTER TABLE default_UserDBElements RENAME default_en_userdbelements
    ERROR - ALTER TABLE `default_en_userdbelements` CHANGE `ID` `userdbelements_id` INT( 4 ) NOT NULL AUTO_INCREMENT
    ERROR - ALTER TABLE `default_en_userdbelements` CHANGE `field_name` `userdbelements_field_name` CHAR VARYING( 80 ) NOT NULL
    ERROR - ALTER TABLE `default_en_userdbelements` CHANGE `field_value` `userdbelements_field_value` TEXT NOT NULL
    ERROR - ALTER TABLE `default_en_userdbelements` CHANGE `user_id` `userdb_id` INT( 4 ) NOT NULL
    ERROR - ALTER TABLE `default_en_userdbelements` DROP INDEX `ID`
    ERROR - DROP TABLE `default_userFormElements`
    ERROR - ALTER TABLE default_userImages RENAME default_en_userimages
    ERROR - ALTER TABLE `default_en_userimages` CHANGE `ID` `userimages_id` INT( 4 ) NOT NULL AUTO_INCREMENT
    ERROR - ALTER TABLE `default_en_userimages` CHANGE `user_id` `userdb_id` INT( 4 ) NOT NULL
    ERROR - ALTER TABLE `default_en_userimages` CHANGE `caption` `userimages_caption` CHAR VARYING( 255 ) NOT NULL
    ERROR - ALTER TABLE `default_en_userimages` CHANGE `file_name` `userimages_file_name` CHAR VARYING( 80 ) NOT NULL
    ERROR - ALTER TABLE `default_en_userimages` CHANGE `thumb_file_name` `userimages_thumb_file_name` CHAR VARYING( 80 ) NOT NULL
    ERROR - ALTER TABLE `default_en_userimages` CHANGE `description` `userimages_description` TEXT NOT NULL
    ERROR - ALTER TABLE `default_en_userimages` CHANGE `rank` `userimages_rank` INT( 4 ) NOT NULL
    ERROR - ALTER TABLE `default_en_userimages` CHANGE `active` `userimages_active` CHAR( 3 ) NOT NULL
    ERROR - ALTER TABLE default_userSavedSearches RENAME default_en_usersavedsearches
    ERROR - ALTER TABLE `default_en_usersavedsearches` CHANGE `ID` `usersavedsearches_id` INT( 4 ) NOT NULL AUTO_INCREMENT
    ERROR - ALTER TABLE `default_en_usersavedsearches` CHANGE `user_ID` `userdb_id` INT( 4 ) NOT NULL
    ERROR - ALTER TABLE `default_en_usersavedsearches` CHANGE `Title` `usersavedsearches_title` CHAR VARYING( 255 ) NOT NULL
    ERROR - ALTER TABLE `default_en_usersavedsearches` CHANGE `query_string` `usersavedsearches_query_string` TEXT NOT NULL
    ERROR - ALTER TABLE `default_en_usersavedsearches` CHANGE `last_viewed` `usersavedsearches_last_viewed` TIMESTAMP
    ERROR - ALTER TABLE `default_en_usersavedsearches` CHANGE `new_listings` `usersavedsearches_new_listings` TINYINT( 2 ) NOT NULL
    ERROR - ALTER TABLE default_userFavoriteListings RENAME default_en_userfavoritelistings
    ERROR - ALTER TABLE `default_en_userfavoritelistings` CHANGE `ID` `userfavoritelistings_id` INT( 4 ) NOT NULL AUTO_INCREMENT
    ERROR - ALTER TABLE `default_en_userfavoritelistings` CHANGE `user_ID` `userdb_id` INT( 4 ) NOT NULL
    ERROR - ALTER TABLE `default_en_userfavoritelistings` CHANGE `listing_ID` `listingsdb_id` INT( 4 ) NOT NULL

  9. #9
    Join Date
    Apr 2005
    Posts
    15

    Default

    ERROR - ALTER TABLE default_memberFormElements RENAME default_en_memberformelements
    ERROR - ALTER TABLE `default_en_memberformelements` CHANGE `ID` `memberformelements_id` INT( 4 ) NOT NULL AUTO_INCREMENT
    ERROR - ALTER TABLE `default_en_memberformelements` CHANGE `field_type` `memberformelements_field_type` CHAR VARYING( 20 ) NOT NULL
    ERROR - ALTER TABLE `default_en_memberformelements` CHANGE `field_name` `memberformelements_field_name` CHAR VARYING( 20 ) NOT NULL
    ERROR - ALTER TABLE `default_en_memberformelements` CHANGE `field_caption` `memberformelements_field_caption` CHAR VARYING( 80 ) NOT NULL
    ERROR - ALTER TABLE `default_en_memberformelements` CHANGE `default_text` `memberformelements_default_text` TEXT NOT NULL
    ERROR - ALTER TABLE `default_en_memberformelements` CHANGE `field_elements` `memberformelements_field_elements` TEXT NOT NULL
    ERROR - ALTER TABLE `default_en_memberformelements` CHANGE `rank` `memberformelements_rank` INT( 4 ) NOT NULL
    ERROR - ALTER TABLE `default_en_memberformelements` CHANGE `required` `memberformelements_required` CHAR( 3 ) NOT NULL
    ERROR - ALTER TABLE default_agentFormElements RENAME default_en_agentformelements
    ERROR - ALTER TABLE `default_en_agentformelements` CHANGE `ID` `agentformelements_id` INT( 4 ) NOT NULL AUTO_INCREMENT
    ERROR - ALTER TABLE `default_en_agentformelements` CHANGE `field_type` `agentformelements_field_type` CHAR VARYING( 20 ) NOT NULL
    ERROR - ALTER TABLE `default_en_agentformelements` CHANGE `field_name` `agentformelements_field_name` CHAR VARYING( 20 ) NOT NULL
    ERROR - ALTER TABLE `default_en_agentformelements` CHANGE `field_caption` `agentformelements_field_caption` CHAR VARYING( 80 ) NOT NULL
    ERROR - ALTER TABLE `default_en_agentformelements` CHANGE `default_text` `agentformelements_default_text` TEXT NOT NULL
    ERROR - ALTER TABLE `default_en_agentformelements` CHANGE `field_elements` `agentformelements_field_elements` TEXT NOT NULL
    ERROR - ALTER TABLE `default_en_agentformelements` CHANGE `rank` `agentformelements_rank` INT( 4 ) NOT NULL
    ERROR - ALTER TABLE `default_en_agentformelements` CHANGE `required` `agentformelements_required` CHAR( 3 ) NOT NULL
    ERROR - ALTER TABLE `default_en_agentformelements` ADD `agentformelements_display_priv` INT4 NOT NULL
    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) );


    Again, this is only a test site, so it's not critical. If you want to see the system, or want me to try again let me know.

    Thanks,
    Corey

  10. #10
    Join Date
    Jun 2004
    Posts
    1,067

    Default

    Restore your backup of the 1.1.5 database and rerun the upgrade script on it. It looks like you tried to upgrade a database that was partially upgraded by the script already. I juts posted 2.0.1 btw. I tested it on a 1.1.5 install here and it does run without error.

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
  •