Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 1200
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: 1200
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 IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm
No new posts FTP Skip or ignore error and process ... AJAYREDDY All Other Mainframe Topics 3 Wed Sep 27, 2017 8:12 pm
No new posts Assembler Macro Copybook converted to... Ziquilix PL/I & Assembler 4 Tue Sep 26, 2017 3:07 am
No new posts FUSE - IBM MQ - CICS integration error Kevin Vaz CICS 1 Mon Sep 18, 2017 4:31 pm
No new posts Reply MQ open error Vignesh Sid COBOL Programming 6 Thu Sep 07, 2017 6:02 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us