Hello-

My apologies if this is a really stupid question, but I'm not sure
where else to turn. I am working through the Definitive Guide to
Pylons book (which is fantastic on all kinds of levels), and
everything has been going swimmingly until the last part of the
tutorial in chapter 14 - basically all the section stuff. I have
gotten up to the point of getting everything except the routing
implemented, and went to test adding sections and pages, and every
time I get an error on the create/save stuff, along the lines of:

InterfaceError: (InterfaceError) Error binding parameter 1 - probably
unsupported type. u'SELECT nav.id AS nav_id, nav.name AS nav_name,
nav.path AS nav_path, nav.section AS nav_section, nav."before" AS
nav_before, nav.type AS nav_type \nFROM nav \nWHERE nav.path = ? AND
nav.section = ? AND nav.type = ?
\n LIMIT 1 OFFSET 0' [u'john', ['section'], 'page']

So obviously something wonky with the query to sqlalchemy.

So to see if I can figure out what is going on, I run both the last
example in the Chapter 14 files (SimpleSite28) and also the
downloadable chapter files from the pylons book site.

And I still get the error, even on these apps! So I'm not sure what I
should be looking for here - not savvy enough to decipher the query
issue unfortunately. Also, even though the 'complete' apps should have
routing fully implemented, in my experience these don't work as
expected either. Downloading the sample code, deleting the provided
db, and running the paster setup-app development.ini creates a new
site with the websetup.py pages added, as expected, but the routing
still doesn't work: 127.0.0.1:5000 returns a 404 page, while 127.0.0.1/
page/view/6 works as expected.

Again, my apologies if this is the wrong place to ask. Any thoughts or
assistance would be greatly appreciated.
-Eric

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"pylons-discuss" 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/pylons-discuss?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to