"no such post exist" when try to edit or delete po

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
Organic Angel Alexiel
Registered User
Posts: 262
Joined: Tue Oct 24, 2006 10:30 pm
Location: Sunny Cal, USA
Contact:

Post by Organic Angel Alexiel » Sun Jan 14, 2007 8:34 pm


rename .php to .php.txt
But yeah, it definitely looks like the post ID is not linked correctly, or the sql query is broken.
Need help with apache? Visit the Apache Lounge
I would heartily recommend reading through the Knowledge Base. I recently have and it has solved a number of questions I had.
EasyMod is great for a vanilla phpBB. Visit my website and see why I do everything by hand. :P

MapleShilc
Registered User
Posts: 82
Joined: Tue Jul 26, 2005 4:57 am

Post by MapleShilc » Sun Jan 14, 2007 10:40 pm


MapleShilc
Registered User
Posts: 82
Joined: Tue Jul 26, 2005 4:57 am

Post by MapleShilc » Mon Jan 15, 2007 5:06 am

bumping according to the rules

MapleShilc
Registered User
Posts: 82
Joined: Tue Jul 26, 2005 4:57 am

Post by MapleShilc » Mon Jan 15, 2007 4:18 pm

bump

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51863
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Post by Brf » Mon Jan 15, 2007 4:59 pm

Hmmm.... Yours looks like this:

Code: Select all

if ( ($result = $db->sql_query($sql)) && ($post_info = $db->sql_fetchrow($result)) )
{
	$db->sql_freeresult($result);
and mine looks like this:

Code: Select all

if ( $result = $db->sql_query($sql) )
{
	$post_info = $db->sql_fetchrow($result);
	$db->sql_freeresult($result);
I wonder if the optimizer is having trouble with yours?

MapleShilc
Registered User
Posts: 82
Joined: Tue Jul 26, 2005 4:57 am

Post by MapleShilc » Tue Jan 16, 2007 12:42 am

Brf wrote: Hmmm.... Yours looks like this:

Code: Select all

if ( ($result = $db->sql_query($sql)) && ($post_info = $db->sql_fetchrow($result)) )
{
	$db->sql_freeresult($result);
and mine looks like this:

Code: Select all

if ( $result = $db->sql_query($sql) )
{
	$post_info = $db->sql_fetchrow($result);
	$db->sql_freeresult($result);
I wonder if the optimizer is having trouble with yours?


I tried with your format, it still didnt work, i tried posting a new post and delete it , still says can not find the post

and what is the optimizer you are talking about?

thanks again

MapleShilc
Registered User
Posts: 82
Joined: Tue Jul 26, 2005 4:57 am

Post by MapleShilc » Tue Jan 16, 2007 4:04 pm

bump

MapleShilc
Registered User
Posts: 82
Joined: Tue Jul 26, 2005 4:57 am

Post by MapleShilc » Wed Jan 17, 2007 1:32 am

bump

MapleShilc
Registered User
Posts: 82
Joined: Tue Jul 26, 2005 4:57 am

Post by MapleShilc » Wed Jan 17, 2007 4:19 pm

bump

MapleShilc
Registered User
Posts: 82
Joined: Tue Jul 26, 2005 4:57 am

Post by MapleShilc » Thu Jan 18, 2007 7:51 am

bump ... anyone >.<?

MapleShilc
Registered User
Posts: 82
Joined: Tue Jul 26, 2005 4:57 am

Post by MapleShilc » Thu Jan 18, 2007 4:19 pm

bump

User avatar
BrotherTank
Registered User
Posts: 73
Joined: Sun Jan 11, 2004 1:39 pm
Location: Hamilton, Ontario, Canada
Name: Greg
Contact:

Post by BrotherTank » Thu Jan 18, 2007 4:53 pm

MapleShilc wrote: bump


You bumped without actually checking your forums. I posted 2 messages asking on your forums via the test area, and asked for some information. My first post lists as post #63 to me, and I wondered what # it showed you when you enter the moderator CP to delete the post??

BrotherTank

PS> I may not reply for a few hours as I have to see my chiropractor and physio-therapist in an hour or so. Got hit by a car almost a year ago and I am limited to the amount of time I can sit at the computer or do just about anything else for that matter.. I will find an answer to the problem.. as I like a challenge.

User avatar
BrotherTank
Registered User
Posts: 73
Joined: Sun Jan 11, 2004 1:39 pm
Location: Hamilton, Ontario, Canada
Name: Greg
Contact:

Post by BrotherTank » Thu Jan 18, 2007 5:53 pm

I think it's a problem with your Cash mod..

Comment out the following lines by placing a // in front of the code:

Lines: 227, 228, 236, and 237.

And then test out the delete... or quote.... If they work, then it is the logic of the 228 line that is throwing off the code and breaking the ability to do any of those functions.

BrotherTank

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51863
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Post by Brf » Thu Jan 18, 2007 6:03 pm

All those lines are doing, is making sure the prior post info is retrieved... It might help to see just what the SQL query is, by showing it in the DIE statement....

In this statement:

Code: Select all

}
else
{
	message_die(GENERAL_MESSAGE, $lang['No_such_post']);
}

replace the message_die like this:

Code: Select all

message_die(GENERAL_ERROR, $lang['No_such_post''], "", __LINE__, __FILE__, $sql);

MapleShilc
Registered User
Posts: 82
Joined: Tue Jul 26, 2005 4:57 am

Post by MapleShilc » Fri Jan 19, 2007 3:48 am

BrotherTank wrote:
MapleShilc wrote:bump


You bumped without actually checking your forums. I posted 2 messages asking on your forums via the test area, and asked for some information. My first post lists as post #63 to me, and I wondered what # it showed you when you enter the moderator CP to delete the post??

BrotherTank

PS> I may not reply for a few hours as I have to see my chiropractor and physio-therapist in an hour or so. Got hit by a car almost a year ago and I am limited to the amount of time I can sit at the computer or do just about anything else for that matter.. I will find an answer to the problem.. as I like a challenge.


yes... its #63...



BrotherTank wrote: I think it's a problem with your Cash mod..

Comment out the following lines by placing a // in front of the code:

Lines: 227, 228, 236, and 237.

And then test out the delete... or quote.... If they work, then it is the logic of the 228 line that is throwing off the code and breaking the ability to do any of those functions.

BrotherTank


tried, same result, doesnt work at all =/
Brf wrote: PostPosted: Thu Jan 18, 2007 10:03 am Post subject:
All those lines are doing, is making sure the prior post info is retrieved... It might help to see just what the SQL query is, by showing it in the DIE statement....

In this statement:

Code:
}
else
{
message_die(GENERAL_MESSAGE, $lang['No_such_post']);
}



replace the message_die like this:

Code:
message_die(GENERAL_ERROR, $lang['No_such_post''], "", __LINE__, __FILE__, $sql);


should'nt it be 'No_such_post' instead of ''

i tried, gave me this

Code: Select all

There is no such post. Please return and try again.

DEBUG MODE

SQL Error : 1054 Unknown column 't.topic_announce_duration' in 'field list'

SELECT f.*, t.topic_id, t.topic_status, t.topic_type, t.topic_first_post_id, t.topic_last_post_id, t.topic_vote, p.post_id, p.poster_id, t.topic_title,t.topic_announce_duration, p.enable_bbcode, p.enable_html, p.enable_smilies, p.enable_sig, p.post_username, pt.post_subject, pt.post_text, pt.bbcode_uid, u.username, u.user_id, u.user_sig, u.user_sig_bbcode_uid FROM phpbb_posts p, phpbb_topics t, phpbb_forums f, phpbb_posts_text pt, phpbb_users u WHERE p.post_id = 71 AND t.topic_id = p.topic_id AND f.forum_id = p.forum_id AND pt.post_id = p.post_id AND u.user_id = p.poster_id

Line : 366
File : posting.php 
  

Locked

Return to “2.0.x Support Forum”