Announcement

Collapse
No announcement yet.

Database error, need help please . . .

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

  • Database error, need help please . . .

    Hi Folks,

    I had to move my web file from one computer to a new computer. This was the first time I had to do that and I ended up causing all kinds of problems for myself. I ended up deleting my Forum directory (not backed up of course). I had the hosting company restore it.

    However, when I go to view a thread or hit post to finish posting a new thread I get the generic database error. It actually does manage to post a new thread, but then I can't get into it.

    Here is the source code from the error:


    <!-- Database error in vBulletin: Invalid SQL:
    SELECT
    session.userid AS sessionuserid,
    post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
    attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
    ,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
    FROM
    post
    LEFT JOIN icon ON icon.iconid=post.iconid
    LEFT JOIN user ON user.userid=post.userid
    LEFT JOIN userfield ON userfield.userid=user.userid
    LEFT JOIN avatar ON avatar.avatarid=user.avatarid
    LEFT JOIN customavatar ON customavatar.userid=user.userid
    LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
    LEFT JOIN session ON (session.userid = user.userid
    AND session.userid > 0

    AND session.lastactivity>989178695)
    WHERE
    post.postid IN (0,15)
    ORDER BY dateline

    mysql error: Unknown column 'customavatar.dateline' in 'field list'
    mysql error number: 1054
    Date: Sunday 06th of May 2001 02:06:35 PM
    Script: /forum/showthread.php?s=&threadid=10
    Referer: http://cavyrescue.com/forum/forumdis...?s=&forumid=26
    -->
    </td></tr></table>
    <p>There seems to have been a slight problem with the database.
    Please try again by pressing the refresh button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:[email protected]">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p>

    -----------------

    I'm hoping this is a simple fix. I'm very much a neophyte on this and don't have permissions to run jobs at my hosted site. I would have to call them and have them do it.

    I upgraded from Candidate 1 to Candidate 2 against the hope that something in the upgrade script would magically fix it, but no go. Still have the error, but I did do a successful upgrade.

    Thanks,


  • #2
    Have you completely run upgrade4.php in the past?

    Comment


    • #3
      There was one time when I wasn't sure about the sequence of what happened. It was a while ago. As I recall it seemed like the upgrade script did two together. It was around that time. But, everything seemed to be working. So I thought I had been upgrading successfully.

      So, I guess it's possible I may have goofed somewhere.

      Comment


      • #4
        You'll want to run the following MySQL query on your databiase via telnet or phpMyAdmin:

        ALTER TABLE customavatar ADD dateline int(10) unsigned DEFAULT '0' NOT NULL;

        Comment


        • #5
          Halfway home!!

          Now I can view all the threads that are there, but when I try to post a new thread I get this:


          <!-- Database error in vBulletin: Invalid SQL: REPLACE INTO searchindex (wordid,postid,intitle) VALUES (7,16,1),(2,16,1),(6,16,0)
          mysql error: Unknown column 'intitle' in 'field list'
          mysql error number: 1054
          Date: Sunday 06th of May 2001 03:55:26 PM
          Script: /forum/newthread.php
          Referer: http://www.cavyrescue.com/forum/newt...ead&forumid=14
          -->
          </td></tr></table>
          <p>There seems to have been a slight problem with the database.
          Please try again by pressing the refresh button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:[email protected]">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p>

          Related problem???

          Comment


          • #6
            Well, first -- would you change your technical email address setting in your config.php?

            Ok, now I'm 95% sure you didn't run upgrade4.php fully, but alas, since you have parts of it now, you won't really be able to run it easily...

            Do you have an option "Allow Ignore Moderators" in your "user and registration" section of your control panel options?

            Comment


            • #7
              Well, first -- would you change your technical email address setting in your config.php?
              Oh.... That is where the email for database problems go to you instead of me? (sheepish, sorry about that) I'm not sure how I change it.

              Ok, now I'm 95% sure you didn't run upgrade4.php fully, but alas, since you have parts of it now, you won't really be able to run it easily...
              Bummer.

              Do you have an option "Allow Ignore Moderators" in your "user and registration" section of your control panel options?
              No.

              Comment


              • #8
                Never mind about how to update config.php. Dumb question. I'll take care of it.

                Comment


                • #9
                  You were sending your error messages to John Although I don't think he checks that account (or forwards it to /dev/null).

                  Ok, you didn't run upgrade4.php. Drop the field I told you to add and run it:

                  ALTER TABLE customavatar DROP dateline;

                  Comment


                  • #10
                    What exactly do you mean by "drop the field I told you to add?" If you could give me the command to do that, it would save me countless learning curve hours!! Or, do I just run the command you listed (alter table)?

                    Don't forget I'm a neophyte!

                    Do I run upgrage4?

                    oh yeah, I did hear from John!

                    Comment


                    • #11
                      Run this command to drop the field:
                      ALTER TABLE customavatar DROP dateline;

                      Comment


                      • #12
                        Not sure if I successfully deleted it or not, but it's gone and I still have a problem.

                        <!-- Database error in vBulletin: Invalid SQL:
                        SELECT
                        session.userid AS sessionuserid,
                        post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
                        attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
                        ,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
                        FROM
                        post
                        LEFT JOIN icon ON icon.iconid=post.iconid
                        LEFT JOIN user ON user.userid=post.userid
                        LEFT JOIN userfield ON userfield.userid=user.userid
                        LEFT JOIN avatar ON avatar.avatarid=user.avatarid
                        LEFT JOIN customavatar ON customavatar.userid=user.userid
                        LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
                        LEFT JOIN session ON (session.userid = user.userid
                        AND session.userid > 0

                        AND session.lastactivity>989353136)
                        WHERE
                        post.postid IN (0,9,10,11)
                        ORDER BY dateline

                        mysql error: Unknown column 'customavatar.dateline' in 'field list'
                        mysql error number: 1054
                        Date: Tuesday 08th of May 2001 02:33:57 PM
                        Script: /forum/showthread.php?s=&threadid=6
                        Referer: http://cavyrescue.com/forum/forumdis...p?s=&forumid=3
                        -->
                        </td></tr></table>
                        <p>There seems to have been a slight problem with the database.
                        Please try again by pressing the refresh button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:[email protected]">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p>


                        Is there a next step?

                        Comment


                        • #13
                          Well, I'm staring at upgrade4.php, and it adds that field, so I'm guessing you still didn't run upgrade4....

                          Comment


                          • #14
                            Oh. Sorry. I wasn't sure specifically if I was supposed to do that or not. I'm erring on the side of caution so I don't make it worse.

                            I'll go run it now.

                            Thanks,

                            Comment


                            • #15
                              Okay, it died somewhere in what looked like the middle of step 7.

                              Trying to back into the forum gives me this:

                              <!-- Database error in vBulletin: Invalid SQL:
                              SELECT
                              session.userid AS sessionuserid,
                              post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
                              attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
                              ,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
                              FROM
                              post
                              LEFT JOIN icon ON icon.iconid=post.iconid
                              LEFT JOIN user ON user.userid=post.userid
                              LEFT JOIN userfield ON userfield.userid=user.userid
                              LEFT JOIN avatar ON avatar.avatarid=user.avatarid
                              LEFT JOIN customavatar ON customavatar.userid=user.userid
                              LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
                              LEFT JOIN session ON (session.userid = user.userid
                              AND session.userid > 0

                              AND session.lastactivity>989353136)
                              WHERE
                              post.postid IN (0,9,10,11)
                              ORDER BY dateline

                              mysql error: Unknown column 'customavatar.dateline' in 'field list'
                              mysql error number: 1054
                              Date: Tuesday 08th of May 2001 02:33:57 PM
                              Script: /forum/showthread.php?s=&threadid=6
                              Referer: http://cavyrescue.com/forum/forumdis...p?s=&forumid=3
                              -->
                              </td></tr></table>
                              <p>There seems to have been a slight problem with the database.
                              Please try again by pressing the refresh button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:[email protected]">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p>

                              ----

                              Is it really bad now?

                              Comment

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