David..
Clients-
Posts
1,214 -
Joined
-
Last visited
Content Type
Downloads
Release Notes
IPS4 Guides
IPS4 Developer Documentation
Invision Community Blog
Development Blog
Deprecation Tracker
Providers Directory
Forums
Events
Store
Gallery
Everything posted by David..
-
After the 4.7.16 update I am getting this error: UPDATE `ipb__core_members_known_ip_addresses` `core_members_known_ip_addresses` SET `ip_address`='' WHERE ip_address != '' AND last_seen <1705676237 IPS\Db\Exception: Duplicate entry '00000189671fd0ffd6c0861a4dcf4040-8606095-' for key 'PRIMARY' (1062) #0 /public_html/system/Db/Db.php(1159): IPS\_Db->preparedQuery() #1 /public_html/applications/core/extensions/core/IpAddresses/Logins.php(33): IPS\_Db->update() #2 /public_html/system/Member/Member.php(6504): IPS\core\extensions\core\IpAddresses\_Logins->pruneIpAddresses() #3 /public_html/applications/core/tasks/pruneipaddresses.php(43): IPS\_Member::pruneAllLoggedIpAddresses() #4 /public_html/system/Task/Task.php(281): IPS\core\tasks\_pruneipaddresses->execute() #5 /public_html/applications/core/modules/admin/settings/advanced.php(751): IPS\_Task->run() #6 /public_html/system/Dispatcher/Controller.php(107): IPS\core\modules\admin\settings\_advanced->runTask() #7 /public_html/applications/core/modules/admin/settings/advanced.php(38): IPS\Dispatcher\_Controller->execute() #8 /public_html/system/Dispatcher/Dispatcher.php(153): IPS\core\modules\admin\settings\_advanced->execute() #9 /public_html/Prevail/index.php(13): IPS\_Dispatcher->run() #10 {main} What's the solution to this?
-
Select which subscriptions coupon code is available for
David.. replied to David..'s topic in General Questions
But you have the option to renew your subscription and it will automatically add months to your active subscription. This does not seem to be the case with products based subscriptions. -
Select which subscriptions coupon code is available for
David.. replied to David..'s topic in General Questions
Subscriptions automatically stack, but products do not even though they're being sold as subscriptions. Why are both lacking features the other one already has? -
[Commerce] Subscriptions vs Product With Renewal
David.. replied to Foxtrek_64's topic in General Questions
@Marc Stridgen Is there a way to automatically stack product purchases that are being sold as subscriptions? -
We can select which *products* the coupon will work on but not *subscriptions*. Why is this? Is this an oversight?
-
SEO Essentials by @Daniel F offers an option to disable indexing.
-
known issue Reddit.com embed links no longer working
David.. replied to David..'s topic in Technical Problems
How did you contact Reddit to unblock your IP? -
Hello! It seems that on my community & a friend's community the Reddit.com links are no longer working but they work on invision community. Can someone from the team look into this? My community: IC:
-
Does Invision support Stripe Apple Pay / link?
David.. replied to ekforum's topic in General Questions
Done! https://invisioncommunity.com/forums/topic/475683-apple-google-pay-automatic-renewals-support/ -
Hello! Using Stripe we can implement Apple & Google Pay support but it currently does not support automatic renewals to subscriptions. I think having this option is a great addition and would generate extra revenue for any community selling subscriptions. Hoping this gets implemented. Thank you!
-
Does Invision support Stripe Apple Pay / link?
David.. replied to ekforum's topic in General Questions
Is the recurring payments feature an Invision, Stripe or Apple/Google Pay limitation? -
Disposable emails block feature doesn't work
David.. replied to Apfelstrudel's topic in Technical Problems
For me it was the first result on Google. -
Option to disable "Your Registration is Complete!" emails
David.. replied to Michael Collins's topic in Feedback
We could expand this to enable or disable any automatic emails the community sends out. -
I think I remember seeing somewhere that it will be mobile first. Hoping that is true!
-
I made a video on a bug I found with the login and the video does contain some sensitive information so I would rather share it privately with the staff.
-
Older iOS devices no longer able to post or see pics after update
David.. replied to Mikeiw3001's topic in Technical Problems
Yes, but iOS 13 is ~3 years old so we shouldn't abandon it so soon. -
Older iOS devices no longer able to post or see pics after update
David.. replied to Mikeiw3001's topic in Technical Problems
Yes, everything works fine on my other devices. Seems to be an issue with the older iOS versions? I'm able to reproduce this issue on ipsfocus.net too even after clearing all website data in Safari settings. -
Older iOS devices no longer able to post or see pics after update
David.. replied to Mikeiw3001's topic in Technical Problems
-
Older iOS devices no longer able to post or see pics after update
David.. replied to Mikeiw3001's topic in Technical Problems
Where is this available? How can I apply this on my community? I am on an iOS 13 device and the issue seems to be much more than just the images not loading. I & a member can reproduce on 3 separate Invision Community websites. It seems that the CKEditor is failing to load, the search & sign in dropdown does not load, the rating starts icon isn't loading, and as you can see from the screenshot @The Old Man posted above, there are also various (CSS) layout issues. This issue does not seem to happen on the latest versions of iOS. -
How to stop new members posting to other profiles?
David.. replied to BankFodder's topic in Technical Problems
This can be done with a theme edit if you find the profile posting code then wrap it around {{if member.member_posts > 50}} so that only members with higher than 50 posts can see it. -
Various issues with member_id surpassing mediumint(8)
David.. replied to David..'s topic in Technical Problems
I understand, I guess just a review of all the SQL queries before proceeding would suffice. -
Various issues with member_id surpassing mediumint(8)
David.. replied to David..'s topic in Technical Problems
Hi @Stuart Silvester! These are the SQL queries the ACP support tool is telling me to run. I noticed there's a few DROPs in there so I thought I'd put them here before continuing to make sure. UPDATE `core_sys_cp_sessions` SET `session_member_id`=0 WHERE `session_member_id` IS NULL; ALTER TABLE `core_sys_cp_sessions` DROP INDEX `session_member_id`, CHANGE COLUMN `session_member_id` `session_member_id` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD KEY `session_member_id` (`session_member_id`); UPDATE `core_validating` SET `member_id`=0 WHERE `member_id` IS NULL; ALTER TABLE `core_validating` DROP INDEX `member_id`, CHANGE COLUMN `member_id` `member_id` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD KEY `member_id` (`member_id`); UPDATE `core_pfields_content` SET `member_id`=0 WHERE `member_id` IS NULL; CREATE TABLE `core_pfields_content_new` LIKE `core_pfields_content`; ALTER TABLE `core_pfields_content_new` DROP INDEX `PRIMARY`, CHANGE COLUMN `member_id` `member_id` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD PRIMARY KEY (`member_id`); INSERT IGNORE INTO `core_pfields_content_new` SELECT * FROM `core_pfields_content`; DROP TABLE `core_pfields_content`; RENAME TABLE `core_pfields_content_new` TO `core_pfields_content`; ALTER TABLE `core_admin_logs` DROP INDEX `member`, CHANGE COLUMN `member_id` `member_id` BIGINT UNSIGNED NULL DEFAULT 0 , ADD KEY `member` (`member_id`); UPDATE `core_attachments` SET `attach_member_id`=0 WHERE `attach_member_id` IS NULL; ALTER TABLE `core_attachments` DROP INDEX `attach_mid_size`, CHANGE COLUMN `attach_member_id` `attach_member_id` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD KEY `attach_mid_size` (`attach_member_id`,`attach_filesize`); ALTER TABLE `core_sessions` DROP INDEX `login_type`, DROP INDEX `member_id`, DROP INDEX `ip_address`, CHANGE COLUMN `member_id` `member_id` BIGINT UNSIGNED NULL , ADD KEY `login_type` (`login_type`,`running_time`,`member_id`,`member_group`), ADD KEY `member_id` (`member_id`,`ip_address`), ADD KEY `ip_address` (`ip_address`,`member_id`); UPDATE `core_message_topics` SET `mt_to_member_id`=0 WHERE `mt_to_member_id` IS NULL; ALTER TABLE `core_message_topics` CHANGE COLUMN `mt_to_member_id` `mt_to_member_id` BIGINT UNSIGNED NOT NULL DEFAULT 0 ; UPDATE `core_message_posts` SET `msg_author_id`=0 WHERE `msg_author_id` IS NULL; ALTER TABLE `core_message_posts` DROP INDEX `msg_author_id`, CHANGE COLUMN `msg_author_id` `msg_author_id` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD KEY `msg_author_id` (`msg_author_id`); UPDATE `core_message_topic_user_map` SET `map_user_id`=0 WHERE `map_user_id` IS NULL; CREATE TABLE `core_message_topic_user_map_new` LIKE `core_message_topic_user_map`; ALTER TABLE `core_message_topic_user_map_new` DROP INDEX `map_main`, DROP INDEX `map_user`, CHANGE COLUMN `map_user_id` `map_user_id` BIGINT NOT NULL DEFAULT 0 , ADD UNIQUE KEY `map_main` (`map_user_id`,`map_topic_id`), ADD KEY `map_user` (`map_user_id`,`map_user_active`,`map_last_topic_reply`); INSERT IGNORE INTO `core_message_topic_user_map_new` SELECT * FROM `core_message_topic_user_map`; DROP TABLE `core_message_topic_user_map`; RENAME TABLE `core_message_topic_user_map_new` TO `core_message_topic_user_map`; UPDATE `core_rc_comments` SET `comment_by`=0 WHERE `comment_by` IS NULL; ALTER TABLE `core_rc_comments` DROP INDEX `member`, CHANGE COLUMN `comment_by` `comment_by` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD KEY `member` (`comment_by`); UPDATE `core_rc_reports` SET `report_by`=0 WHERE `report_by` IS NULL; ALTER TABLE `core_rc_reports` DROP INDEX `report_by`, CHANGE COLUMN `report_by` `report_by` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD KEY `report_by` (`report_by`); UPDATE `core_item_markers` SET `item_member_id`=0 WHERE `item_member_id` IS NULL; CREATE TABLE `core_item_markers_new` LIKE `core_item_markers`; ALTER TABLE `core_item_markers_new` DROP INDEX `combo_key`, DROP INDEX `marker_index`, CHANGE COLUMN `item_member_id` `item_member_id` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD UNIQUE KEY `combo_key` (`item_key`,`item_member_id`,`item_app`), ADD KEY `marker_index` (`item_member_id`,`item_app`,`item_app_key_1`); INSERT IGNORE INTO `core_item_markers_new` SELECT * FROM `core_item_markers`; DROP TABLE `core_item_markers`; RENAME TABLE `core_item_markers_new` TO `core_item_markers`; UPDATE `core_upgrade_history` SET `upgrade_mid`=0 WHERE `upgrade_mid` IS NULL; ALTER TABLE `core_upgrade_history` CHANGE COLUMN `upgrade_mid` `upgrade_mid` BIGINT NOT NULL DEFAULT 0 ; ALTER TABLE `core_members_warn_logs` DROP INDEX `wl_date`, CHANGE COLUMN `wl_member` `wl_member` BIGINT UNSIGNED NULL , ADD KEY `wl_date` (`wl_member`,`wl_date`), DROP INDEX `wl_moderator`, CHANGE COLUMN `wl_moderator` `wl_moderator` BIGINT UNSIGNED NULL , ADD KEY `wl_moderator` (`wl_moderator`); UPDATE `core_error_logs` SET `log_member`=0 WHERE `log_member` IS NULL; ALTER TABLE `core_error_logs` DROP INDEX `member`, CHANGE COLUMN `log_member` `log_member` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD KEY `member` (`log_member`); UPDATE `core_ignored_users` SET `ignore_owner_id`=0 WHERE `ignore_owner_id` IS NULL; UPDATE `core_ignored_users` SET `ignore_ignore_id`=0 WHERE `ignore_ignore_id` IS NULL; ALTER TABLE `core_ignored_users` DROP INDEX `ignore_owner_id`, CHANGE COLUMN `ignore_owner_id` `ignore_owner_id` BIGINT NOT NULL DEFAULT 0 , ADD KEY `ignore_owner_id` (`ignore_owner_id`), DROP INDEX `ignore_ignore_id`, CHANGE COLUMN `ignore_ignore_id` `ignore_ignore_id` BIGINT NOT NULL DEFAULT 0 , ADD KEY `ignore_ignore_id` (`ignore_ignore_id`); UPDATE `core_announcements` SET `announce_member_id`=0 WHERE `announce_member_id` IS NULL; ALTER TABLE `core_announcements` DROP INDEX `member`, CHANGE COLUMN `announce_member_id` `announce_member_id` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD KEY `member` (`announce_member_id`); UPDATE `core_leaders` SET `leader_type_id`=0 WHERE `leader_type_id` IS NULL; CREATE TABLE `core_leaders_new` LIKE `core_leaders`; ALTER TABLE `core_leaders_new` DROP INDEX `leader_type`, CHANGE COLUMN `leader_type_id` `leader_type_id` BIGINT NOT NULL DEFAULT 0 COMMENT 'Member or group ID', ADD UNIQUE KEY `leader_type` (`leader_type`,`leader_type_id`); INSERT IGNORE INTO `core_leaders_new` SELECT * FROM `core_leaders`; DROP TABLE `core_leaders`; RENAME TABLE `core_leaders_new` TO `core_leaders`; ALTER TABLE `core_advertisements` DROP INDEX `member`, CHANGE COLUMN `ad_member` `ad_member` BIGINT UNSIGNED NULL COMMENT 'If created by Nexus, the customer ID', ADD KEY `member` (`ad_member`); UPDATE `core_edit_history` SET `member`=0 WHERE `member` IS NULL; ALTER TABLE `core_edit_history` DROP INDEX `member`, CHANGE COLUMN `member` `member` BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'The ID number of the member making the edit', ADD KEY `member` (`member`); UPDATE `core_tags` SET `tag_member_id`=0 WHERE `tag_member_id` IS NULL; ALTER TABLE `core_tags` DROP INDEX `tag_member_id`, CHANGE COLUMN `tag_member_id` `tag_member_id` BIGINT NOT NULL DEFAULT 0 , ADD KEY `tag_member_id` (`tag_member_id`); UPDATE `core_reputation_index` SET `member_received`=0 WHERE `member_received` IS NULL; ALTER TABLE `core_reputation_index` DROP INDEX `app`, DROP INDEX `member_received`, DROP INDEX `leaderboard`, CHANGE COLUMN `member_received` `member_received` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD KEY `app` (`app`,`type`,`type_id`,`member_id`,`member_received`), ADD KEY `member_received` (`member_received`,`rep_date`,`rep_class`,`rep_rating`), ADD KEY `leaderboard` (`rep_class`,`rep_date`,`member_received`,`rep_rating`); UPDATE `core_follow` SET `follow_member_id`=0 WHERE `follow_member_id` IS NULL; ALTER TABLE `core_follow` DROP INDEX `follow_member_id`, DROP INDEX `follow_stream`, DROP INDEX `follow_added_extra`, DROP INDEX `digest_task`, CHANGE COLUMN `follow_member_id` `follow_member_id` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD KEY `follow_member_id` (`follow_member_id`,`follow_visible`,`follow_added`), ADD KEY `follow_stream` (`follow_app`(73),`follow_area`(98),`follow_member_id`), ADD KEY `follow_added_extra` (`follow_added`,`follow_is_anon`,`follow_member_id`), ADD KEY `digest_task` (`follow_notify_do`,`follow_notify_freq`,`follow_notify_sent`,`follow_member_id`); UPDATE `core_polls` SET `starter_id`=0 WHERE `starter_id` IS NULL; ALTER TABLE `core_polls` DROP INDEX `member`, CHANGE COLUMN `starter_id` `starter_id` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD KEY `member` (`starter_id`); UPDATE `core_voters` SET `member_id`=0 WHERE `member_id` IS NULL; ALTER TABLE `core_voters` DROP INDEX `member`, CHANGE COLUMN `member_id` `member_id` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD KEY `member` (`member_id`,`poll`); UPDATE `core_member_status_updates` SET `status_member_id`=0 WHERE `status_member_id` IS NULL; UPDATE `core_member_status_updates` SET `status_author_id`=0 WHERE `status_author_id` IS NULL; ALTER TABLE `core_member_status_updates` DROP INDEX `s_hash`, DROP INDEX `status_author_lookup`, DROP INDEX `status_member_id`, CHANGE COLUMN `status_member_id` `status_member_id` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD KEY `s_hash` (`status_member_id`,`status_hash`,`status_date`), ADD KEY `status_author_lookup` (`status_author_id`,`status_member_id`,`status_date`), ADD KEY `status_member_id` (`status_member_id`,`status_approved`,`status_date`), CHANGE COLUMN `status_author_id` `status_author_id` BIGINT NOT NULL DEFAULT 0 ; UPDATE `core_member_status_replies` SET `reply_member_id`=0 WHERE `reply_member_id` IS NULL; ALTER TABLE `core_member_status_replies` DROP INDEX `reply_member_id`, DROP INDEX `reply_status_count`, CHANGE COLUMN `reply_member_id` `reply_member_id` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD KEY `reply_member_id` (`reply_member_id`), ADD KEY `reply_status_count` (`reply_status_id`,`reply_member_id`); ALTER TABLE `core_sys_social_groups` DROP INDEX `owner`, CHANGE COLUMN `owner_id` `owner_id` BIGINT UNSIGNED NULL , ADD KEY `owner` (`owner_id`); ALTER TABLE `core_sys_social_group_members` DROP INDEX `member`, CHANGE COLUMN `member_id` `member_id` BIGINT UNSIGNED NULL , ADD KEY `member` (`member_id`); UPDATE `core_soft_delete_log` SET `sdl_obj_member_id`=0 WHERE `sdl_obj_member_id` IS NULL; ALTER TABLE `core_soft_delete_log` DROP INDEX `member`, CHANGE COLUMN `sdl_obj_member_id` `sdl_obj_member_id` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD KEY `member` (`sdl_obj_member_id`); UPDATE `core_search_index` SET `index_author`=0 WHERE `index_author` IS NULL; ALTER TABLE `core_search_index` DROP INDEX `author_posted_in`, DROP INDEX `author_lookup`, CHANGE COLUMN `index_author` `index_author` BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'The object author id', ADD KEY `author_posted_in` (`index_author`,`index_item_index_id`), ADD KEY `author_lookup` (`index_author`,`index_class`(150),`index_hidden`,`index_date_updated`,`index_date_commented`), DROP INDEX `index_item_author`, CHANGE COLUMN `index_item_author` `index_item_author` BIGINT UNSIGNED NULL COMMENT 'The author of the item', ADD KEY `index_item_author` (`index_item_author`,`index_date_commented`); ALTER TABLE `core_streams` DROP INDEX `member`, CHANGE COLUMN `member` `member` BIGINT NULL COMMENT 'The member who created the stream or null for a global stream', ADD KEY `member` (`member`); UPDATE `core_log` SET `member_id`=0 WHERE `member_id` IS NULL; ALTER TABLE `core_log` CHANGE COLUMN `member_id` `member_id` BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Member that triggered the error, if any'; UPDATE `core_search_index_item_map` SET `index_author_id`=0 WHERE `index_author_id` IS NULL; CREATE TABLE `core_search_index_item_map_new` LIKE `core_search_index_item_map`; ALTER TABLE `core_search_index_item_map_new` DROP INDEX `search_map`, CHANGE COLUMN `index_author_id` `index_author_id` BIGINT NOT NULL DEFAULT 0 , ADD UNIQUE KEY `search_map` (`index_item_id`,`index_class`,`index_author_id`); INSERT IGNORE INTO `core_search_index_item_map_new` SELECT * FROM `core_search_index_item_map`; DROP TABLE `core_search_index_item_map`; RENAME TABLE `core_search_index_item_map_new` TO `core_search_index_item_map`; UPDATE `core_security_answers` SET `answer_member_id`='' WHERE `answer_member_id` IS NULL; CREATE TABLE `core_security_answers_new` LIKE `core_security_answers`; ALTER TABLE `core_security_answers_new` DROP INDEX `question_and_member`, DROP INDEX `member`, CHANGE COLUMN `answer_member_id` `answer_member_id` BIGINT UNSIGNED NOT NULL COMMENT 'The member ID this answer is for', ADD UNIQUE KEY `question_and_member` (`answer_question_id`,`answer_member_id`), ADD KEY `member` (`answer_member_id`); INSERT IGNORE INTO `core_security_answers_new` SELECT * FROM `core_security_answers`; DROP TABLE `core_security_answers`; RENAME TABLE `core_security_answers_new` TO `core_security_answers`; UPDATE `core_reputation_leaderboard_history` SET `leader_member_id`=0 WHERE `leader_member_id` IS NULL; CREATE TABLE `core_reputation_leaderboard_history_new` LIKE `core_reputation_leaderboard_history`; ALTER TABLE `core_reputation_leaderboard_history_new` DROP INDEX `leader_date`, DROP INDEX `first_place`, CHANGE COLUMN `leader_member_id` `leader_member_id` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD UNIQUE KEY `leader_date` (`leader_date`,`leader_member_id`), ADD KEY `first_place` (`leader_position`,`leader_member_id`); INSERT IGNORE INTO `core_reputation_leaderboard_history_new` SELECT * FROM `core_reputation_leaderboard_history`; DROP TABLE `core_reputation_leaderboard_history`; RENAME TABLE `core_reputation_leaderboard_history_new` TO `core_reputation_leaderboard_history`; UPDATE `forums_forums` SET `last_poster_id`=0 WHERE `last_poster_id` IS NULL; ALTER TABLE `forums_forums` CHANGE COLUMN `last_poster_id` `last_poster_id` BIGINT UNSIGNED NOT NULL DEFAULT 0 ; UPDATE `forums_topics` SET `starter_id`=0 WHERE `starter_id` IS NULL; UPDATE `forums_topics` SET `last_poster_id`=0 WHERE `last_poster_id` IS NULL; ALTER TABLE `forums_topics` DROP INDEX `starter_id`, CHANGE COLUMN `starter_id` `starter_id` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD KEY `starter_id` (`starter_id`,`forum_id`,`approved`,`start_date`), CHANGE COLUMN `last_poster_id` `last_poster_id` BIGINT UNSIGNED NOT NULL DEFAULT 0 ; UPDATE `forums_posts` SET `author_id`=0 WHERE `author_id` IS NULL; ALTER TABLE `forums_posts` DROP INDEX `author_id`, DROP INDEX `topic_id`, CHANGE COLUMN `author_id` `author_id` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD KEY `author_id` (`author_id`,`post_date`,`queued`), ADD KEY `topic_id` (`topic_id`,`queued`,`post_date`,`author_id`); CREATE TABLE `forums_question_ratings_new` LIKE `forums_question_ratings`; ALTER TABLE `forums_question_ratings_new` DROP INDEX `member_rating`, DROP INDEX `topic`, CHANGE COLUMN `member` `member` BIGINT UNSIGNED NULL COMMENT 'The member giving the rating', ADD UNIQUE KEY `member_rating` (`member`,`topic`), ADD KEY `topic` (`topic`,`member`); INSERT IGNORE INTO `forums_question_ratings_new` SELECT * FROM `forums_question_ratings`; DROP TABLE `forums_question_ratings`; RENAME TABLE `forums_question_ratings_new` TO `forums_question_ratings`; UPDATE `forums_archive_posts` SET `archive_author_id`=0 WHERE `archive_author_id` IS NULL; ALTER TABLE `forums_archive_posts` DROP INDEX `archive_author_id`, CHANGE COLUMN `archive_author_id` `archive_author_id` BIGINT NOT NULL DEFAULT 0 , ADD KEY `archive_author_id` (`archive_author_id`); UPDATE `nexus_invoices` SET `i_id`='' WHERE `i_id` IS NULL; UPDATE `nexus_invoices` SET `i_member`=0 WHERE `i_member` IS NULL; ALTER TABLE `nexus_invoices` CHANGE COLUMN `i_id` `i_id` INT NOT NULL AUTO_INCREMENT , DROP INDEX `i_member`, CHANGE COLUMN `i_member` `i_member` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD KEY `i_member` (`i_member`); UPDATE `nexus_transactions` SET `t_member`=0 WHERE `t_member` IS NULL; ALTER TABLE `nexus_transactions` DROP INDEX `t_member`, CHANGE COLUMN `t_member` `t_member` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD KEY `t_member` (`t_member`,`t_status`,`t_fraud_blocked`); UPDATE `nexus_customers` SET `member_id`=0 WHERE `member_id` IS NULL; CREATE TABLE `nexus_customers_new` LIKE `nexus_customers`; ALTER TABLE `nexus_customers_new` DROP INDEX `PRIMARY`, CHANGE COLUMN `member_id` `member_id` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD PRIMARY KEY (`member_id`); INSERT IGNORE INTO `nexus_customers_new` SELECT * FROM `nexus_customers`; DROP TABLE `nexus_customers`; RENAME TABLE `nexus_customers_new` TO `nexus_customers`; UPDATE `nexus_purchases` SET `ps_member`=0 WHERE `ps_member` IS NULL; ALTER TABLE `nexus_purchases` DROP INDEX `ps_member`, CHANGE COLUMN `ps_member` `ps_member` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD KEY `ps_member` (`ps_member`), CHANGE COLUMN `ps_pay_to` `ps_pay_to` BIGINT UNSIGNED NULL ; UPDATE `nexus_payouts` SET `po_member`=0 WHERE `po_member` IS NULL; ALTER TABLE `nexus_payouts` DROP INDEX `po_member`, CHANGE COLUMN `po_member` `po_member` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD KEY `po_member` (`po_member`,`po_date`), CHANGE COLUMN `po_processed_by` `po_processed_by` BIGINT UNSIGNED NULL ; UPDATE `nexus_support_replies` SET `reply_member`=0 WHERE `reply_member` IS NULL; ALTER TABLE `nexus_support_replies` DROP INDEX `reply_member`, CHANGE COLUMN `reply_member` `reply_member` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD KEY `reply_member` (`reply_member`); UPDATE `nexus_support_requests` SET `r_member`=0 WHERE `r_member` IS NULL; UPDATE `nexus_support_requests` SET `r_last_reply_by`=0 WHERE `r_last_reply_by` IS NULL; UPDATE `nexus_support_requests` SET `r_staff`=0 WHERE `r_staff` IS NULL; ALTER TABLE `nexus_support_requests` DROP INDEX `r_member`, CHANGE COLUMN `r_member` `r_member` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD KEY `r_member` (`r_member`), DROP INDEX `r_last_reply_by`, CHANGE COLUMN `r_last_reply_by` `r_last_reply_by` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD KEY `r_last_reply_by` (`r_last_reply_by`), DROP INDEX `r_staff`, CHANGE COLUMN `r_staff` `r_staff` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD KEY `r_staff` (`r_staff`); UPDATE `nexus_support_tracker` SET `member_id`=0 WHERE `member_id` IS NULL; CREATE TABLE `nexus_support_tracker_new` LIKE `nexus_support_tracker`; ALTER TABLE `nexus_support_tracker_new` DROP INDEX `PRIMARY`, CHANGE COLUMN `member_id` `member_id` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD PRIMARY KEY (`member_id`,`request_id`); INSERT IGNORE INTO `nexus_support_tracker_new` SELECT * FROM `nexus_support_tracker`; DROP TABLE `nexus_support_tracker`; RENAME TABLE `nexus_support_tracker_new` TO `nexus_support_tracker`; UPDATE `nexus_support_views` SET `view_member`=0 WHERE `view_member` IS NULL; CREATE TABLE `nexus_support_views_new` LIKE `nexus_support_views`; ALTER TABLE `nexus_support_views_new` DROP INDEX `PRIMARY`, CHANGE COLUMN `view_member` `view_member` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD PRIMARY KEY (`view_rid`,`view_member`); INSERT IGNORE INTO `nexus_support_views_new` SELECT * FROM `nexus_support_views`; DROP TABLE `nexus_support_views`; RENAME TABLE `nexus_support_views_new` TO `nexus_support_views`; UPDATE `nexus_support_stock_actions` SET `action_staff`=0 WHERE `action_staff` IS NULL; ALTER TABLE `nexus_support_stock_actions` CHANGE COLUMN `action_staff` `action_staff` BIGINT UNSIGNED NOT NULL DEFAULT 0 ; ALTER TABLE `nexus_support_ratings` DROP INDEX `rating_from`, CHANGE COLUMN `rating_from` `rating_from` BIGINT UNSIGNED NULL , ADD KEY `rating_from` (`rating_from`), DROP INDEX `rating_staff`, CHANGE COLUMN `rating_staff` `rating_staff` BIGINT UNSIGNED NULL , ADD KEY `rating_staff` (`rating_staff`); ALTER TABLE `nexus_licensekeys` DROP INDEX `lkey_member`, CHANGE COLUMN `lkey_member` `lkey_member` BIGINT UNSIGNED NULL , ADD KEY `lkey_member` (`lkey_member`); ALTER TABLE `nexus_reviews` DROP INDEX `review_author_id`, CHANGE COLUMN `review_author_id` `review_author_id` BIGINT UNSIGNED NULL , ADD KEY `review_author_id` (`review_author_id`), CHANGE COLUMN `review_edit_member_id` `review_edit_member_id` BIGINT UNSIGNED NULL ; UPDATE `nexus_alternate_contacts` SET `main_id`=0 WHERE `main_id` IS NULL; UPDATE `nexus_alternate_contacts` SET `alt_id`=0 WHERE `alt_id` IS NULL; CREATE TABLE `nexus_alternate_contacts_new` LIKE `nexus_alternate_contacts`; ALTER TABLE `nexus_alternate_contacts_new` DROP INDEX `PRIMARY`, CHANGE COLUMN `main_id` `main_id` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD PRIMARY KEY (`main_id`,`alt_id`), DROP INDEX `alt_id`, CHANGE COLUMN `alt_id` `alt_id` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD KEY `alt_id` (`alt_id`); INSERT IGNORE INTO `nexus_alternate_contacts_new` SELECT * FROM `nexus_alternate_contacts`; DROP TABLE `nexus_alternate_contacts`; RENAME TABLE `nexus_alternate_contacts_new` TO `nexus_alternate_contacts`; ALTER TABLE `nexus_donate_logs` CHANGE COLUMN `dl_member` `dl_member` BIGINT UNSIGNED NULL ; UPDATE `nexus_notes` SET `note_member`=0 WHERE `note_member` IS NULL; UPDATE `nexus_notes` SET `note_author`=0 WHERE `note_author` IS NULL; ALTER TABLE `nexus_notes` DROP INDEX `note_member`, CHANGE COLUMN `note_member` `note_member` BIGINT UNSIGNED NOT NULL DEFAULT 0 , ADD KEY `note_member` (`note_member`), CHANGE COLUMN `note_author` `note_author` BIGINT UNSIGNED NOT NULL DEFAULT 0 ; UPDATE `nexus_support_request_log` SET `rlog_member`='' WHERE `rlog_member` IS NULL; ALTER TABLE `nexus_support_request_log` DROP INDEX `rlog_member`, CHANGE COLUMN `rlog_member` `rlog_member` BIGINT UNSIGNED NOT NULL COMMENT 'The member ID of the staff performing the action', ADD KEY `rlog_member` (`rlog_member`); ALTER TABLE `nexus_billing_agreements` DROP INDEX `member`, CHANGE COLUMN `ba_member` `ba_member` BIGINT UNSIGNED NULL COMMENT 'Customer ID', ADD KEY `member` (`ba_member`); ALTER TABLE `nexus_support_streams` DROP INDEX `list`, CHANGE COLUMN `stream_owner` `stream_owner` BIGINT UNSIGNED NULL DEFAULT 0 COMMENT 'The ID number of the staff member who owns the stream', ADD KEY `list` (`stream_owner`,`stream_position`); UPDATE `nexus_support_staff_preferences` SET `staff_id`='' WHERE `staff_id` IS NULL; ALTER TABLE `nexus_support_staff_preferences` CHANGE COLUMN `staff_id` `staff_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID Number of staff member'; CREATE TABLE `nexus_support_staff_dpt_order_new` LIKE `nexus_support_staff_dpt_order`; ALTER TABLE `nexus_support_staff_dpt_order_new` DROP INDEX `staff_and_department`, CHANGE COLUMN `staff_id` `staff_id` BIGINT UNSIGNED NULL DEFAULT 0 COMMENT 'The staff\'s member ID', ADD UNIQUE KEY `staff_and_department` (`staff_id`,`department_id`); INSERT IGNORE INTO `nexus_support_staff_dpt_order_new` SELECT * FROM `nexus_support_staff_dpt_order`; DROP TABLE `nexus_support_staff_dpt_order`; RENAME TABLE `nexus_support_staff_dpt_order_new` TO `nexus_support_staff_dpt_order`; Is anyone from IPS able to do this? I'd feel more comfortable if that were to be the case. -
Various issues with member_id surpassing mediumint(8)
David.. replied to David..'s topic in Technical Problems
I’m on the latest, 4.7.5. Only have not applied the moderator bug patch.