Announcement

Collapse
No announcement yet.

old post at top of every thread.

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • old post at top of every thread.

    Had a tough DB error. I have recoved from that using:

    mysqlcheck -p --all-databases -r #repair

    It worked when nothing else would.

    However, all is not back to normal. Now every new thread has a weird old post at the top.
    see:
    http://netcookingtalk.com/forums/showthread.php?t=19564

    Any ideas how I can get rid of this? I tried repairing the post & thread table but that did not fix things.

    When running the table repair I get this message:
    thread Check Warning: Found row where the auto_increment column has the value 0
    http://www.netcookingtalk.com/forums/


  • #2
    That weird 1st post (which has no number) does have a check box. I checked the check box and tried to delete it, as admin. Here is the message that came up:
    you do not have permission to access this page. This could be due to one of several reasons:
    1. Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
    2. If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
    http://www.netcookingtalk.com/forums/

    Comment


    • #3
      Tried removing orphan posts. No joy.
      http://www.netcookingtalk.com/forums/

      Comment


      • #4
        If you go into phpmyadmin, and look at the post table, sort by postid, is there a postid of 0?

        Comment


        • #5
          Originally posted by Zachery View Post
          If you go into phpmyadmin, and look at the post table, sort by postid, is there a postid of 0?
          I just installled phpmyadmin on my server. It does not come up via command line. It it accessed via http? Any hints on how I get into phpmyadmin. TIA!
          http://www.netcookingtalk.com/forums/

          Comment


          • #6
            phpmyadmin is a third party script that lets you admin your database from a GUI.

            You have a post in your table with a postid of 0, which is where that guest post is coming from. You could just delete it byc licking on edit, and deleting the post.

            Comment


            • #7
              I tried to delete it via VB and it says I do not have permissions even though I'm admin.
              Trying to get phpMyAdmin running, maybe I can do it from there.
              http://www.netcookingtalk.com/forums/

              Comment


              • #8
                You access phpMyAdmin through the browser. I would strongly suggest putting .htaccess protection on it.

                Please don't PM or VM me for support - I only help out in the threads.
                vBulletin Manual & vBulletin 4.0 Code Documentation (API)
                Want help modifying your vbulletin forum? Head on over to vbulletin.org
                If I post CSS and you don't know where it goes, throw it into the additional.css template.

                W3Schools <- awesome site for html/css help

                Comment


                • #9
                  I'm not having any luck with phpmyadmin .... is there any other way to get rid of this problem (post at the top of every new thread).
                  I can't delete it, it says I do not have permissions. Any idea on how I can modify permissions for that post? This is so annoying and my members are getting restless.
                  Thanks in advance.
                  Last edited by Orp; Sat 27th Aug '11, 8:53pm.
                  http://www.netcookingtalk.com/forums/

                  Comment


                  • #10
                    Assuming you have a backup of your database if something goes wrong you can delete it via mysql query:

                    First do a test to see how many post have id of zero:

                    Code:
                    SELECT * FROM post WHERE postid = 0
                    If you only have 1 or maybe two posts with id zero and yo're ok deleting them then run:

                    Code:
                    DELETE FROM post WHERE postid = 0
                    But if you have a lot of posts with id of zero may not want to delete them all.

                    Comment


                    • #11
                      Originally posted by BirdOPrey5 View Post
                      Assuming you have a backup of your database if something goes wrong you can delete it via mysql query:

                      First do a test to see how many post have id of zero:

                      Code:
                      SELECT * FROM post WHERE postid = 0
                      If you only have 1 or maybe two posts with id zero and yo're ok deleting them then run:

                      Code:
                      DELETE FROM post WHERE postid = 0
                      But if you have a lot of posts with id of zero may not want to delete them all.

                      Worked like a charm. I only had one post with zero ID. THANKS BirdOPrey5!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
                      http://www.netcookingtalk.com/forums/

                      Comment

                      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                      Working...
                      X