  |
|
| View previous topic - View next topic |
| Author |
Message |
cowgod
Wandering Minstrel
Joined: 22 Nov 2005
Posts: 114
Location: Pittsburgh, USA
|
 Posted: Wed Mar 04, 2009 6:17 pm Post subject: Unread Topics |
[quote] |
|
For the past week or so, I've gotten an error message every time I click on the unread posts link. I didn't have time to post about it before, but I think it's time that I did.
It's strange that no one else has already posted about it.
Here is the message:
General Error
Could not obtain search results
DEBUG MODE
SQL Error : 1054 Unknown column 't.topic_id' in 'on clause'
SELECT t.*, f.forum_id, f.forum_name, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time , IFNULL(r.read_time, 0) AS read_time FROM phpbb_topics t, phpbb_forums f, phpbb_users u, phpbb_posts p, phpbb_posts p2, phpbb_users u2 LEFT JOIN phpbb_reads r ON t.topic_id = r.read_topic_id AND r.read_user_id = 646 WHERE t.topic_id IN (2012, 2095, 2103, 2107, 2111, 2115, 2123, 2124, 2125, 2126, 2127, 2128, 2129, 2130, 2131) AND t.topic_poster = u.user_id AND f.forum_id = t.forum_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND u2.user_id = p2.poster_id ORDER BY p2.post_time DESC LIMIT 0, 25
Line : 796
File : search.php
|
|
| Back to top |
|
 |
Ninkazu
Demon Hunter
Joined: 08 Aug 2002
Posts: 945
Location: Location:
|
| Posted: Wed Mar 04, 2009 7:01 pm Post subject: |
[quote] |
|
Dupe.
(i.e. it's been noted)
|
|
| Back to top |
|
|
Bjorn
Demon Hunter
Joined: 29 May 2002
Posts: 1425
Location: Germany
|
| Posted: Sun Mar 08, 2009 5:21 pm Post subject: |
[quote] |
|
Yep, it's broken somehow (related to MySQL upgrade I think), but I don't have time to fix it. The code is out there if you want to have a look yourself:
http://gitorious.org/projects/rpgdx
Last thing I did was disabling a similar custom query in viewforum.php to at least allow browsing the forums again.
|
|
| Back to top |
|
|
Hajo
Demon Hunter
Joined: 30 Sep 2003
Posts: 779
Location: Between chair and keyboard.
|
| Posted: Mon Mar 23, 2009 9:28 am Post subject: |
[quote] |
|
Can we just upgrade the whole forum to a new software?
I wouldn't mind if the looks change a bit, because of a no-longer working template or so ... the accumulating number of unread threads make it hard to find new messages :/
|
|
| Back to top |
|
|
DeveloperX
202192397
Joined: 04 May 2003
Posts: 1626
Location: Decatur, IL, USA
|
|
| Back to top |
|
|
DeveloperX
202192397
Joined: 04 May 2003
Posts: 1626
Location: Decatur, IL, USA
|
|
| Back to top |
|
|
Hajo
Demon Hunter
Joined: 30 Sep 2003
Posts: 779
Location: Between chair and keyboard.
|
| Posted: Fri Mar 27, 2009 10:02 am Post subject: |
[quote] |
|
|
Thanks a lot :)
|
|
| Back to top |
|
|
DeveloperX
202192397
Joined: 04 May 2003
Posts: 1626
Location: Decatur, IL, USA
|
| Posted: Fri Mar 27, 2009 12:16 pm Post subject: |
[quote] |
|
| Hajo wrote: | | Thanks a lot :) |
Like I've always said; I'm here to help out in any way that I can.
I fully support this community, even though I am trying to grow my own indie game development community; my forums are oriented more towards educating people. I love RPGDX. I will do whatever I can to make it a better place. :)
_________________
Principal Software Architect
Rambling Indie Games, LLC
See my professional portfolio
|
|
| Back to top |
|
|
RedSlash
Mage
Joined: 12 May 2005
Posts: 331
|
| Posted: Sun Mar 29, 2009 8:08 am Post subject: |
[quote] |
|
|
What was the issue?
|
|
| Back to top |
|
|
DeveloperX
202192397
Joined: 04 May 2003
Posts: 1626
Location: Decatur, IL, USA
|
|
| Back to top |
|
|
| |
Page 1 of 1 |
All times are GMT
|
|
