Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.

Question2Answer - fatal error: Specified user column type is not one of allowed values - please read documentation

+1 vote
78 views
asked Sep 10 in Q2A Core by Erik

hello everyone, i need your help.
I have a problem with the install process, in this case I'm using Q2A version 1.6.2, and XAMPP(v3.2.2) PHP version 5.6 and MYSQLI.
and why do I get an error like this?

what's the solution?

Thanks. :)

Question2Answer fatal error:

Specified user column type is not one of allowed values - please read documentation

Stack trace:

require() in index.php:31
require() in qa-index.php:175
qa_page_queue_pending() in qa-page.php:786
qa_preload_options() in qa-page.php:66
qa_db_multi_select() in qa-app-options.php:150
qa_db_query_raw() in qa-db.php:562
qa_db_fail_error() in qa-db.php:199
qa_page_db_fail_handler() in qa-db.php:111
require() in qa-page.php:53
qa_db_check_tables() in qa-install.php:190
qa_db_table_definitions() in qa-db-install.php:603
qa_db_user_column_type_verify() in qa-db-install.php:101

Q2A version: 1.6.2

1 Answer

+1 vote
answered Sep 10 by Scott
Firstly, you should upgrade to 1.7.5 asap as there a couple of security issues that have been fixed recently.

For your specific error, that comes from the Single Sign On feature. Presumably you have edited the 'qa_get_mysql_user_column_type' function in 'qa-external/qa-external-users.php' but you must return a valid type from that function. See the comment above it for the possible values you can use. For example

return 'INT UNSIGNED';

If you are not using SSO then delete or rename the 'qa-external' folder in your installation.
...