Search the Community
Showing results for tags 'sql'.
Found 2 results
-
Hi, i was trying to import our WHMCS Database into Blesta. The Debugging says: [1] => importSupportTickets: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #30 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db_whmcs01.tbladmins.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by on line 196 [2] => importAffiliates: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tbltickets.admin' in 'on clause' on line 196 [3] => importMisc: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM `tbltickets`, `tblaffiliates`, `tblconfiguration` LEFT JOIN `tbladmins` O' at line 1 on li Does anyone has an Idear what I can do to solve this? Regards and Thanks
-
I needed my transactions in QuickBooks, I am using Stripe, so I wanted each transaction reduced by the cost of Stripe to make everything easy to reconcile. I worked a developer to put together the attached files which are placed in /exportcsv I am thrilled with the results, let me know if you have any questions. This is running on a cpanel host, I see no reason it wouldn't run on any host with rights to access the Blesta database. A couple modifications I have planned: - We use Transaction Pro Importer to pull the csv file into QuickBooks. I am thinking about using qodbc or CData's remoteconnector to make things a bit more seamless. - It should be possible to get the database connection parameters from /config/blesta.php config.php index.php Output.xlsx
-
- 2
-
-
- export
- quickbooks
- (and 2 more)
