Jump to content

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..

  1. Hi again @Matt. Just wanted to ask if there is an update to this since new members are unable to properly use the community, and it seems like they are creating topics (according to pending numbers in board index) but they are nowhere to be seen. Similar issue for posts, PMs, commerce, and likely other parts of the community. Looking forward to your reply.
  2. Hi Matt! Thank you for replying and hope you're having a Merry Christmas! Is this something that would require resolution on my live board the coming days, or would I have wait until the next IPS release? I can also upgrade them to bigint myself if you could get me a list of all the member_id columns. Looking forward to your next reply.
  3. On my community, member IDs now surpass the 8 digit value and because of this, there are numerous issues with new registrations. It started with them being unable to create a new account, which thankfully was resolved here: https://invisioncommunity.com/forums/topic/471135-new-accounts-unable-to-be-created/#comment-2919659 After resolving the registrations, because of the member IDs surpassing 8 digits, it also caused issues with nexus, posts (both partially fixed but IPS complaining as seen below) and seems like I cannot start new PMs. When trying to make a new post or PM now, it double posts but the posts do not actually show which may be causing issues with the database. The same issue can also be seen via PM. While changing to BIGINT(20) solves the issue, IPS support seems to be complaining about there being an issue with the database: 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 `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`; 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`); UPDATE `nexus_invoices` SET `i_id`='' WHERE `i_id` IS NULL; ALTER TABLE `nexus_invoices` CHANGE COLUMN `i_id` `i_id` INT NOT NULL AUTO_INCREMENT ; Hopefully someone from the IPS team ( @Matt, @Daniel F & others) can take some time to look into this or at least tell me where all the member ID columns that need to be changed to BIGINT are. This should be escalated as it seems to be a bug with the IPS software itself as pointed out by @teraßyte here: https://invisioncommunity.com/forums/topic/471135-new-accounts-unable-to-be-created/?do=findComment&comment=2919579 I have made sure the access information is up to date. Sorry this had to happen on Christmas day, but it is out of my control. Thank you.
  4. This is something I have sought to accomplish but was told that it was not possible which left me no choice but to continue using the file modifications.
  5. I understand. They are insignificant in terms of the whole software, and this problem, but they are significant & required for my community to run. In fact, the main change is allowing Oauth redirects to be URIs instead of only URLs. Something which should be by done by default. Around 7 lines of code are commented out. Specifically: if ( $redirectUri ) { //if ( !\in_array( $redirectUri, $allowedRedirectUris ) ) //{ // throw new \IPS\Login\Handler\OAuth2\InitException('oauth_err_invalid_redirect_uri'); //} //else //{ $obj->redirectUri = \IPS\Http\Url::external( $redirectUri ); //} } This is what I was willing to do in a previous support topic but the issue here is that once the modifications are removed the Oauth is broken and inaccessible for seemingly hours until someone from IPS looks into the issue, and even longer if they have to escalate. This is not an ideal solution for us, and that's why I refrain from asking support from staff. You are correct, so just replace cupholders with anything else insignificant that would not affect the entirety of the car, or the issue at hand. Just to be clear: I'm referring to my case here, I don't know what others do to their modified files.
  6. That is understandable, except in this case I’ve modified my cup holders so Volkswagen shouldn’t deny servicing the actual problem. As I mentioned, the modified files are minor and only affect the API & Oauth. This should not make it so the whole community is unable to be supported, especially as you can see in this topic, the issue was entirely unrelated to the file modifications.
  7. Hi @Gary, I unfortunately refrain from getting in touch with IPS support given that the simple file modification I’ve made makes it impossible to receive support from the staff. Thankfully, other members were able to assist with this issue. I would like to emphasize that this issue had nothing to do with the modified files, and neither did my previous support topics.
  8. Thank you for this. The problem seems to be solved now. Thank you!
  9. I have tested with those reverted back and everything disabled after a fresh update to 4.7.5, the issue is still present.
  10. Disabled everything, switched to default theme and unfortunately the issue is still present.
  11. As mentioned in the first post, that does not seem to help. One thing I do notice is that disabling everything still keeps the custom theme for guests which was usually not the case.
  12. When trying to create a new account on our site it creates the account successfully but on the registration form it proceeds to say "That display name is in use by another member." & That email address is in use by another member. Do you need to reset your password?" There is an issue here as the account name & email was available right before hitting the "Create my Account" button. I tried disabling all apps & plugins via support, but the issue was strangely still present. Access information is up to date. Potentially related system log: INSERT INTO `ipb__core_pfields_content` ( `member_id`, `field_12`, `field_13`, `field_27` ) VALUES ( 8497548, 'Windows', '11', 0 ) ON DUPLICATE KEY UPDATE `member_id`=VALUES(`member_id`), `field_12`=VALUES(`field_12`), `field_13`=VALUES(`field_13`), `field_27`=VALUES(`field_27`) IPS\Db\Exception: Out of range value for column 'member_id' at row 1 (1264) #0 public_html/system/Db/Db.php(941): IPS\_Db->preparedQuery() #1 public_html/applications/core/extensions/core/ProfileSteps/ProfileFields.php(208): IPS\_Db->insert() #2 public_html/applications/core/modules/front/system/register.php(572): IPS\core\extensions\core\ProfileSteps\_ProfileFields::formatFormValues() #3 public_html/applications/core/modules/front/system/register.php(242): IPS\core\modules\front\system\_register::_createMember() #4 public_html/applications/core/modules/front/system/register.php(176): IPS\core\modules\front\system\_register->_registrationForm() #5 public_html/system/Helpers/Wizard/Wizard.php(181): IPS\core\modules\front\system\_register->IPS\core\modules\front\system\{closure}() #6 public_html/applications/core/modules/front/system/register.php(183): IPS\Helpers\_Wizard->__toString() #7 public_html/init.php(927) : eval()'d code(27): IPS\core\modules\front\system\_register->manage() #8 public_html/system/Dispatcher/Controller.php(118): IPS\core\modules\front\system\nexus_hook_register->manage() #9 public_html/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute() #10 public_html/index.php(13): IPS\_Dispatcher->run() #11 {main} Backtrace: #0 public_html/init.php(1029): IPS\_Log::log() #1 public_html/system/Helpers/Wizard/Wizard.php(227): IPS\IPS::exceptionHandler() #2 public_html/applications/core/modules/front/system/register.php(183): IPS\Helpers\_Wizard->__toString() #3 public_html/init.php(927) : eval()'d code(27): IPS\core\modules\front\system\_register->manage() #4 public_html/system/Dispatcher/Controller.php(118): IPS\core\modules\front\system\nexus_hook_register->manage() #5 public_html/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute() #6 public_html/index.php(13): IPS\_Dispatcher->run() #7 {main}
  13. Sadly, no. I just check my email and it was getting spammed. I haven't received anything on other emails as of now.
  14. I am still experiencing this problem. I’m not entirely sure, but it may be related to topics created via the API.
  15. It’s the default search method. Even if the option is off.
  16. @DawPi This is enabled by default regardless of setting on 4.7.3. Can we fix it please?
  17. Then really it should be labeled as posts, not as topics, right?
  18. In my case, it arranges topics by recent activity, posts. It doesn’t arrange topics by start date. So with that, it seems like it’s arranging by posts rather than topics.
  19. I guess, but selecting “Topics” should only show topics, don’t you think?
  20. It’s fine, I thought the same too. I think it was doable before but now it seems to no longer be the case.
  21. Thank you for your reply. Have you tried that? Selecting the topics option also includes posts. Happens here on IC too.
  22. Creating a new activity stream is great, but is there a reason why topics and posts are combined into one? I cannot seem to create a new stream with just new topics for example. It's always showing recent posts made in topics too.
  23. @All Astronauts Can we also add the features from this plugin? And of course the old online indicator plugins too. https://invisioncommunity.com/files/file/7853-online-indicator/
×
×
  • Create New...