Announcement

Collapse
No announcement yet.

error try to reinstall my test forum 5.5.5?

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

  • error try to reinstall my test forum 5.5.5?

    try to do a clean istall of my test forum PHP7.3 get this datebase error
    can somebody point me o the wright direction how can I fix
    thanks
    ……………………………………………………………………..

    5.5.5
    5.5.5
    vbulletin-style.xml:
    vbulletin-settings.xml:
    5.5.5
    5.5.5
    vbulletin-language.xml:
    vbulletin-adminhelp.xml:

    vBulletin 5.5.5 Install System
    (Please be patient as some parts may take some time)
    Install 5.5.5
    Status: Aborted
    6%



    Install Progress
    Installing
    Step 1 - Connection successful
    Step 2 - Skipping step, not needed
    Creating vbad table
    Creating vbadcriteria table
    Creating vbadminhelp table
    Creating vbadministrator table
    Creating vbadminlog table
    Creating vbadminmessage table
    Creating vbadminutil table
    Creating vbannouncement table
    Creating vbannouncementread table
    Creating vbattach table
    Creating vbapiclient table
    Creating vbapiclient_devicetoken table
    Creating vbapilog table
    Creating vbattachmentcategory table
    Creating vbattachmentcategoryuser table
    Creating vbattachmentpermission table
    Creating vbattachmenttype table
    Creating vbattachmentviews table
    Creating vbavatar table
    Creating vbautosavetext table
    Creating vbbbcode table
    Creating vbbbcode_video table
    Creating vbcache table
    Creating vbcacheevent table
    Creating vbcalendar table
    Creating vbcalendarcustomfield table
    Creating vbcalendarmoderator table
    Creating vbcalendarpermission table
    Creating vbchannel table
    Creating vbchannelprefixset table
    Creating vbclosure table
    Creating vbcontenttype table
    Creating vbcpsession table
    Creating vbcron table
    Creating vbcronlog table
    Creating vbcustomavatar table
    Creating vbcustomprofile table
    Creating vbdatastore table
    Creating vbdeletionlog table
    Creating vbdiscussion table
    Creating vbeditlog table
    Creating vbevent table
    Creating vbexternalcache table
    Creating vbfaq table
    Creating vbfcmessage table
    Creating vbfcmessage_queue table
    Creating vbfcmessage_offload table
    Creating vbfiledata table
    Creating vbfiledataresize table
    Creating vbforumpermission table
    Creating vbgallery table
    Creating vbprivacyconsent table
    Creating vbhook table
    Creating vbholiday table
    Creating vbhumanverify table
    Creating vbhvanswer table
    Creating vbhvquestion table
    Creating vbicon table
    Creating vbimagecategory table
    Creating vbimagecategorypermission table
    Creating vbinfraction table
    Creating vbinfractionban table
    Creating vbinfractiongroup table
    Creating vbinfractionlevel table
    Creating vbipaddressinfo table
    Creating vbgroupintopic table
    Creating vblanguage table
    Creating vblink table
    Creating vbmailqueue table
    Creating vbmessagefolder table
    Creating vbmoderation table
    Creating vbmoderator table
    Creating vbmoderatorlog table
    Creating vbnode table
    An error has occurred with your database. Please contact vBulletin Support for assistance.
    Module: install, Step 3 Database Error:1709
    Index column size too large. The maximum column size is 767 bytes
    .
    Query:
    CREATE TABLE vbnode (
    nodeid INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    routeid INT UNSIGNED NOT NULL,
    contenttypeid SMALLINT NOT NULL,
    publishdate INTEGER,
    unpublishdate INTEGER,
    userid INT UNSIGNED ,
    groupid INT UNSIGNED,
    authorname VARCHAR(100),
    description VARCHAR(1024),
    title VARCHAR(512),
    htmltitle VARCHAR(512),
    parentid INTEGER NOT NULL,
    urlident VARCHAR(512),
    displayorder SMALLINT,
    starter INT NOT NULL DEFAULT '0',
    created INT,
    lastcontent INT NOT NULL DEFAULT '0',
    lastcontentid INT NOT NULL DEFAULT '0',
    lastcontentauthor VARCHAR(100) NOT NULL DEFAULT '',
    lastauthorid INT UNSIGNED NOT NULL DEFAULT '0',
    lastprefixid VARCHAR(25) NOT NULL DEFAULT '',
    textcount mediumint UNSIGNED NOT NULL DEFAULT '0',
    textunpubcount mediumint UNSIGNED NOT NULL DEFAULT '0',
    totalcount mediumint UNSIGNED NOT NULL DEFAULT '0',
    totalunpubcount mediumint UNSIGNED NOT NULL DEFAULT '0',
    ipaddress VARCHAR(45) NOT NULL DEFAULT '',
    showpublished SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    oldid INT UNSIGNED,
    oldcontenttypeid INT UNSIGNED,
    nextupdate INTEGER,
    lastupdate INTEGER,
    featured SMALLINT NOT NULL DEFAULT 0,
    CRC32 VARCHAR(10) NOT NULL DEFAULT '',
    taglist MEDIUMTEXT,
    inlist SMALLINT UNSIGNED NOT NULL DEFAULT '1',
    protected SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    setfor INTEGER NOT NULL DEFAULT 0,
    votes SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
    hasphoto SMALLINT NOT NULL DEFAULT '0',
    hasvideo SMALLINT NOT NULL DEFAULT '0',
    deleteuserid INT UNSIGNED,
    deletereason VARCHAR(125),
    open SMALLINT NOT NULL DEFAULT '1',
    showopen SMALLINT NOT NULL DEFAULT '1',
    sticky TINYINT(1) NOT NULL DEFAULT '0',
    approved TINYINT(1) NOT NULL DEFAULT '1',
    showapproved TINYINT(1) NOT NULL DEFAULT '1',
    viewperms TINYINT NOT NULL DEFAULT 2,
    commentperms TINYINT NOT NULL DEFAULT 1,
    nodeoptions INT UNSIGNED NOT NULL DEFAULT 138,
    prefixid VARCHAR(25) NOT NULL DEFAULT '',
    iconid SMALLINT NOT NULL DEFAULT '0',
    public_preview SMALLINT NOT NULL DEFAULT '0',
    INDEX node_lastauthorid(lastauthorid),
    INDEX node_lastcontent(lastcontent),
    INDEX node_textcount(textcount),
    INDEX node_ip(ipaddress),
    INDEX node_pubdate(publishdate, nodeid),
    INDEX node_unpubdate(unpublishdate),
    INDEX node_parent_lastcontent(parentid, showpublished, showapproved, lastcontent, lastcontentid),
    INDEX node_parent_inlist_lastcontent(parentid, inlist, lastcontent),
    INDEX node_parent_userid(parentid, userid),
    INDEX node_nextupdate(nextupdate),
    INDEX node_lastupdate(lastupdate),
    INDEX node_user(userid),
    INDEX node_oldinfo(oldcontenttypeid, oldid),
    INDEX node_urlident(urlident),
    INDEX node_sticky(sticky),
    INDEX node_starter(starter),
    INDEX node_approved(approved),
    INDEX node_ppreview(public_preview),
    INDEX node_showapproved(showapproved),
    INDEX node_ctypid_userid_dispo_idx(contenttypeid, userid, displayorder),
    INDEX node_setfor_pubdt_idx(setfor, publishdate),
    INDEX prefixid (prefixid, nodeid),
    INDEX nodeid (nodeid, contenttypeid),
    INDEX contenttypeid_parentid (contenttypeid, parentid),
    INDEX node_featured(featured),
    INDEX node_inlist(inlist),
    INDEX created(created, nodeid),
    INDEX totalcount(totalcount),
    INDEX showpublished(showpublished),
    INDEX routeid(routeid)
    ) ENGINE = InnoDB
    Status: Aborted
    vBulletin v5.5.5, Copyright © 2020 MH Sub I, LLC dba vBulletin. All rights reserved.
    Last edited by voyger; Wed 22 Jan '20, 3:04am.
    voyger.: In Almighty God I trust, everyone else has to provide evidence."

    vBulletin Version 5.5.5

  • #2
    https://dev.mysql.com/doc/refman/5.7...db-limits.html

    You need to set the variable innodb_large_prefix in your MySQL configuration or upgrade to MySQL 5.7+ (I believe MariaDB 10.3 is equivalent).
    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

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