search

jmueller17 / Aixada

Aixada helps self-managed consumption cooperatives to organize their flow of products, money, and information.
Other
33 stars 37 forks source link

Table aixada_user doesn't exist #221

Closed dmanubens-zz closed 6 years ago

dmanubens-zz commented 6 years ago

Hi, On Ubuntu 16.04, MySQL version 5.7.21-0ubuntu0.16.04.1 (Ubuntu)

The aixada_manual_install.sql does not create aixada_user table. Here is the log:

mysql> use myaixada;                                                                                                                                  Database changed
mysql> show tables;                                                                                                                                   Empty set (0,00 sec)

mysql> source aixada_manual_install.sql;
Query OK, 0 rows affected (0,25 sec)

Query OK, 0 rows affected (0,31 sec)

Query OK, 0 rows affected (0,33 sec)

Query OK, 0 rows affected (0,42 sec)

ERROR 1067 (42000): Invalid default value for 'last_successful_login'
ERROR 1215 (HY000): Cannot add foreign key constraint
Query OK, 0 rows affected (0,26 sec)

Query OK, 0 rows affected (0,27 sec)

Query OK, 0 rows affected (0,33 sec)

Query OK, 0 rows affected (0,31 sec)

Query OK, 0 rows affected (0,27 sec)

Query OK, 0 rows affected (0,82 sec)

Query OK, 0 rows affected (0,32 sec)

ERROR 1067 (42000): Invalid default value for 'ts_sent_off'
ERROR 1067 (42000): Invalid default value for 'ts_validated'
ERROR 1215 (HY000): Cannot add foreign key constraint
ERROR 1215 (HY000): Cannot add foreign key constraint
ERROR 1215 (HY000): Cannot add foreign key constraint
Query OK, 0 rows affected (0,28 sec)

ERROR 1215 (HY000): Cannot add foreign key constraint
Query OK, 0 rows affected (0,47 sec)

Query OK, 0 rows affected (0,44 sec)

ERROR 1215 (HY000): Cannot add foreign key constraint
Query OK, 0 rows affected (0,64 sec)

ERROR 1215 (HY000): Cannot add foreign key constraint
ERROR 1215 (HY000): Cannot add foreign key constraint
Query OK, 0 rows affected (0,27 sec)

Query OK, 23 rows affected (0,03 sec)
Records: 23  Duplicates: 0  Warnings: 0

Query OK, 3 rows affected (0,10 sec)
Records: 3  Duplicates: 0  Warnings: 0

Query OK, 3 rows affected (0,04 sec)
Records: 3  Duplicates: 0  Warnings: 0

Query OK, 2 rows affected (0,10 sec)
Records: 2  Duplicates: 0  Warnings: 0

Query OK, 13 rows affected (0,03 sec)
Records: 13  Duplicates: 0  Warnings: 0

Query OK, 8 rows affected (0,10 sec)
Records: 8  Duplicates: 0  Warnings: 0

Query OK, 2 rows affected (0,14 sec)
Records: 2  Duplicates: 0  Warnings: 0

Query OK, 4 rows affected (0,03 sec)
Records: 4  Duplicates: 0  Warnings: 0

Query OK, 4 rows affected (0,10 sec)
Records: 4  Duplicates: 0  Warnings: 0

Query OK, 1 row affected (0,10 sec)

Query OK, 3 rows affected (0,04 sec)
Records: 3  Duplicates: 0  Warnings: 0

Query OK, 1 row affected (0,10 sec)

Query OK, 1 row affected (0,03 sec)

ERROR 1146 (42S02): Table 'myaixada.aixada_user' doesn't exist
ERROR 1146 (42S02): Table 'myaixada.aixada_user_role' doesn't exist
ERROR 1146 (42S02): Table 'myaixada.aixada_account' doesn't exist
Query OK, 0 rows affected, 1 warning (0,00 sec)

Query OK, 0 rows affected (0,01 sec)

Trying to connect to the front-page:

An error "CALL get_incidents_listing('2018-02-16','2018-02-25','3') generated error 1146: Table 'myaixada.aixada_user' doesn't exist", status "error" occurred during loading data: CALL get_incidents_listing('2018-02-16','2018-02-25','3') generated error 1146: Table 'myaixada.aixada_user' doesn't exist
jorix commented 6 years ago

SET SESSION SQL_MODE = ''; before executing 'aixada.sql'!!

See #222