Remove all instances of pgonly from the database

kees-b · 2017-04-05 12:58:23

Hi,

After a succesful upgrade from 4.5.7 to 4.6.2 I see a load of errors in debug mode about the pgonly tag atribute. As I was not using it actively I now want to remove all instances of pageonly="0" from the database. But how? Can someone provide me the right SQL query to do that in one big sweep?

thanks,

Kees

Bloke · 2017-04-05 13:08:21

Although it could be done, I’d be tempted not to use such a broad-brush (and potentially devastating) approach. You’ll probably find pageonly is confined to a few Pages/Forms, in which case, smd_where_used should be able to locate the attribute usage easily enough to allow you to hack them out of your templates.

kees-b · 2017-04-05 16:35:27

Bloke wrote #305226:

Although it could be done, I’d be tempted not to use such a broad-brush (and potentially devastating) approach. You’ll probably find pageonly is confined to a few Pages/Forms, in which case, smd_where_used should be able to locate the attribute usage easily enough to allow you to hack them out of your templates.

Thanks Bloke, I’ll better do it that way…
I checked allready with smd_where_used and there where quit some instances. It’s a big site, with many pages and forms, but it can be done. And the error doesn’t harm. Beter not run a sql sweep script on a live site indeed.

Bloke · 2017-04-05 17:21:48

kees-b wrote #305230:

there where quit some instances.

Not that this helps you, but I do have an unfinished version of smd_where_used that allows replacements to be made with matched assets. Might get round to finishing it one day.

kees-b · 2017-04-06 08:18:54

Bloke wrote #305231:

Not that this helps you, but I do have an unfinished version of smd_where_used that allows replacements to be made with matched assets. Might get round to finishing it one day.

Thanks Stef! I’ll keep an eye on that.

Textpattern CMS

Textpattern CMS support forum

#1 2017-04-05 12:58:23