by (120 points)
I am having issued with installing seotoaster in my database and keep receiving this error: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes. please help i am new to this!

1 Answer

by (1.0k points)
Please, provide us your versions of MySQL, PHP, Web Server and phpinfo configuration.

Thank you.
by (120 points)
PHP Version 5.4.20-pl0-gentoo
mysqlnd 5.0.10 - 20111026
server: Apache2

by (2.6k points)
Dear User,

Thank you for sending us the requested information. Actually we need your system SQL parameters. Please execute the query 'SHOW VARIABLES' and provide us with the obtained result. Also we can suggest you to set the 'innodb_large_prefix' as OFF and launch the installation process once again.

Kind regards,
Seotoaster Support
by (120 points)
edited by
Bare with me, but Im new to mysql and databases, how would I change the 'innodb_large_prefix'?
Im not 100% sure if this is what you're looking for but here:

Variable    Session value / Global value
auto increment increment    1
auto increment offset    1
automatic sp privileges    ON
back log    50
basedir    /usr/
binlog cache size    32,768
bulk insert buffer size    8,388,608
character set client    utf8
character set connection    utf8
character set database    utf8
character set filesystem    binary
character set results    utf8
character set server    utf8
character set system    utf8
character sets dir    /usr/share/mysql/charsets/
collation connection    utf8_general_ci
collation database    utf8_general_ci
collation server    utf8_general_ci
completion type    0
concurrent insert    1
connect timeout    10
datadir    /var/lib/mysql/
date format    %Y-%m-%d
datetime format    %Y-%m-%d %H:%i:%s
default week format    0
delay key write    ON
delayed insert limit    100
delayed insert timeout    300
delayed queue size    1,000
div precision increment    4
keep files on create    OFF
engine condition pushdown    OFF
expire logs days    0
flush    OFF
flush time    0
ft boolean syntax    + -><()~*:""&|
ft max word len    84
ft min word len    4
ft query expansion limit    20
ft stopword file    (built-in)
group concat max len    1,024
have archive    NO
have bdb    NO
have blackhole engine    NO
have compress    YES
have community features    YES
have profiling    NO
have crypt    YES
have csv    NO
have dynamic loading    YES
have example engine    NO
have federated engine    NO
have geometry    YES
have innodb    DISABLED
have isam    NO
have merge engine    YES
have ndbcluster    NO
have openssl    DISABLED
have ssl    DISABLED
have query cache    YES
have raid    NO
have rtree keys    YES
have symlink    YES
hostname    atl4mysqlv113
init connect   
init file   
init slave   
innodb additional mem pool size    1,048,576
innodb autoextend increment    8
innodb buffer pool awe mem mb    0
innodb buffer pool size    8,388,608
innodb checksums    ON
innodb commit concurrency    0
innodb concurrency tickets    500
innodb data file path   
innodb data home dir   
innodb adaptive hash index    ON
innodb doublewrite    ON
innodb fast shutdown    1
innodb file io threads    4
innodb file per table    OFF
innodb flush log at trx commit    1
innodb show locks held    10
innodb show verbose locks    0
innodb flush method   
innodb force recovery    0
innodb lock wait timeout    50
innodb locks unsafe for binlog    OFF
innodb log arch dir   
innodb log archive    OFF
innodb log buffer size    1,048,576
innodb log file size    5,242,880
innodb log files in group    2
innodb log group home dir   
innodb max dirty pages pct    90
innodb max purge lag    0
innodb mirrored log groups    1
innodb open files    300
innodb rollback on timeout    OFF
innodb support xa    ON
innodb sync spin loops    20
innodb table locks    ON
innodb thread concurrency    8
innodb thread sleep delay    10,000
innodb io capacity    200
innodb ibuf max size    9223372036854775807
innodb ibuf active contract    0
innodb ibuf accel rate    100
innodb flush neighbor pages    1
innodb read ahead    both
innodb enable unsafe group commit    0
innodb adaptive checkpoint    none
innodb read io threads    8
innodb write io threads    8
innodb use sys malloc    ON
innodb fast recovery    OFF
innodb thread concurrency timer based    OFF
innodb extra rsegments    0
innodb dict size limit    0
innodb io pattern trace    0
innodb io pattern trace running    0
innodb io pattern size limit    0
innodb use legacy cardinality algorithm    ON
interactive timeout    60
join buffer size    131,072
key buffer size    402,653,184
key cache age threshold    300
key cache block size    1,024
key cache division limit    100
language    /usr/share/mysql/english/
large files support    ON
large page size    0
large pages    OFF
lc time names    en_US
license    GPL
local infile    ON
locked in memory    OFF
log    OFF
log bin    OFF
log bin trust function creators    OFF
log error    /var/log/mysql/mysqld.err
log queries not using indexes    OFF
log slave updates    OFF
log slow queries    OFF
log slow filter   
log slow rate limit    1
log slow verbosity    microtime
log warnings    1
long query time    10
low priority updates    OFF
lower case file system    OFF
lower case table names    0
max allowed packet    16,777,216
max binlog cache size    18446744073709547520
max binlog size    1,073,741,824
max connect errors    999,999,999
max connections    4,096
max delayed threads    20
max error count    64
max heap table size    16,777,216
max insert delayed threads    20
max join size    18446744073709551615
max length for sort data    1,024
max prepared stmt count    16,382
max relay log size    0
max seeks for key    18446744073709551615
max sort length    1,024
max sp recursion depth    0
max tmp tables    32
max user connections    30
max write lock count    18446744073709551615
min examined row limit    0
multi range count    256
myisam data pointer size    6
myisam max sort file size    9223372036853727232
myisam mmap size    18446744073709551615
myisam recover options    OFF
myisam repair threads    1
myisam sort buffer size    67,108,864
myisam stats method    nulls_unequal
net buffer length    16,384
net read timeout    30
net retry count    10
net write timeout    60
new    OFF
old passwords    OFF
open files limit    20,480
optimizer prune level    1
optimizer search depth    62
pid file    /var/run/mysqld/
plugin dir   
port    3,306
preload buffer size    32,768
protocol version    10
query alloc block size    8,192
query cache limit    1,048,576
query cache min res unit    4,096
query cache size    33,554,432
query cache type    ON
query cache wlock invalidate    OFF
query prealloc size    8,192
range alloc block size    4,096
read buffer size    2,097,152
read only    OFF
read rnd buffer size    8,388,608
relay log   
relay log index   
relay log info file
relay log purge    ON
relay log space limit    0
rpl recovery rank    0
secure auth    OFF
secure file priv   
server id    1
skip external locking    ON
skip networking    OFF
skip show database    ON
slave compressed protocol    OFF
slave load tmpdir    /tmp/
slave net timeout    3,600
slave skip errors    OFF
slave transaction retries    10
slow launch time    2
slow query log    OFF
slow query log file   
socket    /var/run/mysqld/mysqld.sock
sort buffer size    2,097,152
sql big selects    ON
sql mode   
sql notes    ON
sql warnings    OFF
ssl ca   
ssl capath   
ssl cert   
ssl cipher   
ssl key   
storage engine    MyISAM
sync binlog    0
sync frm    ON
system time zone    EST
table cache    512
table lock wait timeout    50
table type    MyISAM
thread cache size    8
thread stack    262,144
time format    %H:%i:%s
time zone    SYSTEM
timed mutexes    OFF
tmp table size    33,554,432
tmpdir    /tmp/
transaction alloc block size    8,192
transaction prealloc size    4,096
tx isolation    REPEATABLE-READ
updatable views with limit    YES
userstat running    OFF
use global long query time    OFF
version    5.0.91
version comment    Gentoo Linux mysql-5.0.91
version compile machine    x86_64
version compile os    pc-linux-gnu
wait timeout    60
by (2.6k points)
Dear User,

Thank you for your reply.

Our programmers can check if the configuration of your database meets the requirements of SeoToaster. Please send us the SSH (username, password, host, port) so we can get the access. You can e-mail the information to

Kind regards,
Seotoaster Support
by (2.6k points)
Dear User,

Unfortunately, we can not connect to server mysql, atl4mysqlv113 with the information you have sent. Please provide us with the correct host name.

Kind regards,
Seotoaster Support
by (14.9k points)
From sec231 :

I also believe my host is: localhost
Is there any further info i need to provide?

This could also be a problem as to why im having trouble:
try one of these:
Server Alias: mysqlv113
server/host address:
I appreciate your patience
Thank you
by (480 points)
Sorry, we can not get access for user:
ERROR 1045 (28000): Access denied for user 'djmgmt'@'' (using password: YES)
by (100 points)
i'v similiar error like this, would you like help me, please ?
by (2.6k points)
Hello Bluestuck,

Our programmers can check if the configuration of your database meets the requirements of SeoToaster. Please send us the SSH (username, password, host, port) so we can get the access. You can e-mail the information to

Thank you for using the SeoToaster!

Kind Regards,
SeoToaster Support