search

Open-Web-Analytics / Open-Web-Analytics

Official repository for Open Web Analytics which is an open source alternative to commercial tools such as Google Analytics. Stay in control of the data you collect about the use of your website or app. Please consider sponsoring this project.
http://www.openwebanalytics.com
GNU General Public License v2.0
2.5k stars 453 forks source link

login page not displayed #256

Closed satishverma143 closed 4 years ago

satishverma143 commented 7 years ago

Hey @team after installation complete Login page not displayed. when i click "Login and generate a site tracker!" button, it redirect to install page again. what should i do to fix this issue? image please reply me fast.

140 #login page not displayed

satishverma143 commented 7 years ago

i have checked the error log file : all the tables are created successfully. but in last line of file it write : 02:37:07 06/16/17 13594 [notice] Installation complete. 02:37:07 06/16/17 13594 [notice] Checking for existence of default site. 02:37:07 06/16/17 13594 [notice] Created default site. 02:37:07 06/16/17 13594 [notice] Could not add Install Complete Flag to configuration.

padams commented 7 years ago

Try turning on debugging mode in the config file and then re-run the install to see what additional error msgs show up in the logs.

On Jun 16, 2017, at 5:41 AM, Satish Verma notifications@github.com wrote:

i have checked the error log file : all the tables are created successfully. but in last line of file it write : 02:37:07 06/16/17 13594 [notice] Installation complete. 02:37:07 06/16/17 13594 [notice] Checking for existence of default site. 02:37:07 06/16/17 13594 [notice] Created default site. 02:37:07 06/16/17 13594 [notice] Could not add Install Complete Flag to configuration.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or mute the thread.

padams commented 7 years ago

Please remove your debug log from GitHub as it contains your password hash.

Also, you cannot run OWA as local host. It requires a fully qualified domain.

Once you have one, drop all owa tables from your DB and install again.

On Jun 16, 2017, at 8:32 AM, Satish Verma notifications@github.com wrote:

i reinstall after on debugging mode and the below error saved in the error file. please have a look to this : 05:29:59 06/16/17 19813 [debug] check for http host 05:29:59 06/16/17 19813 [debug] Not setting cookie domain as .localhost is not a FQDN. 05:29:59 06/16/17 19813 [debug] Starting Open Web Analytics vmaster. Running under PHP v7.1.6-1~ubuntu16.04.1+deb.sury.org+1 (Linux) 05:29:59 06/16/17 19813 [debug] Request URL: /install.php?owa_site_id=&owa_do=base.installDefaultsEntry& 05:29:59 06/16/17 19813 [debug] User Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 05:29:59 06/16/17 19813 [debug] Host: localhost:9910 05:29:59 06/16/17 19813 [debug] Caller configuration overrides applied. 05:29:59 06/16/17 19813 [debug] Filtering register_build_package 05:29:59 06/16/17 19813 [debug] Filtering register_build_package 05:29:59 06/16/17 19813 [debug] Filtering register_build_package 05:29:59 06/16/17 19813 [debug] base Schema version is 1 05:29:59 06/16/17 19813 [debug] base Required Schema version is 9 05:29:59 06/16/17 19813 [debug] Getting state - store: u key: 05:29:59 06/16/17 19813 [debug] Notifying listeners of init 05:29:59 06/16/17 19813 [debug] no listeners registered for this event type. 05:29:59 06/16/17 19813 [debug] EHS: Responses - Array ( )

05:29:59 06/16/17 19813 [debug] EHS: Event was handled successfully by all handlers. 05:29:59 06/16/17 19813 [debug] Handling request with params: Array ( [site_id] => [do] => base.installDefaultsEntry )

05:29:59 06/16/17 19813 [debug] About to perform action: base.installDefaultsEntry 05:29:59 06/16/17 19813 [debug] Performing Action: owa_installDefaultsEntryController 05:29:59 06/16/17 19813 [debug] Assembling view: owa_installView 05:29:59 06/16/17 19813 [debug] Total session time: 0.01511287689209 05:29:59 06/16/17 19813 [debug] goodbye from OWA 05:30:07 06/16/17 19813 [debug] check for http host 05:30:07 06/16/17 19813 [debug] Not setting cookie domain as .localhost is not a FQDN. 05:30:07 06/16/17 19813 [debug] Starting Open Web Analytics vmaster. Running under PHP v7.1.6-1~ubuntu16.04.1+deb.sury.org+1 (Linux) 05:30:07 06/16/17 19813 [debug] Request URL: /install.php?owa_site_id=&owa_do=base.installDefaultsEntry& 05:30:07 06/16/17 19813 [debug] User Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 05:30:07 06/16/17 19813 [debug] Host: localhost:9910 05:30:07 06/16/17 19813 [debug] Caller configuration overrides applied. 05:30:07 06/16/17 19813 [debug] Filtering register_build_package 05:30:07 06/16/17 19813 [debug] Filtering register_build_package 05:30:07 06/16/17 19813 [debug] Filtering register_build_package 05:30:07 06/16/17 19813 [debug] base Schema version is 1 05:30:07 06/16/17 19813 [debug] base Required Schema version is 9 05:30:07 06/16/17 19813 [debug] Getting state - store: u key: 05:30:07 06/16/17 19813 [debug] Notifying listeners of init 05:30:07 06/16/17 19813 [debug] no listeners registered for this event type. 05:30:07 06/16/17 19813 [debug] EHS: Responses - Array ( )

05:30:07 06/16/17 19813 [debug] EHS: Event was handled successfully by all handlers. 05:30:07 06/16/17 19813 [debug] Handling request with params: Array ( [site_id] => [do] => base.installBase [protocol] => http:// [domain] => localhost:9911/ [email_address] => satish.verma143@gmail.com [password] => 12345 [nonce] => 0e83a0a1eb [save_button] => Continue... )

05:30:07 06/16/17 19813 [debug] About to perform action: base.installBase 05:30:07 06/16/17 19813 [debug] Performing Action: owa_installBaseController 05:30:07 06/16/17 19813 [debug] passed nonce: 0e83a0a1eb | matching nonce: 0e83a0a1eb 05:30:07 06/16/17 19813 [debug] Col: domain, value: http://localhost:9911/ 05:30:07 06/16/17 19813 [debug] Query: SELECT FROM owa_site WHERE domain = 'http://localhost:9911/' LIMIT 1 05:30:07 06/16/17 19813 [debug] A MySQL error ocured. Error: (1146) Table 'demo_owa2.owa_site' doesn't exist. Query: SELECT FROM owa_site WHERE domain = 'http://localhost:9911/' LIMIT 1 05:30:07 06/16/17 19813 [debug] 2017-06-16 05:30:07 (PDT) 2 mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given /home/satish/DiskData/Tutorials/clickheat/MyProject/owa/plugins/db/owa_db_mysql.php 218 05:30:07 06/16/17 19813 [notice] Starting installation of module: base 05:30:07 06/16/17 19813 [debug] Query: CREATE TABLE IF NOT EXISTS owa_request (id BIGINT PRIMARY KEY, visitor_id BIGINT, session_id BIGINT, INDEX (session_id), site_id VARCHAR(255), INDEX (site_id), referer_id BIGINT, ua_id BIGINT, host_id BIGINT, os_id BIGINT, location_id BIGINT, referring_search_term_id BIGINT, timestamp INT, yyyymmdd INT, INDEX (yyyymmdd), year INT, month INT, day TINYINT(2), dayofweek VARCHAR(10), dayofyear INT, weekofyear INT, last_req BIGINT, ip_address VARCHAR(255), is_new_visitor TINYINT(1), is_repeat_visitor TINYINT(1), language VARCHAR(255), days_since_prior_session INT, days_since_first_session INT, num_prior_sessions INT, medium VARCHAR(255), source_id BIGINT, ad_id BIGINT, campaign_id BIGINT, user_name VARCHAR(255), cv1_name VARCHAR(255), cv1_value VARCHAR(255), cv2_name VARCHAR(255), cv2_value VARCHAR(255), cv3_name VARCHAR(255), cv3_value VARCHAR(255), cv4_name VARCHAR(255), cv4_value VARCHAR(255), cv5_name VARCHAR(255), cv5_value VARCHAR(255), inbound_visitor_id BIGINT, inbound_session_id BIGINT, feed_subscription_id BIGINT, user_email VARCHAR(255), hour TINYINT(2), minute TINYINT(2), second TINYINT(2), msec INT, document_id VARCHAR(255), site VARCHAR(255), os VARCHAR(255), prior_document_id BIGINT, is_comment TINYINT(1), is_entry_page TINYINT(1), is_browser TINYINT(1), is_robot TINYINT(1), is_feedreader TINYINT(1)) ENGINE = INNODB CHARACTER SET = utf8 05:30:08 06/16/17 19813 [notice] owa_request Table Created. 05:30:08 06/16/17 19813 [debug] Query: CREATE TABLE IF NOT EXISTS owa_session (id BIGINT PRIMARY KEY, visitor_id BIGINT, site_id VARCHAR(255), INDEX (site_id), referer_id BIGINT, ua_id BIGINT, host_id BIGINT, os_id BIGINT, location_id BIGINT, referring_search_term_id BIGINT, timestamp INT, yyyymmdd INT, INDEX (yyyymmdd), year INT, month INT, day TINYINT(2), dayofweek VARCHAR(10), dayofyear INT, weekofyear INT, last_req BIGINT, ip_address VARCHAR(255), is_new_visitor TINYINT(1), is_repeat_visitor TINYINT(1), language VARCHAR(255), days_since_prior_session INT, days_since_first_session INT, num_prior_sessions INT, medium VARCHAR(255), source_id BIGINT, ad_id BIGINT, campaign_id BIGINT, user_name VARCHAR(255), cv1_name VARCHAR(255), cv1_value VARCHAR(255), cv2_name VARCHAR(255), cv2_value VARCHAR(255), cv3_name VARCHAR(255), cv3_value VARCHAR(255), cv4_name VARCHAR(255), cv4_value VARCHAR(255), cv5_name VARCHAR(255), cv5_value VARCHAR(255), user_email VARCHAR(255), hour TINYINT(2), minute TINYINT(2), num_pageviews INT, num_comments INT, is_bounce TINYINT(1), prior_session_lastreq BIGINT, prior_session_id BIGINT, time_sinse_priorsession INT, prior_session_year TINYINT(4), prior_session_month VARCHAR(255), prior_session_day TINYINT(2), prior_session_dayofweek INT, prior_session_hour TINYINT(2), prior_session_minute TINYINT(2), os VARCHAR(255), first_page_id BIGINT, last_page_id BIGINT, host VARCHAR(255), city VARCHAR(255), country VARCHAR(255), site VARCHAR(255), is_robot TINYINT(1), is_browser TINYINT(1), is_feedreader TINYINT(1), latest_attributions BLOB, goal_1 TINYINT(1), goal_1_start TINYINT(1), goal_1_value BIGINT, goal_2 TINYINT(1), goal_2_start TINYINT(1), goal_2_value BIGINT, goal_3 TINYINT(1), goal_3_start TINYINT(1), goal_3_value BIGINT, goal_4 TINYINT(1), goal_4_start TINYINT(1), goal_4_value BIGINT, goal_5 TINYINT(1), goal_5_start TINYINT(1), goal_5_value BIGINT, goal_6 TINYINT(1), goal_6_start TINYINT(1), goal_6_value BIGINT, goal_7 TINYINT(1), goal_7_start TINYINT(1), goal_7_value BIGINT, goal_8 TINYINT(1), goal_8_start TINYINT(1), goal_8_value BIGINT, goal_9 TINYINT(1), goal_9_start TINYINT(1), goal_9_value BIGINT, goal_10 TINYINT(1), goal_10_start TINYINT(1), goal_10_value BIGINT, goal_11 TINYINT(1), goal_11_start TINYINT(1), goal_11_value BIGINT, goal_12 TINYINT(1), goal_12_start TINYINT(1), goal_12_value BIGINT, goal_13 TINYINT(1), goal_13_start TINYINT(1), goal_13_value BIGINT, goal_14 TINYINT(1), goal_14_start TINYINT(1), goal_14_value BIGINT, goal_15 TINYINT(1), goal_15_start TINYINT(1), goal_15_value BIGINT, num_goals TINYINT(1), num_goal_starts TINYINT(1), goals_value BIGINT, commerce_trans_count INT, commerce_trans_revenue BIGINT, commerce_items_revenue BIGINT, commerce_items_count INT, commerce_items_quantity INT, commerce_shipping_revenue BIGINT, commerce_tax_revenue BIGINT) ENGINE = INNODB CHARACTER SET = utf8 05:30:08 06/16/17 19813 [notice] owa_session Table Created. 05:30:08 06/16/17 19813 [debug] Query: CREATE TABLE IF NOT EXISTS owa_document (id BIGINT PRIMARY KEY, url VARCHAR(255), uri VARCHAR(255), page_title VARCHAR(255), page_type VARCHAR(255)) ENGINE = INNODB CHARACTER SET = utf8 05:30:09 06/16/17 19813 [notice] owa_document Table Created. 05:30:09 06/16/17 19813 [debug] Query: CREATE TABLE IF NOT EXISTS owa_feed_request (id BIGINT PRIMARY KEY, visitor_id BIGINT, session_id BIGINT, document_id BIGINT, site_id VARCHAR(255), ua_id VARCHAR(255), host_id BIGINT, os_id VARCHAR(255), site VARCHAR(255), host VARCHAR(255), feed_reader_guid VARCHAR(255), subscription_id BIGINT, timestamp BIGINT, yyyymmdd INT, INDEX (yyyymmdd), month INT, day TINYINT(2), dayofweek VARCHAR(10), dayofyear INT, weekofyear INT, year INT, hour TINYINT(2), minute TINYINT(2), second TINYINT(2), msec INT, last_req BIGINT, feed_format VARCHAR(255), ip_address VARCHAR(255), os VARCHAR(255)) ENGINE = INNODB CHARACTER SET = utf8 05:30:09 06/16/17 19813 [notice] owa_feed_request Table Created. 05:30:09 06/16/17 19813 [debug] Query: CREATE TABLE IF NOT EXISTS owa_click (id BIGINT PRIMARY KEY, visitor_id BIGINT, session_id BIGINT, INDEX (session_id), site_id VARCHAR(255), INDEX (site_id), referer_id BIGINT, ua_id BIGINT, host_id BIGINT, os_id BIGINT, location_id BIGINT, referring_search_term_id BIGINT, timestamp INT, yyyymmdd INT, INDEX (yyyymmdd), year INT, month INT, day TINYINT(2), dayofweek VARCHAR(10), dayofyear INT, weekofyear INT, last_req BIGINT, ip_address VARCHAR(255), is_new_visitor TINYINT(1), is_repeat_visitor TINYINT(1), language VARCHAR(255), days_since_prior_session INT, days_since_first_session INT, num_prior_sessions INT, medium VARCHAR(255), source_id BIGINT, ad_id BIGINT, campaign_id BIGINT, user_name VARCHAR(255), cv1_name VARCHAR(255), cv1_value VARCHAR(255), cv2_name VARCHAR(255), cv2_value VARCHAR(255), cv3_name VARCHAR(255), cv3_value VARCHAR(255), cv4_name VARCHAR(255), cv4_value VARCHAR(255), cv5_name VARCHAR(255), cv5_value VARCHAR(255), last_impression_id BIGINT, document_id BIGINT, target_id BIGINT, target_url VARCHAR(255), hour TINYINT(2), minute TINYINT(2), second INT, msec VARCHAR(255), click_x INT, click_y INT, page_width INT, page_height INT, position INT, approx_position BIGINT, dom_element_x INT, dom_element_y INT, dom_element_name VARCHAR(255), dom_element_id VARCHAR(255), dom_element_value VARCHAR(255), dom_element_tag VARCHAR(255), dom_element_text VARCHAR(255), dom_element_class VARCHAR(255), dom_element_parent_id VARCHAR(255), tag_id BIGINT, placement_id BIGINT, ad_group_id BIGINT, host VARCHAR(255)) ENGINE = INNODB CHARACTER SET = utf8 05:30:10 06/16/17 19813 [notice] owa_click Table Created. 05:30:10 06/16/17 19813 [debug] Query: CREATE TABLE IF NOT EXISTS owa_ua (id BIGINT PRIMARY KEY, ua VARCHAR(255), browser_type VARCHAR(255), browser VARCHAR(255)) ENGINE = INNODB CHARACTER SET = utf8 05:30:10 06/16/17 19813 [notice] owa_ua Table Created. 05:30:10 06/16/17 19813 [debug] Query: CREATE TABLE IF NOT EXISTS owa_referer (id BIGINT PRIMARY KEY, url VARCHAR(255), site_name VARCHAR(255), site VARCHAR(255), query_terms VARCHAR(255), refering_anchortext VARCHAR(255), page_title VARCHAR(255), snippet MEDIUMTEXT, is_searchengine TINYINT(1)) ENGINE = INNODB CHARACTER SET = utf8 05:30:11 06/16/17 19813 [notice] owa_referer Table Created. 05:30:11 06/16/17 19813 [debug] Query: CREATE TABLE IF NOT EXISTS owa_site (id BIGINT PRIMARY KEY, site_id VARCHAR(255), domain VARCHAR(255), name VARCHAR(255), description MEDIUMTEXT, site_family VARCHAR(255), settings BLOB) ENGINE = INNODB CHARACTER SET = utf8 05:30:11 06/16/17 19813 [notice] owa_site Table Created. 05:30:11 06/16/17 19813 [debug] Query: CREATE TABLE IF NOT EXISTS owa_visitor (id BIGINT PRIMARY KEY, user_name VARCHAR(255), user_email VARCHAR(255), first_session_id BIGINT, first_session_year INT, first_session_month VARCHAR(255), first_session_day INT, first_session_dayofyear INT, first_session_timestamp BIGINT, first_session_yyyymmdd BIGINT, last_session_id BIGINT, last_session_year INT, last_session_month VARCHAR(255), last_session_day INT, last_session_dayofyear INT, num_prior_sessions INT) ENGINE = INNODB CHARACTER SET = utf8 05:30:11 06/16/17 19813 [notice] owa_visitor Table Created. 05:30:11 06/16/17 19813 [debug] Query: CREATE TABLE IF NOT EXISTS owa_host (id BIGINT PRIMARY KEY, ip_address VARCHAR(255), host VARCHAR(255), full_host VARCHAR(255), city VARCHAR(255), country VARCHAR(255), latitude VARCHAR(255), longitude VARCHAR(255)) ENGINE = INNODB CHARACTER SET = utf8 05:30:12 06/16/17 19813 [notice] owa_host Table Created. 05:30:12 06/16/17 19813 [debug] Query: CREATE TABLE IF NOT EXISTS owa_exit (id BIGINT PRIMARY KEY, url VARCHAR(255), site_name VARCHAR(255), site VARCHAR(255), anchortext VARCHAR(255), page_title VARCHAR(255)) ENGINE = INNODB CHARACTER SET = utf8 05:30:12 06/16/17 19813 [notice] owa_exit Table Created. 05:30:12 06/16/17 19813 [debug] Query: CREATE TABLE IF NOT EXISTS owa_os (id BIGINT PRIMARY KEY, name VARCHAR(255)) ENGINE = INNODB CHARACTER SET = utf8 05:30:12 06/16/17 19813 [notice] owa_os Table Created. 05:30:12 06/16/17 19813 [debug] Query: CREATE TABLE IF NOT EXISTS owa_impression (id BIGINT PRIMARY KEY, visitor_id BIGINT, session_id BIGINT, tag_id BIGINT, placement_id BIGINT, campaign_id BIGINT, ad_group_id BIGINT, ad_id BIGINT, site_id VARCHAR(255), last_impression_id BIGINT, last_impression_timestamp BIGINT, timestamp BIGINT, year INT, month INT, day INT, dayofyear INT, weekofyear INT, hour TINYINT(2), minute TINYINT(2), msec BIGINT, url VARCHAR(255), ua_id BIGINT, ip_address VARCHAR(255), host_id VARCHAR(255), host VARCHAR(255)) ENGINE = INNODB CHARACTER SET = utf8 05:30:13 06/16/17 19813 [notice] owa_impression Table Created. 05:30:13 06/16/17 19813 [debug] Query: CREATE TABLE IF NOT EXISTS owa_configuration (id BIGINT PRIMARY KEY, settings BLOB) ENGINE = INNODB CHARACTER SET = utf8 05:30:13 06/16/17 19813 [notice] owa_configuration Table Created. 05:30:13 06/16/17 19813 [debug] Query: CREATE TABLE IF NOT EXISTS owa_user (id SERIAL AUTO_INCREMENT, user_id VARCHAR(255) PRIMARY KEY, password VARCHAR(255), role VARCHAR(255), real_name VARCHAR(255), email_address VARCHAR(255), temp_passkey VARCHAR(255), creation_date BIGINT, last_update_date BIGINT, api_key VARCHAR(255)) ENGINE = INNODB CHARACTER SET = utf8 05:30:14 06/16/17 19813 [notice] owa_user Table Created. 05:30:14 06/16/17 19813 [debug] Query: CREATE TABLE IF NOT EXISTS owa_domstream (id BIGINT PRIMARY KEY, visitor_id BIGINT, session_id BIGINT, INDEX (session_id), site_id VARCHAR(255), INDEX (site_id), referer_id BIGINT, ua_id BIGINT, host_id BIGINT, os_id BIGINT, location_id BIGINT, referring_search_term_id BIGINT, timestamp INT, yyyymmdd INT, INDEX (yyyymmdd), year INT, month INT, day TINYINT(2), dayofweek VARCHAR(10), dayofyear INT, weekofyear INT, last_req BIGINT, ip_address VARCHAR(255), is_new_visitor TINYINT(1), is_repeat_visitor TINYINT(1), language VARCHAR(255), days_since_prior_session INT, days_since_first_session INT, num_prior_sessions INT, medium VARCHAR(255), source_id BIGINT, ad_id BIGINT, campaign_id BIGINT, user_name VARCHAR(255), cv1_name VARCHAR(255), cv1_value VARCHAR(255), cv2_name VARCHAR(255), cv2_value VARCHAR(255), cv3_name VARCHAR(255), cv3_value VARCHAR(255), cv4_name VARCHAR(255), cv4_value VARCHAR(255), cv5_name VARCHAR(255), cv5_value VARCHAR(255), document_id BIGINT, domstream_guid BIGINT, events BLOB, duration INT, page_url VARCHAR(255)) ENGINE = INNODB CHARACTER SET = utf8 05:30:14 06/16/17 19813 [notice] owa_domstream Table Created. 05:30:14 06/16/17 19813 [debug] Query: CREATE TABLE IF NOT EXISTS owa_action_fact (id BIGINT PRIMARY KEY, visitor_id BIGINT, session_id BIGINT, INDEX (session_id), site_id VARCHAR(255), INDEX (site_id), referer_id BIGINT, ua_id BIGINT, host_id BIGINT, os_id BIGINT, location_id BIGINT, referring_search_term_id BIGINT, timestamp INT, yyyymmdd INT, INDEX (yyyymmdd), year INT, month INT, day TINYINT(2), dayofweek VARCHAR(10), dayofyear INT, weekofyear INT, last_req BIGINT, ip_address VARCHAR(255), is_new_visitor TINYINT(1), is_repeat_visitor TINYINT(1), language VARCHAR(255), days_since_prior_session INT, days_since_first_session INT, num_prior_sessions INT, medium VARCHAR(255), source_id BIGINT, ad_id BIGINT, campaign_id BIGINT, user_name VARCHAR(255), cv1_name VARCHAR(255), cv1_value VARCHAR(255), cv2_name VARCHAR(255), cv2_value VARCHAR(255), cv3_name VARCHAR(255), cv3_value VARCHAR(255), cv4_name VARCHAR(255), cv4_value VARCHAR(255), cv5_name VARCHAR(255), cv5_value VARCHAR(255), document_id BIGINT, action_name VARCHAR(255), action_label VARCHAR(255), action_group VARCHAR(255), numeric_value INT) ENGINE = INNODB CHARACTER SET = utf8 05:30:15 06/16/17 19813 [notice] owa_action_fact Table Created. 05:30:15 06/16/17 19813 [debug] Query: CREATE TABLE IF NOT EXISTS owa_search_term_dim (id BIGINT PRIMARY KEY, terms VARCHAR(255), term_count VARCHAR(255)) ENGINE = INNODB CHARACTER SET = utf8 05:30:15 06/16/17 19813 [notice] owa_search_term_dim Table Created. 05:30:15 06/16/17 19813 [debug] Query: CREATE TABLE IF NOT EXISTS owa_ad_dim (id BIGINT PRIMARY KEY, name VARCHAR(255), type VARCHAR(255)) ENGINE = INNODB CHARACTER SET = utf8 05:30:16 06/16/17 19813 [notice] owa_ad_dim Table Created. 05:30:16 06/16/17 19813 [debug] Query: CREATE TABLE IF NOT EXISTS owa_source_dim (id BIGINT PRIMARY KEY, source_domain VARCHAR(255)) ENGINE = INNODB CHARACTER SET = utf8 05:30:16 06/16/17 19813 [notice] owa_source_dim Table Created. 05:30:16 06/16/17 19813 [debug] Query: CREATE TABLE IF NOT EXISTS owa_campaign_dim (id BIGINT PRIMARY KEY, name VARCHAR(255)) ENGINE = INNODB CHARACTER SET = utf8 05:30:16 06/16/17 19813 [notice] owa_campaign_dim Table Created. 05:30:16 06/16/17 19813 [debug] Query: CREATE TABLE IF NOT EXISTS owa_location_dim (id BIGINT PRIMARY KEY, country VARCHAR(255), country_code VARCHAR(255), state VARCHAR(255), city VARCHAR(255), latitude VARCHAR(255), longitude VARCHAR(255)) ENGINE = INNODB CHARACTER SET = utf8 05:30:17 06/16/17 19813 [notice] owa_location_dim Table Created. 05:30:17 06/16/17 19813 [debug] Query: CREATE TABLE IF NOT EXISTS owa_commerce_transaction_fact (id BIGINT PRIMARY KEY, visitor_id BIGINT, session_id BIGINT, INDEX (session_id), site_id VARCHAR(255), INDEX (site_id), referer_id BIGINT, ua_id BIGINT, host_id BIGINT, os_id BIGINT, location_id BIGINT, referring_search_term_id BIGINT, timestamp INT, yyyymmdd INT, INDEX (yyyymmdd), year INT, month INT, day TINYINT(2), dayofweek VARCHAR(10), dayofyear INT, weekofyear INT, last_req BIGINT, ip_address VARCHAR(255), is_new_visitor TINYINT(1), is_repeat_visitor TINYINT(1), language VARCHAR(255), days_since_prior_session INT, days_since_first_session INT, num_prior_sessions INT, medium VARCHAR(255), source_id BIGINT, ad_id BIGINT, campaign_id BIGINT, user_name VARCHAR(255), cv1_name VARCHAR(255), cv1_value VARCHAR(255), cv2_name VARCHAR(255), cv2_value VARCHAR(255), cv3_name VARCHAR(255), cv3_value VARCHAR(255), cv4_name VARCHAR(255), cv4_value VARCHAR(255), cv5_name VARCHAR(255), cv5_value VARCHAR(255), document_id BIGINT, order_id VARCHAR(255), INDEX (order_id), order_source VARCHAR(255), gateway VARCHAR(255), total_revenue BIGINT, tax_revenue BIGINT, shipping_revenue BIGINT) ENGINE = INNODB CHARACTER SET = utf8 05:30:17 06/16/17 19813 [notice] owa_commerce_transaction_fact Table Created. 05:30:17 06/16/17 19813 [debug] Query: CREATE TABLE IF NOT EXISTS owa_commerce_line_item_fact (id BIGINT PRIMARY KEY, visitor_id BIGINT, session_id BIGINT, INDEX (session_id), site_id VARCHAR(255), INDEX (site_id), referer_id BIGINT, ua_id BIGINT, host_id BIGINT, os_id BIGINT, location_id BIGINT, referring_search_term_id BIGINT, timestamp INT, yyyymmdd INT, INDEX (yyyymmdd), year INT, month INT, day TINYINT(2), dayofweek VARCHAR(10), dayofyear INT, weekofyear INT, last_req BIGINT, ip_address VARCHAR(255), is_new_visitor TINYINT(1), is_repeat_visitor TINYINT(1), language VARCHAR(255), days_since_prior_session INT, days_since_first_session INT, num_prior_sessions INT, medium VARCHAR(255), source_id BIGINT, ad_id BIGINT, campaign_id BIGINT, user_name VARCHAR(255), cv1_name VARCHAR(255), cv1_value VARCHAR(255), cv2_name VARCHAR(255), cv2_value VARCHAR(255), cv3_name VARCHAR(255), cv3_value VARCHAR(255), cv4_name VARCHAR(255), cv4_value VARCHAR(255), cv5_name VARCHAR(255), cv5_value VARCHAR(255), document_id BIGINT, order_id VARCHAR(255), INDEX (order_id), sku VARCHAR(255), product_name VARCHAR(255), category VARCHAR(255), unit_price BIGINT, quantity INT, item_revenue BIGINT) ENGINE = INNODB CHARACTER SET = utf8 05:30:18 06/16/17 19813 [notice] owa_commerce_line_item_fact Table Created. 05:30:18 06/16/17 19813 [debug] Query: CREATE TABLE IF NOT EXISTS owa_queue_item (id BIGINT PRIMARY KEY, event_type VARCHAR(255), priority INT, status VARCHAR(255), event BLOB, insertion_datestamp TIMESTAMP, insertion_timestamp INT, handled_timestamp INT, last_attempt_timestamp INT, not_before_timestamp INT, failed_attempt_count INT, is_assigned TINYINT(1), last_error_msg VARCHAR(255), handled_by VARCHAR(255), handler_duration INT) ENGINE = INNODB CHARACTER SET = utf8 05:30:18 06/16/17 19813 [notice] owa_queue_item Table Created. 05:30:18 06/16/17 19813 [debug] Query: CREATE TABLE IF NOT EXISTS owa_site_user (site_id BIGINT, user_id INT) ENGINE = INNODB CHARACTER SET = utf8 05:30:19 06/16/17 19813 [notice] owa_site_user Table Created. 05:30:19 06/16/17 19813 [notice] Post install proceadure was a success. 05:30:19 06/16/17 19813 [debug] Col: id, value: 1 05:30:19 06/16/17 19813 [debug] Query: SELECT FROM owa_configuration WHERE id = '1' LIMIT 1 05:30:19 06/16/17 19813 [debug] Query: INSERT into owa_configuration (id, settings) VALUES ('1', 'a:1:{s:4:"base";a:2:{s:14:"schema_version";i:9;s:9:"is_active";b:1;}}') 05:30:19 06/16/17 19813 [notice] Module base activated 05:30:19 06/16/17 19813 [notice] Installation complete. 05:30:19 06/16/17 19813 [debug] Col: role, value: admin 05:30:19 06/16/17 19813 [debug] Query: SELECT FROM owa_user WHERE role = 'admin' LIMIT 1 05:30:19 06/16/17 19813 [debug] Col: user_id, value: admin 05:30:19 06/16/17 19813 [debug] Query: SELECT FROM owa_user WHERE user_id = 'admin' LIMIT 1 05:30:19 06/16/17 19813 [debug] Query: INSERT into owa_user (user_id, password, role, real_name, email_address, temp_passkey, creation_date, last_update_date, api_key) VALUES ('admin', '00c66aaf5f2c3f49946f15c1ad2ea0d3', 'admin', '', 'satish.verma143@gmail.com', '4d2b3a2e708be014940225f8af668eb3', '1497616219', '1497616219', '32b18c00e9a7672db0892898be1fde3f') 05:30:19 06/16/17 19813 [debug] Admin user created successfully. 05:30:19 06/16/17 19813 [notice] Checking for existence of default site. 05:30:19 06/16/17 19813 [debug] Col: site_id, value: 272dcd0b4eb553cf455a33b1e5f003ed 05:30:19 06/16/17 19813 [debug] Query: SELECT FROM owa_site WHERE site_id = '272dcd0b4eb553cf455a33b1e5f003ed' LIMIT 1 05:30:19 06/16/17 19813 [debug] Query: INSERT into owa_site (id, site_id, domain, name, description, site_family, settings) VALUES ('388287723', '272dcd0b4eb553cf455a33b1e5f003ed', 'http://localhost:9911/', 'http://localhost:9911/', '', '', '') 05:30:19 06/16/17 19813 [notice] Created default site. 05:30:19 06/16/17 19813 [debug] Col: id, value: 1 05:30:19 06/16/17 19813 [debug] Query: SELECT * FROM owa_configuration WHERE id = '1' LIMIT 1 05:30:19 06/16/17 19813 [debug] 2017-06-16 05:30:19 (PDT) 8 Array to string conversion /home/satish/DiskData/Tutorials/clickheat/MyProject/owa/plugins/db/owa_db_mysql.php 220 05:30:19 06/16/17 19813 [debug] entity loaded from db 05:30:19 06/16/17 19813 [debug] Query: INSERT into owa_configuration (id, settings) VALUES ('1', 'a:1:{s:4:"base";a:3:{s:14:"schema_version";i:9;s:9:"is_active";b:1;s:16:"install_complete";b:1;}}') 05:30:19 06/16/17 19813 [debug] A MySQL error ocured. Error: (1062) Duplicate entry '1' for key 'PRIMARY'. Query: INSERT into owa_configuration (id, settings) VALUES ('1', 'a:1:{s:4:"base";a:3:{s:14:"schema_version";i:9;s:9:"is_active";b:1;s:16:"install_complete";b:1;}}') 05:30:19 06/16/17 19813 [notice] Could not add Install Complete Flag to configuration. 05:30:19 06/16/17 19813 [debug] Notifying listeners of install_complete 05:30:19 06/16/17 19813 [debug] install_complete event handled by owa_baseModule. 05:30:19 06/16/17 19813 [debug] EHS: Responses - Array ( [owa_baseModule] => )

05:30:19 06/16/17 19813 [debug] EHS: Event was handled successfully by all handlers. 05:30:19 06/16/17 19813 [debug] Assembling view: owa_installView 05:30:19 06/16/17 19813 [debug] Total session time: 11.4408659935 05:30:19 06/16/17 19813 [debug] goodbye from OWA

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.

bfarayev commented 7 years ago

I'm having the same issue as @satishverma143 after fresh install. Additionally getting this when I add a new site: Can this be a reason? 

Notice: Array to string conversion in <path-to-owa>/plugins/db/owa_db_mysql.php on line 220
blankrustic commented 7 years ago

same issue.

I first installed from the webpage download, but had to change my PHP version back to an obsolete version 5.x to get it to work.

Then, after getting it working, I liked the heat mapping and dom stream, but I didn't want to use PHP 5 for any production sites, so I kept reading and found that using the master branch should work with PHP 7, so I switched to 7.1.11, uploaded the files from the master, but now I cannot get past install.php.

It appears to install correctly, but then, as others have said, when I click the "Login and generate a site tracker!" button, it takes me back to the start.

This is the best analytics software there is for free, and one of the best period. I know because I've downloaded and tried or researched almost all of them over the years. Now I'm just beginning a new project with a different host, and I want to use OWA on a PHP 7 server, but it won't go.

blankrustic commented 7 years ago

On a whim I changed my PHP version to 7.0.25, and with a fresh installation and database, it went right through exactly as intended, and I have a working analytics system now.

padams commented 7 years ago

Try a fresh install/db with 7.1

I suspect your DB was in a bad state before the master fixes were applied.

On Nov 1, 2017, at 6:15 AM, blankrustic notifications@github.com wrote:

On a whim I changed my PHP version to 7.0.25, and with a fresh installation and database, it went right through exactly as intended, and I have a working analytics system now.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.

bytephunk commented 6 years ago

Hello. Same issue here. After enabling debugging I narrowed it down to this issue. There is a second mysql Insert query which triggers an error in the mysql engine due to a duplicate entry on a key field. The second mysql i guess should be an UPDATE statement?

11:07:27 2017-12-09 6659 [debug_log] Query: INSERT into owa_configuration (id, settings) VALUES ('1', 'a:1:{s:4:\"base\";a:2:{s:14:\"schema_version\";i:9;s:9:\"is_active\";b:1;}}') 11:07:27 2017-12-09 6659 [debug_log] Query: INSERT into owa_configuration (id, settings) VALUES ('1', 'a:1:{s:4:\"base\";a:3:{s:14:\"schema_version\";i:9;s:9:\"is_active\";b:1;s:16:\"install_complete\";b:1;}}') 11:07:27 2017-12-09 6659 [debug_log] A MySQL error ocured. Error: (1062) Duplicate entry '1' for key 'PRIMARY'. Query: INSERT into owa_configuration (id, settings) VALUES ('1', 'a:1:{s:4:\"base\";a:3:{s:14:\"schema_version\";i:9;s:9:\"is_active\";b:1;s:16:\"install_complete\";b:1;}}')

EXman007 commented 5 years ago

Got the same issue... Re - installed like 3 times from fresh clearly I am doing something wrong... logs folder owa/owa-data/logs is empty from logs... any suggestions ?

padams commented 4 years ago

This has been fixed in master.