Topics list support

[neo2504]

After installing without problems on 2.0.4, I made the topic correctly, it shows the list of the letters but doesn't show the topic in the list.
Can someone help me ?

[abraamz]

I need some support with this mod please.
I have upgraded to 2.0.9 from 2.0.3
I have errors like these:

Unknown column 'b.board_order' in 'order clause'
File: /home/www/abraamz/mwrakia.gr/www/smf/Sources/Subs.php
Line: 4662

Code Select Expand

Σημείωση: Η βάση δεδομένων σας πιθανόν να χρειάζεται αναβάθμιση. Τα αρχεία του φόρουμ είναι έκδοσης SMF 2.0.9, ενώ η βάση δεδομένων είναι σε έκδοση 2.0.2. Το παραπάνω σφάλμα πιθανότατα θα διορθωθεί αν εκτελέσετε την τελευταία έκδοση του upgrade.php

The Greek text says in other words that your database might need upgrading. Forum files are 2.0.9 version but database is in version 2.0.2 You can probably repair this by running upgrade.php
If I remember corectly this will wipe out all files to the default versions so its not a good option now.

Inside my Subs.php there are 2 functions related to this mod.
The error according to SMF's error log is in the last line of this SQL:

"SELECT
         t.ID_TOPIC, t.ID_FIRST_MSG, m.subject, m.ID_MSG, m.icon
      FROM ({$db_prefix}topics AS t)
         LEFT JOIN {$db_prefix}messages AS m ON (m.ID_MSG = t.ID_FIRST_MSG)
      WHERE t.ID_BOARD = $board AND t.locked = 0 AND t.is_Sticky = 0 AND ( subject REGEXP \"$my_regexp\" )"
      . (empty($modSettings['limitTListQuery']) ? '' : "
       LIMIT ".$modSettings['limitTListQuery'])
       );

and this SQL is part of the code below:
code
EDIT: Due to a problem posting the code is attached in the doc file


Can any kind soul provide an easy fix for this?
If not I will have to uninstall but I thought this to be an interesting mod!

[Deaks]

yasou, firstly this mod isnt really compatible with 2.0.9, their are numerous changes since 2.0 RC2, for the database well that is an issue not related to the mod, you said you pgraded for 2.0.2 to 2.0.9 how did you do this? was it with large upgrade? or individual update patches?

As for error with the mod I cant help as I am not good with sql, sygnomi.

[abraamz]

The database message appears only when I try to reach a post using this mod. I have not seen this message in other parts of the forum. So I thought it might be related to the mod.
I did all the updates with packages, one after the other. In a couple of cases I had to manually edit some files but that wasn't a problem.
I thought that those small updates did not touch the database!?

I like the spelling of your name  Ρούνικ.
Its somewhat weird. You are looking forward to come to Greece for the summer and I am trying to find better paid work in UK!

[Lucarella]

Hello,
with this mod I get this error, not sure why it works with MariaDB




Is there a solution?

Thank you

[Lucarella]

This is the solution for MariaDB


Thanks to T@by

[Alpay]

I need some support with this mod please.
I have upgraded to 2.0.9 from 2.0.3
I have errors like these:

Unknown column 'b.board_order' in 'order clause'
File: /home/www/abraamz/mwrakia.gr/www/smf/Sources/Subs.php
Line: 4662

Code Select Expand

Σημείωση: Η βάση δεδομένων σας πιθανόν να χρειάζεται αναβάθμιση. Τα αρχεία του φόρουμ είναι έκδοσης SMF 2.0.9, ενώ η βάση δεδομένων είναι σε έκδοση 2.0.2. Το παραπάνω σφάλμα πιθανότατα θα διορθωθεί αν εκτελέσετε την τελευταία έκδοση του upgrade.php

The Greek text says in other words that your database might need upgrading. Forum files are 2.0.9 version but database is in version 2.0.2 You can probably repair this by running upgrade.php
If I remember corectly this will wipe out all files to the default versions so its not a good option now.

Inside my Subs.php there are 2 functions related to this mod.
The error according to SMF's error log is in the last line of this SQL:

"SELECT
         t.ID_TOPIC, t.ID_FIRST_MSG, m.subject, m.ID_MSG, m.icon
      FROM ({$db_prefix}topics AS t)
         LEFT JOIN {$db_prefix}messages AS m ON (m.ID_MSG = t.ID_FIRST_MSG)
      WHERE t.ID_BOARD = $board AND t.locked = 0 AND t.is_Sticky = 0 AND ( subject REGEXP \"$my_regexp\" )"
      . (empty($modSettings['limitTListQuery']) ? '' : "
       LIMIT ".$modSettings['limitTListQuery'])
       );

and this SQL is part of the code below:
code
EDIT: Due to a problem posting the code is attached in the doc file


Can any kind soul provide an easy fix for this?
If not I will have to uninstall but I thought this to be an interesting mod!

Solition:

Subs.php

Code (find) Select Expand


$request = $smcFunc['db_query']('boardindex_fetch_boards',
"SELECT
t.ID_TOPIC, t.ID_FIRST_MSG, m.subject, m.ID_MSG, m.icon
FROM ({$db_prefix}topics AS t)
LEFT JOIN {$db_prefix}messages AS m ON (m.ID_MSG = t.ID_FIRST_MSG)
messages AS m = boards AS b m.ID_MSG = b.id_board t.ID_FIRST_MSG = t.id_board
WHERE t.ID_BOARD = $board AND t.locked = 0 AND t.is_Sticky = 0 AND ( subject REGEXP \"$my_regexp\" )"
. (empty($modSettings['limitTListQuery']) ? '' : "
LIMIT ".$modSettings['limitTListQuery'])
);

Code (replace) Select Expand


$request = $smcFunc['db_query']('boardindex_fetch_boards',
"SELECT
t.ID_TOPIC, t.ID_FIRST_MSG, m.subject, m.ID_MSG, m.icon
FROM ({$db_prefix}topics AS t)
LEFT JOIN {$db_prefix}messages AS m ON (m.ID_MSG = t.ID_FIRST_MSG)
LEFT JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board)
messages AS m = boards AS b m.ID_MSG = b.id_board t.ID_FIRST_MSG = t.id_board
WHERE t.ID_BOARD = $board AND t.locked = 0 AND t.is_Sticky = 0 AND ( subject REGEXP \"$my_regexp\" )"
. (empty($modSettings['limitTListQuery']) ? '' : "
LIMIT ".$modSettings['limitTListQuery'])
);

Ty : Yağız...

[skb]

Installed the Mod & tried to create the topic list. I get this error

Unknown column 'b.board_order' in 'order clause'
File: /home/diabesv6/public_html/forum/Sources/Subs.php
Line: 4571

Help ?

[Alpay]

@skb

I need some support with this mod please.
I have upgraded to 2.0.9 from 2.0.3
I have errors like these:

Unknown column 'b.board_order' in 'order clause'
File: /home/www/abraamz/mwrakia.gr/www/smf/Sources/Subs.php
Line: 4662

Code Select Expand

Σημείωση: Η βάση δεδομένων σας πιθανόν να χρειάζεται αναβάθμιση. Τα αρχεία του φόρουμ είναι έκδοσης SMF 2.0.9, ενώ η βάση δεδομένων είναι σε έκδοση 2.0.2. Το παραπάνω σφάλμα πιθανότατα θα διορθωθεί αν εκτελέσετε την τελευταία έκδοση του upgrade.php

The Greek text says in other words that your database might need upgrading. Forum files are 2.0.9 version but database is in version 2.0.2 You can probably repair this by running upgrade.php
If I remember corectly this will wipe out all files to the default versions so its not a good option now.

Inside my Subs.php there are 2 functions related to this mod.
The error according to SMF's error log is in the last line of this SQL:

"SELECT
         t.ID_TOPIC, t.ID_FIRST_MSG, m.subject, m.ID_MSG, m.icon
      FROM ({$db_prefix}topics AS t)
         LEFT JOIN {$db_prefix}messages AS m ON (m.ID_MSG = t.ID_FIRST_MSG)
      WHERE t.ID_BOARD = $board AND t.locked = 0 AND t.is_Sticky = 0 AND ( subject REGEXP \"$my_regexp\" )"
      . (empty($modSettings['limitTListQuery']) ? '' : "
       LIMIT ".$modSettings['limitTListQuery'])
       );

and this SQL is part of the code below:
code
EDIT: Due to a problem posting the code is attached in the doc file


Can any kind soul provide an easy fix for this?
If not I will have to uninstall but I thought this to be an interesting mod!

Solition:

Subs.php

Code (find) Select Expand


$request = $smcFunc['db_query']('boardindex_fetch_boards',
"SELECT
t.ID_TOPIC, t.ID_FIRST_MSG, m.subject, m.ID_MSG, m.icon
FROM ({$db_prefix}topics AS t)
LEFT JOIN {$db_prefix}messages AS m ON (m.ID_MSG = t.ID_FIRST_MSG)
messages AS m = boards AS b m.ID_MSG = b.id_board t.ID_FIRST_MSG = t.id_board
WHERE t.ID_BOARD = $board AND t.locked = 0 AND t.is_Sticky = 0 AND ( subject REGEXP \"$my_regexp\" )"
. (empty($modSettings['limitTListQuery']) ? '' : "
LIMIT ".$modSettings['limitTListQuery'])
);

Code (replace) Select Expand


$request = $smcFunc['db_query']('boardindex_fetch_boards',
"SELECT
t.ID_TOPIC, t.ID_FIRST_MSG, m.subject, m.ID_MSG, m.icon
FROM ({$db_prefix}topics AS t)
LEFT JOIN {$db_prefix}messages AS m ON (m.ID_MSG = t.ID_FIRST_MSG)
LEFT JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board)
messages AS m = boards AS b m.ID_MSG = b.id_board t.ID_FIRST_MSG = t.id_board
WHERE t.ID_BOARD = $board AND t.locked = 0 AND t.is_Sticky = 0 AND ( subject REGEXP \"$my_regexp\" )"
. (empty($modSettings['limitTListQuery']) ? '' : "
LIMIT ".$modSettings['limitTListQuery'])
);

Ty : Yağız...

[skb]

Thanks Alpay,

I unistalled the Mod yesterday. Now if I try to install the Mods the forum stops working. This has something to do with the edits that were required during unistall. I'll hold this project for another day.
Thank you so much.

[skb]

Alpay,

I extracted the subs.php from a week old backup. Uploaded it, reinstalled the package & applied the code edits in your post and now this error comes up when I try to create a Topic Index

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 'messages AS m = boards AS b m.ID_MSG = b.id_board t.ID_FIRST_MSG = t.id_board
' at line 6
File: /forum/Sources/Subs.php
Line: 4573

I'm using    ISO-8859-1 Language set. Maybe changing to utf-8 will solve the issue.

[skb]

I converted to utf-8 but the error still persists.

[Cola-Coca]

This mod is not compatible with SMF 2.0.12 

[Cola-Coca]

Hi,

I have the latest version of SMF installed 2.0.15 and i have the last version of this mod installed.
I use letters in the forum as: đ,ć,č,š

The mod works correctly when I use English letters, but if I put the letters in topic list such as "đ,ć,č,š" I get an error (see img):



Line 5016

Code Select Expand


$request = $smcFunc['db_query']('',
         "SELECT
            t.ID_TOPIC, t.ID_FIRST_MSG, m.subject, m.ID_MSG, m.icon
        FROM ({$db_prefix}topics AS t)
            LEFT JOIN {$db_prefix}messages AS m ON (m.ID_MSG = t.ID_FIRST_MSG)
        WHERE t.ID_BOARD = $board AND t.locked = 0 AND t.is_Sticky = 0 AND ( subject REGEXP \"$my_regexp\" )"
        . (empty($modSettings['limitTListQuery']) ? '' : "
         LIMIT ".$modSettings['limitTListQuery'])
         );



The line 5016 is );
Does anyone help me solve this problem)
Thanks.

[Cola-Coca]

bumP!

[Cola-Coca]

Hi,

I have the latest version of SMF installed 2.0.15 and i have the last version of this mod installed.
I use letters in the forum as: đ,ć,č,š

The mod works correctly when I use English letters, but if I put the letters in topic list such as "đ,ć,č,š" I get an error (see img):



Line 5016

Code Select Expand


$request = $smcFunc['db_query']('',
         "SELECT
            t.ID_TOPIC, t.ID_FIRST_MSG, m.subject, m.ID_MSG, m.icon
        FROM ({$db_prefix}topics AS t)
            LEFT JOIN {$db_prefix}messages AS m ON (m.ID_MSG = t.ID_FIRST_MSG)
        WHERE t.ID_BOARD = $board AND t.locked = 0 AND t.is_Sticky = 0 AND ( subject REGEXP \"$my_regexp\" )"
        . (empty($modSettings['limitTListQuery']) ? '' : "
         LIMIT ".$modSettings['limitTListQuery'])
         );



The line 5016 is );
Does anyone help me solve this problem)
Thanks.

Can somebody help me with this problem please.   

[Cola-Coca]

Is there a mod for version 2.0 that is similar to this ?