Author Topic: Import goes through without error but no contacts show up (Read 1434 times)

Colin Sagan · August 08, 2007, 12:23:43 pm

I am trying to import a group of contacts, and everything seems to go fine with no errors. But when I get to the final screen where I can click "done", I notice that my contacts haven't been added to the groups I specified, only to find out that they aren't importing at all. I've tried all the different import settings but all with the same result.

Nothing is going into the civicrm_contact table.

I know this is super vague but if anyone had any troubleshooting suggestions they would be greatly appreciated.

Thanks,
Colin

Colin Sagan · August 08, 2007, 12:37:00 pm

When I turn on debugging I get this immediately:

Error Details:

Code: [Select]

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => UPDATE  civicrm_domain  SET name = 'Domain Name 1' , contact_name = 'Domain Contact Name' , email_domain = 'FIXME.ORG' , config_backend = 'a:94:{s:5:\"debug\";s:1:\"1\";s:9:\"backtrace\";s:1:\"0\";s:18:\"fatalErrorTemplate\";s:13:\"CRM/error.tpl\";s:17:\"fatalErrorHandler\";s:0:\"\";s:11:\"mapProvider\";s:0:\"\";s:9:\"mapAPIKey\";s:86:\"ABQIAAAAMBnHJjsLu2g3KL-RBZkx6RSj4J82GgdWcvorIT-bjDG-X6xwyhTl34J5G-P6ybLpe_Trxy6vwoxpkQ\";s:10:\"lcMessages\";s:5:\"en_US\";s:10:\"lcMonetary\";s:5:\"en_US\";s:11:\"moneyformat\";s:5:\"%c %a\";s:12:\"countryLimit\";a:109:{i:0;s:4:\"1228\";i:1;s:4:\"1013\";i:2;s:4:\"1010\";i:3;s:4:\"1020\";i:4;s:4:\"1029\";i:5;s:4:\"1044\";i:6;s:4:\"1045\";i:7;s:4:\"1048\";i:8;s:4:\"1059\";i:9;s:4:\"1076\";i:10;s:4:\"1082\";i:11;s:4:\"1094\";i:12;s:4:\"1098\";i:13;s:4:\"1101\";i:14;s:4:\"1102\";i:15;s:4:\"1103\";i:16;s:4:\"1104\";i:17;s:4:\"1105\";i:18;s:4:\"1106\";i:19;s:4:\"1107\";i:20;s:4:\"1109\";i:21;s:4:\"1112\";i:22;s:4:\"1114\";i:23;s:4:\"1115\";i:24;s:4:\"1131\";i:25;s:4:\"1140\";i:26;s:4:\"1146\";i:27;s:4:\"1152\";i:28;s:4:\"1157\";i:29;s:4:\"1161\";i:30;s:4:\"1165\";i:31;s:4:\"1169\";i:32;s:4:\"1170\";i:33;s:4:\"1173\";i:34;s:4:\"1174\";i:35;s:4:\"1177\";i:36;s:4:\"1178\";i:37;s:4:\"1191\";i:38;s:4:\"1195\";i:39;s:4:\"1203\";i:40;s:4:\"1204\";i:41;s:4:\"1205\";i:42;s:4:\"1208\";i:43;s:4:\"1217\";i:44;s:4:\"1225\";i:45;s:4:\"1226\";i:46;s:4:\"1227\";i:47;s:4:\"1229\";i:48;s:4:\"1232\";i:49;s:4:\"1233\";i:50;s:4:\"1017\";i:51;s:4:\"1150\";i:52;s:4:\"1196\";i:53;s:4:\"1089\";i:54;s:4:\"1211\";i:55;s:4:\"1219\";i:56;s:4:\"1223\";i:57;s:4:\"1039\";i:58;s:4:\"1083\";i:59;s:4:\"1234\";i:60;s:4:\"1003\";i:61;s:4:\"1011\";i:62;s:4:\"1033\";i:63;s:4:\"1038\";i:64;s:4:\"1062\";i:65;s:4:\"1066\";i:66;s:4:\"1074\";i:67;s:4:\"1133\";i:68;s:4:\"1188\";i:69;s:4:\"1240\";i:70;s:4:\"1014\";i:71;s:4:\"1025\";i:72;s:4:\"1065\";i:73;s:4:\"1085\";i:74;s:4:\"1108\";i:75;s:4:\"1163\";i:76;s:4:\"1172\";i:77;s:4:\"1187\";i:78;s:4:\"1198\";i:79;s:4:\"1002\";i:80;s:4:\"1018\";i:81;s:4:\"1019\";i:82;s:4:\"1053\";i:83;s:4:\"1058\";i:84;s:4:\"1069\";i:85;s:4:\"1070\";i:86;s:4:\"1075\";i:87;s:4:\"1081\";i:88;s:4:\"1093\";i:89;s:4:\"1099\";i:90;s:4:\"1100\";i:91;s:4:\"1119\";i:92;s:4:\"1120\";i:93;s:4:\"1125\";i:94;s:4:\"1148\";i:95;s:4:\"1154\";i:96;s:4:\"1155\";i:97;s:4:\"1176\";i:98;s:4:\"1193\";i:99;s:4:\"1199\";i:100;s:4:\"1200\";i:101;s:4:\"1210\";i:102;s:4:\"1218\";i:103;s:4:\"1224\";i:104;s:4:\"1237\";i:105;s:4:\"1238\";i:106;s:4:\"1055\";i:107;s:4:\"1130\";i:108;s:4:\"1021\";}s:13:\"provinceLimit\";a:10:{i:0;s:4:\"1228\";i:1;s:4:\"1039\";i:2;s:4:\"1140\";i:3;s:4:\"1101\";i:4;s:4:\"1131\";i:5;s:4:\"1074\";i:6;s:4:\"1157\";i:7;s:4:\"1106\";i:8;s:4:\"1013\";i:9;s:4:\"1029\";}s:21:\"defaultContactCountry\";s:4:\"1228\";s:15:\"defaultCurrency\";s:3:\"USD\";s:14:\"legacyEncoding\";s:12:\"Windows-1252\";s:13:\"addressFormat\";s:134:\"{street_address}\r\n{supplemental_address_1}\r\n{supplemental_address_2}\r\n{city}{, }{county}{ }{state_province}{ }{postal_code}\r\n{country}\";s:17:\"maxLocationBlocks\";s:1:\"4\";s:13:\"includeCounty\";s:1:\"1\";s:18:\"AddressStdProvider\";s:0:\"\";s:16:\"AddressStdUserID\";s:0:\"\";s:13:\"AddressStdURL\";s:0:\"\";s:20:\"individualNameFormat\";s:87:\"{individual_prefix}{ } {first_name}{ }{middle_name}{ }{last_name}{ }{individual_suffix}\";s:18:\"mailingLabelFormat\";s:139:\"{contact_name}\r\n{street_address}\r\n{supplemental_address_1}\r\n{supplemental_address_2}\r\n{city}{, }{state_province}{ }{postal_code}\r\n{country}\";s:24:\"userFrameworkResourceURL\";s:56:\"http://clpp.hampshire.edu/crm/sites/all/modules/civicrm/\";s:14:\"imageUploadURL\";s:63:\"http://clpp.hampshire.edu/crm/files/civicrm/persist/contribute/\";s:16:\"enableComponents\";a:1:{i:0;s:9:\"CiviEvent\";}s:9:\"uploadDir\";s:44:\"/var/www/clpp/clpp/crm/files/civicrm/upload/\";s:14:\"imageUploadDir\";s:56:\"/var/www/clpp/clpp/crm/files/civicrm/persist/contribute/\";s:19:\"customFileUploadDir\";s:51:\"/var/www/clpp/clpp/crm/files/civicrm/upload/custom/\";s:17:\"customTemplateDir\";s:39:\"/var/www/clpp/clpp/crm/custom_templates\";s:8:\"daoDebug\";i:0;s:9:\"smartyDir\";s:26:\"/opt/local/lib/php/Smarty/\";s:10:\"pluginsDir\";s:34:\"/opt/local/lib/php/Smarty/plugins/\";s:11:\"templateDir\";s:12:\"./templates/\";s:8:\"mainMenu\";N;s:12:\"resourceBase\";s:46:\"http://clpp.hampshire.edu/crm/modules/civicrm/\";s:15:\"DAOFactoryClass\";s:23:\"CRM_Contact_DAO_Factory\";s:8:\"cleanURL\";b:0;s:15:\"addressSequence\";a:8:{i:0;s:14:\"street_address\";i:1;s:22:\"supplemental_address_1\";i:2;s:22:\"supplemental_address_2\";i:3;s:4:\"city\";i:4;s:6:\"county\";i:5;s:14:\"state_province\";i:6;s:11:\"postal_code\";i:7;s:7:\"country\";}s:18:\"dateformatDatetime\";s:20:\"%B %E%f, %Y %l:%M %P\";s:14:\"dateformatFull\";s:11:\"%B %E%f, %Y\";s:17:\"dateformatPartial\";s:5:\"%B %Y\";s:14:\"dateformatYear\";s:2:\"%Y\";s:16:\"dateformatQfDate\";s:8:\"%b %d %Y\";s:20:\"dateformatQfDatetime\";s:20:\"%b %d %Y, %I : %M %P\";s:15:\"currencySymbols\";s:0:\"\";s:21:\"defaultCurrencySymbol\";s:1:\"$\";s:14:\"gettextCodeset\";s:5:\"utf-8\";s:13:\"gettextDomain\";s:7:\"civicrm\";s:10:\"smtpServer\";s:18:\"smtp.hampshire.edu\";s:8:\"smtpPort\";i:25;s:8:\"smtpAuth\";b:0;s:12:\"smtpUsername\";s:0:\"\";s:12:\"smtpPassword\";s:0:\"\";s:13:\"userFramework\";s:6:\"Drupal\";s:20:\"userFrameworkVersion\";d:4.5999999999999996447286321199499070644378662109375;s:18:\"userFrameworkClass\";s:23:\"CRM_Utils_System_Drupal\";s:13:\"userHookClass\";s:21:\"CRM_Utils_Hook_Drupal\";s:19:\"userPermissionClass\";s:26:\"CRM_Core_Permission_Drupal\";s:19:\"userFrameworkURLVar\";s:1:\"q\";s:16:\"userFrameworkDSN\";N;s:27:\"userFrameworkUsersTableName\";s:5:\"users\";s:21:\"userFrameworkFrontend\";b:0;s:12:\"mysqlVersion\";d:4.0999999999999996447286321199499070644378662109375;s:9:\"mysqlPath\";s:9:\"/usr/bin/\";s:17:\"maxImportFileSize\";i:1048576;s:13:\"geocodeMethod\";s:0:\"\";s:12:\"versionCheck\";b:1;s:12:\"mailerPeriod\";i:180;s:13:\"verpSeparator\";s:1:\".\";s:16:\"mailerBatchLimit\";i:0;s:9:\"enableSSL\";i:0;s:15:\"captchaFontPath\";s:25:\"/usr/X11R6/lib/X11/fonts/\";s:11:\"captchaFont\";s:17:\"HelveticaBold.ttf\";s:20:\"includeEmailInSearch\";i:1;s:24:\"includeAlphabeticalPager\";i:1;s:20:\"includeOrderByClause\";i:1;s:15:\"includeDomainID\";i:1;s:13:\"oldInputStyle\";i:1;s:11:\"includeDojo\";i:1;s:12:\"paymentClass\";N;s:18:\"paymentBillingMode\";N;s:15:\"paymentPassword\";a:2:{s:4:\"live\";s:0:\"\";s:4:\"test\";s:0:\"\";}s:14:\"paymentSubject\";N;s:10:\"paymentKey\";a:2:{s:4:\"live\";s:0:\"\";s:4:\"test\";s:0:\"\";}s:16:\"paymentProcessor\";s:0:\"\";s:22:\"paymentProcessorButton\";s:57:\"https://www.paypal.com/en_US/i/btn/btn_xpressCheckout.gif\";s:23:\"paymentPayPalExpressUrl\";s:14:\"www.paypal.com\";s:27:\"paymentPayPalExpressTestUrl\";s:22:\"www.sandbox.paypal.com\";s:12:\"mapGeoCoding\";i:1;s:20:\"paymentExpressButton\";s:57:\"https://www.paypal.com/en_US/i/btn/btn_xpressCheckout.gif\";s:20:\"paymentCertPath_test\";s:1:\"/\";s:20:\"paymentCertPath_live\";s:1:\"/\";s:20:\"paymentUsername_test\";s:0:\"\";s:20:\"paymentUsername_live\";s:0:\"\";}'   WHERE (  civicrm_domain.id = 1 )   
[nativecode=1205 ** Lock wait timeout exceeded; try restarting transaction]

[/code]

Kurund Jalmi · August 09, 2007, 04:08:37 am

Colin:

Can you try to replicate this on http://demo.civicrm.org/drupal. If yes then file an issue in jira and do attach sample csv file.

kurund

Dave Greenberg · August 09, 2007, 02:41:25 pm

Colin - The query that's erroring out is a core insert to set configuration data in the civicrm_domain table - so I would guess that things on this install are somewhat or very messed up. :-( Does any record inserts work on this install?

I googled on the error message you're getting:
lock wait timeout exceeded try restarting transaction

... and it there's a number of posts related to INNODB issues, etc. You might look through some of those and see if anything rings a bell.

CiviCRM Community Forums (archive)

News:

Author Topic: Import goes through without error but no contacts show up (Read 1434 times)

Colin Sagan

Import goes through without error but no contacts show up

Colin Sagan

Re: Import goes through without error but no contacts show up

Kurund Jalmi

Re: Import goes through without error but no contacts show up

Dave Greenberg

Re: Import goes through without error but no contacts show up