Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC: 2.7 upgrade issues

2.7 upgrade issues 14 years 1 month ago #9867

  • elrig
  • elrig's Avatar
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 23
  • Thank you received: 0
are the rollback scripts available online?

Please Log in or Create an account to join the conversation.

2.7 upgrade issues 14 years 1 month ago #9887

  • kinto92
  • kinto92's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 6
  • Thank you received: 0

elrig wrote: are the rollback scripts available online?


I'm not sure if DTH has as script for this.

I made my own script for the TABLE RENAME. For the ALTER TABLE, I did it one by one because not all tables have auto increments on the PRIMARY KEY.

If you're going to use the RENAME script please backup your data first!
RENAME TABLE 	`YOURSITE_dtregister_rollback_acos` 	TO 	`YOURSITE_dtregister_acos`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_aros` 	TO 	`YOURSITE_dtregister_aros`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_captcha` 	TO 	`YOURSITE_dtregister_captcha`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_categories` 	TO 	`YOURSITE_dtregister_categories`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_codes` 	TO 	`YOURSITE_dtregister_codes`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_config` 	TO 	`YOURSITE_dtregister_config`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_event_config` 	TO 	`YOURSITE_dtregister_event_config`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_event_detail` 	TO 	`YOURSITE_dtregister_event_detail`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_events_codes` 	TO 	`YOURSITE_dtregister_events_codes`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_export_fields` 	TO 	`YOURSITE_dtregister_export_fields`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_export_settings` 	TO 	`YOURSITE_dtregister_export_settings`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_fee` 	TO 	`YOURSITE_dtregister_fee`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_feeorder` 	TO 	`YOURSITE_dtregister_feeorder`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_field_event` 	TO 	`YOURSITE_dtregister_field_event`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_fields` 	TO 	`YOURSITE_dtregister_fields`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_files` 	TO 	`YOURSITE_dtregister_files`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_group` 	TO 	`YOURSITE_dtregister_group`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_group_amount` 	TO 	`YOURSITE_dtregister_group_amount`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_group_event` 	TO 	`YOURSITE_dtregister_group_event`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_group_member` 	TO 	`YOURSITE_dtregister_group_member`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_history` 	TO 	`YOURSITE_dtregister_history`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_locations` 	TO 	`YOURSITE_dtregister_locations`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_member_field_values` 	TO 	`YOURSITE_dtregister_member_field_values`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_paylater` 	TO 	`YOURSITE_dtregister_paylater`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_payment` 	TO 	`YOURSITE_dtregister_payment`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_payment_config` 	TO 	`YOURSITE_dtregister_payment_config`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_permissions` 	TO 	`YOURSITE_dtregister_permissions`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_prerequisite` 	TO 	`YOURSITE_dtregister_prerequisite`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_prerequisite_category` 	TO 	`YOURSITE_dtregister_prerequisite_category`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_repetitions` 	TO 	`YOURSITE_dtregister_repetitions`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_session` 	TO 	`YOURSITE_dtregister_session`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_sync` 	TO 	`YOURSITE_dtregister_sync`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_user` 	TO 	`YOURSITE_dtregister_user`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_user_field_values` 	TO 	`YOURSITE_dtregister_user_field_values`; 
RENAME TABLE 	`YOURSITE_dtregister_rollback_waiting` 	TO 	`YOURSITE_dtregister_waiting`; 

Please Log in or Create an account to join the conversation.

2.7 upgrade issues 14 years 1 month ago #9943

  • dthadmin
  • dthadmin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 5470
  • Thank you received: 3
Guys, please be aware that further updates have been made... many issues resolved, including the upgrade process being much more stable than it was initially. Thanks for your patience.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
  • 2
Time to create page: 0.097 seconds