#2918 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

[Wolf On Tour]

the bug is in the File: db_schema_2_3.php
Search for:
" s_file ".self::$COL_FILE." NULL,".

and repleaced for
" s_file ".self::$COL_FILE." NOT NULL,".

[Gerry Kroll]

This bug was fixed on 20 Dec 2016, in the SVN 7148 update.

You should be using the "SVN" version of PhpGedView. This version can be downloaded by clicking on the "SVN" link at the top of this page. SourceForge will create a snapshot of the SVN repository. If you can't find the correct directory in that snapshot, please let me know. I can make a ZIP file available on my server if necessary. e-mail: gkroll (at) keldine (dot) ca .