This is a bug that was fixed: http://code.google.com/p/web2py/issues/detail?id=647
Try trunk. Anthony On Wednesday, August 22, 2012 4:44:13 PM UTC-4, Mike Girard wrote: > > Traceback (most recent call last): > > File "/Applications/web2pystable/gluon/restricted.py", line 205, in > restricted > > exec ccode in environment > File "/Applications/web2pystable/applications/myapp/controllers/default.py" > <http://127.0.0.1:8000/admin/default/edit/movietooth/controllers/default.py>, > line 199, in <module> > > File "/Applications/web2pystable/gluon/globals.py", line 173, in <lambda> > > self._caller = lambda f: f() > > File "/Applications/web2pystable/applications/myapp/controllers/default.py" > <http://127.0.0.1:8000/admin/default/edit/movietooth/controllers/default.py>, > line 44, in load_data > > rows = parse_and_load() > File "/Applications/web2pystable/applications/myapp/models/movie.py" > <http://127.0.0.1:8000/admin/default/edit/movietooth/models/movie.py>, line > 246, in parse_and_load > > msg = db.movie.validate_and_insert(**movie) > > File "/Applications/web2pystable/gluon/dal.py", line 6836, in > validate_and_insert > > value,error = self[key].validate(value) > > File "/Applications/web2pystable/gluon/dal.py", line 7434, in validate > > (value, error) = validator(value) > > File "/Applications/web2pystable/gluon/validators.py", line 484, in __call__ > > if not [x for x in values if not str(x) in self.theset]: > TypeError: argument of type 'NoneType' is not iterable > > > On Wed, Aug 22, 2012 at 4:36 PM, Anthony <abas...@gmail.com > <javascript:>>wrote: > >> Can you show the actual traceback so we can see where the code is >> failing? Perhaps the problem is in the field validator. >> >> Anthony >> >> >> On Wednesday, August 22, 2012 4:10:40 PM UTC-4, Mike Girard wrote: >>> >>> Yeah, I get the references directly from the genre/person tables before >>> inserting them in movie. I also test to make sure the item being inserted >>> is a list with data. Printing contents after the error shows nothing odd. >>> >>> I have tested this in both Postgres and SQLlite. Same thing happens in >>> both. >>> >>> >>> >>> On Wednesday, August 22, 2012 3:45:31 PM UTC-4, villas wrote: >>>> >>>> Did you try checking that all the references exist? >>>> So, maybe it is a referential integrity problem. >>>> You are prob not using Sqlite but a proper DB. >>>> Just ideas, D >>>> >>>> >>>> On Wednesday, August 22, 2012 8:23:23 PM UTC+1, Mike Girard wrote: >>>>> >>>>> Yeah. A result of switching it off and then back on. >>>>> >>>>> Good catch. >>>>> >>>>> On Wed, Aug 22, 2012 at 3:19 PM, Anthony <abas...@gmail.com> wrote: >>>>> >>>>>> I assume this is a typo too, but just to be sure: >>>>>> >>>>>> Field('genres','string','list:**reference genre', ... >>>>>> >>>>>> You have both 'string' and 'list:reference' there. >>>>>> >>>>>> Anthony >>>>>> >>>>>> >>>>>> On Wednesday, August 22, 2012 2:49:29 PM UTC-4, Mike Girard wrote: >>>>>> >>>>>>> I have written a script to parse a large xml file and insert the >>>>>>> contents in to my app db. I am using lxml. >>>>>>> >>>>>>> After about 10 records get inserted, the script fails with >>>>>>> <type 'exceptions.TypeError'> argument of type 'NoneType' is not >>>>>>> iterable >>>>>>> >>>>>>> Troubleshooting determined the following: >>>>>>> >>>>>>> 1. This error is associated with 3 list:reference fields. When I >>>>>>> remove them from the script, the script executes uneventfully. If any >>>>>>> one >>>>>>> of them is included, it fails. >>>>>>> 2. This only happens after 10 records have been successfully >>>>>>> inserted. >>>>>>> 3. There is no discernible difference between the records that get >>>>>>> successfully added and those that don't. The error happens even when I >>>>>>> hard >>>>>>> code the lists for the list:reference field. It seems to be associated >>>>>>> with >>>>>>> number of records, rather than which records. >>>>>>> 4. The script executes successfully when I change the field types >>>>>>> from 'list:reference' to 'string' and insert strings instead of lists. >>>>>>> You >>>>>>> should not assume from this that there is a data issue. As I said, >>>>>>> hardcoded lists get rejected also. I am 99% certain valid data is not >>>>>>> the >>>>>>> issue. >>>>>>> 5. This happens in both SQLLite and Postgres >>>>>>> >>>>>>> Here is the model declaration for one of the three fields. They are >>>>>>> all analogous: >>>>>>> >>>>>>> Field('genres','string','list:****reference genre', >>>>>>> requires=IS_IN_DB(db, 'genre.id', '%(name)s [%(id)s]', >>>>>>> multiple=True)) >>>>>>> >>>>>>> Here is how I update each new row in the the database: >>>>>>> >>>>>>> db.movies.validate_and_insert(******movie) (movie is a dict) >>>>>>> >>>>>>> Here is how I hardcoded values into the fields: movie['genre'] = >>>>>>> {456, 368, 239] >>>>>>> >>>>>>> Now, if someone doesn't have a solution, can they tell me if I can >>>>>>> >>>>>>> 1.Programmatically remove the list:reference from the model prior to >>>>>>> data updates and programmatically restore it afterwards? >>>>>>> 2. Retain all the functionality of these fields by toggling this >>>>>>> way? >>>>>>> >>>>>>> Seriously considering going the join table route and skipping the >>>>>>> list reference fields. Are there any gotchas there? >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>>> -- >> >> >> >> > > --
