[rt-users] Upgrade: RTFM Article, Content CustomField not displaying
Hi, When viewing/editing an RTFM Article, Content CustomField is not displaying. This is after installing a fresh copy of RT 3.8.17 + RTFM 2.4.5 and pointing at copy of database, and upgraded as per steps in: http://www.bestpractical.com/docs/rt/3.8/UPGRADING.html from 3.8.2. I chose not to run optional perl etc/upgrade/split-out-cf-categories in 3.8.5 step. CustomFields already exist; I don't need to create new ones. The data in database has not changed during database upgrade. Test system ( RT 3.8.17 + RTFM 2.4.5 ): For both menus: Menu: RTFM - Configuration - Custom Fields Menu: Configuration - RTFM - Custom Fields Lists record #32 from the CustomFields table. Applied column is empty. Lists record #31 from the CustomFields table. Applied column is empty. Clicking on each CustomField, Applies to is RTFM Articles. I think it should be referencing CF records from FM_CustomFields table instead? Works fine with RT 3.8.2 + RTFM 2.4.1. Is this a bug or have I missed something? Thanks, Anthony
Re: [rt-users] MySQL issue - Windows vs. Linux - Table name case seems
Just an update for everyone: I'm using Ubuntu 12.04LTS as the MySQL test bed to move my RT databases to. While this link: http://dev.mysql.com/doc/refman/5.5/en/identifier-case-sensitivity.html provided by Maciej Dobrzanski did help, I noticed a small issue. For some reason, 2 is not a valid option on Ubuntu. 0 and 1 both work, but 2 seems to get ignored. I've been trying to work out if its me or the database server. The RT database is small enough than I can manually fix the tables names, but just wanted to give a heads up if anyone else goes through this. Stephen Cena QVII MIS/IT Dept 850 Hudson Ave. Rochester, NY. 14620 585-544-0450 x300 s...@qvii.com Thank you for helping us help you help us all.
Re: [rt-users] Regex
Putting specific numbers in your expressions like that really hamstrings you if things don't match up to the exact counts you specify. To match your city, just do this: /^\s*(\w.*?),\s+\w{2}\s+\d{5}/ Start of line, optionally followed by 0 or more spaces, (start capture) followed by a word character, followed by a non-greedy match of any number of characters (stop capture) up to a comma, followed by 1 or more spaces, followed by two word characters, followed by 1 or more spaces, followed by 5 digits. -- Andy Harrison public key: 0x67518262 On Fri, Aug 9, 2013 at 7:37 PM, Bryon Baker bba...@copesan.com wrote: Sorry back to the drawing board does not work if the city is two words.** ** ** ** Bryon Baker Network Operations Manager *Copesan** - Specialists in Pest Solutions* 800-267-3726 • 262-783-6261 ext. 2296 bba...@copesan.com cstep...@copesan.com www.copesan.com *Servicing North America with Local Care* ** ** *From:* Bryon Baker *Sent:* Friday, August 09, 2013 6:05 PM *To:* 'rt-users@lists.bestpractical.com' *Subject:* RE: Regex ** ** Update this is what I came up with seems to work Thoughts? Tries to anchor begin of line but found it is white space. /\s{10}([\w{2},]+),\s*(\w{2})\s*(\d{5})/ ** ** Ok this question is to the regex experts I have this email content and I want returned to me the City. ** ** 116 Walker Ave. Berlin Circle Plaza West Berlin, NJ 08091 Store Contact: MICHAEL OCONNOR - SOPASM Phone: (856)719-0335 Fax : (856)719-2216 ** ** Thanks in advance for you expert help. ** ** Thanks Bryon Baker Network Operations Manager *Copesan** - Specialists in Pest Solutions* 800-267-3726 • 262-783-6261 ext. 2296 bba...@copesan.com cstep...@copesan.com www.copesan.com *Servicing North America with Local Care* ** **