by Rolustech

Visualize your CRM data! Integrate Google Maps with SugarCRM to see leads, contacts, and accounts on a map. Plan routes, optimize sales efforts. Effortless location intelligence.

Free Trial

By clicking you consent to share your profile with the developer

#2728 - After instaling RT Sales there is a database problem by clicking "Userr Settings"?

Closed Bug? created by hka 7 years ago

After instaling RT Sales there is a database problem by clicking "Userr Settings"? I used de Sugar Community version SugarCE-6.5.20 and install the RT_SalesMap_Sugar6V4.0 You team asked for the Log

Wed Nov 30 09:41:08 2016 [8697][1][FATAL] Query Failed: SELECT DISTINCT(billing_address_country) FROM accounts WHERE deleted=0 AND (maps_lat IS NOT NULL OR TRIM(maps_lat) !='') AND (maps_long IS NOT NULL OR TRIM(maps_long) !=''): MySQL error 1054: Unknown column 'maps_lat' in 'where clause' Wed Nov 30 09:41:08 2016 [8697][1][FATAL] Query Failed: SELECT DISTINCT(primary_address_country) FROM leads WHERE deleted=0 AND (maps_lat IS NOT NULL OR TRIM(maps_lat) !='') AND (maps_long IS NOT NULL OR TRIM(maps_long) !=''): MySQL error 1054: Unknown column 'maps_lat' in 'where clause' Wed Nov 30 09:41:08 2016 [8697][1][FATAL] Query Failed: SELECT DISTINCT(primary_address_country) FROM contacts WHERE deleted=0 AND (maps_lat IS NOT NULL OR TRIM(maps_lat) !='') AND (maps_long IS NOT NULL OR TRIM(maps_long) !=''): MySQL error 1054: Unknown column 'maps_lat' in 'where clause' Wed Nov 30 09:41:08 2016 [8697][1][FATAL] Query Failed: SELECT COUNT(id) as total_records FROM accounts WHERE (accounts.maps_lat IS NOT NULL AND TRIM(accounts.maps_lat) !='') AND (accounts.maps_long IS NOT NULL AND TRIM(accounts.maps_long) !='') AND accounts.deleted=0 UNION ALL SELECT COUNT(id) as total_records FROM contacts WHERE (contacts.maps_lat IS NOT NULL AND TRIM(contacts.maps_lat) !='') AND (contacts.maps_long IS NOT NULL AND TRIM(contacts.maps_long) !='') AND contacts.deleted=0 UNION ALL SELECT COUNT(id) as total_records FROM leads WHERE (leads.maps_lat IS NOT NULL AND TRIM(leads.maps_lat) !='') AND (leads.maps_long IS NOT NULL AND TRIM(leads.maps_long) !='') AND leads.deleted=0: MySQL error 1054: Unknown column 'accounts.maps_lat' in 'where clause' Wed Nov 30 09:41:08 2016 [8697][1][FATAL] Query Failed: SELECT records_per_page FROM rt_maps WHERE userid='1' AND deleted=0: MySQL error 1146: Table 'Smartcrm.rt_maps' doesn't exist Wed Nov 30 09:41:08 2016 [8697][1][FATAL] Query Failed: SELECT id,CONCAT(IFNULL(first_name,' '),' ',last_name) AS name,primary_address_street,primary_address_city,primary_address_state,primary_address_postalcode,primary_address_country,salutation,status,lead_source,maps_lat,maps_long,(SELECT DISTINCT table_name FROM information_schema.TABLES WHERE table_name='leads') AS tablename FROM leads WHERE (leads.maps_lat IS NOT NULL AND TRIM(leads.maps_lat) !='') AND (leads.maps_long IS NOT NULL AND TRIM(leads.maps_long) !='') AND leads.deleted=0 UNION ALL SELECT id,CONCAT(IFNULL(first_name,' '),' ',last_name) AS name,primary_address_street,primary_address_city,primary_address_state,primary_address_postalcode,primary_address_country,salutation,lead_source,assistant,maps_lat,maps_long,(SELECT DISTINCT table_name FROM information_schema.TABLES WHERE table_name='contacts') AS tablename FROM contacts WHERE (contacts.maps_lat IS NOT NULL AND TRIM(contacts.maps_lat) !='') AND (contacts.maps_long IS NOT NULL AND TRIM(contacts.maps_long) !='') AND contacts.deleted=0 UNION ALL SELECT id,name,billing_address_street,billing_address_city,billing_address_state,billing_address_postalcode,billing_address_country,website,account_type,industry,maps_lat,maps_long,(SELECT DISTINCT table_name FROM information_schema.TABLES WHERE table_name='accounts') AS tablename FROM accounts WHERE (accounts.maps_lat IS NOT NULL AND TRIM(accounts.maps_lat) !='') AND (accounts.maps_long IS NOT NULL AND TRIM(accounts.maps_long) !='') AND accounts.deleted=0 LIMIT 0,100: MySQL error 1054: Unknown column 'maps_lat' in 'field list' Wed Nov 30 09:41:08 2016 [8697][1][FATAL] Query Failed: SELECT Preferences,license_key,license_validator FROM rt_maps WHERE deleted=0 AND userid='1': MySQL error 1146: Table 'Smartcrm.rt_maps' doesn't exist Wed Nov 30 09:41:08 2016 [8697][1][FATAL] Error inserting into table: rt_maps: Query Failed: INSERT INTO rt_maps (id,name,date_entered,date_modified,modified_user_id,created_by,deleted,userid,Preferences,records_per_page,license_key,license_validator) VALUES ('63f0febd-ef0d-e8c9-3715-583e90de5e49','','2016-11-30 08:41:08','2016-11-30 08:41:08','1','1',0,'1','default',100,'',0): MySQL error 1146: Table 'Smartcrm.rt_maps' doesn't exist

  1. hka member avatar

    hka

    7 years ago

    I try to fix the with Quick Repair and Rebuild Repairs and rebuilds DB, Extensions, Vardefs, Sugar Dashlets etc.

    After that I put the exicute button, but still the same problem. Seems the SQL is missing tables?

  2. rolustech-primary-contact member avatar

    Rolustech Verified Purchase

    7 years ago

    Hi,

    Thank you for reaching out.

    Let us investigate the issue and we will get back to you as soon as we have an update.

    Kind Regards, Rolustech Support Email: support@rolustech.com Website: www.rolustech.com

  3. rolustech-primary-contact member avatar

    Rolustech Verified Purchase

    7 years ago

    Hi,

    Set your instance permission 775 and give full permission 777 to cache directory in the Sugar root directory. After this, do a quick repair and rebuild from admin.

    If you are unable to achieve this please share your SSH credentials and Sugar admin credentials with us at support@rolustech.com and our technical team will resolve it for you.

    Kind Regards, Rolustech Support Email: support@rolustech.com Website: www.rolustech.com

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating