MYSQL ERROR 1146 while hosting Suitecrm in my online server..

When im hosting suite crm in my online godaddy server i’m getting this kind of blocker MYSQL ERROR 1146 in Suitecrm.log file hereafter i cant proceed Installation process…What can i do ??
Please find the Error Log below…

Wed Sep 13 11:41:24 2017 [969981][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘arcuscrmdemo.aow_workflow’ doesn’t exist
Wed Sep 13 11:41:24 2017 [969981][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘arcuscrmdemo.aow_workflow’ doesn’t exist
Wed Sep 13 11:41:24 2017 [969981][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘arcuscrmdemo.aow_workflow’ doesn’t exist
Wed Sep 13 11:41:24 2017 [969981][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘arcuscrmdemo.aow_workflow’ doesn’t exist
Wed Sep 13 11:41:25 2017 [969981][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘arcuscrmdemo.aow_workflow’ doesn’t exist
Wed Sep 13 11:41:25 2017 [969981][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘arcuscrmdemo.aow_workflow’ doesn’t exist
Wed Sep 13 11:41:25 2017 [969981][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘arcuscrmdemo.aow_workflow’ doesn’t exist
Wed Sep 13 11:41:25 2017 [969981][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘arcuscrmdemo.aow_workflow’ doesn’t exist
Wed Sep 13 11:41:25 2017 [969981][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘arcuscrmdemo.aow_workflow’ doesn’t exist
Wed Sep 13 11:41:25 2017 [969981][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘arcuscrmdemo.aow_workflow’ doesn’t exist
Wed Sep 13 11:41:25 2017 [969981][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘arcuscrmdemo.aow_workflow’ doesn’t exist
Wed Sep 13 11:41:25 2017 [969981][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘arcuscrmdemo.aow_workflow’ doesn’t exist
Wed Sep 13 11:41:25 2017 [969981][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘arcuscrmdemo.aow_workflow’ doesn’t exist
Wed Sep 13 11:41:25 2017 [969981][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘arcuscrmdemo.aow_workflow’ doesn’t exist
Wed Sep 13 11:41:25 2017 [969981][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘arcuscrmdemo.aow_workflow’ doesn’t exist
Wed Sep 13 11:41:25 2017 [969981][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘arcuscrmdemo.aow_workflow’ doesn’t exist

You probably got a timeout in the page that creates the tables, and then the rest of the install procedure fails.

Look at the php.ini settings for memory_limit and max_execution_time. You might be able to adjust them yourself, or you might need to ask your hosting.

When you fix that, clean up the database and the files, and restart installation from scratch.

sir, please see the above errors its tells about the database table is missing…the installation page step 8 get freezed while im click next button…

You are using an installer that has worked succesfullly hundreds of thousands of times.

If it failed to created tables, there has to be a reason for it - I listed a few possibilities. That’s what you have to solve, and run the installer again. You won’t go far trying to create tables manually…

i tried u r suggestion for increase max exec time and memory to high value…but still im having this error?? I tried your suggestions already

Ok, let’s continue to investigate. Please check your install.log and tell me if you find any ERROR or FATAL messages.

i am getting this messages in install.log while fresh installation of suitecrm in godaddy hosting…

2017-09-15 11:44:47…installerHook: Could not find custom/install/install_hooks.php
2017-09-15 11:44:55…installerHook: Could not find custom/install/install_hooks.php
2017-09-15 11:45:01…installerHook: Could not find custom/install/install_hooks.php
2017-09-15 11:45:37…Begin System Check Process *************
2017-09-15 11:45:38…XML Parsing Support Found
2017-09-15 11:45:38…MBString Support Found
2017-09-15 11:45:38…ZIP Support Found
2017-09-15 11:45:38…/custom directory and subdirectory check passed
2017-09-15 11:45:38…cache directory and subdirectory check passed
2017-09-15 11:45:38…/module directory and subdirectory check passed
2017-09-15 11:45:38…/upload directory check passed
2017-09-15 11:45:38…/zip check passed
2017-09-15 11:45:38…PCRE version check passed
2017-09-15 11:45:38…installerHook: Could not find custom/install/install_hooks.php
2017-09-15 11:45:38…php.ini location found. /opt/alt/php71/etc/php.ini
2017-09-15 11:45:38…Outputting HTML for System check
2017-09-15 11:45:38…No Errors were found *************
2017-09-15 11:45:42…installerHook: Could not find custom/install/install_hooks.php
2017-09-15 11:45:45…installerHook: Could not find custom/install/install_hooks.php
2017-09-15 11:45:48…installerHook: Could not find custom/install/install_hooks.php
2017-09-15 11:47:55…Begin DB Check Process *************
2017-09-15 11:47:55…testing with mysql:mysqli
2017-09-15 11:47:55…Basic form info is valid, continuing Process.
2017-09-15 11:47:55…Testing user account…
2017-09-15 11:47:55…ERROR:: The provided database host, username, and/or password is invalid, and a connection to the database could not be established. Please enter a valid host, username and password
2017-09-15 11:47:55…Testing priviliged account…
2017-09-15 11:47:55…Connection made using host: testcrm.inspices.com, usr: arcususer
2017-09-15 11:47:55…DB not selected, will create arcuscrmdemo
2017-09-15 11:47:55…ERROR:: Unable to check database version.
2017-09-15 11:47:55…FATAL:: errors have been detected! User will not be allowed to continue. Errors are as follow:
2017-09-15 11:47:55… The provided database host, username, and/or password is invalid, and a connection to the database could not be established. Please enter a valid host, username and password
2017-09-15 11:47:55… Unable to check database version.
2017-09-15 11:47:55…End DB Check Process *************
2017-09-15 11:49:29…Begin DB Check Process *************
2017-09-15 11:49:29…testing with mysql:mysqli
2017-09-15 11:49:29…Basic form info is valid, continuing Process.
2017-09-15 11:49:29…Testing user account…
2017-09-15 11:49:29…Connection made using host: testcrm.inspices.com, usr: arcususer
2017-09-15 11:49:29…Testing priviliged account…
2017-09-15 11:49:29…Connection made using host: testcrm.inspices.com, usr: arcususer
2017-09-15 11:49:29…ERROR:: The provided Database Name already exists. You can
1. hit the back button and choose a new database name
2. click next and continue but all existing tables on this database will be dropped. This means your tables and data will be blown away.
2017-09-15 11:49:29…Passed DB install check
2017-09-15 11:49:29…WARNING:: no errors detected, but DB tables will be dropped!, issuing warning to user
2017-09-15 11:49:29…End DB Check Process *************
2017-09-15 11:49:45…installerHook: Could not find custom/install/install_hooks.php
2017-09-15 11:50:04…installerHook: Could not find custom/install/install_hooks.php
2017-09-15 11:50:10…installerHook: Could not find custom/install/install_hooks.php
2017-09-15 11:50:10…calling handleSugarConfig()
2017-09-15 11:50:10…calling handleHtaccess()
2017-09-15 11:50:10…calling handleDbCharsetCollation()
2017-09-15 11:50:13…looping through all the Beans and create their tables
2017-09-15 11:50:13…processing table acl_actions
2017-09-15 11:50:13…dropping table acl_actions
2017-09-15 11:50:13…creating table acl_actions
2017-09-15 11:50:13…creating Relationship Meta for ACLAction
2017-09-15 11:50:13…processing table acl_roles
2017-09-15 11:50:13…dropping table acl_roles
2017-09-15 11:50:13…creating table acl_roles
2017-09-15 11:50:13…creating Relationship Meta for ACLRole
2017-09-15 11:50:13…processing table relationships
2017-09-15 11:50:13…dropping table relationships
2017-09-15 11:50:13…creating table relationships
2017-09-15 11:50:13…creating Relationship Meta for Relationship
2017-09-15 11:50:13…processing table leads
2017-09-15 11:50:13…dropping table leads
2017-09-15 11:50:13…creating table leads
2017-09-15 11:50:13…creating Relationship Meta for Lead
2017-09-15 11:50:13…processing table cases
2017-09-15 11:50:13…dropping table cases
2017-09-15 11:50:13…creating table cases
2017-09-15 11:50:13…creating Relationship Meta for Case

Check what hostname, user and password you’re using. It seems PHP can’t connect to the database. Maybe you should ask GoDaddy which values you should use.

fine boss,
but The connection was made and it can create 7 tables in corresponding database…
According to you if connection is not create how the tables are created???
Im trying every time with clean and fresh database…

If you are creating the database yourself in MySQL or phpMyAdmin, don’t do that. The installer creates the database from scratch. Try simply deleting it completely, and reinstalling.

If you’ve already done that, I don’t know what else to advise, let me think for a while…

having error in sugarcrm.log

Sat Sep 16 04:33:37 2017 [863091][-none-][FATAL] Query Failed: CREATE DATABASE suitecrm CHARACTER SET utf8 COLLATE utf8_general_ci: MySQL error 1044: Access denied for user ‘arcususer’@‘166.62.28.146’ to database ‘suitecrm’
Sat Sep 16 04:33:37 2017 [863091][-none-][FATAL] Could not connect to DB server testcrm.inspices.com as arcususer. port : Access denied for user ‘arcususer’@‘166.62.28.146’ to database ‘suitecrm’

Are you sure that’s sugarcrm.log, and not suitecrm.log? Strange…

Well, if you have access denied errors, you really need to check your connection parameters: server address, port, user name, password.

Check if you can login to MySQL locally, using those credentials.

Maybe try using a simpler password, avoid any strange characters.