Announcement

Collapse
No announcement yet.

erreur vb5 fresh install

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

  • erreur vb5 fresh install

    bonjour,

    j'essaye d'installer vb 5.2.5 sur mon nouveau serveur sous vpssim
    • PHP Version 7.0.15
    • MySQL Version 5.5.5-10.0.28-MariaDB



    et je bute sur cette erreur à 3% de l'installation

    que faire ? merci


    Code:
    • An error has occurred with your database. Please contact vBulletin Support for assistance. Module: install, Step 2 Database Error:1709 Index column size too large. The maximum column size is 767 bytes. Query: CREATE TABLE node ( 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 CHAR(15) 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(parentid), 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) ) ENGINE = InnoDB
    Last edited by benn82; Thu 9th Feb '17, 11:58pm.

  • #2
    Cette erreur ne me dit rien à première vue, je me renseigne et reviens vers vous

    vBulletin QA - vBulletin Support French - Lead Project Tools developer

    Next release? Soon(tm)

    Comment


    • #3
      A moins d'avoir un serveur dédié, vous devez demander à votre hébergeur de modifier la valeur de la variable SQL inno_large_prefix qui semble être trop faible.

      vBulletin QA - vBulletin Support French - Lead Project Tools developer

      Next release? Soon(tm)

      Comment


      • #4
        merci pour votre reponse rapide

        oui c'est un dedié , sauriez vous ou modifier cette valeur ?
        j'ai plusieurs script installer sur ce serveur et seul vb cause souci

        Comment


        • #5
          Les réponses dans ce lien pourrait vous aider

          http://stackoverflow.com/questions/3...e-is-767-bytes

          vBulletin QA - vBulletin Support French - Lead Project Tools developer

          Next release? Soon(tm)

          Comment

          Related Topics

          Collapse

          Working...
          X