VirtualX installation Create User "subjects_users" table not exists error

[Subramanian]

Greetings. We are able to set up the environment successfully however upon creating the user I get an error saying "something went wrong". Upon analyzing the log file, it seems a table with subjects_users doesn't exist.

Thread link: https://sourceforge.net/p/virtualx/discussion/1344392/thread/4bb1b170/#41c3

Looking forward for your valuable suggestion to resolve the above issue.

Thanks!

[PIT Solutions]

Thanks for using VirtualX. We will check the issue and come back.

[Khelender Sasan]

Any update? Getting same problem
ApplicationController::current_user
ApplicationController::current_user_session
^[[1m^[[36mSQL (0.7ms)^[[0m ^[[1mdescribe subjects_users^[[0m
Mysql::Error: Table 'virtualx.subjects_users' doesn't exist: describe subjects_users

[PIT Solutions]

The error seems to be 'subjects_users' table doesn't exist in your database. You need to migrate before starting the server. Try this command 'rake db:migrate' and then start the server.

[Khelender Sasan]

I've infact done the migration and its not working after that

See the existence of tables in run below where the incorrect join of table names may be there.

(a table with name of subjectusers is getting created instead of subjects_users)
See run below to see incorrect table name generation

mysql> use virtx
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables ;
+-------------------+
| Tables_in_virtx   |
+-------------------+
| aboutus           |
| academic_years    |
..
| subcategories     |
| subjects          |
| subjectusers      |
| users             |
+-------------------+
45 rows in set (0.00 sec)
mysql>

[PIT Solutions]

We couldn't reproduce any such issue. So we need the full error log from their side to investigate further. Could you please provide it?