db.commit()
On Monday, 5 August 2013 10:39:50 UTC-5, mweissen wrote:
>
> I have made a new web2py installation on Ubuntu, using the script
> setup-web2py-ubuntu.sh
> web2py can be opened and admin shows:
> Version
>
> 2.5.1-stable+timestamp.2013.06.06.15.39.19
> (L?uft auf Apache/2.2.22 (Ubuntu))
>
> When I try to open the "Welcome" application I get:
> Error ticket for "welcome" Ticket ID
>
> 178.190.67.157.2013-08-05.17-24-49.9c9dbd34-b526-41aa-a6f2-b56eabf219df
> <type 'exceptions.RuntimeError'> Failure to connect, tried 5 times:
> Traceback (most recent call last): File
> "/home/www-data/web2py/gluon/dal.py", line 7413, in __init__ self._adapter
> = ADAPTERS[self._dbname](**kwargs) File
> "/home/www-data/web2py/gluon/dal.py", line 2192, in __init__ if do_connect:
> self.find_driver(adapter_args) File "/home/www-data/web2py/gluon/dal.py",
> line 733, in find_driver raise RuntimeError("no driver available %s" %
> str(self.drivers)) RuntimeError: no driver available ('sqlite2', 'sqlite3')
> Version web2py™Version 2.5.1-stable+timestamp.2013.06.06.15.39.19PythonPython
> 2.7.4: /usr/local/bin/python (prefix: /usr/local)
> I have tried to use sqlite from Python:
>
> Python 2.7.5 (default, Aug 5 2013, 06:36:44)
> [GCC 4.7.3] on linux2
> Type "help", "copyright", "credits" or "license" for more information.
> >>> import sqlite3
> >>> print sqlite3.version
> 2.6.0
> >>> print sqlite3.sqlite_version
> 3.7.15.2
>
> Seems to be ok.
>
> Now I have tried to open an interactive console:
>
> root@mw:/home/www-data/web2py# python web2py.py -M -S welcome
> web2py Web Framework
> Created by Massimo Di Pierro, Copyright 2007-2013
> Version 2.5.1-stable+timestamp.2013.06.06.15.39.19
> Database drivers available: SQLite(sqlite3), MySQL(pymysql),
> PostgreSQL(pg8000), IMAP(imaplib)
> WARNING:web2py:import IPython error; use default python shell
> Python 2.7.5 (default, Aug 5 2013, 06:36:44)
> [GCC 4.7.3] on linux2
> Type "help", "copyright", "credits" or "license" for more information.
> (InteractiveConsole)
> >>> db=DAL("sqlite://storage.sqlite")
> >>> db.tables
> []
> >>> db.define_table("test", Field("x"))
> <Table test (id,x)>
> >>> db.tables
> ['test']
> >>>
>
> Looks good, but this table will not be saved. After closing and opening
> the table list is empty again.
>
> Any ideas?
> Do I need both sqlite2 and sqlite3?
>
> Regards, Martin
>
--
---
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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
