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 [email protected] http://www.impredicative.com/cgi-bin/mailman/listinfo/ur
