. MySQL Error : Unknown column 'u.infractiongroupid' in 'field list'

تقليص
X
 
  • تصفية - فلترة
  • الوقت
  • عرض
إلغاء تحديد الكل
مشاركات جديدة

  • . MySQL Error : Unknown column 'u.infractiongroupid' in 'field list'

    اصلاح الخطا فى قاعده البينات


    كود:
    ALTER TABLE `user`
    ADD COLUMN infractiongroupid SMALLINT UNSIGNED NOT NULL DEFAULT '0' AFTER infractiongroupids;​




    او



    كود:
    DROP TABLE session;
    CREATE TABLE session (
    sessionhash CHAR(32) NOT NULL DEFAULT '',
    userid INT UNSIGNED NOT NULL DEFAULT '0',
    host VARCHAR(45) NOT NULL DEFAULT '',
    idhash CHAR(32) NOT NULL DEFAULT '',
    lastactivity INT UNSIGNED NOT NULL DEFAULT '0',
    ******************************** CHAR(255) NOT NULL DEFAULT '',
    useragent CHAR(255) NOT NULL DEFAULT '',
    styleid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    ********************************id SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    loggedin SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    bad******************************** SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    apiclientid INT UNSIGNED NOT NULL DEFAULT '0',
    apiaccesstoken VARCHAR(32) NOT NULL DEFAULT '',
    wol CHAR(255) NOT NULL DEFAULT '',
    pagekey VARCHAR(255) NOT NULL DEFAULT '',
    emailstamp INT UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (sessionhash),
    KEY last_activity USING BTREE (lastactivity),
    KEY user_activity USING BTREE (userid, lastactivity),
    KEY guest_lookup (idhash, host, userid),
    KEY apiaccesstoken (apiaccesstoken),
    KEY pagekey (pagekey)
    );​
    
    ​

    وشكرا لدعم .vbulletin.com
يعمل...
X