"usertextfield doesnt exist"

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • seangworld
    Senior Member
    • Jan 2002
    • 245
    • 3.7.x

    "usertextfield doesnt exist"

    i moved from shared hosting to my own server, and my site was working fine after the move. i did nothing to it cuz i was working on another domain since the move.

    now, all of a sudden about 2 days ago, i get a db error, cant login to the acp or anything. i get emails of error messages for every single time someone visits the site. here is a copy of the message:

    Database error in vBulletin 3.7.0 Beta 5:

    Invalid SQL:

    SELECT administrator.*,
    userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
    language.phrasegroup_cphome AS phrasegroup_cphome,
    language.phrasegroup_cpglobal AS phrasegroup_cpglobal,
    language.phrasegroup_prefix AS phrasegroup_prefix,
    language.phrasegroup_global AS phrasegroup_global,
    language.options AS lang_options,
    language.languagecode AS lang_code,
    language.charset AS lang_charset,
    language.locale AS lang_locale,
    language.imagesoverride AS lang_imagesoverride,
    language.dateoverride AS lang_dateoverride,
    language.timeoverride AS lang_timeoverride,
    language.registereddateoverride AS lang_registereddateoverride,
    language.calformat1override AS lang_calformat1override,
    language.calformat2override AS lang_calformat2override,
    language.logdateoverride AS lang_logdateoverride,
    language.decimalsep AS lang_decimalsep,
    language.thousandsep AS lang_thousandsep

    FROM user AS user
    LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
    LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN administrator AS administrator ON (administrator.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))

    WHERE user.userid = 1;

    MySQL Error : Table 'XXXXXXXXXX_forum.usertextfield' doesn't exist
    Error Number : 1146
    Date : Friday, March 14th 2008 @ 02:05:38 PM
    Script : http://www.thehawaiicommunity.com/forum/admincp/index.php
    Referrer :
    IP Address : 66.91.221.77
    Username :
    Classname : vb_database
    MySQL Version :
    i put in bold what i suspect is a missing db entry. so, somehow, i conclude, im missing this table. is it possible i just need to add this table again? if so, can you please reply with the proper sql info so i can do the query?
    sigpic
  • seangworld
    Senior Member
    • Jan 2002
    • 245
    • 3.7.x

    #2
    crap.

    i just saw this: http://www.vbulletin.com/forum/showthread.php?t=150459

    so does this mean i have start all over with my site????
    sigpic

    Comment

    • boogie box high
      Senior Member
      • Jul 2004
      • 200
      • 3.6.x

      #3
      Seems to be photoplog issue...would recommend to ask on www.photoplog.com or www.vbulletin.org if you can't disable this product.
      Maybe I'm wrong but it wouldn't hurt to ask


      <!--
      Database error in vBulletin 3.7.0 Beta 5:

      Invalid SQL:

      SELECT
      post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
      user.*, userfield.*, usertextfield.*,
      icon.title as icontitle, icon.iconpath,
      avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,


      editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
      editlog.reason AS edit_reason, editlog.hashistory,
      postparsed.pagetext_html, postparsed.hasimages,
      sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
      sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
      IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid

      , IF(SUM(photoplog_fileuploads.moderate) &gt; 0 AND 0 = 0,COUNT(photoplog_fileuploads.moderate) - SUM(photoplog_fileuploads.moderate),COUNT(photoplog_fileuploads.moderate)) AS photoplog_filecount
      FROM post AS post
      LEFT JOIN user AS user ON(user.userid = post.userid)
      LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
      LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
      LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
      LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)


      LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
      LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 10 AND postparsed.languageid = 1)
      LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 10 AND sigparsed.languageid = 1)
      LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
      LEFT JOIN photoplog_fileuploads AS photoplog_fileuploads ON(photoplog_fileuploads.userid = user.userid)
      WHERE post.postid IN (0,1283) GROUP BY post.postid
      ORDER BY post.dateline;

      MySQL Error : Table 'spg12_forum.usertextfield' doesn't exist
      Error Number : 1146
      Date : Friday, March 14th 2008 @ 02:35:38 PM
      Script : http://thehawaiicommunity.com/forum/...ead.php?t=1173
      Referrer : http://thehawaiicommunity.com/forum/headlines/
      Username : Unregistered
      Classname : vb_database
      MySQL Version :
      -->

      Comment

      • seangworld
        Senior Member
        • Jan 2002
        • 245
        • 3.7.x

        #4
        well, i dropped all tables from my flashchat (errors in phpmyadmin) and all tables from the photoplog.

        same error exists - usertextfield doesnt exist.
        sigpic

        Comment

        • bonjurkes
          Senior Member
          • Apr 2005
          • 257
          • 3.6.x

          #5
          usertextfield is a vbulletin default table, its not related with any hacks, i am not sure how you can create it

          Comment

          • seangworld
            Senior Member
            • Jan 2002
            • 245
            • 3.7.x

            #6
            someone can dl a sql query, cut/paste the instructions here in a quote so i can create it.
            sigpic

            Comment

            • seangworld
              Senior Member
              • Jan 2002
              • 245
              • 3.7.x

              #7
              actually, i just realized i can try and reinstall it with the installer and selecting the tables....im going to see if that works.
              sigpic

              Comment

              • Steve Machol
                Former Customer Support Manager
                • Jul 2000
                • 154488

                #8
                The problem with this is that this field needs to have the same userids and rows as the user and userfield tables. So simply adding this table is unlikely to solve your problem.

                Nonetheless here's the query to crete that tale:

                CREATE TABLE usertextfield (
                userid INT UNSIGNED NOT NULL DEFAULT '0',
                subfolders MEDIUMTEXT,
                pmfolders MEDIUMTEXT,
                buddylist MEDIUMTEXT,
                ignorelist MEDIUMTEXT,
                signature MEDIUMTEXT,
                searchprefs MEDIUMTEXT,
                rank MEDIUMTEXT,
                PRIMARY KEY (userid)
                );

                Note also that all queries to create vB tables are in the 'install/mysql-schema.php' file.
                Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                Change CKEditor Colors to Match Style (for 4.1.4 and above)

                Steve Machol Photography


                Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                Comment

                • seangworld
                  Senior Member
                  • Jan 2002
                  • 245
                  • 3.7.x

                  #9
                  nope, didnt work. got an error there too.

                  im just going to reinstall. frick.
                  Last edited by seangworld; Fri 14 Mar '08, 5:51pm. Reason: i was referring to my last idea....NOW you tell me...pfft...lol
                  sigpic

                  Comment

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