[Agilo for Trac] Upgrade Failed for MySQL

Discussion:

Dean Millam

2013-03-22 01:11:42 UTC

I was attempting to create a new Agilo (1.3.9) project using MySQL as the
backend on a Windows Server machine. I have Trac (1.0.1) installed and
MySQL 5.6.

When I did called the trac_admin upgrade command I received the following
error message and only 7 of the agilo tables were created. I attempted
this twice with the same results both times. Has anyone else experienced a
similar problem?

The upgrade failed. Please fix the issue and try again.

UnableToLoadObjectError: An error occurred while getting None from the
database:
(1146, "Table 'trac.agilo_sprint' doesn't exist")
--
--
Follow Agilo on Twitter: http://twitter.com/agilofortrac
Please support us by reviewing and voting on:
http://userstories.com/products/8-agilo-for-scrum
http://ohloh.net/p/agilo-trac
http://freshmeat.net/projects/agiloforscrum

You have received this message because you are subscribed to
the "Agilo for Trac" Google Group. This group is focused on
supporting Agilo for Trac users and is moderated by
Agilo Software GmbH <http://www.agilosoftware.com>.

To post to this group, send email to agilo-/***@public.gmane.org
To unsubscribe from this group, send an email to
agilo+unsubscribe-/***@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/agilo

---
You received this message because you are subscribed to the Google Groups "Agilo for Trac" group.
To unsubscribe from this group and stop receiving emails from it, send an email to agilo+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/***@public.gmane.org
For more options, visit https://groups.google.com/groups/opt_out.

Stefano Rago

2013-04-09 09:28:51 UTC

Permalink

Hi Dean,

Can you please provide the steps you used to install Agilo?

Cheers

Stefano Rago
--
--
Follow Agilo on Twitter: http://twitter.com/agilofortrac
Please support us by reviewing and voting on:
http://userstories.com/products/8-agilo-for-scrum
http://ohloh.net/p/agilo-trac
http://freshmeat.net/projects/agiloforscrum

You have received this message because you are subscribed to
the "Agilo for Trac" Google Group. This group is focused on
supporting Agilo for Trac users and is moderated by
Agilo Software GmbH <http://www.agilosoftware.com>.

To post to this group, send email to agilo-/***@public.gmane.org
To unsubscribe from this group, send an email to
agilo+unsubscribe-/***@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/agilo

---
You received this message because you are subscribed to the Google Groups "Agilo for Trac" group.
To unsubscribe from this group and stop receiving emails from it, send an email to agilo+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/***@public.gmane.org
For more options, visit https://groups.google.com/groups/opt_out.

Dean Millam

2013-04-09 21:13:14 UTC

Permalink

What exact steps are you interested in?

I created a trac environment using trac_admin *myproject* initenv command
with MySQL as the database. That worked fine.

Then I set agilo.* = enabled in trac.ini. And did the trac_admin *myproject*upgradecommand and received the error.

I created both Postgres and SQLite Agilo projects without any issue. I
even attempted to migrate those projects to a MySQL project and they failed
with the same error message.

Post by Dean Millam
I was attempting to create a new Agilo (1.3.9) project using MySQL as the
backend on a Windows Server machine. I have Trac (1.0.1) installed and
MySQL 5.6.
When I did called the trac_admin upgrade command I received the following
error message and only 7 of the agilo tables were created. I attempted
this twice with the same results both times. Has anyone else experienced a
similar problem?
The upgrade failed. Please fix the issue and try again.
UnableToLoadObjectError: An error occurred while getting None from the
(1146, "Table 'trac.agilo_sprint' doesn't exist")

--
--
Follow Agilo on Twitter: http://twitter.com/agilofortrac
Please support us by reviewing and voting on:
http://userstories.com/products/8-agilo-for-scrum
http://ohloh.net/p/agilo-trac
http://freshmeat.net/projects/agiloforscrum

You have received this message because you are subscribed to
the "Agilo for Trac" Google Group. This group is focused on
supporting Agilo for Trac users and is moderated by
Agilo Software GmbH <http://www.agilosoftware.com>.

To post to this group, send email to agilo-/***@public.gmane.org
To unsubscribe from this group, send an email to
agilo+unsubscribe-/***@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/agilo

---
You received this message because you are subscribed to the Google Groups "Agilo for Trac" group.
To unsubscribe from this group and stop receiving emails from it, send an email to agilo+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/***@public.gmane.org
For more options, visit https://groups.google.com/groups/opt_out.

Stefano Rago

2013-04-10 07:33:05 UTC

Permalink

Hi Dean,

thanks for the info. How did you install Agilo? Did you use the Windows installer or some other method?

Cheers

Stefano

Post by Dean Millam
What exact steps are you interested in?
I created a trac environment using trac_admin myproject initenv command with MySQL as the database. That worked fine.
Then I set agilo.* = enabled in trac.ini. And did the trac_admin myproject upgrade command and received the error.
I created both Postgres and SQLite Agilo projects without any issue. I even attempted to migrate those projects to a MySQL project and they failed with the same error message.
I was attempting to create a new Agilo (1.3.9) project using MySQL as the backend on a Windows Server machine. I have Trac (1.0.1) installed and MySQL 5.6.
When I did called the trac_admin upgrade command I received the following error message and only 7 of the agilo tables were created. I attempted this twice with the same results both times. Has anyone else experienced a similar problem?
The upgrade failed. Please fix the issue and try again.
(1146, "Table 'trac.agilo_sprint' doesn't exist")
--
--
Follow Agilo on Twitter: http://twitter.com/agilofortrac
http://userstories.com/products/8-agilo-for-scrum
http://ohloh.net/p/agilo-trac
http://freshmeat.net/projects/agiloforscrum
You have received this message because you are subscribed to
the "Agilo for Trac" Google Group. This group is focused on
supporting Agilo for Trac users and is moderated by
Agilo Software GmbH <http://www.agilosoftware.com>.
To unsubscribe from this group, send an email to
For more options, visit this group at
http://groups.google.com/group/agilo
---
You received this message because you are subscribed to the Google Groups "Agilo for Trac" group.
For more options, visit https://groups.google.com/groups/opt_out.

Dean Millam

2013-04-10 20:25:18 UTC

Permalink

I installed Trac with the Bit Nami Trac Stack installer.
I installed Agilo by installing the egg file. easy_install
binary_agilo-1.3.9_PRO-py2.7.egg

Stefano Rago

2013-04-11 07:28:11 UTC

Permalink

Hi Dean,

Post by Dean Millam
I installed Trac with the Bit Nami Trac Stack installer.
I installed Agilo by installing the egg file. easy_install binary_agilo-1.3.9_PRO-py2.7.egg

Thanks for the information. I will try and reproduce the issue and come back to you asap!

Stefano Rago
--
--
Follow Agilo on Twitter: http://twitter.com/agilofortrac
Please support us by reviewing and voting on:
http://userstories.com/products/8-agilo-for-scrum
http://ohloh.net/p/agilo-trac
http://freshmeat.net/projects/agiloforscrum

You have received this message because you are subscribed to
the "Agilo for Trac" Google Group. This group is focused on
supporting Agilo for Trac users and is moderated by
Agilo Software GmbH <http://www.agilosoftware.com>.

To post to this group, send email to agilo-/***@public.gmane.org
To unsubscribe from this group, send an email to
agilo+unsubscribe-/***@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/agilo

---
You received this message because you are subscribed to the Google Groups "Agilo for Trac" group.
To unsubscribe from this group and stop receiving emails from it, send an email to agilo+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/***@public.gmane.org
For more options, visit https://groups.google.com/groups/opt_out.

Stefano Rago

2013-04-26 09:26:31 UTC

Permalink

Hi Dean,

Post by Stefano Rago
Thanks for the information. I will try and reproduce the issue and come back to you asap!

I have downloaded the latest bitnami trac stack, and installed agilo using the default project and default configuration, and there was no problem.
Looking back at your emails, I've seen you mentioned using mysql on a windows server machine.
Is this a different setup than the bitnami trac stack? If so, can you point me to where can I find it?

Cheers

Stefano Rago
--
--
Follow Agilo on Twitter: http://twitter.com/agilofortrac
Please support us by reviewing and voting on:
http://userstories.com/products/8-agilo-for-scrum
http://ohloh.net/p/agilo-trac
http://freshmeat.net/projects/agiloforscrum

You have received this message because you are subscribed to
the "Agilo for Trac" Google Group. This group is focused on
supporting Agilo for Trac users and is moderated by
Agilo Software GmbH <http://www.agilosoftware.com>.

To post to this group, send email to agilo-/***@public.gmane.org
To unsubscribe from this group, send an email to
agilo+unsubscribe-/***@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/agilo

---
You received this message because you are subscribed to the Google Groups "Agilo for Trac" group.
To unsubscribe from this group and stop receiving emails from it, send an email to agilo+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/***@public.gmane.org
For more options, visit https://groups.google.com/groups/opt_out.