AlliumCepa / webgui

A free open source content management system and web application framework. The most widely deployed mod_perl application on the planet.
http://www.webgui.org/
41 stars 14 forks source link

Misleading Table missing error during initialization #40

Open dannymk opened 5 years ago

dannymk commented 5 years ago

The following error shows up during a new installation however the table does exist in the appropriate database.

allium | ERROR 1146 (42S02) at line 1: Table 'www_example_com.webguiVersion' doesn't exist

MariaDB [mysql]> select * from www_example_com.webguiVersion;
+---------------+-----------------+-------------+
| webguiVersion | versionType     | dateApplied |
+---------------+-----------------+-------------+
| 8.0.0         | Initial Install |  1554417094 |
+---------------+-----------------+-------------+
1 row in set (0.000 sec)

MariaDB [mysql]>
scottwalters commented 5 years ago

Not sure of a good way to test that the database is done loading from create.sql other than to do a show tables or something like that and look for the last one to load. Seems hackish but I'll do that (eventually) if no one has ideas for a better test.