PS 1.7.0.0 RC3 - Error 500 on install

[smprofx]

Hello!

I'm trying to install on dev server the just released RC3 but I get Error 500 when trying to access the domain.

If I go directly by www.domain.com/install I get the first page of the install process by when I press the next I get again the HTTP Error 500 message.

 

On the same host (different dev folder) I have installed and running the RC2 .... 

 

Regards,

Ser

[smprofx]

Here is the error code behind the Error 500 after activating the dev mode

 

[PrestaShopDatabaseException]

Table 'prestashop.ps_shop_url' doesn't exist
 

SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = '----privacy edited----' OR su.domain_ssl = '----privacy edited----')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
at line 744 in file classes/db/Db.php

 

739. if ($webservice_call && $errno) {
740. $dbg = debug_backtrace();
741. WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
742. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
743. if ($sql) {
744. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
745. }
746.
747. throw new PrestaShopDatabaseException($this->getMsgError());
748. }
749. }

• DbCore->displayError - [line 378 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 596 - classes/db/Db.php] - [1 Arguments]
• DbCore->executeS - [line 351 - classes/shop/Shop.php] - [1 Arguments]
• ShopCore::initialize - [line 112 - config/config.inc.php]
• require - [line 27 - index.php] - [1 Arguments]

[masterblaster]

I just tried to install it too

 

I was unable to get the "prestashop.zip" archive automatically extracted by the installer so I did it manually,

then when I pointed the domain to the /install/ path I got :

 

 

Link to database cannot be established: SQLSTATE[HY000] [1045] Access denied for user 'root'@'127.0.0.1' (using password: NO) 

 

?

 

RC2 is installing / working correctly on the same machine. I will do further checks 

[smprofx]

For me it's unzipped fine on the host folder using the control panel file manager tool.

Now I'm trying unzipping the folder locally and upload all files manually by FTP.  Have to check this possibility also before giving up...

 

Looking forward for the developers to confirm if it's a release problem or my particular problem ...

Edited October 27, 2016 by smprofx (see edit history)

[rocky]

 

Here is the error code behind the Error 500 after activating the dev mode

 

[PrestaShopDatabaseException]

Table 'prestashop.ps_shop_url' doesn't exist

 

SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main

FROM ps_shop_url su

LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)

WHERE (su.domain = '----privacy edited----' OR su.domain_ssl = '----privacy edited----')

AND s.active = 1

AND s.deleted = 0

ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC

at line 744 in file classes/db/Db.php

 

739. if ($webservice_call && $errno) {

740. $dbg = debug_backtrace();

741. WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);

742. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {

743. if ($sql) {

744. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');

745. }

746.

747. throw new PrestaShopDatabaseException($this->getMsgError());

748. }

749. }

• DbCore->displayError - [line 378 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 596 - classes/db/Db.php] - [1 Arguments]
• DbCore->executeS - [line 351 - classes/shop/Shop.php] - [1 Arguments]
• ShopCore::initialize - [line 112 - config/config.inc.php]
• require - [line 27 - index.php] - [1 Arguments]

 

 

I've encountered the same problem when installing PrestaShop on XAMPP with PHP 5.6. I found downgrading to XAMPP with PHP 5.5 fixed it. Seems PrestaShop doesn't handle MariaDB well.

[smprofx]

Tried with manual FTP upload of all unzipped files.

 

Still no luck.

 

if I open the domain.com/install page I get the first page working then when click the next button I get the following error as output by dev mode on:

 

Warning: session_start(): open(/var/lib/php/session/sess_49e631175bbf0a3a9fa3d95ff3e6643d, O_RDWR) failed: Permission denied (13) in /home/admin/*domain.com*/install/classes/session.php on line 47

Fatal error: Uncaught exception 'Defuse\Crypto\Exception\BadFormatException' with message 'Encoding::hexToBin() input is not a hex string.' in /home/admin/*domain.com/vendor/defuse/php-encryption/src/Encoding.php:65 Stack trace: #0 /home/admin/*domain.com/vendor/defuse/php-encryption/src/Encoding.php(164): Defuse\Crypto\Encoding::hexToBin('/home/admin/vid...') #1 /home/admin/*domain.com/vendor/defuse/php-encryption/src/Key.php(38): Defuse\Crypto\Encoding::loadBytesFromChecksummedAsciiSafeString('\xDE\xF0\x00\x00', '/home/admin/vid...') #2 /home/admin/*domain.com*/classes/PhpEncryptionEngine.php(111): Defuse\Crypto\Key::loadFromAsciiSafeString('/home/admin/vid...') #3 /home/admin/*domain.com*/classes/PhpEncryptionEngine.php(46): PhpEncryptionEngineCore::loadFromAsciiSafeString('/home/admin/vid...') #4 /home/admin/*domain.com*/classes/PhpEncryption.php(45): PhpEncryptionEngineCore->__construct('/home/admin/vid...') #5 /home/admin/*domain.com*/classes/Cookie.php(80): PhpEncryptionCore->__construct('/home/admin/vid...') #6 in/home/admin/*domain.com*/vendor/defuse/php-encryption/src/Encoding.php on line 65

Warning: Unknown: open(/var/lib/php/session/sess_49e631175bbf0a3a9fa3d95ff3e6643d, O_RDWR) failed: Permission denied (13) in Unknown on line 0

Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/var/lib/php/session) in Unknown on line 0

 

Note: for privacy reasons the actual domain name was replaced with *domain.com* in this error log.