Thank you Jim, so much On Saturday, August 1, 2020 at 5:08:22 PM UTC+2, Jim S wrote: > > I am definitely not an expert on this, but it looks to me like you have > some data in one of your tables that python cannot pickle. I'm guessing > you have some unicode characters that snuck into your db. Can you write a > quick python script to scan through the data in all your tables to see > which records won't pickle? > > -Jim > > On Saturday, August 1, 2020 at 12:23:04 AM UTC-5, mostwanted wrote: >> >> Hey Jim, thats the traceback below: >> Traceback >> >> 1. >> 2. >> 3. >> 4. >> 5. >> 6. >> 7. >> 8. >> 9. >> 10. >> 11. >> 12. >> 13. >> 14. >> 15. >> 16. >> 17. >> >> Traceback (most recent call last): >> File "C:\Users\Maswabi\Desktop\WEB2PY >> APPLICATIONS\web2py-2.20.4\gluon\restricted.py", line 219, in restricted >> exec(ccode, environment) >> File "C:/Users/Maswabi/Desktop/WEB2PY >> APPLICATIONS/web2py-2.20.4/applications/wah/models/dbmanaq.py" >> <http://127.0.0.1:8000/admin/default/edit/wah/models/dbmanaq.py>, line 54, >> in <module> >> format='%(product)s') >> File "C:\Users\Maswabi\Desktop\WEB2PY >> APPLICATIONS\web2py-2.20.4\gluon\packages\dal\pydal\base.py", line 657, in >> define_table >> table = self.lazy_define_table(tablename, *fields, **kwargs) >> File "C:\Users\Maswabi\Desktop\WEB2PY >> APPLICATIONS\web2py-2.20.4\gluon\packages\dal\pydal\base.py", line 698, in >> lazy_define_table >> polymodel=polymodel, >> File "C:\Users\Maswabi\Desktop\WEB2PY >> APPLICATIONS\web2py-2.20.4\gluon\packages\dal\pydal\adapters\base.py", line >> 913, in create_table >> return self.migrator.create_table(*args, **kwargs) >> File "C:\Users\Maswabi\Desktop\WEB2PY >> APPLICATIONS\web2py-2.20.4\gluon\packages\dal\pydal\migrator.py", line 323, >> in create_table >> sql_fields_old = pickle.load(tfile) >> File "pickle.py", line 1384, in load >> File "pickle.py", line 864, in load >> KeyError: '\x00' >> >> >> I really wanna fully understand this error & the best way to solve it >> because I have encountered it in the past & it always became a struggle, it >> turned into a nightmare that I started to dread it with every application i >> developed especially standalone applications which can be affected by >> sudden powercuts in computers without UPS or laptops with batter batteries! >> >> On Friday, July 31, 2020 at 8:12:10 PM UTC+2, Jim S wrote: >>> >>> Can you post a more complete traceback? >>> >>> >>> >>> On Friday, July 31, 2020 at 11:16:12 AM UTC-5, mostwanted wrote: >>>> >>>> Hi guys, *t*oday I encountered this error*: <type >>>> 'exceptions.KeyError'> '\x00'*, I think it occured during shut down >>>> because wheni rebooted my laptop it was there, in chapter 6 of the book >>>> (fixing migrations) it says we should add* db.define_table(...., >>>> migrate=True, fake_migrate=True) *but when I did that the error still >>>> persists it doesnt go anywhere, I then added *migrate=False *alone in >>>> the tables that came up in the issued TICKETS and the app was good and >>>> running, why is this and what is the difference between >>>> adding *db.define_table(...., migrate=True, fake_migrate=True) and *just >>>> adding >>>> >>>> *db* >>>> >>>> >>>> *.define_table(...., migrate=True)?*Regards; >>>> >>>> >>>> Mostwanted >>>> >>>>
-- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/3ac56427-a81d-40fd-8266-29562c8471d4o%40googlegroups.com.