Announcement

Collapse
No announcement yet.

"usertextfield doesnt exist"

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

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

    Leave a comment:


  • Steve Machol
    replied
    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.

    Leave a comment:


  • seangworld
    replied
    actually, i just realized i can try and reinstall it with the installer and selecting the tables....im going to see if that works.

    Leave a comment:


  • seangworld
    replied
    someone can dl a sql query, cut/paste the instructions here in a quote so i can create it.

    Leave a comment:


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

    Leave a comment:


  • seangworld
    replied
    well, i dropped all tables from my flashchat (errors in phpmyadmin) and all tables from the photoplog.

    same error exists - usertextfield doesnt exist.

    Leave a comment:


  • boogie box high
    replied
    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 :
    -->

    Leave a comment:


  • seangworld
    replied
    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????

    Leave a comment:


  • seangworld
    started a topic "usertextfield doesnt exist"

    "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?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X