I was following the .mov tutorial: so, I went ahead and let tg-admin sql
create "repair". I got a python exception
...
File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py", line
33, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1170, "BLOB/TEXT column 'pagename'
used in key specification without a key length")
I noticed in the printed tutorial model.py was
class Page(SQLObject):
pagename = StringCol(alternateID=True, length=30)
data = StringCol()
instead of what's in the (otherwise spiffy) movie tutorial
class Page(SQLObject):
pagename = StringCol(alternateID=True)
data = StringCol()
That fixed things, and tg-admin sql create now does as advertised.
Caveat Emptor, I think I'll proceed with the printed version.
Kevin Dangoor wrote:
It looks like it makes a difference as to whether it's installed or
not. If you run in develop mode, it works. If it's installed, it
doesn't.
Kevin
On 10/14/05, Elvelind Grandin <[EMAIL PROTECTED]> wrote:
For me it does create a sqlobject.txt file. I cant really see why It shouldn't.
On 10/14/05, Kevin Dangoor <[EMAIL PROTECTED]> wrote:
The first thing I see is that there appears to be a bug in quickstart.
It *should* be creating an sqlobject.txt file in the egg-info
directory but isn't.
However, tg-admin sql create, for me at least, fixed this. It didn't
appear to create the database on the same run as when it fixed the
missing metadata, but it did create the database without complaint on
the next run.
Time to put some automated tests on the quickstart. If I have time to
fix this later today, I will, but I'm not sure if I will get to it. A
patch to fix quickstart's failure to copy sqlobject.txt to the right
place would be much appreciated, if someone else can beat me to it.
Kevin
On 10/14/05, RM <[EMAIL PROTECTED]> wrote:
I'm trying to run sql create from the top level dir that the tg-admin
quickstart created, ie,
[EMAIL PROTECTED]:~/play/turbogears/wiki20> ls *
dev.cfg prod.cfg setup.pyc wiki20-start.py
dev.cfg~ setup.py TestGears-0.2-py2.4.egg
wiki20:
controllers.py __init__.py model.py sqlobject-history templates
controllers.pyc __init__.pyc model.py~ static
Wiki-20.egg-info:
PKG-INFO requires.txt top_level.txt
[EMAIL PROTECTED]:~/play/turbogears/wiki20> tg-admin sql create
Using database URI mysql://turbogear:[EMAIL PROTECTED]/wiki20
This project seems incomplete. In order to use the sqlobject commands
without manually specifying a model, there needs to be an
egg-info directory with an appropriate sqlobject.txt file.
I can fix this automatically. Would you like me to?
--
Kevin Dangoor
Author of the Zesty News RSS newsreader
email: [EMAIL PROTECTED]
company: http://www.BlazingThings.com
blog: http://www.BlueSkyOnMars.com
--
cheers
elvelind grandin
--
Kevin Dangoor
Author of the Zesty News RSS newsreader
email: [EMAIL PROTECTED]
company: http://www.BlazingThings.com
blog: http://www.BlueSkyOnMars.com
