IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

[Solved]SQL error while logging!


IBM Mainframe Forums -> Suggestions & Feedback
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
rakesha.hg

Active User


Joined: 21 Mar 2008
Posts: 161
Location: bangalore

PostPosted: Tue Apr 01, 2008 8:41 am
Reply with quote

hi all,

i got the following error while logging in to the forum.

have a look.....

icon_arrow.gif Could not obtain topic information

DEBUG MODE

SQL Error : 1064 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 f.forum_id = t.forum_id' at line 4

SELECT t.*, t.title_compl_infos, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments, f.auth_download, t.topic_attachment, f.auth_ban, f.auth_greencard, f.auth_bluecard FROM phpbb_topics t, phpbb_forums f WHERE t.topic_id = AND f.forum_id = t.forum_id

Line : 154
File : *****************/viewtopic.php icon_question.gif

two times i got this error, but later i could logon.
Back to top
View user's profile Send private message
rakesha.hg

Active User


Joined: 21 Mar 2008
Posts: 161
Location: bangalore

PostPosted: Wed Apr 02, 2008 9:09 am
Reply with quote

hello guys,

please pardon me for writing in the same post....

i got the above error again this morning ....

after two or three times i was able to login icon_rolleyes.gif

is this problem related to my PC ? or what should i do?
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed Apr 02, 2008 7:03 pm
Reply with quote

Hello,

If this happens again and you have not received anything from the forum, please post another reply and i will send a note to the site admins.

Apologies that you are having this problem.
Back to top
View user's profile Send private message
rakesha.hg

Active User


Joined: 21 Mar 2008
Posts: 161
Location: bangalore

PostPosted: Thu Apr 03, 2008 10:20 am
Reply with quote

hi dick,

this is the third day in succession .....same problem

please do something!
Back to top
View user's profile Send private message
mcmillan

Site Admin


Joined: 18 May 2003
Posts: 1210
Location: India

PostPosted: Thu Apr 03, 2008 1:40 pm
Reply with quote

Quote:
t.topic_id = AND f.forum_id


Its a syntax error happened due to a security method implemented in the forum.

It happened because you visited the "forum" as a Guest and tried to visit a "topic" from a User-only forum (like IBM/CA/Compuware Tools), as a User using an invalid/expired/hacked session ID(from your system cookie) .

Unfortunately we cant assign a topic ID for guests as it affects the security of the forum.

It will not happen, if you visit the forum(not only the topic) as a User or in 'Always On' mode.

Anyway we will try to issue some warning message instead of this syntax error.
Back to top
View user's profile Send private message
rakesha.hg

Active User


Joined: 21 Mar 2008
Posts: 161
Location: bangalore

PostPosted: Thu Apr 03, 2008 2:25 pm
Reply with quote

mcmillan wrote:
Anyway we will try to issue some warning message instead of this syntax error.



i think this will be good,

thanks a lot icon_lol.gif
Back to top
View user's profile Send private message
mcmillan

Site Admin


Joined: 18 May 2003
Posts: 1210
Location: India

PostPosted: Tue Apr 08, 2008 12:51 am
Reply with quote

We have solved this issue and you will not get any Syntax error more.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Apr 08, 2008 1:01 am
Reply with quote

Thanx icon_cool.gif

d
Back to top
View user's profile Send private message
rakesha.hg

Active User


Joined: 21 Mar 2008
Posts: 161
Location: bangalore

PostPosted: Tue Apr 08, 2008 10:41 am
Reply with quote

thanks!
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Suggestions & Feedback

 


Similar Topics
Topic Forum Replies
No new posts Error to read log with rexx CLIST & REXX 11
No new posts Error when install DB2 DB2 2
No new posts CLIST - Virtual storage allocation error CLIST & REXX 5
No new posts Error while running web tool kit REXX... CLIST & REXX 5
No new posts Getting Error while trying to establi... DB2 3
Search our Forums:

Back to Top