> > Is it possible you already have duplicate data in that column (e.g., > perhaps multiple empty strings)? What happens if you start with a fresh > application and database? >
thank you so much for your detail explaination, anthony, no duplicate data or multiple empty strings in that column, i've already start with a fresh application and database and correct my mistake by : 1. notnull=True is not work without requires=IS_NOT_EMPTY() i put requires, to validate user input in web form. 2. length is not work without requires=IS_LENGTH() i by pass it, because when i test the actual length of uuid is 47, and sometimes more than that, so i just remove length in uuid and it's requires 3. uuid is not work in unique=True it's work now after i start the new fresh installation. -- --- 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.