Jump to content

CodingJungle's Apps [support topic]


CodingJungle

Recommended Posts

  • 2 weeks later...

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.

image.thumb.png.92ce02b4eba84bd7389feb843f78572e.png

When I click on "fix this" I get presented with the following:

image.thumb.png.06acf451bb54670c3d30b9b4bd250ae8.png

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:

image.thumb.png.b9fa1586fd1c83265220ea220c486a5e.png

Can you please advise on how to solve this?

Thank you,

qp

Link to comment
Share on other sites

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.

image.thumb.png.92ce02b4eba84bd7389feb843f78572e.png

When I click on "fix this" I get presented with the following:

image.thumb.png.06acf451bb54670c3d30b9b4bd250ae8.png

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:

image.thumb.png.b9fa1586fd1c83265220ea220c486a5e.png

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. 

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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?

image.thumb.png.b9fa1586fd1c83265220ea220c486a5e.png

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. 

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • 2 weeks later...
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!

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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 by CodingJungle
Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...