• Welcome to Simple Machines Community Forum. Please login or sign up.
December 04, 2021, 04:17:36 AM

News:

SMF 2.1 RC4 has been released! Try it out and help us test! :) Read more.


Topics list support

Started by T@by, November 08, 2008, 05:34:22 AM

Previous topic - Next topic

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:
QuoteUnknown column 'b.board_order' in 'order clause'
File: /home/www/abraamz/mwrakia.gr/www/smf/Sources/Subs.php
Line: 4662

Σημείωση: Η βάση δεδομένων σας πιθανόν να χρειάζεται αναβάθμιση. Τα αρχεία του φόρουμ είναι έκδοσης 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:
Quote"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!

Horme Gaming

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

Quote from: abraamz on April 17, 2015, 02:29:59 PM
I need some support with this mod please.
I have upgraded to 2.0.9 from 2.0.3
I have errors like these:
QuoteUnknown column 'b.board_order' in 'order clause'
File: /home/www/abraamz/mwrakia.gr/www/smf/Sources/Subs.php
Line: 4662

Σημείωση: Η βάση δεδομένων σας πιθανόν να χρειάζεται αναβάθμιση. Τα αρχεία του φόρουμ είναι έκδοσης 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:
Quote"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

$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

$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 ?

SMF 2.1 RC4 (default theme) / TP 2.1.0

Alpay

@skb

Quote from: Alpay on September 02, 2016, 05:22:51 AM
Quote from: abraamz on April 17, 2015, 02:29:59 PM
I need some support with this mod please.
I have upgraded to 2.0.9 from 2.0.3
I have errors like these:
QuoteUnknown column 'b.board_order' in 'order clause'
File: /home/www/abraamz/mwrakia.gr/www/smf/Sources/Subs.php
Line: 4662

Σημείωση: Η βάση δεδομένων σας πιθανόν να χρειάζεται αναβάθμιση. Τα αρχεία του φόρουμ είναι έκδοσης 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:
Quote"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

$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

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

SMF 2.1 RC4 (default theme) / TP 2.1.0

skb

September 06, 2016, 02:28:02 AM #210 Last Edit: September 06, 2016, 03:16:04 AM by 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
QuoteYou 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.

SMF 2.1 RC4 (default theme) / TP 2.1.0

skb

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

SMF 2.1 RC4 (default theme) / TP 2.1.0

Cola-Coca

This mod is not compatible with SMF 2.0.12  :'( :'(
I LOVE SMF

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

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


I LOVE SMF

Cola-Coca

I LOVE SMF

Cola-Coca

Quote from: Cola-Coca on March 15, 2018, 03:57:44 PM
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

$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.   :'( :'( :'(
I LOVE SMF

Advertisement: