Page 3 of 4 FirstFirst 1234 LastLast
Results 31 to 45 of 54

Thread: forum bugs

   
  1. #31
    Points: 15,885, Level: 81
    Level completed: 7%, Points required for next Level: 465
    Overall activity: 5.0%
    Achievements:
    Veteran10000 Experience PointsOverdrive

    Join Date
    Jul 2003
    Posts
    26,710
    Points
    15,885
    Level
    81
    Thanks
    0
    Thanked 1,680 Times in 740 Posts

    Default Re: forum bugs

    Test..
    Last edited by elusive moonwalker; 18-05-2020 at 05:03 PM.

  2. #32
    Points: 8,580, Level: 62
    Level completed: 44%, Points required for next Level: 170
    Overall activity: 14.0%
    Achievements:
    3 months registeredOverdrive5000 Experience Points

    Join Date
    Oct 2019
    Location
    Germany
    Posts
    2,689
    Points
    8,580
    Level
    62
    Thanks
    2,210
    Thanked 2,839 Times in 1,483 Posts

    Default Re: forum bugs

    I ran into a problem with the search feature. To reproduce, do the following:

    Go to advanced search.
    Go to the “Multiple content types” tab.
    Type “dynamite” into the first search box (“Keyword(s)”).
    Select “search entire posts”.
    Leave everything else at default.
    Click “Search now”.
    On the search results page, find the pagination (Page 1 of 7) and click on page 2.

    The server throws the following error:

    “Warning: mysqli_query(): (42000/1064): 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 ')' at line 10 in ..../includes/class_core.php on line 1393”

    This problem seems to appear for some search terms only. So use “dynamite” specifically to reproduce the result.
    Last edited by ScreenOrigami; 23-08-2020 at 11:59 AM.
    Twitter: @ScreenOrigami
    Pokémon Go: 5702 7276 8494

  3. #33
    Points: 26,669, Level: 97
    Level completed: 32%, Points required for next Level: 681
    Overall activity: 33.0%
    Achievements:
    Three FriendsTagger Second ClassVeteran25000 Experience Points
    Anna's Avatar
    Join Date
    Mar 2009
    Location
    UK
    Posts
    6,555
    Points
    26,669
    Level
    97
    Thanks
    325
    Thanked 1,170 Times in 558 Posts

    Default Re: forum bugs

    Quote Originally Posted by ScreenOrigami View Post
    This problem seems to appear for some search terms only. So use “dynamite” specifically to reproduce the result.
    Just did it and it worked fine.

  4. #34
    Points: 8,580, Level: 62
    Level completed: 44%, Points required for next Level: 170
    Overall activity: 14.0%
    Achievements:
    3 months registeredOverdrive5000 Experience Points

    Join Date
    Oct 2019
    Location
    Germany
    Posts
    2,689
    Points
    8,580
    Level
    62
    Thanks
    2,210
    Thanked 2,839 Times in 1,483 Posts

    Default Re: forum bugs

    Quote Originally Posted by Anna View Post
    Just did it and it worked fine.
    That’s odd. Still throws an error for me. Are you on desktop or mobile?

    I tried it again and still get the error. It’s a database error, so this time around definitely nothing on the user’s end:



    Edit: Could have something to do with UTF-8 encoding.
    Last edited by ScreenOrigami; 23-08-2020 at 12:23 PM.
    Twitter: @ScreenOrigami
    Pokémon Go: 5702 7276 8494

  5. #35
    Points: 17,689, Level: 84
    Level completed: 68%, Points required for next Level: 161
    Overall activity: 31.0%
    Achievements:
    Three FriendsOverdriveTagger Second ClassVeteran10000 Experience Points
    Mikky Dee's Avatar
    Join Date
    Mar 2016
    Location
    Australia
    Posts
    2,591
    Points
    17,689
    Level
    84
    Thanks
    4,753
    Thanked 2,413 Times in 1,196 Posts

    Default Re: forum bugs

    Quote Originally Posted by ScreenOrigami View Post
    That’s odd. Still throws an error for me. Are you on desktop or mobile?

    I tried it again and still get the error. It’s a database error, so this time around definitely nothing on the user’s end:



    Edit: Could have something to do with UTF-8 encoding.

    I get the error as well. Page 1 works fine, but the error is on all other pages. I'm on a desk top.

  6. The Following User Says Thank You to Mikky Dee For This Useful Post:


  7. #36
    Points: 26,760, Level: 97
    Level completed: 41%, Points required for next Level: 590
    Overall activity: 11.0%
    Achievements:
    Three FriendsVeteran25000 Experience Points
    Galactus123's Avatar
    Join Date
    Jan 2011
    Location
    Finland
    Posts
    4,768
    Points
    26,760
    Level
    97
    Thanks
    2,429
    Thanked 2,963 Times in 1,496 Posts

    Default Re: forum bugs

    My forum signature doesn't show when I post on my phone. It could have something to do with the mobile version of the site.

  8. #37
    Points: 26,669, Level: 97
    Level completed: 32%, Points required for next Level: 681
    Overall activity: 33.0%
    Achievements:
    Three FriendsTagger Second ClassVeteran25000 Experience Points
    Anna's Avatar
    Join Date
    Mar 2009
    Location
    UK
    Posts
    6,555
    Points
    26,669
    Level
    97
    Thanks
    325
    Thanked 1,170 Times in 558 Posts

    Default Re: forum bugs

    Quote Originally Posted by ScreenOrigami View Post
    That’s odd. Still throws an error for me. Are you on desktop or mobile?

    I tried it again and still get the error. It’s a database error, so this time around definitely nothing on the user’s end:



    Edit: Could have something to do with UTF-8 encoding.
    Desktop version on mobile.

  9. #38
    Points: 8,580, Level: 62
    Level completed: 44%, Points required for next Level: 170
    Overall activity: 14.0%
    Achievements:
    3 months registeredOverdrive5000 Experience Points

    Join Date
    Oct 2019
    Location
    Germany
    Posts
    2,689
    Points
    8,580
    Level
    62
    Thanks
    2,210
    Thanked 2,839 Times in 1,483 Posts

    Default Re: forum bugs

    Quote Originally Posted by Anna View Post
    Desktop version on mobile.
    Tried it with the desktop view on my mobile, and I still get the error:



    Firefox for Android
    Twitter: @ScreenOrigami
    Pokémon Go: 5702 7276 8494

  10. #39
    Points: 26,669, Level: 97
    Level completed: 32%, Points required for next Level: 681
    Overall activity: 33.0%
    Achievements:
    Three FriendsTagger Second ClassVeteran25000 Experience Points
    Anna's Avatar
    Join Date
    Mar 2009
    Location
    UK
    Posts
    6,555
    Points
    26,669
    Level
    97
    Thanks
    325
    Thanked 1,170 Times in 558 Posts

    Default Re: forum bugs

    Quote Originally Posted by ScreenOrigami View Post
    Tried it with the desktop view on my mobile, and I still get the error:



    Firefox for Android
    It works for me on the Full Site version on mobile Chrome.

  11. #40
    Points: 7,292, Level: 56
    Level completed: 72%, Points required for next Level: 58
    Overall activity: 3.0%
    Achievements:
    OverdriveVeteran5000 Experience Points

    Join Date
    Jul 2016
    Posts
    1,631
    Points
    7,292
    Level
    56
    Thanks
    826
    Thanked 1,363 Times in 709 Posts

    Default Re: forum bugs

    The search function is broken. So many things you search for and you get the message "Sorry - no matches. Please try some different terms." I just typed in the keyword "Bad" and got this annoying message. Does this forum not recognise Michael's second most successful album?

  12. #41
    Points: 26,669, Level: 97
    Level completed: 32%, Points required for next Level: 681
    Overall activity: 33.0%
    Achievements:
    Three FriendsTagger Second ClassVeteran25000 Experience Points
    Anna's Avatar
    Join Date
    Mar 2009
    Location
    UK
    Posts
    6,555
    Points
    26,669
    Level
    97
    Thanks
    325
    Thanked 1,170 Times in 558 Posts

    Default Re: forum bugs

    Quote Originally Posted by Nite Line View Post
    The search function is broken. So many things you search for and you get the message "Sorry - no matches. Please try some different terms." I just typed in the keyword "Bad" and got this annoying message. Does this forum not recognise Michael's second most successful album?
    It's not broken. Three letter words are too short. And some terms aren't specific enough to give results.

  13. #42
    Points: 24,701, Level: 95
    Level completed: 36%, Points required for next Level: 649
    Overall activity: 3.0%
    Achievements:
    VeteranThree Friends10000 Experience PointsOverdrive
    Gaz's Avatar
    Join Date
    Dec 2002
    Location
    London
    Posts
    1,106
    Points
    24,701
    Level
    95
    Thanks
    251
    Thanked 3,350 Times in 685 Posts

    Default Re: forum bugs

    Quote Originally Posted by Anna View Post
    It's not broken. Three letter words are too short. And some terms aren't specific enough to give results.
    That's correct Anna, the forum search is set to a minimum of four letters, this is due to the amount of resource and quieries on the database should it be less, can you image how many times the word 'Bad' has been used on a forum of 3 million posts on a Michael Jackson discussion forum? it's all about managing the server load to ensure the forum is fit for use for all.
    MJJCommunity Owner And Founder
    Making that change for Michael since 2001
    Loyal fan since 1978

  14. The Following 2 Users Say Thank You to Gaz For This Useful Post:


  15. #43
    Points: 8,580, Level: 62
    Level completed: 44%, Points required for next Level: 170
    Overall activity: 14.0%
    Achievements:
    3 months registeredOverdrive5000 Experience Points

    Join Date
    Oct 2019
    Location
    Germany
    Posts
    2,689
    Points
    8,580
    Level
    62
    Thanks
    2,210
    Thanked 2,839 Times in 1,483 Posts

    Default Re: forum bugs

    Is the “Reported Threads & Posts” thread supposed to be visible for regular users? Just wondering because reporting was supposed to be anonymous. I don’t mind, but maybe others do. I can view the entire Staff subforum now.

    Twitter: @ScreenOrigami
    Pokémon Go: 5702 7276 8494

  16. The Following User Says Thank You to ScreenOrigami For This Useful Post:


  17. #44
    Points: 26,669, Level: 97
    Level completed: 32%, Points required for next Level: 681
    Overall activity: 33.0%
    Achievements:
    Three FriendsTagger Second ClassVeteran25000 Experience Points
    Anna's Avatar
    Join Date
    Mar 2009
    Location
    UK
    Posts
    6,555
    Points
    26,669
    Level
    97
    Thanks
    325
    Thanked 1,170 Times in 558 Posts

    Default Re: forum bugs

    Quote Originally Posted by ScreenOrigami View Post
    Is the “Reported Threads & Posts” thread supposed to be visible for regular users? Just wondering because reporting was supposed to be anonymous. I don’t mind, but maybe others do. I can view the entire Staff subforum now.


    Thanks, I'll let Gaz know. It's probably an incorrect permission with the patron group.

  18. #45
    Points: 24,701, Level: 95
    Level completed: 36%, Points required for next Level: 649
    Overall activity: 3.0%
    Achievements:
    VeteranThree Friends10000 Experience PointsOverdrive
    Gaz's Avatar
    Join Date
    Dec 2002
    Location
    London
    Posts
    1,106
    Points
    24,701
    Level
    95
    Thanks
    251
    Thanked 3,350 Times in 685 Posts

    Default Re: forum bugs

    Thanks for letting us know, yes it’s a permissions error lol.
    MJJCommunity Owner And Founder
    Making that change for Michael since 2001
    Loyal fan since 1978

  19. The Following User Says Thank You to Gaz For This Useful Post:


Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •