Compatibility with sqlite ?

[svgta1]

Is the extension compatible with sqlite ?
When I try to activate it, I've the error :

Erreur générale
SQL ERROR [ sqlite3 ]

table phpbb_users has no column named Y [1]

SQL

INSERT OR ROLLBACK INTO phpbb_users (user_id,user_type,group_id,user_permissions,user_perm_from,user_ip,user_regdate,username,username_clean,user_password,user_passchg,user_email,user_birthday,user_lastvisit,user_lastmark,user_lastpost_time,user_lastpage,user_last_confirm_key,user_last_search,user_warnings,user_last_warning,user_login_attempts,user_inactive_reason,user_inactive_time,user_posts,user_lang,user_timezone,user_dateformat,user_style,user_rank,user_colour,user_new_privmsg,user_unread_privmsg,user_last_privmsg,user_message_rules,user_full_folder,user_emailtime,user_topic_show_days,user_topic_sortby_type,user_topic_sortby_dir,user_post_show_days,user_post_sortby_type,user_post_sortby_dir,user_notify,user_notify_pm,user_notify_type,user_allow_pm,user_allow_viewonline,user_allow_viewemail,user_allow_massemail,user_options,user_avatar,user_avatar_type,user_avatar_width,user_avatar_height,user_sig,user_sig_bbcode_uid,user_sig_bbcode_bitfield,user_jabber,user_actkey,reset_token,reset_token_expiration,user_newpasswd,user_form_salt,user_new,user_reminded,user_reminded_time,user_mchat_avatars,user_mchat_capital_letter,user_mchat_character_count,user_mchat_date,Y,user_mchat_index,user_mchat_input_area,user_mchat_location,user_mchat_message_top,user_mchat_posts,user_mchat_relative_time,user_mchat_sound,user_mchat_stats_index,user_mchat_whois_index) SELECT user_id,user_type,group_id,user_permissions,user_perm_from,user_ip,user_regdate,username,username_clean,user_password,user_passchg,user_email,user_birthday,user_lastvisit,user_lastmark,user_lastpost_time,user_lastpage,user_last_confirm_key,user_last_search,user_warnings,user_last_warning,user_login_attempts,user_inactive_reason,user_inactive_time,user_posts,user_lang,user_timezone,user_dateformat,user_style,user_rank,user_colour,user_new_privmsg,user_unread_privmsg,user_last_privmsg,user_message_rules,user_full_folder,user_emailtime,user_topic_show_days,user_topic_sortby_type,user_topic_sortby_dir,user_post_show_days,user_post_sortby_type,user_post_sortby_dir,user_notify,user_notify_pm,user_notify_type,user_allow_pm,user_allow_viewonline,user_allow_viewemail,user_allow_massemail,user_options,user_avatar,user_avatar_type,user_avatar_width,user_avatar_height,user_sig,user_sig_bbcode_uid,user_sig_bbcode_bitfield,user_jabber,user_actkey,reset_token,reset_token_expiration,user_newpasswd,user_form_salt,user_new,user_reminded,user_reminded_time,user_mchat_avatars,user_mchat_capital_letter,user_mchat_character_count,user_mchat_date,Y,user_mchat_index,user_mchat_input_area,user_mchat_location,user_mchat_message_top,user_mchat_posts,user_mchat_relative_time,user_mchat_sound,user_mchat_stats_index,user_mchat_whois_index FROM phpbb_users_temp;

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1020
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/sqlite3.php
LINE: 154
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 1011
CALL: phpbb\db\driver\sqlite3->sql_query()

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 1295
CALL: phpbb\db\tools\tools->_sql_run_sql()

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 554
CALL: phpbb\db\tools\tools->sql_column_remove()

FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\db\tools\tools->perform_schema_changes()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 714
CALL: call_user_func_array()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 661
CALL: phpbb\db\migrator->run_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 400
CALL: phpbb\db\migrator->process_data_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 351
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 351
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 351
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 351
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 351
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 351
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 288
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 241
CALL: phpbb\db\migrator->update_do()

FILE: [ROOT]/phpbb/extension/base.php
LINE: 78
CALL: phpbb\db\migrator->update()

FILE: [ROOT]/phpbb/extension/manager.php
LINE: 231
CALL: phpbb\extension\base->enable_step()

FILE: [ROOT]/includes/acp/acp_extensions.php
LINE: 209
CALL: phpbb\extension\manager->enable_step()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: acp_extensions->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()

Thank's for your help.

[martinschnurer]

Hi, I had similar problem. Manually create column with name Y in table phpbb_users, complete migration (enabling extension) and then drop column Y. This worked for me.