Announcement

Collapse
No announcement yet.

Problems Problems Problems

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

  • Problems Problems Problems

    Hello
    I'm having a problem When I tried to edit my profile I got

    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.

    On the email I got this message


    Database error in vBulletin: Invalid SQL: UPDATE user
    SET styleid='1',adminemail='1',
    showemail='0',invisible='0',cookieuser='1',
    maxposts='-1',daysprune='1',
    timezoneoffset='-5',emailnotification='0',
    startofweek='1',options='0',receivepm='1',
    emailonpm='1',pmpopup='0',usergroupid='6',
    nosessionhash='0'
    WHERE userid='3'
    mysql error: Unknown column 'options' in 'field list'
    mysql error number: 1054
    Date: Tuesday 10th of April 2001 09:51:29 PM
    Script:
    /vb/member.php?allowmail=yes&invisible=no&showemail=no&cookieuser=yes&nosessionhash=no&receive pm=yes&emailonpm=yes&pmpopup=no&prunedays=1&umaxposts=-1&startofweek=1&timezoneoffset=-5&emailnotification=no&showsignatures=no&modifyavatar=%CA%DA%CF%ED%E1+%C7%E1%D5%E6%D1%C9&n ewstyleset=1&action=updateoptions
    Referer:


    + That I can't register When I tried to register I got a white page

  • #2
    Which beta version are you running?

    Comment


    • #3
      BETA 4

      Comment


      • #4
        Did you run the upgrade4.php script?

        Comment


        • #5
          Yes

          Comment


          • #6
            Did you have problems when running upgrade4.php or did you run upgrade1.php?

            Comment


            • #7
              Sorry I used upgrade1.php.
              upgrade4.php didn't work with me.

              Comment


              • #8

                Comment


                • #9
                  Did you upgrade from beta 3 or from 1.1.x?

                  Comment


                  • #10
                    from 1.1.6

                    Comment


                    • #11
                      I'm still receving this error message when I try to update my profile and when anyone try to register


                      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.

                      On the email I got this message


                      Database error in vBulletin: Invalid SQL: UPDATE user
                      SET styleid='1',adminemail='1',
                      showemail='0',invisible='0',cookieuser='1',
                      maxposts='-1',daysprune='1',
                      timezoneoffset='-5',emailnotification='0',
                      startofweek='1',options='0',receivepm='1',
                      emailonpm='1',pmpopup='0',usergroupid='6',
                      nosessionhash='0'
                      WHERE userid='3'
                      mysql error: Unknown column 'options' in 'field list'
                      mysql error number: 1054
                      Date: Tuesday 10th of April 2001 09:51:29 PM
                      Script:
                      /vb/member.php?allowmail=yes&invisible=no&showemail=no&cookieuser=yes&nosessionhash=no&receive pm=yes&emailonpm=yes&pmpopup=no&prunedays=1&umaxposts=-1&startofweek=1&timezoneoffset=-5&emailnotification=no&showsignatures=no&modifyavatar=%CA%DA%CF%ED%E1+%C7%E1%D5%E6%D1%C9&n ewstyleset=1&action=updateoptions
                      Referer:


                      I upgrade from 1.1.6 --- > to Beta 4
                      No problems while I was upgrading.

                      Waitting ........

                      Comment


                      • #12
                        Run this query in phpMyAdmin

                        ALTER TABLE user CHANGE showsignatures options SMALLINT (6) DEFAULT '1' not null

                        Comment


                        • #13
                          I'm getting this new message when I tried to add avatar pic,

                          <!-- Database error in vBulletin: Invalid SQL: INSERT INTO customavatar (userid,avatardata,dateline,filename) VALUES (1,'GIF89a\0\0‘\0\0QH_õÓ\0ÿÿÿ\0\0\0!ù\0\0\0,\0\0\0\0\0\0\0.”
                          ™Ç’áb Zyê½\0I<¡‰!hnVª~-§+sù)eöv”|jd¾C\0;','988114527','vba4527')
                          mysql error: Unknown column 'filename' in 'field list'
                          mysql error number: 1054
                          Date: Tuesday 24th of April 2001 08:15:27 AM
                          Script: /vb/member.php
                          Referer: http://mysite/myvb/member.php?action=editavatar
                          -->
                          </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:****@****.com">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p>

                          Comment


                          • #14

                            Comment


                            • #15
                              Run:

                              ALTER TABLE customavatar ADD filename VARCHAR(100);

                              Alternatively, reinstalling completely would fix all these issues.

                              Comment

                              Loading...
                              Working...
                              X