skelly Posted August 26, 2013 Report 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
Michael Posted August 26, 2013 Report Posted August 26, 2013 Is this on a local server because the IP doesn't load for me?
skelly Posted August 26, 2013 Author Report 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.
Michael Posted August 26, 2013 Report 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.
skelly Posted August 26, 2013 Author Report 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.
skelly Posted August 27, 2013 Author Report 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?
Paul Posted August 27, 2013 Report 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?
skelly Posted August 28, 2013 Author Report Posted August 28, 2013 Disable ONLY_FULL_GROUP_BY. BINGO! Thanks Cody, never would have found that myself.
Recommended Posts