[web2py] Re: web2py broken with Python 3.8
Hi Jim I think you are understanding it correctly, there isn't enough explicit info to give you enough reassurance.about moving to 3.8. I do not use 3.8 myself, but if Massimo says it works, then I assume it now does, but you still have to test your own app in your own environment. As you say, hopefully any 3.8 users might chip in here with something more specific. I usually check the Github issues if I'm concerned about general bugs. -- 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/9eb26cc5-7824-4ceb-a735-0f7d511df51f%40googlegroups.com.
[web2py] Re: web2py broken with Python 3.8
Hi Villas, Then I'm confused... I've got 15k+ lines of reasonably complex web2py based Python 3.7.6 code. I'm thinking ahead to when it would be wise/necessary to migrate to 3.8 Massimo said "Both web2py and py4web are currently incompatible with python 3.8" (beginning of December) and later said "Works for me right now." (middle of January). He explained the reasons for the problems and I interpreted his second note as implying he fixed things. My question is - if there were code changes to accommodate the 3.8 incompatibilities, how does one access them given that the official version of web2py hasn't changed in nearly a year ? Was also hoping that Woody would respond to say if he tried it, as he planned to, and what the outcome was Am I misunderstanding something? Thanks On Thursday, March 12, 2020 at 11:19:57 AM UTC-7, villas wrote: > > web2py itself is designed to work on both versions of python. > > > > -- 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/ac57c0a7-60e9-4e9c-bb17-77aa3b8d4ce2%40googlegroups.com.
[web2py] Re: web2py broken with Python 3.8
web2py itself is designed to work on both versions of python. Perhaps it goes without saying, any code that you write yourself must be compatible with the python that you are targeting. -- 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/e24f7d7d-bdbd-4a93-ae97-adca603588d3%40googlegroups.com.
[web2py] Re: web2py broken with Python 3.8
Hi, How does one access the changes made in web2py to use Python 3.8? when I fire it up it tells me its up-to-date with 2.18.5-stable+timestamp.2019.04.08.04.22.03 I presume that version doesn't have the changes ?? Thanks On Friday, March 6, 2020 at 2:26:10 PM UTC-8, jim kaubisch wrote: > > What was the result of 3.8 for you when you tried it? > > On Wednesday, January 15, 2020 at 9:36:55 AM UTC-8, Woody wrote: >> >> Good news! I'll give it a try. >> >> On Friday, December 6, 2019 at 10:56:48 AM UTC-5, Woody wrote: >>> >>> web2py is broken with Python 3.8. I asked a question about this a few >>> days ago and was told that it would be fixed. Looking at the open issues >>> for w2p, I don't see open issues related to fixing these incompatibilities. >>> I would be interested in some discussion about specifically what the >>> incompatibilities are, which open issues are addressing these problems and >>> the time frame to fix. What's the scale of these problems? Is it possible >>> to manually patch the problems? >>> >> -- 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/0eab61e1-6cce-46b6-bb8d-d25844247d3f%40googlegroups.com.
[web2py] Re: web2py broken with Python 3.8
What was the result of 3.8 for you when you tried it? On Wednesday, January 15, 2020 at 9:36:55 AM UTC-8, Woody wrote: > > Good news! I'll give it a try. > > On Friday, December 6, 2019 at 10:56:48 AM UTC-5, Woody wrote: >> >> web2py is broken with Python 3.8. I asked a question about this a few >> days ago and was told that it would be fixed. Looking at the open issues >> for w2p, I don't see open issues related to fixing these incompatibilities. >> I would be interested in some discussion about specifically what the >> incompatibilities are, which open issues are addressing these problems and >> the time frame to fix. What's the scale of these problems? Is it possible >> to manually patch the problems? >> > -- 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/ba69-c27c-42ae-b53d-2cf8648e3e44%40googlegroups.com.
[web2py] Re: web2py broken with Python 3.8
Good news! I'll give it a try. On Friday, December 6, 2019 at 10:56:48 AM UTC-5, Woody wrote: > > web2py is broken with Python 3.8. I asked a question about this a few days > ago and was told that it would be fixed. Looking at the open issues for > w2p, I don't see open issues related to fixing these incompatibilities. I > would be interested in some discussion about specifically what the > incompatibilities are, which open issues are addressing these problems and > the time frame to fix. What's the scale of these problems? Is it possible > to manually patch the problems? > -- 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/01441dad-ce91-4d97-b160-3ad9f1185625%40googlegroups.com.
[web2py] Re: web2py broken with Python 3.8
Works for me right now. On Monday, 6 January 2020 14:41:42 UTC-8, Woody wrote: > > Any update on when web2py will be compatible with Python 3.8? > > On Sunday, December 8, 2019 at 2:59:49 AM UTC-5, Massimo Di Pierro wrote: >> >> Both web2py and py4web are currently incompatible with python 3.8 because >> the latter break backward compatibility again. One of the issue is that >> stream-like objects are now required to support more methods than they used >> to. Another issue I am trying to get to the bottom of has to do with >> pickling. I will try fix this over the week-end. It is a priority. >> >> On Friday, 6 December 2019 07:56:48 UTC-8, Woody wrote: >>> >>> web2py is broken with Python 3.8. I asked a question about this a few >>> days ago and was told that it would be fixed. Looking at the open issues >>> for w2p, I don't see open issues related to fixing these incompatibilities. >>> I would be interested in some discussion about specifically what the >>> incompatibilities are, which open issues are addressing these problems and >>> the time frame to fix. What's the scale of these problems? Is it possible >>> to manually patch the problems? >>> >> -- 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/042e8423-306d-4a90-82ac-f87fdc49607f%40googlegroups.com.
[web2py] Re: web2py broken with Python 3.8
Any update on when web2py will be compatible with Python 3.8? On Sunday, December 8, 2019 at 2:59:49 AM UTC-5, Massimo Di Pierro wrote: > > Both web2py and py4web are currently incompatible with python 3.8 because > the latter break backward compatibility again. One of the issue is that > stream-like objects are now required to support more methods than they used > to. Another issue I am trying to get to the bottom of has to do with > pickling. I will try fix this over the week-end. It is a priority. > > On Friday, 6 December 2019 07:56:48 UTC-8, Woody wrote: >> >> web2py is broken with Python 3.8. I asked a question about this a few >> days ago and was told that it would be fixed. Looking at the open issues >> for w2p, I don't see open issues related to fixing these incompatibilities. >> I would be interested in some discussion about specifically what the >> incompatibilities are, which open issues are addressing these problems and >> the time frame to fix. What's the scale of these problems? Is it possible >> to manually patch the problems? >> > -- 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/08699b10-57fa-4b16-b76c-311ac0e560b5%40googlegroups.com.
[web2py] Re: web2py broken with Python 3.8
Both web2py and py4web are currently incompatible with python 3.8 because the latter break backward compatibility again. One of the issue is that stream-like objects are now required to support more methods than they used to. Another issue I am trying to get to the bottom of has to do with pickling. I will try fix this over the week-end. It is a priority. On Friday, 6 December 2019 07:56:48 UTC-8, Woody wrote: > > web2py is broken with Python 3.8. I asked a question about this a few days > ago and was told that it would be fixed. Looking at the open issues for > w2p, I don't see open issues related to fixing these incompatibilities. I > would be interested in some discussion about specifically what the > incompatibilities are, which open issues are addressing these problems and > the time frame to fix. What's the scale of these problems? Is it possible > to manually patch the problems? > -- 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/823dd2c6-4bd4-46ce-b4c6-44c01f9b9f2e%40googlegroups.com.
Re: [web2py] Re: web2py broken
still not sure where problem is in web2py part or in database sqlite part just an idea, why not separate the root cause first. in dev or testing environment, 1. use the same web2py app, with new database (test crud work or not). if work, then the problem probably is in database part 2. just follow anthony suggestion above to test your database using pure python (not just connection, but the query one (crud, pls backup your database before doing this in dev or testing environment), if work, then the problem probably is in web2py part 3. if 2 step above is work separately, then the problem probably is with your os (permission, security (selinux, etc) ) best regards, stifan -- 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/d/optout.
Re: [web2py] Re: web2py broken
well in windows (home pc) I got full access for myself, system, admin and authenticated users. on my linux server I got the following: -rw-r--r-- 1 www-data www-data but never the less it doesn't work on either system. Any other idea? On Sunday, August 12, 2018 at 12:44:10 PM UTC+2, Junior Phanter wrote: > > check the database permissions... > > Em 12/08/2018 06:14, "BlueShadow" > > escreveu: > > Do you guys have any tips what I can try next in order to fix it? > Do you need to see other files? > thanks for your help kind regards > BlueShadow > > -- > 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+un...@googlegroups.com . > For more options, visit https://groups.google.com/d/optout. > > > -- 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/d/optout.
Re: [web2py] Re: web2py broken
check the database permissions... Em 12/08/2018 06:14, "BlueShadow" escreveu: Do you guys have any tips what I can try next in order to fix it? Do you need to see other files? thanks for your help kind regards BlueShadow -- 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/d/optout. -- 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/d/optout.
Re: [web2py] Re: web2py broken
Do you guys have any tips what I can try next in order to fix it? Do you need to see other files? thanks for your help kind regards BlueShadow -- 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/d/optout.
Re: [web2py] Re: web2py broken
So I tried to connect on python. and it seems to work. I wrote this tiny program: import sqlite3 conn = sqlite3.connect('storage.sqlite') print(conn) c = conn.cursor() c.close() this is the output: So I guess it has nothing to do with a corrupted database. -- 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/d/optout.
Re: [web2py] Re: web2py broken
here is my menu.py: # -*- coding: utf-8 -*- # this file is released under public domain and you can use without limitations # ## Customize your APP title, subtitle and menus here # response.title = ' '.join(word.capitalize() for word in request.application. split('_')) response.subtitle = T('customize me!') ## read more at http://dev.w3.org/html5/markup/meta.name.html response.meta.author = 'xxx' response.meta.description = 'xxx' response.meta.keywords = 'xxx' response.meta.generator = 'Web2py Web Framework' #response.meta.copyright = 'Copyright 2012-'+str(datetime.datetime.now().year) ## your http://google.com/analytics id response.google_analytics_id = "xxx" # ## this is the main application menu add/remove items as required # response.menu = [ ('', False,A('START',_href=URL('default','index'),_title="Zurück zur Startseite"), []), ('', False,A('ARTIKEL', _href=URL('default','Articles'), _title="Liste aller Artikel"), []), ('', False,A('FILME', _href=URL('default','Movies'),_title="Liste aller Filme"), []), ('', False,A('KRITIKEN', _href=URL('default','Reviews'), _title="Liste aller Kritiken"), []) ] # ## provide shortcuts for development. remove in production # def _(): # shortcuts app = request.application ctr = request.controller # useful links to internal and external resources response.menu+=[ (SPAN('INFOS',_style='color:white'),False, None, [ ('',False,A('Impressum', _href=URL(r=request,c='default' ,f='Impressum'), _title="Informationen zu Movie-Alarm, Haftungsausschluss" )), ('',False,A('Partnerschaft', _href=URL(r=request,c= 'default',f='Partner'), _title="Unsere Partnerseiten /Partner werden")), ('',False,A('Unterstütze MovieAlarm', _href=URL(r= request,c='default',f='SupportMovieAlarm'), _title="Informationen wie du dafür sorgen kannst das wir weiterhin gute inhalte für dich erstellen.")) ] ) ] #--Require Authorization- if auth.has_membership('Author'): response.menu+=[ (SPAN('AUTOREN',_style='color:yellow'),False, None, [ (T('Unfinished'),False,URL(r=request,c='author',f= 'unfinished')), (T('Neuen Artikel Anlegen'),False,URL(r=request,c= 'author',f='newArticle')), (T('Neues Review Schreiben'),False,URL(r=request,c= 'author',f='newReview')), (T('Neuen Film Anlegen'),False,URL(r=request,c='author', f='newMovie')), (T('Neues Bild'),False,URL(r=request,c='author',f= 'newImage')), (T('Hilfe für Autoren'),False,URL(r=request,c='manage',f ='Manuals')), (T('Anleitung Schreiben'),False,URL(r=request,c='manage' ,f='WriteManual')), (T('§ Infos zu Medien §'),False,URL(r=request,c='author' ,f='RInfos')) ] ) ] _() @anthony: I will look up how to connect to sqlite in python dbs and try it @stifan: I am not sure what the problem is. I will keep your solution in mind and try it tomorrow. -- 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/d/optout.
Re: [web2py] Re: web2py broken
if you sure the problem is with database sqlite file and your data is not corrupted (integrity checked database = OK) just an idea why not extract your data and put it on new database (sqlite or another dbms (recommended using export_to_csv_file() and import_from_csv_file() ) *# backup database* sqlite3 ~/web2py/applications/app/databases/app.sqlite .dump > ~/app.bak *# restore database* mv ~/web2py/applications/app/databases/app.sqlite ~/web2py/applications/app/databases/app.sqlite.old sqlite3 ~/web2py/applications/app/databases/app.sqlite < ~/app.bak another way is using web2py export_to_csv_file() then import_from_csv_file() *ref:* http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Exporting-and-importing-data best regards, stifan -- 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/d/optout.
Re: [web2py] Re: web2py broken
Are you able to connect to the database (either the one on your server or the copy you have downloaded to your machine) via a Python shell using https://docs.python.org/2/library/sqlite3.html (i.e., no web2py or DAL)? Anthony On Friday, August 10, 2018 at 11:00:43 AM UTC-4, BlueShadow wrote: > > Hi thanks for all the answers. > Just before I got your answers I found this article: > https://www.team-mediaportal.com/wiki/display/MediaPortal1/Repair+SQLite+Database > > which i followed to check the integrety of my database. and it says *OK* > @stifan: it is the last server backup. the last manual backup i did was in > 2016. (and I changed quite a bit since that time. > my db.py looks like this: > # -*- coding: utf-8 -*- > > # > ## This scaffolding model makes your app work on Google App Engine too > ## File is released under public domain and you can use without limitations > # > > ## if SSL/HTTPS is properly configured and you want all HTTP requests to > ## be redirected to HTTPS, uncomment the line below: > # request.requires_https() > import datetime > import os > from plugin_multiselect_widget import ( > hmultiselect_widget, vmultiselect_widget, > rhmultiselect_widget, rvmultiselect_widget, > ) > > #if not request.env.web2py_runtime_gae: > ## if NOT running on Google App Engine use SQLite or other DB > db = DAL('sqlite://storage.sqlite', migrate=False,lazy_tables=True) > try: > db.executesql("PRAGMA journal_mode=WAL;") > except: > pass > > response.generic_patterns = ['*'] if request.is_local else [] > > > > > > auth = Auth(db, hmac_key="I am not sharing the key") > #crud, service, plugins = Crud(db), Service(), PluginManager() > > ## append auth tables > auth.settings.extra_fields['auth_user']= [ > Field('username', unique=True,requires=IS_NOT_IN_DB(db, > 'auth_user.username')), > Field('address'), > Field('country','reference Land'), > Field('city'), > Field('zip'), > Field('favouritemovie'), > Field('birthday','date',requires=IS_DATE()), > Field('sex','reference Sex'), > Field('phone'), > Field('registration_date','datetime',default=datetime.datetime.now(), > writable=False,readable=False), > Field('newsletter','reference Newsletter') > ] > auth.settings.password_min_length = 5 > auth.settings.registration_requires_verification = True > > ## create all tables needed by auth if not custom tables > > db.define_table('Sex', > Field('Name'), > format = '%(Name)s' > ) > > db.define_table('Land', > Field('Name'), > format = '%(Name)s' > ) > """f = open('countries.txt', 'r')#for some weird reason > this does not work. > countries=f.readlines() > for c in countries: > db.Land.update_or_insert(Name=c) > > f.close()""" > db.define_table('Newsletter', > Field('Name'), > format = '%(Name)s' > ) > auth.define_tables(username=True, migrate=False) > > ## configure email > mail=auth.settings.mailer > mail.settings.server = 'logging' or 'smtp.gmail.com:587' > mail.settings.sender = 'y...@gmail.com' > mail.settings.login = 'username:password' > > ## configure auth policy > auth.settings.registration_requires_verification = False > auth.settings.registration_requires_approval = False > auth.settings.reset_password_requires_verification = True > > ## if you need to use OpenID, Facebook, MySpace, Twitter, Linkedin, etc. > ## register with janrain.com, write your domain:api_key in > private/janrain.key > from gluon.contrib.login_methods.rpx_account import use_janrain > use_janrain(auth,filename='private/janrain.key') > > > db.define_table('myerror', > Field('Time','datetime',default=datetime.datetime.now()), > Field('code','integer'), > Field('request_URL'), > Field('client'), > Field('useragent'), > ) > > > db.define_table('Sort', > Field('Name'), > format = '%(Name)s' > ) > db.Sort.Name.requires = [IS_NOT_EMPTY(), IS_NOT_IN_DB(db, 'Sort.Name')] > > > db.define_table('Genre', > Field('Name'), > format = '%(Name)s' > ) > db.Genre.Name.requires = [IS_NOT_EMPTY(), IS_NOT_IN_DB(db, 'Genre.Name')] > > db.define_table('Category', > Field('Name'), > format = '%(Name)s' > ) > db.Category.Name.requires = [IS_NOT_EMPTY(), IS_NOT_IN_DB(db, > 'Category.Name')] > > > db.Land.Name.requires=[IS_NOT_EMPTY(),IS_NOT_IN_DB(db,'Land.Name')] > > > > db.define_table('Quelle', > Field('Name',length=512), > Field('Copyrightline',length=512), > Field('URL',length=512), > Field('Nutzungsbedingungen','text') > ) > > > db.define_table('Images', > Field('Bildunterschrift'
Re: [web2py] Re: web2py broken
What about menu.py? Can we see that? -Jim On Friday, August 10, 2018 at 10:00:43 AM UTC-5, BlueShadow wrote: > > Hi thanks for all the answers. > Just before I got your answers I found this article: > https://www.team-mediaportal.com/wiki/display/MediaPortal1/Repair+SQLite+Database > > which i followed to check the integrety of my database. and it says *OK* > @stifan: it is the last server backup. the last manual backup i did was in > 2016. (and I changed quite a bit since that time. > my db.py looks like this: > # -*- coding: utf-8 -*- > > # > ## This scaffolding model makes your app work on Google App Engine too > ## File is released under public domain and you can use without limitations > # > > ## if SSL/HTTPS is properly configured and you want all HTTP requests to > ## be redirected to HTTPS, uncomment the line below: > # request.requires_https() > import datetime > import os > from plugin_multiselect_widget import ( > hmultiselect_widget, vmultiselect_widget, > rhmultiselect_widget, rvmultiselect_widget, > ) > > #if not request.env.web2py_runtime_gae: > ## if NOT running on Google App Engine use SQLite or other DB > db = DAL('sqlite://storage.sqlite', migrate=False,lazy_tables=True) > try: > db.executesql("PRAGMA journal_mode=WAL;") > except: > pass > > response.generic_patterns = ['*'] if request.is_local else [] > > > > > > auth = Auth(db, hmac_key="I am not sharing the key") > #crud, service, plugins = Crud(db), Service(), PluginManager() > > ## append auth tables > auth.settings.extra_fields['auth_user']= [ > Field('username', unique=True,requires=IS_NOT_IN_DB(db, > 'auth_user.username')), > Field('address'), > Field('country','reference Land'), > Field('city'), > Field('zip'), > Field('favouritemovie'), > Field('birthday','date',requires=IS_DATE()), > Field('sex','reference Sex'), > Field('phone'), > Field('registration_date','datetime',default=datetime.datetime.now(), > writable=False,readable=False), > Field('newsletter','reference Newsletter') > ] > auth.settings.password_min_length = 5 > auth.settings.registration_requires_verification = True > > ## create all tables needed by auth if not custom tables > > db.define_table('Sex', > Field('Name'), > format = '%(Name)s' > ) > > db.define_table('Land', > Field('Name'), > format = '%(Name)s' > ) > """f = open('countries.txt', 'r')#for some weird reason > this does not work. > countries=f.readlines() > for c in countries: > db.Land.update_or_insert(Name=c) > > f.close()""" > db.define_table('Newsletter', > Field('Name'), > format = '%(Name)s' > ) > auth.define_tables(username=True, migrate=False) > > ## configure email > mail=auth.settings.mailer > mail.settings.server = 'logging' or 'smtp.gmail.com:587' > mail.settings.sender = 'y...@gmail.com ' > mail.settings.login = 'username:password' > > ## configure auth policy > auth.settings.registration_requires_verification = False > auth.settings.registration_requires_approval = False > auth.settings.reset_password_requires_verification = True > > ## if you need to use OpenID, Facebook, MySpace, Twitter, Linkedin, etc. > ## register with janrain.com, write your domain:api_key in > private/janrain.key > from gluon.contrib.login_methods.rpx_account import use_janrain > use_janrain(auth,filename='private/janrain.key') > > > db.define_table('myerror', > Field('Time','datetime',default=datetime.datetime.now()), > Field('code','integer'), > Field('request_URL'), > Field('client'), > Field('useragent'), > ) > > > db.define_table('Sort', > Field('Name'), > format = '%(Name)s' > ) > db.Sort.Name.requires = [IS_NOT_EMPTY(), IS_NOT_IN_DB(db, 'Sort.Name')] > > > db.define_table('Genre', > Field('Name'), > format = '%(Name)s' > ) > db.Genre.Name.requires = [IS_NOT_EMPTY(), IS_NOT_IN_DB(db, 'Genre.Name')] > > db.define_table('Category', > Field('Name'), > format = '%(Name)s' > ) > db.Category.Name.requires = [IS_NOT_EMPTY(), IS_NOT_IN_DB(db, > 'Category.Name')] > > > db.Land.Name.requires=[IS_NOT_EMPTY(),IS_NOT_IN_DB(db,'Land.Name')] > > > > db.define_table('Quelle', > Field('Name',length=512), > Field('Copyrightline',length=512), > Field('URL',length=512), > Field('Nutzungsbedingungen','text') > ) > > > db.define_table('Images', > Field('Bildunterschrift',length=1024), > Field('Image','upload',uploadfolder=os.path.join(request.folder, > 'uploads/')), > Field('thumb','upload',writable=False,readable=False,uploadfolder=os. > path.
Re: [web2py] Re: web2py broken
Although I don't really use SQLite, I just noticed that I have "SQLite2009 Pro Enterprise Manager" on my Windows PC. For a better list of tools, try the SQLite website: https://www.sqlite.org/cvstrac/wiki?p=ManagementTools -- 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/d/optout.
[web2py] Re: web2py broken
you said your last backup is not work, is it on web2py app backup (*.py, etc) or database backup (something.sqlite or *.csv or *.sql) ? did you do incremental backup? if yes pls restore it one by one (date descending) to verify which one is work and the rest is same like the other's suggestion: - pls open sqlite database with the management tools - or change the database to another (export_to_csv sqlite database then import_to_csv to another database) best regards, stifan -- 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/d/optout.
Re: [web2py] Re: web2py broken
How much of your app/data can you share with us? What does db.py look like? -Jim On Friday, August 10, 2018 at 7:32:05 AM UTC-5, BlueShadow wrote: > > Hi thanks for the post villas. > I have the database on my local pc. (storage.sqlite) > I opened it with the tool db browser and it seems to be OK. At least I can > view all the tables and I checked a few entries which are still there. > Are there any tools you reccommend to verify and check it. > > I looked a little in the tables data and I found in addition to my 10 > users I was supposed to have there were roughly 100 more. with cryptic > names like qwertyuio... > So I might have been under an attack. I deleted those lines from my db. > but it still does not help. > > Any Idea why I can view it without a problem in this db browser but web2py > isn't showing it? > > > I tried to move away from sqlite some time ago, but I couldn't get it to > work, so I stuck with it Oo > -- 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/d/optout.
Re: [web2py] Re: web2py broken
Hi thanks for the post villas. I have the database on my local pc. (storage.sqlite) I opened it with the tool db browser and it seems to be OK. At least I can view all the tables and I checked a few entries which are still there. Are there any tools you reccommend to verify and check it. I looked a little in the tables data and I found in addition to my 10 users I was supposed to have there were roughly 100 more. with cryptic names like qwertyuio... So I might have been under an attack. I deleted those lines from my db. but it still does not help. Any Idea why I can view it without a problem in this db browser but web2py isn't showing it? I tried to move away from sqlite some time ago, but I couldn't get it to work, so I stuck with it Oo -- 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/d/optout.
[web2py] Re: web2py broken
Hi Blueshadow, I think I would first make a copy of the SQLite database file and then use SQLite tools to examine and verify its integrity. By the way, whilst I find SQLite very useful for new experimental apps, I would not advise using SQLite in a production environment. I believe you will easily find free SQLite tools available online. Best wishes. -- 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/d/optout.
[web2py] Re: web2py broken
No one? Did I give insufficient information? I really need some help with this Problem thanks guys. On Thursday, August 9, 2018 at 1:27:42 PM UTC+2, BlueShadow wrote: > > > I just downloaded my entire app. (with FTP since I can't access the > webinterface) Now when I try to run it locally on a web2py compiled server > (newest one directly from the site). I get the following error: > > 127.0.0.1.2018-08-09.13-16-30.9c125719-b261-4285-8a88-3012470558cc > file is encrypted or is not a database > > What do I need to do to get my database back? > It should be an sqlite database if I remember correctly. > -- 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/d/optout.
[web2py] Re: web2py broken
I just downloaded my entire app. (with FTP since I can't access the webinterface) Now when I try to run it locally on a web2py compiled server (newest one directly from the site). I get the following error: 127.0.0.1.2018-08-09.13-16-30.9c125719-b261-4285-8a88-3012470558cc file is encrypted or is not a database What do I need to do to get my database back? It should be an sqlite database if I remember correctly. -- 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/d/optout.