[Ur] Fatal initialization error: Table 'uw_board_post' does not exist.
ml at extensibl.com
ml at extensibl.com
Sat May 16 02:18:44 EDT 2015
Hi Stefan,
You need to check your database, you probably have not created the table.
If you are wondering where to get the schema, check "sql" option in
the manual (pdf).
Best,
Alex
On Sat, May 16, 2015 at 02:59:00AM -0300, Stefan Scott Alexander wrote:
> After encountering the error message described in
> my previous message (involving the demos Crud1
> and Sql), I ran another quick test using the
> latest release of Ur/Web (20150412) on someone's
> github repository 'sniderd/urboard' from May
> 2014.
>
> I was again running this on Debian 8 Jessie and
> Postgres 9.4.1, and I got the same error message:
>
> Fatal initialization error: Table 'uw_board_post'
> does not exist.
>
> Could it be that something changed in a recent Ur
> /Web release - possibly involving uppercase vs
> lowercase table names (on Windows vs Linux), for
> Postgres and/or MySQL?
>
> ===
>
> Transcript below:
>
> admin:~/wrk/urboard$ wget https://github.com/
> sniderd/urboard/archive/master.zip
>
> # ...
>
> admin:~/wrk/urboard$ unzip
>
> # ...
>
> admin:~/wrk/urboard$ cd urboard-master
>
> admin:~/wrk/urboard/urboard-master$ ls -l
> total 52
> -rw-r--r-- 1 admin admin 3029 May 26 2014
> board.ur
> drwxr-xr-x 3 admin admin 4096 May 26 2014
> bootstrap
> drwxr-xr-x 2 admin admin 4096 May 26 2014 css
> -rw-r--r-- 1 admin admin 1197 May 26 2014
> login.ur
> -rw-r--r-- 1 admin admin 65 May 26 2014
> login.urs
> -rw-r--r-- 1 admin admin 4797 May 26 2014
> main.ur
> -rw-r--r-- 1 admin admin 37 May 26 2014
> main.urs
> -rw-r--r-- 1 admin admin 1203 May 26 2014
> masterpage.ur
> -rw-r--r-- 1 admin admin 159 May 26 2014
> register.ur
> -rw-r--r-- 1 admin admin 36 May 26 2014
> register.urs
> -rw-r--r-- 1 admin admin 308 May 26 2014
> urboard.urp
> -rw-r--r-- 1 admin admin 2138 May 26 2014
> user.ur
>
> admin:~/wrk/urboard/urboard-master$ cat
> urboard.urp
>
> database dbname=urboard
> sql urboard.sql
> allow url //netdna.bootstrapcdn.com/bootstrap/
> 3.1.1/css/bootstrap.min.css
> allow url http://localhost/~david/css/main.css
> rewrite style Main/* [-]
> rewrite style Bootstrap3/* [-]
> html5
> library bootstrap
>
> $/string
> $/char
> $/list
> user
> register
> board
> login
> masterpage
> main
>
> admin:~/wrk/urboard/urboard-master$ urweb -dbms
> postgres -db "host=localhost port=5432 user=admin
> password=xxxxxxxx dbname=urboard" urboard
>
> admin:~/wrk/urboard/urboard-master$ ls -l
> total 112
> -rw-r--r-- 1 admin admin 3029 May 26 2014
> board.ur
> drwxr-xr-x 3 admin admin 4096 May 26 2014
> bootstrap
> drwxr-xr-x 2 admin admin 4096 May 26 2014 css
> -rw-r--r-- 1 admin admin 1197 May 26 2014
> login.ur
> -rw-r--r-- 1 admin admin 65 May 26 2014
> login.urs
> -rw-r--r-- 1 admin admin 4797 May 26 2014
> main.ur
> -rw-r--r-- 1 admin admin 37 May 26 2014
> main.urs
> -rw-r--r-- 1 admin admin 1203 May 26 2014
> masterpage.ur
> -rw-r--r-- 1 admin admin 159 May 26 2014
> register.ur
> -rw-r--r-- 1 admin admin 36 May 26 2014
> register.urs
> -rwxr-xr-x 1 admin admin 56080 May 16 05:34
> urboard.exe
> -rw-r--r-- 1 admin admin 2784 May 16 05:34
> urboard.sql
> -rw-r--r-- 1 admin admin 308 May 26 2014
> urboard.urp
> -rw-r--r-- 1 admin admin 2138 May 26 2014
> user.ur
>
> [Change to user 'postgres' below:]
>
> admin:~/wrk/urboard/urboard-master$ sudo -i
>
> root:~$ su - postgres
>
> postgres:~$ createdb urboard
>
> postgres:~$ psql -f /home/admin/wrk/urboard/
> urboard-master/urboard.sql urboard
> CREATE TABLE
> CREATE SEQUENCE
> CREATE SEQUENCE
> CREATE TABLE
> CREATE SEQUENCE
> CREATE TABLE
> CREATE SEQUENCE
> CREATE TABLE
>
> postgres::~$ psql
> psql (9.4.1)
> Type "help" for help.
>
> postgres=# grant all on database urboard to
> admin;
> GRANT
> postgres=# \l
> List of
> databases
> Name | Owner | Encoding | Collate |
> Ctype | Access privileges
> -----------+----------+----------+-------------+-------------+-----------------------
> crud1 | postgres | UTF8 | en_US.UTF-8 |
> en_US.UTF-8 | =CTc/postgres +
> | | | |
> | postgres=CTc/postgres+
> | | | |
> | admin=CTc/postgres
> postgres | postgres | UTF8 | en_US.UTF-8 |
> en_US.UTF-8 |
> template0 | postgres | UTF8 | en_US.UTF-8 |
> en_US.UTF-8 | =c/postgres +
> | | | |
> | postgres=CTc/postgres
> template1 | postgres | UTF8 | en_US.UTF-8 |
> en_US.UTF-8 | =c/postgres +
> | | | |
> | postgres=CTc/postgres
> test | postgres | UTF8 | en_US.UTF-8 |
> en_US.UTF-8 | =Tc/postgres +
> | | | |
> | postgres=CTc/postgres+
> | | | |
> | admin=CTc/postgres
> urboard | postgres | UTF8 | en_US.UTF-8 |
> en_US.UTF-8 | =CTc/postgres +
> | | | |
> | postgres=CTc/postgres+
> | | | |
> | admin=CTc/postgres
> (6 rows)
>
> postgres=# \c urboard
> You are now connected to database "urboard" as
> user "postgres".
> urboard=# \d
> List of relations
> Schema | Name | Type | Owner
> --------+-------------------+----------+----------
> public | uw_board_board | table | postgres
> public | uw_board_boardseq | sequence | postgres
> public | uw_board_forum | table | postgres
> public | uw_board_forumseq | sequence | postgres
> public | uw_board_post | table | postgres
> public | uw_board_postseq | sequence | postgres
> public | uw_user_user | table | postgres
> public | uw_user_userseq | sequence | postgres
> (8 rows)
>
> urboard=#\q
>
> postgres:~$ exit
> logout
> root:~# exit
> logout
> admin:~/wrk/urboard/urboard-master$
>
> admin:~/wrk/urboard/urboard-master$ ./urboard.exe
> Fatal initialization error: Table 'uw_board_post'
> does not exist.
>
> ###
>
>
> _______________________________________________
> Ur mailing list
> Ur at impredicative.com
> http://www.impredicative.com/cgi-bin/mailman/listinfo/ur
More information about the Ur
mailing list