Issue when installing on IIS

Permalink
Hi, I am trying to install concrete locally but getting following error after submitting required database and site user information:-
Using local host as the database server which is using MySql 5.7 and PHP Version 7.

Unable to install database: Declaration of Concrete\Core\Attribute\Key\CollectionKey::getList() should be compatible with Concrete\Core\Attribute\Key\Key::getList($akCategoryHandle, $filters = Array).

Trace:
#0 [internal function]: Concrete\Core\Package\StartingPointPackage->install_database() #1 C:\Source\concrete\concrete\controllers\install.php(275): call_user_func(Array) #2 [internal function]: Concrete\Controller\Install->run_routine('elemental_full',

'install_databas...') #3 C:\Source\concrete\concrete\src\Controller\AbstractController.php(156): call_user_func_array(Array, Array) #4 C:\Source\concrete\concrete\src\Routing\ControllerRouteCallback.php(25): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array) #5 C:\Source\concrete\concrete\src\Routing\Router.php(115): Concrete\Core\Routing\ControllerRouteCallback->execute(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Routing\Route), Array) #6 C:\Source\concrete\concrete\src\Support\Facade\Facade.php(119): Concrete\Core\Routing\Router->execute(Object(Concrete\Core\Routing\Route), Array) #7 C:\Source\concrete\concrete\src\Application\Application.php(392): Concrete\Core\Support\Facade\Facade::__callStatic('execute', Array) #8 C:\Source\concrete\concrete\bootstrap\start.php(256): Concrete\Core\Application\Application->dispatch(Object(Concrete\Core\Http\Request)) #9 C:\Source\concrete\concrete\dispatcher.php(36): require('C:\\Source\\concr...') #10 C:\Source\concrete\index.php(2): require('C:\\Source\\concr...') #11 {main}

Khurramali
View Replies: View Best Answer
MrKDilkington replied on at Permalink Best Answer Reply
MrKDilkington
Hi Khurramali,

Version 5.7.5.4 was released today and I believe will install and run using PHP 7. Previous versions would not install on PHP 7.
Khurramali replied on at Permalink Reply
Khurramali
Thanks for your reply. I will try this and get back to you.
Khurramali replied on at Permalink Reply
Khurramali
I have downloaded the new version as per your instructions. The site seems to work now but I am getting following error within Blog section:-

An unexpected error occurred.
An exception occurred while executing 'SELECT date_format(cv.cvDatePublic, "%Y") as navYear, date_format(cv.cvDatePublic, "%m") as navMonth FROM Pages p LEFT JOIN PagePaths pp ON (p.cID = pp.cID and pp.ppIsCanonical = true) LEFT JOIN PageSearchIndex psi ON p.cID = psi.cID LEFT JOIN PageTypes pt ON p.ptID = pt.ptID INNER JOIN Collections c ON p.cID = c.cID INNER JOIN CollectionVersions cv ON p.cID = cv.cID LEFT JOIN CollectionSearchIndexAttributes csi ON c.cID = csi.cID WHERE (pt.ptID = ?) AND (p.cParentID = ?) AND (p.cPointerID < 1) AND (p.cIsTemplate = 0) AND (cvIsApproved = 1) AND (p.cIsActive = ?) AND (p.cIsSystemPage = ?) GROUP BY navYear, navMonth ORDER BY cvDatePublic desc' with params [7, 159, true, false]: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'balmoralb2b.cv.cvDatePublic' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Thanks.
Khurramali replied on at Permalink Reply
Khurramali
Got it working.

It was happening due MySql version change.
Solved it by adding my.ini file changes:-

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

used help from the following post:-
http://craftcms.stackexchange.com/questions/12084/getting-this-sql-...
mlocati replied on at Permalink Reply
mlocati
https://github.com/concrete5/concrete5/pull/4168 should fix this issue without the need to reconfigure mysql