  |
|
| 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
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
