Jump to content

Search the Community

Showing results for tags 'sql'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • General
    • News
    • The Lounge
  • Community
    • Pre-Sales Questions
    • Support
    • The Marketplace
    • Contribute
    • Show Off
    • Feature Requests
    • Bugs
    • Contests
  • Developer Corner
    • General
    • Extensions
  • BlestaStore's Forum
  • BlestaStore's BlestaCMS
  • BlestaStore's Resellers
  • BlestaStore's BlestaForums
  • BlestaStore's Promotions
  • CubeData's Official Announcements From CubeData
  • CubeData's Peer Support
  • CubeData's Resellers
  • ModulesGarden Club's Topics
  • Blesta Addons's Topics

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start





Website URL








Found 2 results

  1. 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
  2. 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
  • Create New...