Page 1 of 1

UDT to make a query to content prop_name

Posted: Mon Oct 01, 2012 7:10 pm
by uloloi
Hi, at the start publishing of a cmsms site I suggested to the editor to use into a cms_content_prop / prop_name : extra1 a string to recognize from which number of magazine publishing belongs this article, then she was just writing something like 'Boletin No. 207', 'Boletin No. 208', in few articles it was forgotten to be put! etc... Well, because the growing of the site, it is needed to make an adjustment, just use into this extra1 field a number value, that's all.

Now, how can I use an UDT to locate all articles that contains in extra1 the same value?, something like using tags, but using extra1 and content_props of the cms_content

I'm searching results for this:

cms_content
- prop_names : target,image,thumbnail,extra1,extra2,extra3,search

cms_content_props
- prop_name : extra1
- content : %Bolet%170%

Well, I want to find all the articles which has filled in the extra1 some string LIKE Boletin No. 170

Re: UDT to make a query to content prop_name

Posted: Wed Oct 03, 2012 8:13 pm
by uloloi
Continuing with further details with the table cms_content...

It is impossible to upgrade to version 1.11.2 from a website done in cmcms in version 1.9. +, NO! can not this simply sends errors.

I want-or pretend-update a website that is now online, the problem with this is that the table has enough information cms_content, many articles, and many news categories_n_items are already published. What can be done? What do you recommend? I can not create a database with new tables of version 1.11.2 and then import a table cms_content the database from the previous version.

Obviously this means take the group of editors, design templates applied, my UDTs, plugins, etc

UGH! Any help?