[glotpress-updates] [GlotPress] #337: SQL errors during installation

[GlotPress]

#337: SQL errors during installation
-----------------------+----------------------
  Reporter:  ozh       |      Owner:  yoavf
      Type:  defect    |     Status:  assigned
  Priority:  critical  |  Milestone:
 Component:  General   |    Version:
Resolution:            |   Keywords:
-----------------------+----------------------
Changes (by usermrpapa):

 * cc: klasen@… (added)


Comment:

 not to pile on, but getting similar errors for an upgrade... long time
 glotpress user for our project...  have not updated it since before all
 the new work on glotpress...  slow weekend so decided to try playing
 around with the new glotpress and its exciting changes (including several
 that allows us to remove our custom hacks to the core)... testing on win7,
 wamp, php 5.5.12, mysql 5.6.17...


 first step was the db upgrade but it fails with similar errors:

 {{{
 SQL ERROR!
 >>> Database: spcom_glotpress (localhost)
 >>>>>> CREATE TABLE IF NOT EXISTS `gp_glossary_entries` (
         `id` INT(10) unsigned NOT NULL auto_increment
 ) DEFAULT CHARACTER SET 'utf8';
 >>>>>> Incorrect table definition; there can be only one auto column and
 it must be defined as a key

 SQL ERROR!
 >>> Database: spcom_glotpress (localhost)
 >>>>>> CREATE TABLE IF NOT EXISTS `gp_glossaries` (
         `id` INT(10) unsigned NOT NULL auto_increment
 ) DEFAULT CHARACTER SET 'utf8';
 >>>>>> Incorrect table definition; there can be only one auto column and
 it must be defined as a key
 }}}

 since it appears related, added to this ticket, but can make it its own if
 desired...

--
Ticket URL: <https://glotpress.trac.wordpress.org/ticket/337#comment:11>
GlotPress <https://glotpress.trac.wordpress.org>
Easy comin', easy goin'