Announcement

Collapse
No announcement yet.

db problem

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

  • db problem

    Hi, since RC2 i've this prob:
    - when an user try to edit his profile
    - when an user try to send a private message
    - when a new user try to register
    they've the following error:

    There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

    We apologise for any inconvenience.
    The real prob, is that I can't receive any e-mail, so can't know the real db problem ...

    HELP ! Thanks
    Last edited by MApI; Sat 26 May '01, 12:06am.

  • #2
    right click and view the source code of the error page and paste the contents in a post here
    :: Always Back Up Forum Database + Attachments BEFORE upgrading !
    :: Nginx SPDY SSL - World Flags Demo [video results]
    :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

    Comment


    • #3
      Here I'm and here it's:
      <!-- Database error in vBulletin: Invalid SQL: SELECT user.avatarid,avatarpath,NOT ISNULL(avatardata) AS hascustom,customavatar.dateline
      FROM user
      LEFT JOIN avatar ON avatar.avatarid=user.avatarid
      LEFT JOIN customavatar ON customavatar.userid=user.userid
      WHERE user.userid='4'
      mysql error: Unknown column 'customavatar.dateline' in 'field list'
      mysql error number: 1054
      Date: Saturday 26th of May 2001 11:03:34 AM
      Script: /member.php?action=getinfo&userid=4
      Referer: http://www.kuibus.f2s.com/forumdisplay.php?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>
      Thaks in adv.

      Comment


      • #4
        have a look into this thread http://vbulletin.com/forum/showthrea...t=customavatar and http://vbulletin.com/forum/showthrea...t=customavatar
        Last edited by George L; Sat 26 May '01, 4:23am.
        :: Always Back Up Forum Database + Attachments BEFORE upgrading !
        :: Nginx SPDY SSL - World Flags Demo [video results]
        :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

        Comment


        • #5
          Ok, might be that I'd forgotten some upradex.php; I din't understand the way to fix problem:[list=a][*]Can I run all upgradex.php ?[*]Do I reinstall vbb ? If so, do I backup & load my db ? (.. and how merge it ? (No telnet))[/list=a]

          Thank you for helping.

          Comment


          • #6
            No do not rerun any upgrade scripts.

            Run this query via phpMyAdmin (instructions in my sig)

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

            Comment


            • #7
              Done and ... everything's working !!!!


              Thanx a lot

              Comment

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