cant get into a thread

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
User avatar
truehead
Registered User
Posts: 16
Joined: Thu Jul 05, 2001 8:28 pm

cant get into a thread

Post by truehead » Wed Jan 30, 2002 10:34 pm

when i or my users try to view a thread when they are not logged in the following error apears:

Code: Select all

Couldn't obtain topic watch information

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near '' at line 4

SELECT notify_status FROM phpbb_topics_watch WHERE topic_id = 1744 AND user_id = 

Line : 230
File : /usr/home/mount1/single/www/hiphop-forum.com/forum/viewtopic.php

User avatar
truehead
Registered User
Posts: 16
Joined: Thu Jul 05, 2001 8:28 pm

Post by truehead » Thu Jan 31, 2002 6:11 pm

any ideas?

i have an upgraded 1.4 version

phpbb-fan
Registered User
Posts: 275
Joined: Fri Oct 12, 2001 5:03 am

Post by phpbb-fan » Sat Mar 02, 2002 1:11 am

Well, I have the same problem, I search for other threads about this, but nobody has the answer :(


What could be wrong? I re-uploaded viewtopic.php, but that didn't help me...

Any ideas?


Oh, I am using phpBB2 RC2

phpbb-fan
Registered User
Posts: 275
Joined: Fri Oct 12, 2001 5:03 am

Post by phpbb-fan » Sat Mar 02, 2002 1:52 am

Does it have anything to do with the table phpbb_topics_watch?? Do I have to change any of this:
topic_id - set to 0
user_id - set to 0
notify_status - set to 0


Or maybe it is because the forum doesn't see my online status (and doesn't know I am there??) as a guest and doesn't allow me to see the topic, see another thread I posted:
http://phpbb.sourceforge.net/phpBB2/vie ... php?t=8016

User avatar
truehead
Registered User
Posts: 16
Joined: Thu Jul 05, 2001 8:28 pm

Post by truehead » Sat Mar 02, 2002 2:58 am

i solved the problem by searching the mysql scheme. I saw that the update didnt add a line, so i run the query myself. it was something with the user.

phpbb-fan
Registered User
Posts: 275
Joined: Fri Oct 12, 2001 5:03 am

Post by phpbb-fan » Sat Mar 02, 2002 3:12 am

What do you mean with mysql scheme? And how do I do it?

gameofhit
Registered User
Posts: 986
Joined: Sun Oct 07, 2001 10:29 pm
Location: Michigan Tech
Contact:

Post by gameofhit » Sat Mar 02, 2002 3:31 am

Did any of you guys check out the bug tracker? If its not there, and you can describe how to reproduce it, submit it. http://sourceforge.net/tracker/?atid=10 ... up_id=7885

User avatar
psoTFX
Former Team Member
Posts: 7425
Joined: Tue Jul 03, 2001 8:50 pm

Post by psoTFX » Sat Mar 02, 2002 1:16 pm

No, please don't, we've been there done that ... problem should be fixed in CVS.

Locked

Return to “2.0.x Support Forum”