I've solved this taking out Order by from all queries!
Thank you Simon
Cheers!
4 years ago
#11
4 years ago
#12
Hi Claudia,
Glad you have solved the problem :)
Yes, you are right about not being able to see the SQL if you set debug to True on 'Model.php', but you can if you use David's 'Postperson' module from the Module Marketplace or Postman if you prefer bloated commercial apps.
Goto http://localhost/blog/blog_notices/show/2 to view your page and hit control+u to show the source code of the page. Scroll down to where the JavaScript is:
Open Postperson in another tab and set request type to 'POST'. Then target URL to
Grab the token from above and paste it into 'Trongate Token' (if you get an invalid token, remove the token and try again), you can also comment out 'api_auth(); in fetch_available_options() of 'Module_relations.php' if all else fails.
For 'Parameters' use this:
then scroll down to 'public function query($sql, $return_type = false)' in 'Model.php' and insert a die($sql); as shown below:
Hit submit in Postperson and you should see the SQL in the popup modal
You can also remove the die() statement to see the returned dropdown options too
cheers,
Si
Glad you have solved the problem :)
Yes, you are right about not being able to see the SQL if you set debug to True on 'Model.php', but you can if you use David's 'Postperson' module from the Module Marketplace or Postman if you prefer bloated commercial apps.
Goto http://localhost/blog/blog_notices/show/2 to view your page and hit control+u to show the source code of the page. Scroll down to where the JavaScript is:
Open Postperson in another tab and set request type to 'POST'. Then target URL to
Grab the token from above and paste it into 'Trongate Token' (if you get an invalid token, remove the token and try again), you can also comment out 'api_auth(); in fetch_available_options() of 'Module_relations.php' if all else fails.
For 'Parameters' use this:
then scroll down to 'public function query($sql, $return_type = false)' in 'Model.php' and insert a die($sql); as shown below:
Hit submit in Postperson and you should see the SQL in the popup modal
You can also remove the die() statement to see the returned dropdown options too
cheers,
Si