The following warnings occurred: | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.31 (Linux)
|
![]() |
Form Tools couldn't find all the database tables - Printable Version +- Form Tools (https://forums.formtools.org) +-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1) +--- Forum: Installation (https://forums.formtools.org/forumdisplay.php?fid=4) +--- Thread: Form Tools couldn't find all the database tables (/showthread.php?tid=1970) |
Form Tools couldn't find all the database tables - icue - Mar 29th, 2012 Hi, I have installed Form Tool(?) but I get the following error: Form Tools couldn't find all the database tables. Please check your /global/config.php file to confirm the $g_table_prefix setting. I checked in PHPmyAdmin and Form Tools created the database and all the tables that it can't find. During the install Form Tools failed to detect mysql version and failed but I ignored and carried on with the install so I assume that is the cause of the problem. Is there a fix for this. RE: Form Tools couldn't find all the database tables - leeburstroghm - Jun 11th, 2013 I have the exact problem trying to install FT 2.2.5 ( latest version ) Server is IIS 6. php is 5.3.0. Install goes through with out a problem. All tables are named correctly and I see them in the DB with phpmyadmin, however when trying to get to the folder. all I get is the: Uh-oh. Form Tools couldn't find all the database tables. Please check your /global/config.php file to confirm the $g_table_prefix setting. The following tables are missing: Everything in the config.php file looks correct?! any help PLEASE!?? RE: Form Tools couldn't find all the database tables - Joe - Jun 11th, 2013 Hi there, Do the Form Tools table match the prefix you have set? If you can log into the admin, I would run a system check and fix the missing tables there. If not you will need to re-install Form Tools. Cheers, Joe RE: Form Tools couldn't find all the database tables - leeburstroghm - Jun 11th, 2013 I have re-installed FormTool many times. all the tables are there and the table names match, and the table prefix matches.. ft_ , as I said already.. I can see them all, and the data with phpmyadmin.. I am NOT able to go anywhere with formtools url. because of the so-called error. of tables not existing.. I do NOT understand and this is very frustrating! in config.php: $g_table_prefix = "ft_"; table names ( as is reported by phpmyadmin ): Browse: (0 Rows) ft_account_settings Browse: (1 Rows) ft_accounts Browse: (0 Rows) ft_client_forms Browse: (0 Rows) ft_client_views Browse: (0 Rows) ft_email_template_edit_submission_views Browse: (0 Rows) ft_email_template_recipients Browse: (0 Rows) ft_email_template_when_sent_views Browse: (0 Rows) ft_email_templates Browse: (0 Rows) ft_field_options Browse: (0 Rows) ft_field_settings Browse: (77 Rows) ft_field_type_setting_options Browse: (44 Rows) ft_field_type_settings Browse: (17 Rows) ft_field_type_validation_rules Browse: (10 Rows) ft_field_types Browse: (0 Rows) ft_field_validation Browse: (0 Rows) ft_form_email_fields Browse: (0 Rows) ft_form_fields Browse: (0 Rows) ft_forms Browse: (16 Rows) ft_hook_calls Browse: (143 Rows) ft_hooks Browse: (2 Rows) ft_list_groups Browse: (18 Rows) ft_menu_items Browse: (2 Rows) ft_menus Browse: (0 Rows) ft_module_export_group_clients Browse: (4 Rows) ft_module_export_groups Browse: (6 Rows) ft_module_export_types Browse: (26 Rows) ft_module_menu_items Browse: (0 Rows) ft_module_pages Browse: (0 Rows) ft_module_pages_clients Browse: (0 Rows) ft_module_swift_mailer_email_template_fields Browse: (8 Rows) ft_modules Browse: (0 Rows) ft_multi_page_form_urls Browse: (0 Rows) ft_new_view_submission_defaults Browse: (0 Rows) ft_option_lists Browse: (0 Rows) ft_public_form_omit_list Browse: (0 Rows) ft_public_view_omit_list Browse: (1 Rows) ft_sessions Browse: (73 Rows) ft_settings Browse: (2 Rows) ft_themes Browse: (0 Rows) ft_view_columns Browse: (0 Rows) ft_view_fields Browse: (0 Rows) ft_view_filters Browse: (0 Rows) ft_view_tabs Browse: (0 Rows) ft_views RE: Form Tools couldn't find all the database tables - leeburstroghm - Jun 11th, 2013 Ok the issue for ME was that my db name is all numbers. and sql has issues with this. so you have to encapsulate the tablename var in ` ` on line 939 of code/general.php ad the ` ` as in the following $result = mysql_query("SHOW TABLES FROM `$g_db_name`"); NOT apostrophe, I am talking the ` below the tilda ~ its a sql thing.. I did NOT try putting it in the config.php as the actuall global var.. that should work.. but to fix all future issues. FormTool should ads the fix to keep this from happening.. The install script must have been written by someone else, with a little more fore site. Kudos! I also found another entry around line 529. Another Show Tables Query. RE: Form Tools couldn't find all the database tables - Joe - Jun 12th, 2013 Thanks for getting back to us with the solution. Cheers, Joe RE: Form Tools couldn't find all the database tables - MadeKellett - Aug 27th, 2020 No doubt form tool is the best document assembly software but many users are facing issues during installation. I have also been going through that problem then I have discussed it with my friend who is a member of bestessaytips review firm he told me to join their services and read all the tips and tricks that are given by professionals on their website especially for the assistance of students. |