Jump to content

q p

Clients
  • Posts

    9
  • Joined

  • Last visited

 Content Type 

Profiles

Downloads

IPS4 Providers

Release Notes

IPS4 Guides

IPS4 Developer Documentation

Invision Community Blog

Forums

Store

Everything posted by q p

  1. Hello! I am receiving this error when I click on the "Activity - All Activity". I am running the latest version of Stratagem on 4.6 Cloud EDIT: In addition, when trying to execute the task weeklydigest we get this error
  2. Hello @MIXOH I was hoping you'd be updating this application for IPS 4.5, we would love to add it to our community.
  3. Hello @Adriano Faria Thank you for your wonderful apps and plugins for IPS. I was hoping you'd consider updating and making this plugin available for 4.5 if possible. Our community would love to have this functionality on our website.
  4. Hello, I am using the Dreadnought theme and if I remember correctly, it used to come with the Pages Plugin bundled. Now with 4.5 IPS upgrade, I upgraded the theme no problem, but the upgrade to the plugin said there was unknown error. So I tried uninstalling and now it tells me to pay $15 for the plugin. I have active renewal on the theme, but it no longer comes with this plugin? Do I have to buy it extra now? Just want to make sure if you can help understand my options, would appreciate it.
  5. yes, it prompted no issues during installation and as far as I understand it seems to be working. As I mentioned earlier, we haven't really used this app but we plan to, so I guess I'll be reporting any issues in the upcoming weeks. I use the 'default' Cloud provided community so haven't messed up with any mysql configuration, whatever is default. We have included a theme and some other applications and plugins if that makes any difference. Let me know how to provide any additional information to help you troubleshoot.
  6. so here are the errors this time (it all looks the same to me lol) There are some problems with your database. Normally it is safe to try to fix these problems automatically however if your community is large, you may want to run the necessary queries manually. If so, the queries to run are: UPDATE `stratagem_projects` SET `project_id`='' WHERE `project_id` IS NULL; UPDATE `stratagem_projects` SET `project_private`=0 WHERE `project_private` IS NULL; UPDATE `stratagem_projects` SET `project_archived`=0 WHERE `project_archived` IS NULL; UPDATE `stratagem_projects` SET `project_manager`=0 WHERE `project_manager` IS NULL; UPDATE `stratagem_projects` SET `project_repo_lastPage`=0 WHERE `project_repo_lastPage` IS NULL; UPDATE `stratagem_projects` SET `project_bitbucket_lastPage`=0 WHERE `project_bitbucket_lastPage` IS NULL; ALTER TABLE `stratagem_projects` CHANGE COLUMN `project_id` `project_id` BIGINT NOT NULL AUTO_INCREMENT COMMENT 'ID Number', CHANGE COLUMN `project_order` `project_order` BIGINT UNSIGNED NULL COMMENT 'Record\'s Position', CHANGE COLUMN `project_club_id` `project_club_id` BIGINT UNSIGNED NULL COMMENT 'Club ID', CHANGE COLUMN `project_bitwise` `project_bitwise` BIGINT UNSIGNED NULL COMMENT 'bitwise field.', CHANGE COLUMN `project_private` `project_private` TINYINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `project_due` `project_due` INT UNSIGNED NULL , CHANGE COLUMN `project_created_date` `project_created_date` INT UNSIGNED NULL , CHANGE COLUMN `project_max_users` `project_max_users` INT UNSIGNED NULL DEFAULT 6 , CHANGE COLUMN `project_archived` `project_archived` TINYINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `project_default_column_topic` `project_default_column_topic` BIGINT UNSIGNED NULL , CHANGE COLUMN `project_manager` `project_manager` BIGINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `project_repo_lastPage` `project_repo_lastPage` INT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `project_issues_column` `project_issues_column` BIGINT UNSIGNED NULL , CHANGE COLUMN `project_download_id` `project_download_id` BIGINT UNSIGNED NULL , CHANGE COLUMN `project_bitbucket_lastPage` `project_bitbucket_lastPage` INT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `project_style` `project_style` INT UNSIGNED NULL DEFAULT 0 , CHANGE COLUMN `project_calendar` `project_calendar` BIGINT UNSIGNED NULL , CHANGE COLUMN `project_event` `project_event` BIGINT UNSIGNED NULL , CHANGE COLUMN `project_max_comments` `project_max_comments` INT UNSIGNED NULL , CHANGE COLUMN `project_publish_date` `project_publish_date` INT UNSIGNED NULL , CHANGE COLUMN `project_cover_photo_offset` `project_cover_photo_offset` INT UNSIGNED NULL , CHANGE COLUMN `project_enabled` `project_enabled` TINYINT UNSIGNED NULL DEFAULT 1 ; UPDATE `stratagem_columns` SET `column_id`='' WHERE `column_id` IS NULL; UPDATE `stratagem_columns` SET `column_order`=0 WHERE `column_order` IS NULL; UPDATE `stratagem_columns` SET `column_project`=0 WHERE `column_project` IS NULL; ALTER TABLE `stratagem_columns` CHANGE COLUMN `column_id` `column_id` BIGINT NOT NULL AUTO_INCREMENT COMMENT 'ID Number', CHANGE COLUMN `column_bitwise` `column_bitwise` BIGINT UNSIGNED NULL COMMENT 'bitwise field.', CHANGE COLUMN `column_order` `column_order` BIGINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `column_project` `column_project` BIGINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `column_last` `column_last` BIGINT UNSIGNED NULL , CHANGE COLUMN `column_expire` `column_expire` INT UNSIGNED NULL , CHANGE COLUMN `column_state` `column_state` TINYINT UNSIGNED NULL , CHANGE COLUMN `column_enabled` `column_enabled` TINYINT UNSIGNED NULL DEFAULT 1 ; UPDATE `stratagem_cards` SET `card_id`='' WHERE `card_id` IS NULL; UPDATE `stratagem_cards` SET `card_column`=0 WHERE `card_column` IS NULL; UPDATE `stratagem_cards` SET `card_order`=0 WHERE `card_order` IS NULL; UPDATE `stratagem_cards` SET `card_sub`=0 WHERE `card_sub` IS NULL; UPDATE `stratagem_cards` SET `card_complete`=0 WHERE `card_complete` IS NULL; UPDATE `stratagem_cards` SET `card_project`=0 WHERE `card_project` IS NULL; UPDATE `stratagem_cards` SET `card_comments`=0 WHERE `card_comments` IS NULL; UPDATE `stratagem_cards` SET `card_commentsTotal`=0 WHERE `card_commentsTotal` IS NULL; UPDATE `stratagem_cards` SET `card_percents`=0 WHERE `card_percents` IS NULL; UPDATE `stratagem_cards` SET `card_waiting`=0 WHERE `card_waiting` IS NULL; UPDATE `stratagem_cards` SET `card_trigger`=0 WHERE `card_trigger` IS NULL; ALTER TABLE `stratagem_cards` CHANGE COLUMN `card_id` `card_id` BIGINT NOT NULL AUTO_INCREMENT COMMENT 'ID Number', CHANGE COLUMN `card_bitwise` `card_bitwise` BIGINT UNSIGNED NULL COMMENT 'bitwise field.', CHANGE COLUMN `card_column` `card_column` BIGINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `card_order` `card_order` BIGINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `card_creator` `card_creator` BIGINT UNSIGNED NULL , CHANGE COLUMN `card_create_date` `card_create_date` INT UNSIGNED NULL , CHANGE COLUMN `card_due_date` `card_due_date` INT UNSIGNED NULL , CHANGE COLUMN `card_sub` `card_sub` BIGINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `card_complete` `card_complete` TINYINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `card_deleted_date` `card_deleted_date` INT UNSIGNED NULL , CHANGE COLUMN `card_project` `card_project` BIGINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `card_complete_date` `card_complete_date` INT UNSIGNED NULL , CHANGE COLUMN `card_complete_by` `card_complete_by` BIGINT UNSIGNED NULL , CHANGE COLUMN `card_comments` `card_comments` BIGINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `card_commentsTotal` `card_commentsTotal` BIGINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `card_votes_positive` `card_votes_positive` INT UNSIGNED NULL DEFAULT 0 , CHANGE COLUMN `card_votes_negative` `card_votes_negative` INT UNSIGNED NULL DEFAULT 0 , CHANGE COLUMN `card_previous_column` `card_previous_column` BIGINT UNSIGNED NULL , DROP INDEX `toCard`, CHANGE COLUMN `card_imported_id` `card_imported_id` BIGINT UNSIGNED NULL , ADD KEY `toCard` (`card_imported_class`(-59),`card_imported_id`), CHANGE COLUMN `card_repo_id` `card_repo_id` BIGINT UNSIGNED NULL , CHANGE COLUMN `card_repo_issue_id` `card_repo_issue_id` INT UNSIGNED NULL , CHANGE COLUMN `card_lists_totals` `card_lists_totals` INT UNSIGNED NULL DEFAULT 0 , CHANGE COLUMN `card_percents` `card_percents` INT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `cards_lists_totals` `cards_lists_totals` INT UNSIGNED NULL DEFAULT 0 , CHANGE COLUMN `card_content_time` `card_content_time` INT UNSIGNED NULL , CHANGE COLUMN `card_event` `card_event` BIGINT UNSIGNED NULL , CHANGE COLUMN `card_ratingTotal` `card_ratingTotal` INT UNSIGNED NULL DEFAULT 0 , CHANGE COLUMN `card_ratingUser` `card_ratingUser` INT UNSIGNED NULL , CHANGE COLUMN `card_waiting` `card_waiting` TINYINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `card_trigger` `card_trigger` TINYINT UNSIGNED NOT NULL DEFAULT 0 ; UPDATE `stratagem_times` SET `time_id`='' WHERE `time_id` IS NULL; ALTER TABLE `stratagem_times` CHANGE COLUMN `time_id` `time_id` BIGINT NOT NULL AUTO_INCREMENT COMMENT 'ID Number', CHANGE COLUMN `time_bitwise` `time_bitwise` BIGINT UNSIGNED NULL COMMENT 'bitwise field.', CHANGE COLUMN `time_member` `time_member` BIGINT UNSIGNED NULL , CHANGE COLUMN `time_card` `time_card` BIGINT UNSIGNED NULL , CHANGE COLUMN `time_date` `time_date` INT UNSIGNED NULL , CHANGE COLUMN `time_hours` `time_hours` INT UNSIGNED NULL , CHANGE COLUMN `time_minutes` `time_minutes` INT UNSIGNED NULL , CHANGE COLUMN `time_project` `time_project` BIGINT UNSIGNED NULL , CHANGE COLUMN `time_clock_start` `time_clock_start` INT UNSIGNED NULL , CHANGE COLUMN `time_clock_end` `time_clock_end` INT UNSIGNED NULL ; UPDATE `stratagem_members` SET `stratagem_mid`='' WHERE `stratagem_mid` IS NULL; ALTER TABLE `stratagem_members` CHANGE COLUMN `stratagem_mid` `stratagem_mid` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID Number', CHANGE COLUMN `stratagem_hourly_rate` `stratagem_hourly_rate` INT UNSIGNED NULL DEFAULT 0 ; UPDATE `stratagem_votes` SET `vote_id`='' WHERE `vote_id` IS NULL; ALTER TABLE `stratagem_votes` CHANGE COLUMN `vote_id` `vote_id` BIGINT NOT NULL AUTO_INCREMENT COMMENT 'ID Number', CHANGE COLUMN `vote_bitwise` `vote_bitwise` BIGINT UNSIGNED NULL COMMENT 'bitwise field.', CHANGE COLUMN `vote_card` `vote_card` BIGINT UNSIGNED NULL , CHANGE COLUMN `vote_member` `vote_member` BIGINT UNSIGNED NULL , CHANGE COLUMN `vote_positive` `vote_positive` INT UNSIGNED NULL , CHANGE COLUMN `vote_negative` `vote_negative` INT UNSIGNED NULL , CHANGE COLUMN `vote_value` `vote_value` INT UNSIGNED NULL ; When I select 'fix automatically' I get the following: ALTER TABLE `stratagem_cards` CHANGE COLUMN `card_id` `card_id` BIGINT NOT NULL AUTO_INCREMENT COMMENT 'ID Number', CHANGE COLUMN `card_bitwise` `card_bitwise` BIGINT UNSIGNED NULL COMMENT 'bitwise field.', CHANGE COLUMN `card_column` `card_column` BIGINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `card_order` `card_order` BIGINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `card_creator` `card_creator` BIGINT UNSIGNED NULL , CHANGE COLUMN `card_create_date` `card_create_date` INT UNSIGNED NULL , CHANGE COLUMN `card_due_date` `card_due_date` INT UNSIGNED NULL , CHANGE COLUMN `card_sub` `card_sub` BIGINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `card_complete` `card_complete` TINYINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `card_deleted_date` `card_deleted_date` INT UNSIGNED NULL , CHANGE COLUMN `card_project` `card_project` BIGINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `card_complete_date` `card_complete_date` INT UNSIGNED NULL , CHANGE COLUMN `card_complete_by` `card_complete_by` BIGINT UNSIGNED NULL , CHANGE COLUMN `card_comments` `card_comments` BIGINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `card_commentsTotal` `card_commentsTotal` BIGINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `card_votes_positive` `card_votes_positive` INT UNSIGNED NULL DEFAULT 0 , CHANGE COLUMN `card_votes_negative` `card_votes_negative` INT UNSIGNED NULL DEFAULT 0 , CHANGE COLUMN `card_previous_column` `card_previous_column` BIGINT UNSIGNED NULL , DROP INDEX `toCard`, CHANGE COLUMN `card_imported_id` `card_imported_id` BIGINT UNSIGNED NULL , ADD KEY `toCard` (`card_imported_class`(-59),`card_imported_id`), CHANGE COLUMN `card_repo_id` `card_repo_id` BIGINT UNSIGNED NULL , CHANGE COLUMN `card_repo_issue_id` `card_repo_issue_id` INT UNSIGNED NULL , CHANGE COLUMN `card_lists_totals` `card_lists_totals` INT UNSIGNED NULL DEFAULT 0 , CHANGE COLUMN `card_percents` `card_percents` INT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `cards_lists_totals` `cards_lists_totals` INT UNSIGNED NULL DEFAULT 0 , CHANGE COLUMN `card_content_time` `card_content_time` INT UNSIGNED NULL , CHANGE COLUMN `card_event` `card_event` BIGINT UNSIGNED NULL , CHANGE COLUMN `card_ratingTotal` `card_ratingTotal` INT UNSIGNED NULL DEFAULT 0 , CHANGE COLUMN `card_ratingUser` `card_ratingUser` INT UNSIGNED NULL , CHANGE COLUMN `card_waiting` `card_waiting` TINYINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `card_trigger` `card_trigger` TINYINT UNSIGNED NOT NULL DEFAULT 0 ;You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-59),`card_imported_id`), CHANGE COLUMN `card_repo_id` `card_repo_id` BIGINT UNS' at line 1 I hope it helps, let me know how I can provide more information
  7. Hello and thank you for the prompt reply! I have uninstalled the application and reinstalled the latest version, and no longer have the old projects we experimented with, however the issue still persists as in my screenshots above. Is there a way to uninstall this besides the 'uninstall' option from the applications screen?
  8. Hello, we've been using stratagem very lightly over the past year, but looking to start working with this app more closely in the next couple of months. I went ahead and upgraded to the latest version, however I have an issue with my database, as seen in the following screenshots taken from the 'support' part of my admin dashboard. When I click on "fix this" I get presented with the following: When I click on "check again" I see the following: There are some problems with your database. Normally it is safe to try to fix these problems automatically however if your community is large, you may want to run the necessary queries manually. If so, the queries to run are: UPDATE `stratagem_projects` SET `project_id`='' WHERE `project_id` IS NULL; UPDATE `stratagem_projects` SET `project_private`=0 WHERE `project_private` IS NULL; UPDATE `stratagem_projects` SET `project_archived`=0 WHERE `project_archived` IS NULL; UPDATE `stratagem_projects` SET `project_manager`=0 WHERE `project_manager` IS NULL; UPDATE `stratagem_projects` SET `project_repo_lastPage`=0 WHERE `project_repo_lastPage` IS NULL; UPDATE `stratagem_projects` SET `project_bitbucket_lastPage`=0 WHERE `project_bitbucket_lastPage` IS NULL; ALTER TABLE `stratagem_projects` CHANGE COLUMN `project_id` `project_id` BIGINT NOT NULL AUTO_INCREMENT COMMENT 'ID Number', CHANGE COLUMN `project_order` `project_order` BIGINT UNSIGNED NULL COMMENT 'Record\'s Position', CHANGE COLUMN `project_club_id` `project_club_id` BIGINT UNSIGNED NULL COMMENT 'Club ID', CHANGE COLUMN `project_bitwise` `project_bitwise` BIGINT UNSIGNED NULL COMMENT 'bitwise field.', CHANGE COLUMN `project_private` `project_private` TINYINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `project_due` `project_due` INT UNSIGNED NULL , CHANGE COLUMN `project_created_date` `project_created_date` INT UNSIGNED NULL , CHANGE COLUMN `project_max_users` `project_max_users` INT UNSIGNED NULL DEFAULT 6 , CHANGE COLUMN `project_archived` `project_archived` TINYINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `project_default_column_topic` `project_default_column_topic` BIGINT UNSIGNED NULL , CHANGE COLUMN `project_manager` `project_manager` BIGINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `project_repo_lastPage` `project_repo_lastPage` INT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `project_issues_column` `project_issues_column` BIGINT UNSIGNED NULL , CHANGE COLUMN `project_download_id` `project_download_id` BIGINT UNSIGNED NULL , CHANGE COLUMN `project_bitbucket_lastPage` `project_bitbucket_lastPage` INT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `project_style` `project_style` INT UNSIGNED NULL DEFAULT 0 , CHANGE COLUMN `project_calendar` `project_calendar` BIGINT UNSIGNED NULL , CHANGE COLUMN `project_event` `project_event` BIGINT UNSIGNED NULL , CHANGE COLUMN `project_max_comments` `project_max_comments` INT UNSIGNED NULL , CHANGE COLUMN `project_publish_date` `project_publish_date` INT UNSIGNED NULL , CHANGE COLUMN `project_cover_photo_offset` `project_cover_photo_offset` INT UNSIGNED NULL , CHANGE COLUMN `project_enabled` `project_enabled` TINYINT UNSIGNED NULL DEFAULT 1 ; UPDATE `stratagem_columns` SET `column_id`='' WHERE `column_id` IS NULL; UPDATE `stratagem_columns` SET `column_order`=0 WHERE `column_order` IS NULL; UPDATE `stratagem_columns` SET `column_project`=0 WHERE `column_project` IS NULL; ALTER TABLE `stratagem_columns` CHANGE COLUMN `column_id` `column_id` BIGINT NOT NULL AUTO_INCREMENT COMMENT 'ID Number', CHANGE COLUMN `column_bitwise` `column_bitwise` BIGINT UNSIGNED NULL COMMENT 'bitwise field.', CHANGE COLUMN `column_order` `column_order` BIGINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `column_project` `column_project` BIGINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `column_last` `column_last` BIGINT UNSIGNED NULL , CHANGE COLUMN `column_expire` `column_expire` INT UNSIGNED NULL , CHANGE COLUMN `column_state` `column_state` TINYINT UNSIGNED NULL , CHANGE COLUMN `column_enabled` `column_enabled` TINYINT UNSIGNED NULL DEFAULT 1 ; UPDATE `stratagem_cards` SET `card_id`='' WHERE `card_id` IS NULL; UPDATE `stratagem_cards` SET `card_column`=0 WHERE `card_column` IS NULL; UPDATE `stratagem_cards` SET `card_order`=0 WHERE `card_order` IS NULL; UPDATE `stratagem_cards` SET `card_sub`=0 WHERE `card_sub` IS NULL; UPDATE `stratagem_cards` SET `card_complete`=0 WHERE `card_complete` IS NULL; UPDATE `stratagem_cards` SET `card_project`=0 WHERE `card_project` IS NULL; UPDATE `stratagem_cards` SET `card_comments`=0 WHERE `card_comments` IS NULL; UPDATE `stratagem_cards` SET `card_commentsTotal`=0 WHERE `card_commentsTotal` IS NULL; UPDATE `stratagem_cards` SET `card_percents`=0 WHERE `card_percents` IS NULL; UPDATE `stratagem_cards` SET `card_waiting`=0 WHERE `card_waiting` IS NULL; UPDATE `stratagem_cards` SET `card_trigger`=0 WHERE `card_trigger` IS NULL; ALTER TABLE `stratagem_cards` CHANGE COLUMN `card_id` `card_id` BIGINT NOT NULL AUTO_INCREMENT COMMENT 'ID Number', CHANGE COLUMN `card_bitwise` `card_bitwise` BIGINT UNSIGNED NULL COMMENT 'bitwise field.', CHANGE COLUMN `card_column` `card_column` BIGINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `card_order` `card_order` BIGINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `card_creator` `card_creator` BIGINT UNSIGNED NULL , CHANGE COLUMN `card_create_date` `card_create_date` INT UNSIGNED NULL , CHANGE COLUMN `card_due_date` `card_due_date` INT UNSIGNED NULL , CHANGE COLUMN `card_sub` `card_sub` BIGINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `card_complete` `card_complete` TINYINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `card_deleted_date` `card_deleted_date` INT UNSIGNED NULL , CHANGE COLUMN `card_project` `card_project` BIGINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `card_complete_date` `card_complete_date` INT UNSIGNED NULL , CHANGE COLUMN `card_complete_by` `card_complete_by` BIGINT UNSIGNED NULL , CHANGE COLUMN `card_comments` `card_comments` BIGINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `card_commentsTotal` `card_commentsTotal` BIGINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `card_votes_positive` `card_votes_positive` INT UNSIGNED NULL DEFAULT 0 , CHANGE COLUMN `card_votes_negative` `card_votes_negative` INT UNSIGNED NULL DEFAULT 0 , CHANGE COLUMN `card_previous_column` `card_previous_column` BIGINT UNSIGNED NULL , DROP INDEX `toCard`, CHANGE COLUMN `card_imported_id` `card_imported_id` BIGINT UNSIGNED NULL , ADD KEY `toCard` (`card_imported_class`(-59),`card_imported_id`), CHANGE COLUMN `card_repo_id` `card_repo_id` BIGINT UNSIGNED NULL , CHANGE COLUMN `card_repo_issue_id` `card_repo_issue_id` INT UNSIGNED NULL , CHANGE COLUMN `card_lists_totals` `card_lists_totals` INT UNSIGNED NULL DEFAULT 0 , CHANGE COLUMN `card_percents` `card_percents` INT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `cards_lists_totals` `cards_lists_totals` INT UNSIGNED NULL DEFAULT 0 , CHANGE COLUMN `card_content_time` `card_content_time` INT UNSIGNED NULL , CHANGE COLUMN `card_event` `card_event` BIGINT UNSIGNED NULL , CHANGE COLUMN `card_ratingTotal` `card_ratingTotal` INT UNSIGNED NULL DEFAULT 0 , CHANGE COLUMN `card_ratingUser` `card_ratingUser` INT UNSIGNED NULL , CHANGE COLUMN `card_waiting` `card_waiting` TINYINT UNSIGNED NOT NULL DEFAULT 0 , CHANGE COLUMN `card_trigger` `card_trigger` TINYINT UNSIGNED NOT NULL DEFAULT 0 ; UPDATE `stratagem_times` SET `time_id`='' WHERE `time_id` IS NULL; ALTER TABLE `stratagem_times` CHANGE COLUMN `time_id` `time_id` BIGINT NOT NULL AUTO_INCREMENT COMMENT 'ID Number', CHANGE COLUMN `time_bitwise` `time_bitwise` BIGINT UNSIGNED NULL COMMENT 'bitwise field.', CHANGE COLUMN `time_member` `time_member` BIGINT UNSIGNED NULL , CHANGE COLUMN `time_card` `time_card` BIGINT UNSIGNED NULL , CHANGE COLUMN `time_date` `time_date` INT UNSIGNED NULL , CHANGE COLUMN `time_hours` `time_hours` INT UNSIGNED NULL , CHANGE COLUMN `time_minutes` `time_minutes` INT UNSIGNED NULL , CHANGE COLUMN `time_project` `time_project` BIGINT UNSIGNED NULL , CHANGE COLUMN `time_clock_start` `time_clock_start` INT UNSIGNED NULL , CHANGE COLUMN `time_clock_end` `time_clock_end` INT UNSIGNED NULL ; UPDATE `stratagem_members` SET `stratagem_mid`='' WHERE `stratagem_mid` IS NULL; ALTER TABLE `stratagem_members` CHANGE COLUMN `stratagem_mid` `stratagem_mid` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID Number', CHANGE COLUMN `stratagem_hourly_rate` `stratagem_hourly_rate` INT UNSIGNED NULL DEFAULT 0 ; UPDATE `stratagem_votes` SET `vote_id`='' WHERE `vote_id` IS NULL; ALTER TABLE `stratagem_votes` CHANGE COLUMN `vote_id` `vote_id` BIGINT NOT NULL AUTO_INCREMENT COMMENT 'ID Number', CHANGE COLUMN `vote_bitwise` `vote_bitwise` BIGINT UNSIGNED NULL COMMENT 'bitwise field.', CHANGE COLUMN `vote_card` `vote_card` BIGINT UNSIGNED NULL , CHANGE COLUMN `vote_member` `vote_member` BIGINT UNSIGNED NULL , CHANGE COLUMN `vote_positive` `vote_positive` INT UNSIGNED NULL , CHANGE COLUMN `vote_negative` `vote_negative` INT UNSIGNED NULL , CHANGE COLUMN `vote_value` `vote_value` INT UNSIGNED NULL ; I have then the option to "fix automatically" and "Check again". When I select the former, I see this: Can you please advise on how to solve this? Thank you, qp
  9. Hi @Fosters thank you for this great tool! How can we be included in the beta testing process? Really looking forward to get more functionality with our Discord instance. Looking forward to hearing from you. Thanks, qp
×
×
  • Create New...