Re: [rt-users] How to update CF via scripted mySQL commands

2013-07-24 Thread Craig Ringer
On 07/22/2013 09:40 PM, scott.dalzell wrote: Thanks for pointing that out. i think ill try to do the API route as i cant afford to corrupt the database. Can the RT API be used to modify a database that is not being used by RT. When you load the RT perl modules they'll read RT_SiteConfig.pm

Re: [rt-users] How to update CF via scripted mySQL commands

2013-07-22 Thread scott.dalzell
Thanks for pointing that out. i think ill try to do the API route as i cant afford to corrupt the database. Can the RT API be used to modify a database that is not being used by RT Just that my final goal is to modify a field in our Bugzilla database (also MYsql) when an RT CF is given a bug

Re: [rt-users] How to update CF via scripted mySQL commands

2013-07-19 Thread scott.dalzell
i have got abit further with this issue and i have got a perl script that does what i need it to do and edit the mysl database, however when i add this code into RT as a scrip i get the following error in the error.log. [Fri Jul 19 12:38:40 2013] [error]: Scrip 491 Prepare failed: Global symbol

Re: [rt-users] How to update CF via scripted mySQL commands

2013-07-19 Thread Thomas Sibley
On 07/19/2013 06:10 AM, scott.dalzell wrote: i have got abit further with this issue and i have got a perl script that does what i need it to do and edit the mysl database, however when i add this code into RT as a scrip i get the following error in the error.log. Updating the RT database via

[rt-users] How to update CF via scripted mySQL commands

2013-07-18 Thread scott.dalzell
Hey guys What i am trying to do is link 1 ticket CF (Bug_No) to another Ticket CF (Ticket_No) by writing a script that will update the CF (Ticket_No) via the mysql database when the CF (Bug_No) is updated The reason i need it done in this manor is becasue this is a trial before doing the same