Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

[Solved]SQL error while logging!

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Suggestions & Feedback
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    Post subject: SQL error while logging!
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    Post subject: Reply to: SQL error while logging!
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

Site Director


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

PostPosted: Wed Apr 02, 2008 7:03 pm    Post subject:
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    Post subject: Reply to: SQL error while logging!
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: 1202
Location: India

PostPosted: Thu Apr 03, 2008 1:40 pm    Post subject:
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    Post subject:
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: 1202
Location: India

PostPosted: Tue Apr 08, 2008 12:51 am    Post subject:
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

Site Director


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

PostPosted: Tue Apr 08, 2008 1:01 am    Post subject: Reply to: SQL error while logging!
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    Post subject: Reply to: SQL error while logging!
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    IBMMAINFRAMES.com Support Forums -> Suggestions & Feedback All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am
No new posts Need help with below DB2 error ashek15 DB2 3 Sat Mar 18, 2017 5:56 am
No new posts FINDREP Syntax Error seahawk789 DFSORT/ICETOOL 4 Thu Mar 09, 2017 10:11 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us