SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    Sep 2009
    Posts
    19
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    geniegate MYSQL problem

    hello.

    im installing geniegate program to my server and im geting error

    #1071 - Specified key was too long; max key length is 1000 bytes

    i tried installing it the normal way, setup.php but i quess its outdated or my system settings are wrong or something

    i try to make this table and it shows up that error

    PHP Code:
                CREATE TABLE cfg_vwpath (
                    
    vid    MEDIUMINT(9NOT NULL AUTO_INCREMENT,
                    
    ap    varchar(127),
                    
    vn    varchar(255),
                    
    classname    varchar(255),
                    
    classfile    varchar(255),
                    
    KEY(vid,ap,vn)
                ) 
    #1071 - Specified key was too long; max key length is 1000 bytes

  2. #2
    SitePoint Member
    Join Date
    Sep 2009
    Posts
    19
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ok i i got it working, changed vn varchar (255) to (200)

  3. #3
    SitePoint Member
    Join Date
    Jun 2010
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I've had this problem too, and have asked the developers of geniegate how to fix this. I got the following answer:

    The problem is with mysql, not so much GenieGate, some installations
    of mysql have a limitation on index length. (really makes it difficult
    to design stuff to run when every host out there is different)

    This would probably do it (through a mysql control panel
    of some sort):

    Code:
    CREATE TABLE cfg_vwpath (
           vid    MEDIUMINT(9) NOT NULL AUTO_INCREMENT,
           ap    varchar(127),
           vn    varchar(255),
           classname varchar(127),
           classfile varchar(127),
           KEY(vid,ap,vn)
    )
    I know this is an old thread, but they asked me if I could post this here since there was many people asking the same thing.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •