Announcement

Collapse
No announcement yet.

SQL Error...

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

  • SQL Error...

    Hi, Im getting this error whenever someone tries to signup to my forum.. any ideas?

    Database error in vBulletin 2.2.1:

    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,options,birthday ,maxposts,startofweek,ipaddress,pmpopup,referrerid,nosessionhash,country,avatarid) VALUES (NULL,'Big Kahuna3','30de6963050507f563773bbc1e8d5311','[email protected]','1','','0','http://www.thementalasylum.com','2801324','','','','1','1','0','Newbie','1012205157','1','-1','1012205157','1012205157','2','0','1','1','0','15','1975-1-27','-1','1','203.164.116.136','0','1','1','','0')
    mysql error:

    mysql error number:

    Date: Monday 28th of January 2002 07:05:57 PM

  • #2
    Country is not a supported field in vBulletin as it is distributed. Contact the author of the hack you installed for assistance or remove it to receive assistance on this issue here.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API - Full / Mobile
    Vote for your favorite feature requests and the bugs you want to see fixed.

    Comment


    • #3
      Ok I removed the country hack.. Now I get this..

      Database error in vBulletin 2.2.1:

      Invalid SQL: INSERT INTO userfield (userid,field1,field2,field3,field4) VALUES (2380,'MSN','HERE','LOTS','JOB')
      mysql error:

      mysql error number:

      Date: Tuesday 29th of January 2002 08:12:05 PM
      Script: http://www.mysite.net/forum/forum/register.php
      Referer: http://www.mysite.net/forum/register.php

      Comment


      • #4
        I don't see anything wrong with that SQL query.. Two things to check since there are no error messages in your posts..

        1) go into a query editor like phpMyAdmin and check and see if there is a record in userfield with that userid
        Code:
        select * from userfield where userid=2380
        If there is see if there is a corresponding record in user
        Code:
        select user,username from user where userid=2380
        If not delete the record from userfield
        Code:
        delete from userfield where userid=2380
        2) When you downloaded vBulletin, there was a folder called Extras. Find the file called repair.php. Close your forums, and upload this to your forum directory. Run repair.php and follow the instructions on the screen. When done delete repair.php and reopen your forums.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API - Full / Mobile
        Vote for your favorite feature requests and the bugs you want to see fixed.

        Comment

        Loading...
        Working...
        X