Advertisement:

Author Topic: Post I cannot delete  (Read 785 times)

Offline njtweb

  • Full Member
  • ***
  • Posts: 572
Post I cannot delete
« on: June 13, 2018, 02:02:15 PM »
I have a custom bbcode in this post. I deleted the post that the bbcode references by the URL within the bbcode tags, (a completely separate post). No I can't open this or delete it. Is there any way to edit this post or delete it in ACP?

I get this message when I click on it.
Call to undefined function mysql_num_rows()

This is the post
Code: [Select]
https://www.youthhockeyinfo.com/index.php/board,70.0.html

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 57,085
  • Gender: Male
    • Kindred-999 on GitHub
Re: Post I cannot delete
« Reply #1 on: June 13, 2018, 02:11:07 PM »
fix the code that is not allowing the post to be deleted...
that can't be the ONLY error. There would be a filename and line number in the error as well...



(no, there is no other interface to delete posts)
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline njtweb

  • Full Member
  • ***
  • Posts: 572
Re: Post I cannot delete
« Reply #2 on: June 13, 2018, 02:25:34 PM »
fix the code that is not allowing the post to be deleted...
that can't be the ONLY error. There would be a filename and line number in the error as well...



(no, there is no other interface to delete posts)

That's the only post in about 450. The post it references is a poll post. The URL for the poll was inside the tags in the post I cannot open. Every other team post has the same custom BBcode tags in them and they open fine.

Thank you

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 57,085
  • Gender: Male
    • Kindred-999 on GitHub
Re: Post I cannot delete
« Reply #3 on: June 13, 2018, 03:55:57 PM »
we can't help without the actual, full error message

otherwise, the only thing we can say is "fix your code" since you (or a mod) obviously broke something
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline Chen Zhen

  • Sophist Member
  • *****
  • Posts: 1,141
  • Gender: Male
  • If you're going through hell, keep going!
    • Underdog-01 on GitHub
    • WebDev.ca
Re: Post I cannot delete
« Reply #4 on: June 13, 2018, 05:13:04 PM »
Kindred is asking you to go to your Admin section & look at the actual error message in the log & post the results in a quote here in this thread.
Admin -> Logs -> Error Log

When you go to your SMF error log, left click on the magnifying glass icon that states "Apply Filter: Only show the errors with the same message".
( when on one of the errors that show undefined function mysql_num_rows() )
Then copy & paste the error message(s) inside a quote bbcode tag in this thread.

BTW - unrelated to your error but ensure to update your personalized bbc mod from my website. I can tell from the page XHTML that you are using an older version.
« Last Edit: June 13, 2018, 05:27:25 PM by Chen Zhen »

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 17,374
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • aleksi-kilpinen on LinkedIn
Re: Post I cannot delete
« Reply #5 on: June 13, 2018, 11:54:20 PM »
Also the complete error when clicked could be useful, the error in the OP seems like it is only a part of an error.
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.

How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline shawnb61

  • Support Specialist
  • Sr. Member
  • *
  • Posts: 939
    • sbulen on GitHub
Re: Post I cannot delete
« Reply #6 on: June 14, 2018, 12:19:55 AM »
You can try:
   Admin | Maintenance | Forum Maintenance | Routine | Find and Repair Any Errors

I think the links to all boards & topics on that site are very interesting...  They all point to .html files, e.g.:
Code: [Select]
https://www.youthhockeyinfo.com/index.php/topic,48.0.htmlWhere I'm used to seeing something more like:
Code: [Select]
https://www.youthhockeyinfo.com/index.php?topic=48.0
Is that a portal mod or URL mod that does that?   


Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Offline landyvlad

  • Full Member
  • ***
  • Posts: 614
  • Gender: Male
    • Michael Reed on Facebook
    • GSX1400 Owners ORG
Re: Post I cannot delete
« Reply #7 on: June 14, 2018, 01:02:07 AM »
Queryless URLs - Turns the use of queries in the forum's URLs on and off (../index.php/topic,1.0.html compared to ../index.php?topic=1.0). In the Admin Center, this setting is referred to as Search engine friendly URLs.

Search engine friendly URLs - When enabled, queryless URLs are used for forum pages. This means they look like ../index.php/topic,1.0.html instead of ../index.php?topic=1.0. This option was introduced in order to help search engines index forum pages, but there is no longer any reason to use it, as search engines are now capable of indexing both formats. The queryless URL format only works for Apache and Lighttpd.

Please do not PM, IM or Email me with questions on astrophysics or theology.  You will get better and faster responses by asking homeless people in the street. Thank you.

To paraphrase Kindred: "There are no technical solutions to social problems."

Offline shawnb61

  • Support Specialist
  • Sr. Member
  • *
  • Posts: 939
    • sbulen on GitHub
Re: Post I cannot delete
« Reply #8 on: June 14, 2018, 01:10:08 AM »
Thanks for that explanation - very helpful.  I had never experimented with that option. 
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 57,085
  • Gender: Male
    • Kindred-999 on GitHub
Re: Post I cannot delete
« Reply #9 on: June 14, 2018, 04:20:09 AM »
Btw, that setting is basically useless and is left over from 15 years ago, when search engines had trouble with ? In the url...

It really does nothing useful these days
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Online GigaWatt

  • The Smiley Guy
  • Support Specialist
  • Sophist Member
  • *
  • Posts: 1,333
  • Gender: Male
    • Macedonian electronics forum
Re: Post I cannot delete
« Reply #10 on: June 14, 2018, 09:55:37 AM »
@njtweb: Try to view the post from the profile of the user (admin). Open the profile and click on Show Posts, see if the same error pops up.
"This is really a generic concept about human thinking - when faced with large tasks we're naturally inclined to try to break them down into a bunch of smaller tasks that together make up the whole."

"A 500 error loosely translates to the webserver saying, "WTF?"..."

Offline shawnb61

  • Support Specialist
  • Sr. Member
  • *
  • Posts: 939
    • sbulen on GitHub
Re: Post I cannot delete
« Reply #11 on: June 14, 2018, 02:53:21 PM »
You can try:
   Admin | Maintenance | Forum Maintenance | Routine | Find and Repair Any Errors

Have you tried Find and Repair Any Errors yet?
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Offline njtweb

  • Full Member
  • ***
  • Posts: 572
Re: Post I cannot delete
« Reply #12 on: June 14, 2018, 04:14:26 PM »
Ok.

So....

@Aleksi "Lex" Kilpinen Here is the post
Code: [Select]
https://www.youthhockeyinfo.com/index.php/topic,48.0.html
I can't click anything, it's just that message. I didn't do anything different than any other team information post except delete the poll referenced in the bbcode I have embedded in that posts subject.

@Chen Zhen - I don't see anything in the error log that says this Apply Filter: Only show the errors with the same message


Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 20,459
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Post I cannot delete
« Reply #13 on: June 14, 2018, 05:43:22 PM »
If you need help I can take a look requires ftp access. And I can see what is going on.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Chen Zhen

  • Sophist Member
  • *****
  • Posts: 1,141
  • Gender: Male
  • If you're going through hell, keep going!
    • Underdog-01 on GitHub
    • WebDev.ca
Re: Post I cannot delete
« Reply #14 on: June 14, 2018, 10:23:24 PM »
Look at the attached image to this post.
Do you see the magnifying glass that I circled?
The text I was referring to pops up when you hover over the magnifying glass and you can click on it.
This allows you to filter messages in your error log.

Either way all you have to do is copy & paste the entire error text from the related error (one that shows Call to undefined function mysql_num_rows() ).
If we can see the name of the file that is throwing the error then we can likely pinpoint which modification is causing the error.
Or you can do a screenshot/crop like the image I attached if you want (but show the entire error message).. whichever you prefer.

Offline shawnb61

  • Support Specialist
  • Sr. Member
  • *
  • Posts: 939
    • sbulen on GitHub
Re: Post I cannot delete
« Reply #15 on: June 14, 2018, 10:31:27 PM »
You can try:
   Admin | Maintenance | Forum Maintenance | Routine | Find and Repair Any Errors

Have you tried Find and Repair Any Errors yet?

There really is an existing function that fixes stray/orphaned topics & posts. 

Third time's a charm!    ;D
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Offline njtweb

  • Full Member
  • ***
  • Posts: 572
Re: Post I cannot delete
« Reply #16 on: June 15, 2018, 09:01:30 AM »
Thank you everybody for your help and interest in helping. Turns out the problem was the custom bbcode. If the post referenced in the URL that is embedded is deleted it will cause the issue. She's fixed the problem. All good now.