Advertisement:

Author Topic: All unread topics -> nothing shown  (Read 19232 times)

Offline wormbox

  • Semi-Newbie
  • *
  • Posts: 22
All unread topics -> nothing shown
« on: November 26, 2006, 06:54:46 PM »
SMF Version: SMF 1.1 RC3
There has been some posts about this issue, but most of them haven't received any replies, or the solutions suggested haven't worked for my forum. However, I apologize if this issue has been solved.

There's a problem on my forum, which is that "all unread topics" either shows nothing or the same as "show unread posts since last visit". (From the upper left "Hey username. You have x new... Show unread posts since last visit" -> "No unread topics found since your last visit. Click here to try all unread topics." -> "No messages...")

This happens even if there would be tons of old unread topics. Or, as said, "all unread topics" shows what "posts since last visit" shows. I hadn't noticed it before, as, for some reason, it worked fine for me (admin of the board). A member was having this problem and informed me. I logged in using another browser and a test account, and this problem indeed occurs.

The "All unread topics" link ends in "index.php?action=unread;all;start=0".

I have no mods (except the security update for RC3) installed, and I have emptied the following tables:
log_mark_read, log_topics, log_boards

After clearing these tables all of the topics on the board are marked as unread, but none of them show up in "all unread topics", allthough as admin I saw four topics in "posts since last visit" and the same in "all unread topics" until loggin out and back in, after which I see nothing in all unread.

I have also tried deleting forum related cookies, but I guess the problem is elsewhere than in corrupted cookies.

Any help on how to fix this?

Offline wormbox

  • Semi-Newbie
  • *
  • Posts: 22
Re: All unread topics -> nothing shown
« Reply #1 on: November 27, 2006, 04:50:24 PM »
Peek-a-boo.

Offline cbmr777

  • Semi-Newbie
  • *
  • Posts: 61
Re: All unread topics -> nothing shown
« Reply #2 on: December 08, 2006, 02:27:57 PM »
I'm having this problem as well...  I have very few mods installed.   :)

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,825
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: All unread topics -> nothing shown
« Reply #3 on: December 27, 2006, 12:46:28 AM »
wormbox or cbmr777,

Where you able to resolve this issue or is it still occuring?

Are you using the latest Version of SMF, 1.1.1?
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline MacDo

  • Jr. Member
  • **
  • Posts: 194
  • Gender: Male
Re: All unread topics -> nothing shown
« Reply #4 on: January 07, 2007, 08:03:34 AM »
I've the same problem, with SMF 1.1.1.
Is there a solution ??

Even if some board icons shows that there is some unread messages, the link "index.php?action=unread;all;start=0" returns nothing. I would like to see the list of all messages unread by the user logged in.

Thank you very much in advance...

3nd3r

  • Guest
Re: All unread topics -> nothing shown
« Reply #5 on: January 08, 2007, 06:08:22 AM »

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,825
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: All unread topics -> nothing shown
« Reply #6 on: January 08, 2007, 11:08:04 AM »
Do any errors appear in the error log?
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

3nd3r

  • Guest
Re: All unread topics -> nothing shown
« Reply #7 on: January 08, 2007, 11:19:54 AM »
Yes... As you can see in my previous link posted here.

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,825
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: All unread topics -> nothing shown
« Reply #8 on: January 08, 2007, 11:28:07 AM »
Try to upload Recent.php again from a fresh install of your SMF version.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

3nd3r

  • Guest
Re: All unread topics -> nothing shown
« Reply #9 on: January 08, 2007, 12:08:07 PM »
Done. Downloaded smf_1-1-1_install.zip, extracted Recent.php, uploaded and overwrote, cleaning browser cache, and...
Same (shame) error. Same logs:

Code: [Select]
8: Undefined index: ID_MSG_LAST_VISIT
Archivo: .../public_html/Sources/Recent.php
Línea: 754
and
Code: [Select]
Error en la Base de Datos: 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
'AND IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, 0)) < t.ID_LAST_MSG' at line 7
Archivo: .../public_html/Sources/Recent.php
Línea: 755

I've got one more error still unsolved (in that link)...
« Last Edit: January 08, 2007, 12:14:37 PM by 3nd3r »

3nd3r

  • Guest
Re: All unread topics -> nothing shown
« Reply #10 on: January 09, 2007, 03:03:42 AM »
¿Do you think that repair_settings.php can help me?

Offline MacDo

  • Jr. Member
  • **
  • Posts: 194
  • Gender: Male
Re: All unread topics -> nothing shown
« Reply #11 on: January 09, 2007, 03:48:10 AM »
I have the same problem, and the same error in the log... SMF 1.1.1, no mod installed, original source files. Many thanks for your help...

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,825
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: All unread topics -> nothing shown
« Reply #12 on: January 09, 2007, 06:54:53 PM »
get the upgrade.php and 2 sql files out of the upgrade package and upload those. Then run upgrade.php

I think since it is a fresh file from the install that your database may not be fully upgraded to 1.1.
So running the upgrade should fix your problem.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

3nd3r

  • Guest
Re: All unread topics -> nothing shown
« Reply #13 on: January 10, 2007, 03:01:15 AM »
Not working. Upgrade ok. Same errors. Same output...  :'(
« Last Edit: January 10, 2007, 03:11:04 AM by 3nd3r »

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,825
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: All unread topics -> nothing shown
« Reply #14 on: January 10, 2007, 06:31:40 PM »
Open up Settings.php

In your database section add this:
Code: [Select]
$db_show_debug = true;
Try that page again. a bigger error message should occur.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

3nd3r

  • Guest
Re: All unread topics -> nothing shown
« Reply #15 on: January 11, 2007, 05:19:08 AM »
Ok. This is the result:

On the top of page:
Code: [Select]
Notice: Undefined index: ID_MSG_LAST_VISIT in ****/public_html/Sources/Recent.php on line 754Error log:
Code: [Select]
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 'AND IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, 0)) < t.ID_LAST_MSG' at line 7
Archivo: ****/public_html/Sources/Recent.php
Línea: 755


SELECT COUNT(*), MIN(t.ID_LAST_MSG)
FROM `pajareon_smf`.smf_topics AS t
LEFT JOIN `pajareon_smf`.smf_log_topics AS lt ON (lt.ID_TOPIC = t.ID_TOPIC AND lt.ID_MEMBER = 1)
LEFT JOIN `pajareon_smf`.smf_log_mark_read AS lmr ON (lmr.ID_BOARD = t.ID_BOARD AND lmr.ID_MEMBER = 1)
WHERE t.ID_BOARD IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13)
AND t.ID_LAST_MSG >
AND IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, 0)) < t.ID_LAST_MSG
« Last Edit: January 13, 2007, 07:10:15 AM by 3nd3r »

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,825
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: All unread topics -> nothing shown
« Reply #16 on: January 11, 2007, 06:25:01 PM »
Ahh well that tells me the error.. Are you using the Default verison of Recent.php? If not can you attach me your modified one?

The problem looks like it can't pick up the one of the variables..

Quote
SELECT COUNT(*), MIN(t.ID_LAST_MSG)
FROM `pajareon_smf`.smf_topics AS t
LEFT JOIN `pajareon_smf`.smf_log_topics AS lt ON (lt.ID_TOPIC = t.ID_TOPIC AND lt.ID_MEMBER = 1)
LEFT JOIN `pajareon_smf`.smf_log_mark_read AS lmr ON (lmr.ID_BOARD = t.ID_BOARD AND lmr.ID_MEMBER = 1)
WHERE t.ID_BOARD IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13)
AND t.ID_LAST_MSG >
AND IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, 0)) < t.ID_LAST_MSG
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

3nd3r

  • Guest
Re: All unread topics -> nothing shown
« Reply #17 on: January 12, 2007, 01:09:27 AM »
I think it's the default one... but here it is

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,825
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: All unread topics -> nothing shown
« Reply #18 on: January 12, 2007, 05:02:04 PM »
Can you try this attached file. It will purposely give the error but there is 2 of same code in that area so I need to identify which one is failing.

Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

3nd3r

  • Guest
Re: All unread topics -> nothing shown
« Reply #19 on: January 12, 2007, 06:35:52 PM »
Same logs in administration log area:
Code: [Select]
Error en la Base de Datos: 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 'AND IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, 0)) < t.ID_LAST_MSG' at line 7
Archivo: ****/public_html/Sources/Recent.php
Línea: 755
and
Code: [Select]
Aplicar filtro: Mostrar solamente los mensajes de error con el mismo mensaje
8: Undefined index: ID_MSG_LAST_VISIT
Archivo: ****/public_html/Sources/Recent.php
Línea: 754

Putting that code in settings.php:
Code: [Select]
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 'AND IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, 0)) < t.ID_LAST_MSG' at line 7
Archivo: ****/public_html/Sources/Recent.php
Línea: 755


SELECT COUNT(*), MIN(t.ID_LAST_MSG)
FROM `pajareon_smf`.smf_topics AS t
LEFT JOIN `pajareon_smf`.smf_log_topics AS lt ON (lt.ID_TOPIC = t.ID_TOPIC AND lt.ID_MEMBER = 1)
LEFT JOIN `pajareon_smf`.smf_log_mark_read AS lmr ON (lmr.ID_BOARD = t.ID_BOARD AND lmr.ID_MEMBER = 1)
WHERE t.ID_BOARD IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13)
AND t.ID_LAST_MSG >
AND IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, 0)) < t.ID_LAST_MSG

Thanks for your assistance... Hope you can fix this!
« Last Edit: January 13, 2007, 07:10:58 AM by 3nd3r »