Announcement

Collapse
No announcement yet.

Database errors

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

  • Database errors

    Upgraded to Beta 5 this morning. Can someone tell me what this error message means? I went out of the office for a few hours and came home and found three of these in my email box. ??

    thanks

    Adam Boettiger

    Database error in vBulletin: Invalid SQL: INSERT INTO user (userid,username,password,email,styleid,parentemail,coppauser,homepage,icq,aim,yahoo,signa ture,adminemail,showemail,invisible,usertitle,joindate,cookieuser,daysprune,lastvisit,last activity,usergroupid,timezoneoffset,emailnotification,receivepm,emailonpm,showsignatures,b irthday,maxposts,startofweek,ipaddress,pmpopup,referrerid,nosessionhash) VALUES (NULL,'testje','testje','[email protected]','1','','0','http://','','','','','1','0','0','Junior Member','986935462','1','45','986935462','986935462','3','0','0','1','0','1','0','40','1', '24.132.81.219','1','0','1')
    mysql error: Unknown column 'showsignatures' in 'field list'
    mysql error number: 1054
    Date: Tuesday 10th of April 2001 01:44:22 PM
    Script: /boards/register.php
    Referer: http://www.i-advertising.com/boards/register.php

  • #2
    Make sure that you have uploaded the latest register.php file from the ZIP - it looks like you are still using the old one from beta 3/4.

    John
    John Percival

    Artificial intelligence usually beats real stupidity ;)

    Comment


    • #3
      another victum

      Glad to know it's not just me...I'll monitor this thread.
      Datman
      Webmaster: Dailydiva.com - My VB is OnTheHush.com

      Comment


      • #4
        Hi John,

        Thanks for your help. I have verified that I am using the Beta 5 version of register.php and I am still getting the following error message.

        <snip>
        Database error in vBulletin: Invalid SQL: UPDATE user
        SET styleid='1',adminemail='1',
        showemail='1',invisible='0',cookieuser='1',
        maxposts='-1',daysprune='-1',
        timezoneoffset='0',emailnotification='0',
        startofweek='1',showsignatures='0',receivepm='0',
        emailonpm='0',pmpopup='0',usergroupid='6',
        nosessionhash='0'
        WHERE userid='1'
        mysql error: Unknown column 'showsignatures' in 'field list'
        mysql error number: 1054
        Date: Tuesday 10th of April 2001 05:28:07 PM
        Script: /boards/member.php?invisible=no&cookieuser=yes&nosessionhash=no&allowmail=yes&showemail=yes&emailn otification=no&receivepm=no&emailonpm=no&pmpopup=no&showsignatures=no&prunedays=-1&umaxposts=-1&startofweek=1&timezoneoffset=0&newstyleset=1&modifyavatar=Change+Avatar&action=updateopt ions
        Referer: http://www.i-advertising.com/boards/...on=editoptions
        </snip>

        I can tell you what I was doing when it occurred. Most likely you can tell from the message, but I clicked on Profile, then Edit Options and was attempting to change or add an icon to my profile. Any time I click add icon or try to save modifications to the profile I get a database error message.

        Anything else you want me to try? My board is at http://www.i-advertising.com/boards/index.php

        Adam Boettiger

        Comment


        • #5
          You can verify if you are using the correct register.php if it only contains a reference to showsignatures 1 time.

          Comment


          • #6
            Sounds like your forgot to upload some of the files -- I suggest you reupload all the PHP files (except for config.php of course )

            Comment

            Loading...
            Working...
            X