[Ur] Fatal initialization error: Table 'uw_board_post' does not exist.
Stefan Scott Alexander
stefanscottalexx at gmail.com
Sat May 16 01:59:00 EDT 2015
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.
###
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.impredicative.com/pipermail/ur/attachments/20150516/52336f5f/attachment-0001.html>
More information about the Ur
mailing list