Announcement

Collapse
No announcement yet.

SQL Error...

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

  • Wayne Luke
    replied
    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.

    Leave a comment:


  • andrew67
    replied
    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

    Leave a comment:


  • Wayne Luke
    replied
    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.

    Leave a comment:


  • andrew67
    started a topic SQL Error...

    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
Loading...
Working...
X