skelly Posted August 26, 2013 Report Share Posted August 26, 2013 Describe the issue you're experiencing. Error after fresh install of 3.0.1 using cli Provide detailed steps necessary to reproduce the issue. Install on clean system using cli installer List any generated errors. (The "Oh Noes" error pages are very helpful.) Oh noes! SQLSTATE[42000]: Syntax error or access violation: 1055 'temp.value' isn't in GROUP BY on line 124 in /etc/nginx/html/newblesta/public_html/lib/model.php Printing Stack Trace: #0 /etc/nginx/html/newblesta/public_html/lib/model.php(124): PDOStatement->execute(Array) #1 /etc/nginx/html/newblesta/public_html/components/record/record.php(654): Model->query('SELECT * FROM (...', Array) #2 /etc/nginx/html/newblesta/public_html/app/models/companies.php(510): Record->fetch() #3 /etc/nginx/html/newblesta/public_html/app/app_controller.php(0): Companies->getSetting() #4 /etc/nginx/html/newblesta/public_html/app/app_controller.php(0): AppController->primeCompany() #5 /etc/nginx/html/newblesta/public_html/app/controllers/admin_login.php(14): AppController->preAction() #6 /etc/nginx/html/newblesta/public_html/lib/dispatcher.php(102): AdminLogin->preAction() #7 /etc/nginx/html/newblesta/public_html/index.php(21): Dispatcher::dispatch('/index.php/admi...') #8 {main} Include the URL the error occurred on, relative to the installation path, ie "/admin/login". https://192.168.1.120 https://192.168.1.120/index.php/admin/ https://192.168.1.120/index.php/admin/login/ Include your configuration settings, i.e. OS, version of Blesta, PHP & MySQL. PHP 5.4.4-14+deb7u3 (cli) (built: Jul 17 2013 14:54:08) with the ionCube PHP Loader v4.2.2 nginx version: nginx/1.5.2 Percona Mysql: v5.5 Link to comment Share on other sites More sharing options...
Michael Posted August 26, 2013 Report Share Posted August 26, 2013 Is this on a local server because the IP doesn't load for me? Link to comment Share on other sites More sharing options...
skelly Posted August 26, 2013 Author Report Share Posted August 26, 2013 Is this on a local server because the IP doesn't load for me? Yes. Its on a local VM for packaging and module/plugin develpment. Link to comment Share on other sites More sharing options...
Michael Posted August 26, 2013 Report Share Posted August 26, 2013 Yes. Its on a local VM for packaging and module/plugin develpment. Erm maybe you need to edit the hosts file, as Paul said on another thread, hostname and your IP in that, so the trial license doesn't think it's used on localhost. But I could be miles away from the answer. If it isn't that Paul, Cody and Tyson can help you. Link to comment Share on other sites More sharing options...
skelly Posted August 26, 2013 Author Report Share Posted August 26, 2013 Erm maybe you need to edit the hosts file, as Paul said on another thread, hostname and your IP in that, so the trial license doesn't think it's used on localhost. But I could be miles away from the answer. If it isn't that Paul, Cody and Tyson can help you. Maybe...though seems to ping fine and mysql networking is up. root@debian-wheezy:~# netstat -lunpt | grep mysqld tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 2616/mysqld root@debian-wheezy:~# cat /etc/hosts 127.0.0.1 localhost debian-wheezy [EDIT] Not getting far enough to enter my license yet. So I doubt it has to do with license/domain verification. Link to comment Share on other sites More sharing options...
skelly Posted August 27, 2013 Author Report Share Posted August 27, 2013 bump. retried 3.0.1 install on fresh vm's three times now. Same oh noes. No other obvious errors in any logs. Any ideas? Link to comment Share on other sites More sharing options...
Paul Posted August 27, 2013 Report Share Posted August 27, 2013 I am suspicious of Percona Mysql: v5.5. This is an apparent issue with a query. Are you able to test on a normal MySQL 5.5 server? Link to comment Share on other sites More sharing options...
Cody Posted August 28, 2013 Report Share Posted August 28, 2013 Disable ONLY_FULL_GROUP_BY. Michael 1 Link to comment Share on other sites More sharing options...
skelly Posted August 28, 2013 Author Report Share Posted August 28, 2013 Disable ONLY_FULL_GROUP_BY. BINGO! Thanks Cody, never would have found that myself. Link to comment Share on other sites More sharing options...
Recommended Posts