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
-~----------~----~----~----~------~----~------~--~---
