#2917 SQL ERROR DURING INSTALL

[Passant jacques]

SQL ERROR DURING INSTALL

SQLSTATE[42000]: Syntax error or access violation: 1171 Toutes les parties d'un index PRIMARY KEY doivent �tre NOT NULL; Si vous avez besoin d'un NULL dans l'index, utilisez un index UNIQUE

WAMPSERVER

Version Apache :
2.4.23 - Documentation
Version de PHP :
5.6.25 - Documentation
Server Software :
Apache/2.4.23 (Win64) PHP/5.6.25 - Port défini pour Apache : 80
Extensions Chargées :

    apache2handler
    bcmath
    bz2
    calendar
    com_dotnet
    Core
    ctype
    curl
    date
    dom
    ereg
    exif
    fileinfo
    filter
    ftp
    gd
    gettext
    gmp
    hash
    iconv
    imap
    intl
    json
    ldap
    libxml
    mbstring
    mcrypt
    mhash
    mysql
    mysqli
    mysqlnd
    odbc
    openssl
    pcre
    PDO
    pdo_mysql
    pdo_sqlite
    Phar
    Reflection
    session
    SimpleXML
    soap
    sockets
    SPL
    sqlite3
    standard
    tokenizer
    wddx
    xdebug
    xml
    xmlreader
    xmlrpc
    xmlwriter
    xsl
    Zend OPcache
    zip
    zlib

Version de MySQL :
5.7.14 - Port défini pour MySQL : 3306 - Documentation

Thanks for information about this.
Bye

[Passant jacques]

This bug concern v4.2.4
Sorry

[Gerry Kroll]

This is a known problem with any PhpGedView version prior to 4.3.0 SVN 7148. It was fixed on 20 Dec 2016, in SVN version 7148. The error only happens on a completely new PhpGedView installation that is running Mysql 5.6 or later.

You must download the "SVN" version of PhpGedView, and install that. Note also that there are a few fixes coming for problems that apply to PHP 5.7 and that can affect PHP 5.6 users under some circumstances. These fixes will appear in SVN within 3 or 4 days.

I believe you are just starting out with PhpGedView. If this is true, you should really consider using Webtrees in preference to PhpGedView. Webtrees has a much more active user community, and is well supported by its developers. PhpGedView support is sort of hit-or-miss.