Jump to content

V3.0.1 - Syntax Error Or Access Violation


skelly

Recommended Posts

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

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

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

Guest
This topic is now closed to further replies.
×
×
  • Create New...