Hi percious. I have tried the following:
Windows + mysql
Ubuntu Linux + mysql and sqlite
Fedora Linux + sqlite
On Fedora Linux I have built with the Fedora RPMs on all components
and also with the easy_install method on all components. On Ubuntu
Linux and Windows I built with easy_install only.
I always get the error when I do a session->flush(). On top of that,
the project I am testing with worked on the following (as tested by
abadger1999):
Fedora Linux + mysql and sqlite (yes, works on both; as he was kind
enough to install mysql on his system for the test)
He took my code and put it in a fresh project of his own and it
worked. I then downloaded the entire project from him, changed his
dburi line to the default dev sqlite line, built my sql and got the
same error.
I have since built according to the exact instructions that he built
by (using Fedora packages) and I still get the error.
On Feb 18, 4:00 pm, percious <[EMAIL PROTECTED]> wrote:
> have you tried your code on sqlite? Perhaps there is a problem with
> your mysql server. What is similar between the three oses? are you
> trying to hook to the same mysql server?
>
> -chris
>
> On Feb 18, 2:03 pm, lorax <[EMAIL PROTECTED]> wrote:
>
> > I now get the same behaviour on Ubuntu, Windows XP, and Fedora Core
> > 8 :-(...
>
> > Can anyone who has this working properly tell me how they installed
> > turbogears?
>
> > I basically use 'python tgsetup.py' and then easy_install the rest of
> > the components:
> > SQLObject
> > SQLAlchemy
> > Elixir
> > ToscaWidgets
> > Genshi
> > gsquickstart
>
> > This must have to do with the way I'm installing. The exact project
> > (with config) works for others but not me.
>
> > Help please? This is my last resort.
>
> > On Feb 16, 2:33 pm, lorax <[EMAIL PROTECTED]> wrote:
>
> > > Get this.. Another person on IRC took my code (with the flush) and ran
> > > it fine. I downloaded the entire project that he build and I still
> > > get the error. I get the error with mysql and sqlite. His worked on
> > > mysql and sqlite.
>
> > > He had (on fedora):
> > > cherrypy-2.3.0, TurboGears-1.0.4.2, sqlalchemy-0.4.2-1.p3,
> > > python-2.5.1, mysql-server-5.0.45-6.fc8, MySQL-python-1.2.2-4.fc8
>
> > > I have (on ubuntu):
> > > CherryPy-2.3.0, TG 1.0.4.3-py2.5, SQLAlchemy-0.4.2p3
>
> > > I get the error on windows with mysql as well. I'm starting to think
> > > something of mine didn't easy_install properly.. That's the only thing
> > > I can think of.
>
> > > On Feb 15, 8:33 am, lorax <[EMAIL PROTECTED]> wrote:
>
> > > > I had checked the config files for anything to do with transactions..
> > > > or transactions being disabled. I couldn't find anything.. I know
> > > > with SQLObject there was the 'notrans_' option in the connect string
> > > > but with sqlalchemy there is nothing about configuring transactions.
> > > > I also searched the forum and the documentation for anything to do
> > > > with a transaction config option and found nothing.
>
> > > > I did try session.commit(). I get an error that commit doesn't exist.
>
> > > > I'll try the manual thing tonight. I hope it provides some clue!
>
> > > > On Feb 14, 10:33 pm, "Kevin Horn" <[EMAIL PROTECTED]> wrote:
>
> > > > > On Thu, Feb 14, 2008 at 8:54 PM, lorax <[EMAIL PROTECTED]> wrote:
>
> > > > > > I have the exact same problem with Elixir + sqlalchemy. :-(
>
> > > > > > On Feb 14, 3:05 pm, lorax <[EMAIL PROTECTED]> wrote:
> > > > > > > Ok a few people have recommended that I go with Elixir now, so I'm
> > > > > > > going to give that a shot. I hope it works because I really want
> > > > > > > TG
> > > > > > > to work out for me!
>
> > > > > > > On Feb 14, 9:36 am, lorax <[EMAIL PROTECTED]> wrote:
>
> > > > > > > > Ok I'm starting to wonder if I've found a bug in Turbogears
> > > > > > > > and/or
> > > > > > > > sqlalchemy. I decided to start with a fresh project and add
> > > > > > > > only the
> > > > > > > > required pieces so I could test this. I'm still getting an
> > > > > > > > error when
> > > > > > > > I execute session.flush().
>
> > > > > > > > I started with the following:
> > > > > > > > tg-admin quickstart --sqlalchemy -t tgbig snifflemap
>
> > > > > > > > Then I added a 'widgets' folder with login_widgets.py
> > > > > > > > containing the
> > > > > > > > following:
>
> > > > > > > > from turbogears import widgets,validators
>
> > > > > > > > class registrationFields(widgets.WidgetsList):
> > > > > > > > user_id = widgets.TextField('user_id', label="User ID")
> > > > > > > > password = widgets.PasswordField('password',
> > > > > > > > label="Password")
> > > > > > > > password_verify = widgets.PasswordField('password_verify',
> > > > > > > > label="Verify Password")
> > > > > > > > first_name = widgets.TextField('first_name', label="First
> > > > > > > > Name")
> > > > > > > > last_name = widgets.TextField('last_name', label="Last
> > > > > > > > Name")
> > > > > > > > email = widgets.TextField('email', label="Email Address")
>
> > > > > > > > class registrationFormSchema(validators.Schema):
> > > > > > > > user_id = validators.UnicodeString(not_empty=True)
> > > > > > > > password = validators.UnicodeString(not_empty=True)
> > > > > > > > password_verify = validators.UnicodeString(not_empty=True)
> > > > > > > > first_name = validators.UnicodeString(not_empty=True)
> > > > > > > > last_name = validators.UnicodeString(not_empty=True)
> > > > > > > > email = validators.Email(not_empty=True)
> > > > > > > > chained_validators = [
> > > > > > > > validators.FieldsMatch('password','password_verify')
> > > > > > > > ]
>
> > > > > > > > registration_form = widgets.TableForm(
> > > > > > > > fields=registrationFields(),
> > > > > > > > action="process_registration",
> > > > > > > > validator=registrationFormSchema()
> > > > > > > > )
>
> > > > > > > > I added a register.kid to templates, containing:
>
> > > > > > > > <body>
> > > > > > > > <div id="content">
> > > > > > > > ${form.display()}
> > > > > > > > </div>
> > > > > > > > </body>
>
> > > > > > > > Finally, to root.py I added a couple imports and registration
> > > > > > > > functions:
>
> > > > > > > > from snifflemap.widgets import login_widgets
> > > > > > > > from snifflemap.model import User
> > > > > > > > from turbogears.database import session
>
> > > > > > > > @expose(template="snifflemap.templates.register")
> > > > > > > > def register(self):
> > > > > > > > return (dict(form=login_widgets.registration_form))
>
> > > > > > > > @expose()
> > > > > > > > def process_registration(self, **data):
> > > > > > > > user=User()
> > > > > > > > user.user_name = data['user_id']
> > > > > > > > user.email_address = data['email']
> > > > > > > > user.password = data['password']
> > > > > > > > session.save(user)
> > > > > > > > try:
> > > > > > > > session.flush()
> > > > > > > > except:
> > > > > > > > flash('There was an error!')
> > > > > > > > raise redirect('/')
>
> > > > > > > > When I include the flush as above, I get the following error in
> > > > > > > > my
> > > > > > > > browser:
> > > > > > > > File "c:\python25\lib\site-packages\sqlalchemy-0.4.2p3-py2.5.egg
> > > > > > > > \sqlalchemy\orm\session.py", line 489, in commit
> > > > > > > > raise exceptions.InvalidRequestError("No transaction is
> > > > > > > > begun.")
> > > > > > > > InvalidRequestError: No transaction is begun
>
> > > > > > > > If I do not include the flush, I cannot trap the exception
> > > > > > > > (IntegrityError) which occurs after I duplicate a user record.
>
> > > > > > > > Is this a bug?
>
> > > > > > > > On Feb 13, 8:39 pm, lorax <[EMAIL PROTECTED]> wrote:
>
> > > > > > > > > I converted my tables to innodb and no luck. I still miss the
> > > > > > > > > exception without the session.flush() and get a 'no open
> > > > > > transaction'
> > > > > > > > > error if I add the session.flush().
>
> > > > > > > > > On Feb 13, 1:20 pm, lorax <[EMAIL PROTECTED]> wrote:
>
> > > > > > > > > > I'm having trouble trapping an IntegrityError with
> > > > > > > > > > sqlalchemy. I
> > > > > > have
> > > > > > > > > > the following:
>
> > > > > > > > > > from turbogears.database import session
> > > > > > > > > > from myproject.model import User
>
> > > > > > > > > > user = User()
> > > > > > > > > > user.user_name = "Harry"
> > > > > > > > > > user.password = "mypass"
>
> > > > > > > > > > try:
> > > > > > > > > > session.save(user)
> > > > > > > > > > except:
> > > > > > > > > > flash("Duplicate entry!")
> > > > > > > > > > raise redirect ("register")
>
> > > > > > > > > > ..but it doesn't catch the error and it comes back to me in
> > > > > > > > > > the
> > > > > > > > > > browser. I tried adding a session.flush() in the try block
> > > > > > > > > > but
> > > > > > there
> > > > > > > > > > is an error about no transaction being created. I'm
> > > > > > > > > > assuming that
> > > > > > is
> > > > > > > > > > because I'm using mysql myISAM
>
> > > > > > > > > > Can anyone help? Thanks so much.
>
> > > > > Not sure whether this will help, but I think you should double-check
> > > > > the
> > > > > following
>
> > > > > 1) make sure automatic transaction wrapping is turned on. There
> > > > > should be a
> > > > > config option for this...not sur ewhat itis off the top of my head
> > > > > though
> > > > > 2) have you tried manually creating the transaction? that might give
> > > > > you a
> > > > > clue. could the creation of the transaction be failing somehow, so
> > > > > that it
> > > > > isn't there when you call flush()?
> > > > > 3) maybe try session.commit() instead of flush()? not sure if that
> > > > > will do
> > > > > any good.
>
> > > > > I'm really not a SQLAlchemy expert...
>
> > > > > Kevin Horn
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---
