q p Posted April 8, 2020 Posted April 8, 2020 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
CodingJungle Posted April 8, 2020 Author Posted April 8, 2020 On 3/28/2020 at 1:02 AM, Tirel said: @CodingJungle Hi. installed the file. but the file page is displayed crookedly. not at all like in your screenshots/ dplus do you have theme alterations that are different than the default theme? it is only geared to move and adjust things based on the default them, so if your theme is to radically different, it could produce a different result than what i show in the screenshot. 2 minutes ago, q p said: 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 its a problem with the schema manger in IPS. in the new versions of mysql, they've deprecated the "length" prop for INT type fields. when i was developing 2.0.0 of stratagem, i was developing on a later version of mysql (8.0.19 to be exact), so i decided to drop the length prop from the int fields, as they aren't needed. the only way to solve this is to wait for IPS to fix it on their end. another way, if the data that currently exist in stratagem isn't important (since you said you haven't been using it that much this last year) you could uninstall and reinstall the app.
q p Posted April 8, 2020 Posted April 8, 2020 2 minutes ago, CodingJungle said: its a problem with the schema manger in IPS. in the new versions of mysql, they've deprecated the "length" prop for INT type fields. when i was developing 2.0.0 of stratagem, i was developing on a later version of mysql (8.0.19 to be exact), so i decided to drop the length prop from the int fields, as they aren't needed. the only way to solve this is to wait for IPS to fix it on their end. another way, if the data that currently exist in stratagem isn't important (since you said you haven't been using it that much this last year) you could uninstall and reinstall the app. 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?
CodingJungle Posted April 8, 2020 Author Posted April 8, 2020 6 minutes ago, q p said: 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? you sure it is the same error? in this image, it says it is cause you have a negative number for a topic to card (which i am not sure how that happened), you shouldn't have any data in the tables after a uninstall/install.
q p Posted April 8, 2020 Posted April 8, 2020 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
CodingJungle Posted April 8, 2020 Author Posted April 8, 2020 i'm almost a 100% positive there is nothing actually wrong still, that is just a problem with the schema manager. it installed without a problem? if there was a problem then the database would've thrown an error, and prevented the installing. what i'm thinking is happening here, is the schema manager check is incorrectly calculating the length of the one index and then the db is throwing an error when it is trying to update it cause it is a invalid index length. what version of mysql you are running? i'll try to setup a container later with it, to see if i can dupe the results, and see if there is any way i can fix it, cause i can't test it on my current local cause every table and int column in IPS comes up as "broken" due to me using 8.0.19 mysql.
q p Posted April 8, 2020 Posted April 8, 2020 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.
SJ77 Posted April 9, 2020 Posted April 9, 2020 How does CJ duplicate logger work? Can I have a brief summary of what it does? I assume it's more than just comparing IP address Thomas P and CoffeeCake 2
CoffeeCake Posted April 23, 2020 Posted April 23, 2020 On 4/9/2020 at 4:56 PM, SJ77 said: How does CJ duplicate logger work? Can I have a brief summary of what it does? I assume it's more than just comparing IP address Following up on the duplicate logger train, two comments: Please consider maintaining a new table rather than modifying core_members--this makes large site installation ... problematic ... due to the time it takes to edit the schema of a very large member table Please consider adding functionality to look for matches from previous data if possible. It appears the detection is only done on the next login. We'd like to compare data from previous registrations and content where available. Thanks! SJ77 1
Chris027 Posted April 23, 2020 Posted April 23, 2020 4 minutes ago, Paul E. said: Following up on the duplicate logger train, two comments: Please consider maintaining a new table rather than modifying core_members--this makes large site installation ... problematic ... due to the time it takes to edit the schema of a very large member table Please consider adding functionality to look for matches from previous data if possible. It appears the detection is only done on the next login. We'd like to compare data from previous registrations and content where available. Thanks! These are excellent suggestions. I love this app already, but there's always room to make it better. SJ77 1
kmk Posted April 25, 2020 Posted April 25, 2020 @CodingJungle I have errors reported many days ago, here and your site but no reply yet...please check pm
Maxxius Posted April 26, 2020 Posted April 26, 2020 On 3/3/2020 at 3:24 PM, Maxxius said: Bug report for Keywords app: I got an error when deleting a member: the member had no posts no nothing , I made it as a test user from ACP. Error: Class 'IPS\keywords\Store' not found (0) #0 /system/Member/Member.php(3767): IPS\keywords\extensions\core\MemberSync\_keywords->onDelete(Object(IPS\Member)) #1 /system/Member/Member.php(329): IPS\_Member->memberSync('onDelete') #2 /applications/core/modules/admin/members/members.php(2712): IPS\_Member->delete(true, false) #3 /system/Dispatcher/Controller.php(85): IPS\core\modules\admin\members\_members->delete() #4 /system/Dispatcher/Dispatcher.php(152): IPS\Dispatcher\_Controller->execute() #5 /admin/index.php(14): IPS\_Dispatcher->run() #6 {main} When will you fix this? When's the next release. Please don't make us wait till 4.5
Joey_M Posted April 27, 2020 Posted April 27, 2020 22 hours ago, eoebrian said: Michael are you ok? I'm very concerned myself, @CodingJungle (Michael) has always been very prompt at replying. I hope you're okay Michael, health comes before anything else. Message me if you need to chat, please don't isolate yourself or try to keep busy. There are people who see you beyond your services, but as a friendly guy that cares. CoffeeCake, BomAle and Maxxius 3
Daniel F Posted April 28, 2020 Posted April 28, 2020 It seems that strategem member sync extension is causing an infinite loop;) public function onDelete($member) { $m = Member::load($member->member_id); .. $m->delete(); } Pjo 1
eoebrian Posted April 29, 2020 Posted April 29, 2020 On 4/27/2020 at 10:03 AM, Joey_M said: I'm very concerned myself, @CodingJungle (Michael) has always been very prompt at replying. I last chatted with him on 4/10 and he hasn't responded to anything since then. I do hope he is ok!!!
Chris027 Posted April 29, 2020 Posted April 29, 2020 Hi Guys, I just started receiving multiple emails per minute saying I have new duplicates. I can't keep up with the emails coming in. Anyone else seeing this?
Chris027 Posted April 29, 2020 Posted April 29, 2020 Now Amazon SES has paused my account. Check this email log.
Chris027 Posted April 29, 2020 Posted April 29, 2020 My Amazon SES Dashboard now says Account Status: SHUTDOWN because of this.
CodingJungle Posted April 29, 2020 Author Posted April 29, 2020 4 minutes ago, Chris027 said: My Amazon SES Dashboard now says Account Status: SHUTDOWN because of this. i've replied to your other topic, but duplicate member doesn't send out emails, only notifications. to everyone, i will be posting an update to my site.
Chris027 Posted April 29, 2020 Posted April 29, 2020 I believe it does send emails. Or, there's another way to have the duplicates found by your app tell IPS to send an email with a link to the app.
CodingJungle Posted April 29, 2020 Author Posted April 29, 2020 (edited) 2 minutes ago, Chris027 said: I believe it does send emails. Or, there's another way to have the duplicates found by your app tell IPS to send an email with a link to the app. the code is disabled for it, if it is sending emails, then this an IPS bug, as i only have it configured to send a notification. or you have another plugin/app that has some how switched on the setting to send emails when it is disabled by the developer. Edited April 29, 2020 by CodingJungle
eoebrian Posted May 4, 2020 Posted May 4, 2020 Michael can you please respond to my query on your site? Thanks!
kmk Posted May 5, 2020 Posted May 5, 2020 @CodingJungle I want to decide for a chat app that let members send voice messages, is possible do that with Babble Chat? 🤔
Recommended Posts