News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

Very high rate of errors since moving to 2.0.17 (another issue re. "Forum" page)

Started by aegersz, March 05, 2020, 09:35:06 PM

Previous topic - Next topic

aegersz

Quote from: Shambles on March 06, 2020, 03:29:48 PM
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 160+ 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

Shambles

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

aegersz

I see ... no, i have accounted for all categories and boards

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)


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 160+ 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

Shambles

Ok, try the following which should skip the faulty board.

I'll look into this later.


aegersz



Thanks for temporarily patching the code for me, Shambles. It works.
The configuration of my Linux VPS (SMF 2.0 with 160+ 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

Shambles

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.

aegersz

Thanks. I did actually look at your changes and saw that you only processed valid board id numbers:

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 160+ 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

Shambles

As before, you're welcome, but this issue is now in my Jira workset so I will look into it at some point mate ;)

aegersz

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 160+ 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

Kindred

Слaва
Украинi

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

aegersz

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.
The configuration of my Linux VPS (SMF 2.0 with 160+ 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

aegersz

The configuration of my Linux VPS (SMF 2.0 with 160+ 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

Advertisement: