ERREURS PHP
Erreur
http://panoramix.home.lan/phpMyAdmin/index.php Il manque l'extension mysqli. Merci de vérifier la configuration PHP. Voir [a@doc/html/faq.html#faqmysql@documentation]la documentation pour plus de détails.
ls /usr/local/lib/php/20190902/ bz2.so json.so pdo_dblib.so phar.so xml.so ctype.so mbstring.so pdo_firebird.so posix.so xmlreader.so dom.so mysqli.so pdo_mysql.so session.so xmlwriter.so filter.so opcache.so pdo_odbc.so simplexml.so zip.so gd.so openssl.so pdo_pgsql.so sqlite3.so zlib.so iconv.so pdo.so pdo_sqlite.so tokenizer.so
service php-fpm restart service mysql-server restart pkg install php74-mysqli-7.4.4 Updating FreeBSD repository catalogue... FreeBSD repository is up to date. All repositories are up to date. Checking integrity... done (0 conflicting) The most recent versions of packages are already installed
reboot
IMPORTANT
Si l'on reçoit un message d'erreur “ne trouve pas la table user” ou tout autre message dans ce genre là, l'erreur vient d'un copier collé de la base donnée !!
Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1932 Table 'ipcamera.utilisateurs' doesn't exist in engine in /usr/local/www/apache24 /data/panoramix.spycam.home.lan/models/mLogin.php:31 Stack trace: #0 /usr/local/www/apache24 /data/panoramix.spycam.home.lan/models/mLogin.php(31): PDOStatement->execute(Array) #1 /usr/local/www/apache24/data/panoramix.spycam.home.lan/controllers/cLogin.php(50): Login('aiko', 'a') #2 {main} thrown in /usr/local/www/apache24/data/panoramix.spycam.home.lan/models/mLogin.php on line 31
SOLUS
1. Toujours faire une exportation avant
2. Ensuite reccréer la database
3. Importer les tables dans la database concernée
Erreur
SQLSTATE[HY000] [2006] MySQL server has gone away
vim /usr/local/www/apache24/data/panoramix.secret.home.lan/models/connexion.php $hote = '192.168.1.12'; $hote = 'localhost';
Erreur
undefined class constant 'mysql_attr_init_command' in ... pkg install -y php74-pdo_mysql-7.4.12 vim /usr/local/etc/php.ini extension=pdo_mysql.so service php-fpm restart service apache24 restart
Erreur
(HY000/2002): No such file or directory vim /usr/local/www/apache24/data/panoramix.secret.home.lan/models/connexion.php ##$hote = 'localhost'; $hote = '127.0.0.1'; service php-fpm restart service apache24 restart
Erreur
mysqli::real_connect(): (HY000/2002): No such file or directory vim config.inc.php $cfg['Servers'][$i]['host'] = '127.0.0.1';