Database table(s) not created
hubris - June 2, 2009 - 19:31
| Project: | Salesforce |
| Version: | 6.x-2.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | won't fix |
Jump to:
Description
I just installed Salesforce module 6.x-2.x-dev, with soapclient in correct folder. Running Drupal 6.10, with Profile module, Advanced User module running. As soon as I activate the Salesforce User module I get the following errors:
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'fields) VALUES ('user', 'Lead', '', 1, 'a:0:{}')' at line 1 query: INSERT INTO salesforce_field_map (drupal, salesforce, action, automatic, fields) VALUES ('user', 'Lead', '', 1, 'a:0:{}') in /.../www/htdocs/includes/common.inc on line 3422.
user warning: Table 'drupal.salesforce_object_map' doesn't exist query: SELECT sfid, fieldmap FROM salesforce_object_map WHERE drupal_type = 'user' AND oid = 1 in /.../www/htdocs/modules/salesforce/salesforce_api/salesforce_api.module on line 553.
That fieldmap does not exist.
user warning: Table 'drupal.salesforce_object_map' doesn't exist query: SELECT sfid, fieldmap FROM salesforce_object_map WHERE drupal_type = 'user' AND oid = 1 in /.../www/htdocs/modules/salesforce/salesforce_api/salesforce_api.module on line 553.
user warning: Table 'drupal.salesforce_field_map' doesn't exist query: SELECT fieldmap, drupal, salesforce FROM salesforce_field_map in /.../www/htdocs/modules/salesforce/salesforce_api/salesforce_api.admin.inc on line 96.
user warning: Table 'drupal.salesforce_object_map' doesn't exist query: SELECT sfid, fieldmap FROM salesforce_object_map WHERE drupal_type = 'user' AND oid = 1 in /.../www/htdocs/modules/salesforce/salesforce_api/salesforce_api.module on line 553.
user warning: Table 'drupal.salesforce_object_map' doesn't exist query: SELECT sfid, fieldmap FROM salesforce_object_map WHERE drupal_type = 'user' AND oid = 1 in /.../www/htdocs/modules/salesforce/salesforce_api/salesforce_api.module on line 553.
user warning: Table 'drupal.salesforce_object_map' doesn't exist query: SELECT sfid, fieldmap FROM salesforce_object_map WHERE drupal_type = 'user' AND oid = 1 in /.../www/htdocs/modules/salesforce/salesforce_api/salesforce_api.module on line 553. Looking at database, no Salesforce tables are created. Ran Update.php just in case (nothing for Salesforce shows up anywhere),... no change.
-Chris
#1
I get similar errors:
# user warning: Table 'treepeople_org_renubora.salesforce_field_map' doesn't exist query: INSERT INTO salesforce_field_map (drupal, salesforce, action, automatic, fields) VALUES ('node_profile', 'Contact', '', 1, 'a:0:{}') in /home/dev/common/crsp/branches/6-1/rel/drupal/includes/common.inc on line 3501.
# user warning: Table 'treepeople_org_renubora.salesforce_field_map' doesn't exist query: SELECT fieldmap, drupal, salesforce FROM salesforce_field_map in /home/dev/treepeople.org/treepeople_org/shadow/treepeople_org/branches/renubora/drupal/modules/salesforce/salesforce_api/salesforce_api.admin.inc on line 96.
# user warning: Table 'treepeople_org_renubora.salesforce_object_map' doesn't exist query: SELECT sfid, fieldmap FROM salesforce_object_map WHERE drupal_type = 'user' AND oid = 1 in /home/dev/treepeople.org/treepeople_org/shadow/treepeople_org/branches/renubora/drupal/modules/salesforce/salesforce_api/salesforce_api.module on line 553.
# user warning: Table 'treepeople_org_renubora.salesforce_object_map' doesn't exist query: SELECT sfid, fieldmap FROM salesforce_object_map WHERE drupal_type = 'user' AND oid = 7 in /home/dev/treepeople.org/treepeople_org/shadow/treepeople_org/branches/renubora/drupal/modules/salesforce/salesforce_api/salesforce_api.module on line 553.
-Renu
#2
Hey guys, the latest dev udpates last week added a new (hopefully permanent) database schema, but it only fires on install. We haven't started with hook_update yet, and probably won't until we get to an actual alpha or beta release.
For right now, if you uninstall and reinstall, you'll get your schema.
#3
Marking wontfix. Next release we will start managing hook_update for data issues.
#4
Could you explain the "uninstall and reinstall" fix? Salesforce doesn't show up under the "uninstall" tab and just unchecking the boxes and then checking again doesn't seem to trigger the install script... update.php doesn't seem to do it for me either.
thanks