Nevermind, I figured it out. My format string was wrong. After fixing that, 
everything works.

On Thursday, January 9, 2014 4:42:01 PM UTC-5, Apple Mason wrote:
>
> My many-to-many table is throwing an error every time I access that table 
> in the admin page:
>
> <type 'exceptions.ValueError'> incomplete format
>
> Traceback (most recent call last):
>   File "/home/apl/Desktop/web2py/gluon/restricted.py", line 217, in 
> restricted
>     exec ccode in environment
>   File 
> "/home/apl/Desktop/web2py/applications/testapp/views/appadmin.html", line 
> 189, in <module>
>     </p>
>   File "/home/apl/Desktop/web2py/gluon/sqlhtml.py", line 2917, in __init__
>     r = A(represent(field, r, record), _href=str(href))
>   File "/home/apl/Desktop/web2py/gluon/sqlhtml.py", line 56, in represent
>     return f(value)
>   File "/home/apl/Desktop/web2py/gluon/dal.py", line 6966, in repr_ref
>     def repr_ref(id, row=None, r=referenced, f=ff): return f(r, id)
>   File "/home/apl/Desktop/web2py/gluon/dal.py", line 6939, in ff
>     return r._format % row
> ValueError: incomplete format
>
> Here is the gist of what I'm trying to do:
>
> db.category.bulk_insert([ {'title':'category1'} ])
> db.subcategory.bulk_insert([ {'title':'subcategory1'} ])
>
> # This part will throw an error when visiting the admin page for this table
> db.category_subcategory.bulk_insert([ {'category_id':1L, 
> 'subcategory_id':1L} ])
>
> My db has these fields:
>
> category: name Field
> subcategory: name Field
> category_subcategory: category_id Field, subcategory_id Field.
>
> Why am I getting this error?
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to