retechp Posted Monday at 03:15 PM Share Posted Monday at 03:15 PM (edited) I am trying to build reports through the SQL Manager. I have built a test report but when I attempt to execute, the following error appears. It does not matter what is selected for the report when executing report. I have seen several issues similar but none relating to PrestaShop SQL Manager and version 8.2.0 I am running: - PrestaShop 8.2.0 - Apache 2 - MySQL version 8.0.40-0 - ubuntu0.20.04.1 Edited 9 hours ago by retechp (see edit history) Link to comment Share on other sites More sharing options...
Prestashop Addict Posted Monday at 03:41 PM Share Posted Monday at 03:41 PM You mean a simple SELECT * FROM ps_order_invoice produce an error? If no put your SQL query here. Link to comment Share on other sites More sharing options...
retechp Posted Tuesday at 02:33 PM Author Share Posted Tuesday at 02:33 PM This was the info I entered into the query window. I allowed me to save it however when I tried to view or download it, the above error appeared. Link to comment Share on other sites More sharing options...
Prestashop Addict Posted Tuesday at 02:53 PM Share Posted Tuesday at 02:53 PM Your query must include all SQL elements SELECT id_order_invoice, id_order FROM ps_order_invoice 1 Link to comment Share on other sites More sharing options...
retechp Posted 9 hours ago Author Share Posted 9 hours ago Thanks On 11/19/2024 at 9:53 AM, Prestashop Addict said: Your query must include all SQL elements SELECT id_order_invoice, id_order FROM ps_order_invoice Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now