skelly

+1 this is a great idea.

BINGO! Thanks Cody, never would have found that myself.

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?

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.

Yes. Its on a local VM for packaging and module/plugin develpment.

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

Yea, maybe a plugin could work. I'm not sure though, more of a biz process guy myself. Needs more coder input before a plan could be in place. Definitely what I want to see though. As a managing/owner type. Would pay for it too, a few hundred ... maybe more. Yea a module would be the way to go for the Blesta team. Get them some money coming in. Sell it. [EDIT] So launch v3 and start working on this...and sell it...as the first Blesta team module. We would want 100% quality no? of course, so no OTHERs (hint hint) need try. Further, lets see what is coming...in more realtime. Like if we could choose to see what is ACTUALLY projected in the next 30 days. In v2, we saw something like that but is/was not reality. Let's see that more accurate and let's see where the business stands. Financially. That my friends, is where Blesta can take down any other. I've seen them all, I've used them and they all fail. Let's see something that can turn your SMB in a day. With one login, first thing in the morning. Turn it around by 6pm. Because you would NOW know where to focus and WHAT to focus on that day. maybe its not that code.. [/EDIT]

Hi, Here's a suggestion. Essentially answering THE most important question EVERY biz owner asks themselves daily .... am I making money or am I heading for broke? Basically, it occurs to me that most of us are small biz and probably have terrible accounting skills along with the fact that very few of us have a bookkeeper on our payroll. So this would give the little guy the advantage and save hundreds/thousands? each year in accounting costs. Have the ability to see an overview of all financial acitivites (Income, Expenses, Taxes (in/out) and extract reports to be given to an accountant for easier use (read less hours/lower charges) at tax time. This would require an expenses capability for bookkeeping. So under billing an authorized person could create a category (ie: Misc. Office Supplies) and any others as needed (Domain Reseller fees). To add an expense, click the category to create an expense line. That line contains a Date, Paid To, Invoice number, Sub total, tax paid, total paid. So if you bought some pencils, you can take the receipt and add that as a purchase. Or any of your monthly upstream invoices can be added as they are paid. Combined with the above, Blesta could then show a real-time overview with total income, total expenses, Profit/Margin. Maybe with a choice such as date-range or last 30,60,90,120, or 1,2,3,4,..12 months. Reports could be pulled as well, all expenses in last (date-range). All taxes paid, All income...etc. etc. which can then be given as CSV to a bookkeeper or accountant for 'easier' accounting. All business' need to provide Income and Expenses as minimum to any accountant. So this just compiles each of those into separate CSV's for importing. Thoughts?