Thread

The output profiler if enabled shows all the SQL statements needed to render a page. Except for the session id, almost always SELECT select statements.

Suppose you create or update a channel, a new field group, custom fields, categories, statuses…would it be possible to output or log the INSERT and UPDATE queries for these actions?

I don’t know if you can output what you need withouth hacking or extending the code.

Anyway MySQL has a Query Log you can probably access (depends on your environment and hosting). This post could prove helpful.

Can I ask what you’re needing it for?

Recently I had to setup a section on a few existing websites and the setup (channel, custom fields) was identical. Not a difficult job but quite some time went into configuring all the custom fields. So I was wondering if there is a way to do the same job faster.

If you are doing the exact same fields each time then take a look at MX Tool Box by the fantastic Max. Can definitely save some time when doing this sort of thing.

Best wishes,

Mark

Mark, that module is just fantastic. Just tested it. Will say thanks to Max too.

Thanks for the assist, Mark.

moonbeetle - Feel free to start a new thread if you have any more questions.