Jump to content

Localhost server problem, SQL engine error, mbstring extension is missing


magazin online

Recommended Posts

Hello,
 
I had the problem that I couldn't upload files bigger than 2 MB.
In php.ini I changed upload_max_filesize from 2M to 2000M. as it is sown here: 


 
After this, if I try to access prestashop, I receive error: 
  500 Server Error

 
If I type admin path in browser:
http://localhost/prestashop/admin/index.php....
This error occurs:

[PrestaShopException]
Cannot select any valid SQL engine.
at line 295 in file classes/db/Db.php
290. } elseif (extension_loaded('mysqli')) {
291. $class = 'DbMySQLi';
292. }
293.
294. if (empty($class)) {
295. throw new PrestaShopException('Cannot select any valid SQL engine.');
296. }
297.
298. return $class;
299. }
300.

If I enter on http://localhost/phpmyadmin/ I receive this error:

phpMyAdmin - Error
The mbstring extension is missing. Please check your PHP configuration.
 

 

Now I do not have acces to my store. Please help me to solve this issue.

 

Is there another way to acces my store and save my work?

 

Thank you so much!

Link to comment
Share on other sites

You might have somehow disabled the php_mbstring extension if the store was working in the past. If you are using multiple apps for webserver you might have a conflict between the two. Check the status of mbstring (easiest way through a phpinfo file) and if it's not present search how you could enable it.

 

To be sure you save your work make a backup of the files and use mysql at command line to make a dump of the database. 

Link to comment
Share on other sites

gabdara thank you for answer!

 

The problem was in php.ini

I found out about an error logging file: apache/logs/error.log

Here, at the time when error occurred, I saw next error lines:

 

[Tue Feb 21 18:32:33.935226 2017] [ssl:warn] [pid 7404:tid 252] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Tue Feb 21 18:32:34.232243 2017] [core:warn] [pid 7404:tid 252] AH00098: pid file C:/xampp/apache/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
PHP:  syntax error, unexpected END_OF_LINE, expecting '=' in C:\xampp\php\php.ini on line 2:0 server certificate does NOT include an ID which matches the server name
 
I checked many times and I found only a space in first row before
. In error.log it found error on line 2:0, I don't know why.
I deleted that space and everything goes fine.
So much work for only a space.
 
Here is somebody with similar problem:
 
Link to comment
Share on other sites

  • 1 year later...
On 27/2/2017 at 12:53 PM, magazin online said:

Gabdara gracias por la respuesta!

 

El problema estaba en php.ini

Descubrí un archivo de registro de errores: apache / logs / error.log

Aquí, en el momento en que ocurrió el error, vi las siguientes líneas de error:

 

[Mar 21 feb: 32: 33.935226 2017] [ssl: warn] [pid 7404: tid 252] AH01909: www.example.com:443:0 El certificado del servidor NO incluye una identificación que coincida con el nombre del servidor
[Mar 21 feb: 32: 34.232243 2017] [core: warn] [pid 7404: tid 252] AH00098: archivo pid C: /xampp/apache/logs/httpd.pid sobrescrito - ¿Apagado imprudente de la ejecución anterior de Apache?
PHP: error de sintaxis, inesperado END_OF_LINE, esperando '=' en C: \ xampp \ php \ php.ini en la línea 2: 0 el certificado del servidor NO incluye una ID que coincida con el nombre del servidor
 
Lo comprobé muchas veces y solo encontré un espacio en la primera fila

Borré ese espacio y todo va bien.
Mucho trabajo solo por un espacio
 
Aquí hay alguien con un problema similar:
 

Hola como solucionaste

 esto? tengo el mismo problema

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...