<div dir="ltr"><div class="gmail_default" style="font-family:georgia,serif;font-size:small">No w I am getting the following error when upgrading, after using the UPDATE command listed below. This only occurs when upgrading from 4.3.9 to 4.3.10. Any further advice would be much appreciated!<br><br><div class="gmail_default"><i>Processing 4.3.10</i></div><div class="gmail_default"><i>Now populating database schema.</i></div><div class="gmail_default"><i>[19046] [Fri Feb 26 21:33:59 2016] [critical]: DBD::mysql::st execute failed: Table 'Assets' already exists at /tmp/rt-4.4.0/sbin/../lib/RT/Handle.pm line 552. (/tmp/rt-4.4.0/sbin/../lib/RT.pm:390)</i></div><div class="gmail_default"><i>DBD::mysql::st execute failed: Table 'Assets' already exists at /tmp/rt-4.4.0/sbin/../lib/RT/Handle.pm line 552.</i></div><div class="gmail_default"><i>Makefile:391: recipe for target 'upgrade-database' failed</i></div></div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><font face="georgia, serif">Sincerely,</font><div><font face="georgia, serif"><br></font></div><div><font face="georgia, serif">Aaron Lush</font></div><div><font face="georgia, serif">Network Administrator</font></div><div><font face="georgia, serif">South Central Community School Corporation</font></div><div><font face="georgia, serif">(219) 767-2266 ext. 1111</font></div></div></div></div></div></div>
<br><div class="gmail_quote">On Fri, Feb 26, 2016 at 3:12 PM, Lush, Aaron <span dir="ltr"><<a href="mailto:alush@scentral.k12.in.us" target="_blank">alush@scentral.k12.in.us</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_default" style="font-family:georgia,serif;font-size:small">Thanks, Joop. I'll restore my 4.2 database backup and run the following SQL command on the database:</div><div class="gmail_default" style="font-family:georgia,serif;font-size:small"><br></div><div class="gmail_default" style="font-family:georgia,serif;font-size:small">UPDATE users SET ExternalAuthID=null WHERE ExternalAuthId IS NOT null;</div><div class="gmail_default" style="font-family:georgia,serif;font-size:small"><br></div><div class="gmail_default" style="font-family:georgia,serif;font-size:small">MySQL isn't my strongest set of skills, but that is how I am understanding your post. Thanks a lot for the quick response!</div></div><div class="gmail_extra"><span class=""><br clear="all"><div><div><div dir="ltr"><div><div dir="ltr"><font face="georgia, serif">Sincerely,</font><div><font face="georgia, serif"><br></font></div><div><font face="georgia, serif">Aaron Lush</font></div><div><font face="georgia, serif">Network Administrator</font></div><div><font face="georgia, serif">South Central Community School Corporation</font></div><div><font face="georgia, serif">(219) 767-2266 ext. 1111</font></div></div></div></div></div></div>
<br></span><div class="gmail_quote"><div><div class="h5">On Fri, Feb 26, 2016 at 2:59 PM, Joop <span dir="ltr"><<a href="mailto:jvdwege@xs4all.nl" target="_blank">jvdwege@xs4all.nl</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5">
<div bgcolor="#FFFFFF" text="#000000"><span>
<div>On 26-2-2016 18:47, Lush, Aaron wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div class="gmail_default" style="font-family:georgia,serif;font-size:small">I'm trying
to upgrade from 4.2.0 > 4.4.0 on Ubuntu Server 15.10 and
have been running into some snags. The first was that I had
"ExternalAuthId" with values in my RT4 database, as I was
using that plug-in. Once I dropped that table I was able to
continue upgrading. However, my upgrade has stalled at the
following:</div>
<div class="gmail_default" style="font-family:georgia,serif;font-size:small"><br>
</div>
<br>
</div>
</blockquote></span>
Using something like : update users set externalauthid=null where
externalauthid is not null should do the trick. Don't drop the users
table.<br>
I just did a test upgrade from 4.0.23 to 4.4.0 and we're using
ExternalAuth too. <br>
For those interested: we also use AssetTracker and I migrated all
its assets to the shine new RT::Assets :-)<br>
Got a question about something related but will post that in a new
thread.<br>
<br>
Regards,<br>
<br>
Joop<br>
<br>
</div>
<br></div></div>---------<br>
RT 4.4 and RTIR Training Sessions (<a href="http://bestpractical.com/services/training.html" rel="noreferrer" target="_blank">http://bestpractical.com/services/training.html</a>)<br>
* Hamburg Germany - March 14 & 15, 2016<br>
* Washington DC - May 23 & 24, 2016<br></blockquote></div><br></div>
</blockquote></div><br></div>
<br>
Email Confidentiality Notice: This email message, including all attachments, is for the sole use of the intended recipient(s) and contains confidential information. If you are not the intended recipient, you may not use, disclose, print, copy or disseminate this information. Please reply and notify the sender, delete the message and any attachments and destroy all copies. <br>