With beta1 I'm getting an error with the quickstart project against
Oracle, which doesn't happen against sqllite.
When accessing the root index page I get an error page caused by the
following auth-related query:
SELECT at_user_password, at_user_user_id, at_user_user_name,
at_user_email_address, at_user_display_name, at_user_created \nFROM
(SELECT at_user.password AS at_user_password, at_user.user_id AS
at_user_user_id, at_user.user_name AS at_user_user_name,
at_user.email_address AS at_user_email_address, at_user.display_name
AS at_user_display_name, at_user.created AS at_user_created,
ROW_NUMBER() OVER (ORDER BY at_user.rowid) AS ora_rn \nFROM at_user
\nWHERE at_user.user_name = :user_name_1) \nWHERE ora_rn>0 AND
ora_rn<=2' {'user_name_1': 250}
Notice the numeric value being passed for user_name_1, which causes
Oracle to balk.
This was a pure quickstart project, with only the connection url
changed in development.ini, plus the following modifications to
auth.py to support Oracle:
- removed the onupdate="CASCADE" args which would cause an error
since Oracle doesn't support cascade updates
- added Sequence() declarations in the pk's so primary key values
can be autogenerated
Where did the 250 value come from for the user_name?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears Trunk" 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-trunk?hl=en
-~----------~----~----~----~------~----~------~--~---
