Advertisement:

Author Topic: Very high rate of errors since moving to 2.0.17 (another issue re. "Forum" page)  (Read 1596 times)

Offline aegersz

  • SMF Hero
  • ******
  • Posts: 1,747
  • Gender: Male
  • the "mods and tweaks" junkie
    • dopetalk (drugs and users)
Actually, I just visited your forum and can see (looking at the page source) that the rogue board does not have a board_id.



Try creating a new board within your "Core Topics" category and see what that does to the board indexing.

I did that and called it Temp (Tempo) (see earlier screenshot). I even moved another board in and out of the category. The board does not have any id, as you correctly mentioned.

The Board handling logic must be very old and I can't imagine that the 2.0.16 (and above) are the culprits.
The configuration of my Linux VPS (SMF 2.0 with 155+ mods & some assorted manual tweaks) can be found here and notes on my mods can be found here (warning: those links will take you to a drug related forum). My (House) music DJ dedication page is here

Offline Shambles

  • SMF Hero
  • ******
  • Posts: 5,629
  • Gender: Male
    • i30 Owners Club
Ok let's take this one step back.

Run a query to show the category IDs in use in your smf209_boards table.

select id_cat from smf209_boards;

Make sure each and every board has a valid category number.

To see valid category numbers, select * from smf209_categories;


My thinking here is that you have a board with a non-existent category

Offline aegersz

  • SMF Hero
  • ******
  • Posts: 1,747
  • Gender: Male
  • the "mods and tweaks" junkie
    • dopetalk (drugs and users)
I see ... no, i have accounted for all categories and boards

Code: [Select]
mysql> select id_cat, id_board from smf209_boards order by 2;
+--------+----------+
| id_cat | id_board |
+--------+----------+
|      1 |        1 |
|      2 |        2 |
|      2 |        3 |
|      2 |        4 |
|      2 |        6 |
|      3 |        7 |
|      1 |        9 |
|      2 |       11 |
|      2 |       12 |
|      2 |       13 |
|      2 |       14 |
|      2 |       21 |
|      2 |       22 |
|      2 |       23 |
|      2 |       24 |
|      2 |       25 |
|      2 |       26 |
|      2 |       29 |
|      2 |       31 |
|      2 |       32 |
|      2 |       33 |
|      2 |       34 |
|      2 |       36 |
|      2 |       37 |
|      2 |       38 |
|      2 |       39 |
|      2 |       40 |
|      2 |       41 |
|      2 |       42 |
|      2 |       43 |
|      2 |       44 |
|      2 |       45 |
|      2 |       48 |
|      2 |       49 |
|      2 |       52 |
|      2 |       53 |
|      3 |       54 |
|      2 |       55 |
|      2 |       56 |
|      2 |       57 |
|      2 |       58 |
|      2 |       59 |
|      9 |       60 |
|      3 |       61 |
|      2 |       62 |
|      2 |       63 |
|      2 |       64 |
|      3 |       65 |
|      2 |       66 |
|      1 |       67 |
|      2 |       68 |
|      2 |       70 |
|      2 |       71 |
|      2 |       72 |
|      2 |       73 |
|      2 |       74 |
|      2 |       75 |
|      2 |       76 |
|      2 |       77 |
|      2 |       78 |
|      2 |       79 |
|      2 |       80 |
|     11 |       85 |
|      2 |       86 |
|      2 |       87 |
|     11 |       88 |
|      2 |       89 |
|      1 |       90 |
|     10 |       91 |
|     10 |       92 |
|      8 |       93 |
|      2 |       94 |
|      2 |       95 |
|      2 |       96 |
|      3 |       97 |
|      1 |       98 |
|     12 |       99 |
|     12 |      100 |
|      1 |      101 |
|      2 |      102 |
|      2 |      103 |
|     13 |      104 |
|      2 |      105 |
|      2 |      106 |
|     12 |      107 |
|      2 |      108 |
|      2 |      109 |
|     12 |      110 |
|      2 |      111 |
|      2 |      112 |
|      2 |      113 |
|      2 |      114 |
|      1 |      115 |
|      2 |      116 |
|      2 |      117 |
+--------+----------+
95 rows in set (0.00 sec)

Code: [Select]
mysql> select * from smf209_categories;
+--------+-----------+---------------+--------------+
| id_cat | cat_order | name          | can_collapse |
+--------+-----------+---------------+--------------+
|      1 |         0 | General       |            1 |
|      2 |         3 | Core Topics   |            1 |
|      3 |         1 | Technology    |            1 |
|      8 |         4 | In Memoriam   |            1 |
|      9 |         5 | Treasury      |            1 |
|     10 |         8 | Salvage Area  |            1 |
|     11 |         7 | Archives      |            1 |
|     12 |         2 | Mind and Body |            1 |
|     13 |         6 | Private       |            1 |
+--------+-----------+---------------+--------------+
9 rows in set (0.00 sec)
The configuration of my Linux VPS (SMF 2.0 with 155+ mods & some assorted manual tweaks) can be found here and notes on my mods can be found here (warning: those links will take you to a drug related forum). My (House) music DJ dedication page is here

Offline Shambles

  • SMF Hero
  • ******
  • Posts: 5,629
  • Gender: Male
    • i30 Owners Club
Ok, try the following which should skip the faulty board.

I'll look into this later.


Offline aegersz

  • SMF Hero
  • ******
  • Posts: 1,747
  • Gender: Male
  • the "mods and tweaks" junkie
    • dopetalk (drugs and users)


Thanks for temporarily patching the code for me, Shambles. It works.
« Last Edit: March 06, 2020, 04:27:53 PM by aegersz »
The configuration of my Linux VPS (SMF 2.0 with 155+ mods & some assorted manual tweaks) can be found here and notes on my mods can be found here (warning: those links will take you to a drug related forum). My (House) music DJ dedication page is here

Offline Shambles

  • SMF Hero
  • ******
  • Posts: 5,629
  • Gender: Male
    • i30 Owners Club
Quote from: aegersz

Thanks for temporarily patching the code for me. It works.


Glad to hear it :)

The "patch" is simply to exclude board outputs that have unset board_id's, so it's more of a fudge than anything else, though the change I made is still a valid check on all board_ids.

When/if I get time (I'm at work at the moment) I'll try and figure out how this situation could occur.

Offline aegersz

  • SMF Hero
  • ******
  • Posts: 1,747
  • Gender: Male
  • the "mods and tweaks" junkie
    • dopetalk (drugs and users)
Thanks. I did actually look at your changes and saw that you only processed valid board id numbers:

Code: [Select]
diff BoardIndex.template.php BoardIndex.template.php-orig
148,149d147
<                               if(!empty($board['id']))
<                               {
255d252
<                       }

I'm marking this as solved anyway as i fear it will be too hard to followup on and your time is valuable.
The configuration of my Linux VPS (SMF 2.0 with 155+ mods & some assorted manual tweaks) can be found here and notes on my mods can be found here (warning: those links will take you to a drug related forum). My (House) music DJ dedication page is here

Offline Shambles

  • SMF Hero
  • ******
  • Posts: 5,629
  • Gender: Male
    • i30 Owners Club
As before, you're welcome, but this issue is now in my Jira workset so I will look into it at some point mate ;)

Offline aegersz

  • SMF Hero
  • ******
  • Posts: 1,747
  • Gender: Male
  • the "mods and tweaks" junkie
    • dopetalk (drugs and users)
One more thing, these 2 additional errors occur when selecting the "forum" option still:

see attached ...
The configuration of my Linux VPS (SMF 2.0 with 155+ mods & some assorted manual tweaks) can be found here and notes on my mods can be found here (warning: those links will take you to a drug related forum). My (House) music DJ dedication page is here

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 60,373
  • Gender: Male
    • Kindred-999 on GitHub
that's mod code...
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Offline aegersz

  • SMF Hero
  • ******
  • Posts: 1,747
  • Gender: Male
  • the "mods and tweaks" junkie
    • dopetalk (drugs and users)
Thanks Kindred ... it is actually:

 * @package Avatars on Board_MessageIndex
 * @version 1.9
 * @Author: Pipke(AdemaStudios)
 * @copyright Copyright (C) 2016, Pipke

I think i will upgrade that mod in my live system also as the errors go away in the latest mod version.
« Last Edit: March 12, 2020, 10:12:42 AM by aegersz »
The configuration of my Linux VPS (SMF 2.0 with 155+ mods & some assorted manual tweaks) can be found here and notes on my mods can be found here (warning: those links will take you to a drug related forum). My (House) music DJ dedication page is here

Offline aegersz

  • SMF Hero
  • ******
  • Posts: 1,747
  • Gender: Male
  • the "mods and tweaks" junkie
    • dopetalk (drugs and users)
The fix for the above can be found here.
The configuration of my Linux VPS (SMF 2.0 with 155+ mods & some assorted manual tweaks) can be found here and notes on my mods can be found here (warning: those links will take you to a drug related forum). My (House) music DJ dedication page is here