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
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
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
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)
-
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
-
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
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
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:
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
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
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
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
12 matches
Mail list logo