sketch_tbhotmail.com Posted March 21, 2008 Share Posted March 21, 2008 Hey, just wanted to let you know that I'm unable to post comments on photos inthe critique forum. I'm using Firefox. Link to comment Share on other sites More sharing options...
lex_jenkins Posted March 21, 2008 Share Posted March 21, 2008 Same here. I was going to reply to a comment on one of my own photos and got an error message - around 30 minutes ago. Link to comment Share on other sites More sharing options...
joshroot Posted March 21, 2008 Share Posted March 21, 2008 I will see if I can find someone awake to look at the issue. Here is the error: ora8.c:4965:lob_dml_cmd: error in `OCIStmtExecute ()': ORA-01653: unable to extend table PHOTONET.GENERAL_COMMENTS by 4096 in tablespace PHOTONET SQL: insert into general_comments ( comment_id, on_what_id, user_id, on_which_table, content, ip_address, comment_date, approved_p, html_p, one_line ) values ( 6117494, 7076272, 888636, 'ph_photos', empty_clob(), '208.12.89.18', sysdate, 't', 'f', 'Ton,' ) returning content into :1 Link to comment Share on other sites More sharing options...
eye of the lens Posted March 21, 2008 Share Posted March 21, 2008 I'm also having the same problem and I have firefox as well Link to comment Share on other sites More sharing options...
bosshogg Posted March 21, 2008 Share Posted March 21, 2008 Me too. Message I get on my own or others when I comment and hit Confirm is: Error in inserting comment We were unable to insert your comment in the database. Here is the error that was returned: ora8.c:4965:lob_dml_cmd: error in `OCIStmtExecute ()': ORA-01653: unable to extend table PHOTONET.GENERAL_COMMENTS by 4096 in tablespace PHOTONET SQL: insert into general_comments ( comment_id, on_what_id, user_id, on_which_table, content, ip_address, comment_date, approved_p, html_p, one_line ) values ( 6117771, 7069949, 2074174, 'ph_photos', empty_clob(), '71.195.96.27', sysdate, 't', 'f', 'Pnina' ) returning content into :1 Link to comment Share on other sites More sharing options...
lex_jenkins Posted March 21, 2008 Share Posted March 21, 2008 Just a guess but a quick web search seems to indicate that during the past couple of weeks there has been a worldwide informal contest among hackers to exploit SQL injection vulnerabilities throughout the web. Dunno whether this is malicious or intended to reveal vulnerabilities to webmasters. It has brought down some sites and interfered with others. WordPress photo albums appear to have been particularly vulnerable to this exploit. Search "hackturkiye" and "SQL injection vulnerability". Link to comment Share on other sites More sharing options...
pnital Posted March 21, 2008 Share Posted March 21, 2008 I join David Meyer, Impossible to insert comments and critique ,getting the same error as David. what is the solution Josh, if there is any? Thanks for an answer. Link to comment Share on other sites More sharing options...
mike_stemberg Posted March 21, 2008 Share Posted March 21, 2008 Still happening Josh, if you don't already know...here is the Error message for me ..it that helps any...<br> Error in inserting comment<br><br> We were unable to insert your comment in the database.<br> Here is the error that was returned:<br> ora8.c:4965:lob_dml_cmd: error in `OCIStmtExecute ()': ORA-01653: unable to extend table PHOTONET.GENERAL_COMMENTS by 4096 in tablespace PHOTONET<br><br> SQL:<br> insert into general_comments (<br> comment_id, <br> on_what_id, <br> user_id, <br> on_which_table, <br> content, <br> ip_address, <br> comment_date, <br> approved_p,<br> html_p, <br> one_line<br> ) values (<br> 6117915, <br> 6716482, <br> 2160230, <br> 'ph_photos', <br> empty_clob(), <br> '87.194.44.225', <br> sysdate, <br> 't', <br> 'f', <br> NULL ) <br> returning <br> content into :1<br> Link to comment Share on other sites More sharing options...
tony_quinlan1 Posted March 21, 2008 Share Posted March 21, 2008 Same here and its been happening for two days now. Seems to occur during your night time. Link to comment Share on other sites More sharing options...
carsten_ranke Posted March 21, 2008 Share Posted March 21, 2008 Same error. Strange. Link to comment Share on other sites More sharing options...
JRX94 Posted March 21, 2008 Share Posted March 21, 2008 same here on IE 6. Link to comment Share on other sites More sharing options...
carsten_ranke Posted March 21, 2008 Share Posted March 21, 2008 Again, cryptic message: Error in inserting comment We were unable to insert your comment in the database. Here is the error that was returned: ora8.c:4965:lob_dml_cmd: error in `OCIStmtExecute ()': ORA-01653: unable to extend table PHOTONET.GENERAL_COMMENTS by 4096 in tablespace PHOTONET SQL: insert into general_comments ( comment_id, on_what_id, user_id, on_which_table, content, ip_address, comment_date, approved_p, html_p, one_line ) values ( 6118052, 7062412, 835489, 'ph_photos', empty_clob(), '91.20.77.82', sysdate, 't', 'f', NULL ) returning content into :1 Link to comment Share on other sites More sharing options...
pnital Posted March 21, 2008 Share Posted March 21, 2008 with TIME OUT all day long( it is friday and not Thursday )and this one: We were unable to insert your comment in the database. Here is the error that was returned: ora8.c:4965:lob_dml_cmd: error in `OCIStmtExecute ()': ORA-01653: unable to extend table PHOTONET.GENERAL_COMMENTS by 4096 in tablespace PHOTONET SQL: insert into general_comments ( comment_id, on_what_id, user_id, on_which_table, content, ip_address, comment_date, approved_p, html_p, one_line ) values ( 6118193, 7063251, 496030, 'ph_photos', empty_clob(), '89.138.111.149', sysdate, 't', 'f', 'Thanks all of you, ' ) returning content into :1 PN is not functioning! Josh, can we get any answer Please? what are the problem, and what is done to resolve the it? Thanks. Link to comment Share on other sites More sharing options...
gordonjb Posted March 21, 2008 Share Posted March 21, 2008 I too am unable to post any comments. I get the same error message as has been mentioned. This goes for either Firefox or IE. Link to comment Share on other sites More sharing options...
jsc Posted March 21, 2008 Share Posted March 21, 2008 We are having database issues possibly related to abuse. I am investigating. In the meantime, we have addressed the database problem and comments should be open again. Link to comment Share on other sites More sharing options...
Xiao Cai Posted March 21, 2008 Share Posted March 21, 2008 It is not "abuse" and the database space is full. Ask the database administrator to increase the database space. Link to comment Share on other sites More sharing options...
joshroot Posted March 21, 2008 Share Posted March 21, 2008 Xiao, It is stupid to argue with Jin. He is our head programmer and knows more about this site and what is going on with it than you will ever know. Link to comment Share on other sites More sharing options...
Xiao Cai Posted March 21, 2008 Share Posted March 21, 2008 It is just my suggestion: Login in the "Database Manager", Check "Tablespaces", the "SYSTEM" would be 99% full... Link to comment Share on other sites More sharing options...
joshroot Posted March 21, 2008 Share Posted March 21, 2008 Yes, and Jin believes that the full database is being caused by some sort of abuse. It's funny that you think you know more than the guys who run the site. This isn't some php board on a shared discount server. We have people who know what they are doing. That is why they have their jobs. Link to comment Share on other sites More sharing options...
gordonjb Posted March 21, 2008 Share Posted March 21, 2008 Josh. It may be possible that the fact Jin used the words 'possibly' and 'investigating ' led Xiao to believe his own comment might have been helpful to sorting out the problem. Link to comment Share on other sites More sharing options...
jsc Posted March 21, 2008 Share Posted March 21, 2008 Just to clarify, yes, the proximate cause was that the database tablespace was full for the comments table. We try to allocate enough space for foreseeable usage, which is why I suspected "possible" abuse as the underlying factor. We did have a round of comment abuse earlier this week, which I cleared up. Due to the way that the database allocates storage however, not all of that space could be recovered. We've now allocated some more space and instituted close monitoring, which should tide us over until we upgrade all the hardware. Link to comment Share on other sites More sharing options...
joshroot Posted March 21, 2008 Share Posted March 21, 2008 Good point Gordon. My prior knowledge of the comment abuse from earlier this week obviously isn't something that Xiao would have known. In any case, just trust Jin when he says something about the site. And trust me that I'll get the right people working on whatever problem we all run into. Link to comment Share on other sites More sharing options...
gordonjb Posted March 21, 2008 Share Posted March 21, 2008 Josh, good point also. It's your site so it stands to reason you guys know best how to solve the problem. The fact that all is well now, tell me it must be so :) Link to comment Share on other sites More sharing options...
dseltzer Posted March 25, 2008 Share Posted March 25, 2008 Just a note in the correct place to thank you for getting back to me about this problem. If I'd realized the right place to post it, you'd have known about a day earlier, too! I am still learning my way around PN. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now