[turba] Trouble Importing Address Fields

Struggle Tribe digitalstruggle at yahoo.com
Fri Jul 20 11:30:25 UTC 2007


Hello everyone, 

In my last message I mentioned that I had tried following the directions at this page:
http://wiki.horde.org/TurbaOutlook2003

to add more fields to Turba's contacts.  The first time I tried this, it didn't work and I reinstalled the server.  I just tried it again after taking note of this line:
(Note: the addresslink type is only available
in the CVS version of Horde/Turba. If you want to use this howto for
the current stable Horde/Turba, use address instead.  It's not as pretty, but it will do the job)

I replaced every instance of "addresslink" in turba/config/attributes.php with "address".  I put the SQL script at the bottom into the "SQL Shell" feature under Administration and executed it.

It spit out this (Warning, lots and lots of text) ... actually, before you get to that, I'll tell you what ended up happening.  If I try to look at "My Address Book", for example, it will say "DB Error: no such field" with a stop sign and a hand near the top.  If I try to add a contact to My Address Book (all of the additional fields are there, btw), it says "There was an error adding the new contact. Contact your system administrator for further help.DB Error: no such field:" in the same fashion near the top.  Yes, after I edited all the files and executed the SQL script, I restarted Apache and MySQL.  I forgot to mention that I am running XAMPP 1.6.2 on WIndows XP with Horde Groupware 1.0.1. 

Here's all that text I promised earlier:

[Query Header - I added this --Christian]

CREATE TABLE turba_objects (
    object_id VARCHAR(32) NOT NULL,
    owner_id VARCHAR(255) NOT NULL,
    object_type VARCHAR(255) DEFAULT 'Object' NOT NULL,
    object_uid VARCHAR(255),
    object_members BLOB,
    object_lastname VARCHAR(255),
    object_alias VARCHAR(32),
    object_email VARCHAR(255),
    object_homestreet VARCHAR(255),
    object_homestreet3 VARCHAR(255),
    object_workstreet VARCHAR(255),
    object_workstreet3 VARCHAR(255),
    object_homephone VARCHAR(25),
    object_workphone VARCHAR(25),
    object_cellphone VARCHAR(25),
    object_workfax VARCHAR(25),
    object_title VARCHAR(255),
    object_company VARCHAR(255),
    object_notes TEXT,
    object_pgppublickey TEXT,
    object_smimepublickey TEXT,
    object_freebusyurl VARCHAR(255),
    object_firstname VARCHAR(255),
    object_homecity VARCHAR(255),
    object_homeprovince VARCHAR(255),
    object_homepostalcode VARCHAR(255),
    object_homecountry VARCHAR(255),
    object_homestreet2 VARCHAR(255),
    object_workstreet2 VARCHAR(255),
    object_workcity VARCHAR(255),
    object_workprovince VARCHAR(255),
    object_workpostalcode VARCHAR(255),
    object_workcountry VARCHAR(255),
    object_website VARCHAR(255),
    object_birthday VARCHAR(255),
    object_nickname VARCHAR(255),
    object_office VARCHAR(255),
    object_jobtitle VARCHAR(255),
    object_profession VARCHAR(255),
    object_manager VARCHAR(255),
    object_assistant VARCHAR(255),
    object_suffix VARCHAR(255),
    object_spouse VARCHAR(255),
    object_anniversary VARCHAR(255),
    object_email2 VARCHAR(255),
    object_email3 VARCHAR(255),
    object_category VARCHAR(255),
    object_assistantphone VARCHAR(25),
    object_workphone2 VARCHAR(25),
    object_callback VARCHAR(255),
    object_carphone VARCHAR(25),
    object_companyphone VARCHAR(25),
    object_homephone2 VARCHAR(25),
    object_homefax VARCHAR(25),
    object_isdn VARCHAR(255),
    object_otherphone VARCHAR(25),
    object_otherfax VARCHAR(25),
    object_pager VARCHAR(25),
    object_primaryphone VARCHAR(25),
    object_radio VARCHAR(255),
    object_telex VARCHAR(255),
    object_ttytdd VARCHAR(255),
    object_otherstreet VARCHAR(255),
    object_otherstreet2 VARCHAR(255),
    object_otherstreet3 VARCHAR(255),
    object_othercity VARCHAR(255),
    object_otherprovince VARCHAR(255),
    object_otherpostalcode VARCHAR(255),
    object_othercountry VARCHAR(255),
    object_middlename VARCHAR(255),
    object_department VARCHAR(255),
--
    PRIMARY KEY(object_id)
);

CREATE INDEX turba_owner_idx ON turba_objects (owner_id);

GRANT SELECT, INSERT, UPDATE, DELETE ON turba_objects TO horde;
[Results Header - I added this --Christian]

object(DB_Error)#13 (8) {
  ["error_message_prefix"]=>
  string(0) ""
  ["mode"]=>
  int(1)
  ["level"]=>
  int(1024)
  ["code"]=>
  int(-2)
  ["message"]=>
  string(22) "DB Error: syntax error"
  ["userinfo"]=>
  string(2974) "CREATE TABLE turba_objects (
    object_id VARCHAR(32) NOT NULL,
    owner_id VARCHAR(255) NOT NULL,
    object_type VARCHAR(255) DEFAULT 'Object' NOT NULL,
    object_uid VARCHAR(255),
    object_members BLOB,
    object_lastname VARCHAR(255),
    object_alias VARCHAR(32),
    object_email VARCHAR(255),
    object_homestreet VARCHAR(255),
    object_homestreet3 VARCHAR(255),
    object_workstreet VARCHAR(255),
    object_workstreet3 VARCHAR(255),
    object_homephone VARCHAR(25),
    object_workphone VARCHAR(25),
    object_cellphone VARCHAR(25),
    object_workfax VARCHAR(25),
    object_title VARCHAR(255),
    object_company VARCHAR(255),
    object_notes TEXT,
    object_pgppublickey TEXT,
    object_smimepublickey TEXT,
    object_freebusyurl VARCHAR(255),
    object_firstname VARCHAR(255),
    object_homecity VARCHAR(255),
    object_homeprovince VARCHAR(255),
    object_homepostalcode VARCHAR(255),
    object_homecountry VARCHAR(255),
    object_homestreet2 VARCHAR(255),
    object_workstreet2 VARCHAR(255),
    object_workcity VARCHAR(255),
    object_workprovince VARCHAR(255),
    object_workpostalcode VARCHAR(255),
    object_workcountry VARCHAR(255),
    object_website VARCHAR(255),
    object_birthday VARCHAR(255),
    object_nickname VARCHAR(255),
    object_office VARCHAR(255),
    object_jobtitle VARCHAR(255),
    object_profession VARCHAR(255),
    object_manager VARCHAR(255),
    object_assistant VARCHAR(255),
    object_suffix VARCHAR(255),
    object_spouse VARCHAR(255),
    object_anniversary VARCHAR(255),
    object_email2 VARCHAR(255),
    object_email3 VARCHAR(255),
    object_category VARCHAR(255),
    object_assistantphone VARCHAR(25),
    object_workphone2 VARCHAR(25),
    object_callback VARCHAR(255),
    object_carphone VARCHAR(25),
    object_companyphone VARCHAR(25),
    object_homephone2 VARCHAR(25),
    object_homefax VARCHAR(25),
    object_isdn VARCHAR(255),
    object_otherphone VARCHAR(25),
    object_otherfax VARCHAR(25),
    object_pager VARCHAR(25),
    object_primaryphone VARCHAR(25),
    object_radio VARCHAR(255),
    object_telex VARCHAR(255),
    object_ttytdd VARCHAR(255),
    object_otherstreet VARCHAR(255),
    object_otherstreet2 VARCHAR(255),
    object_otherstreet3 VARCHAR(255),
    object_othercity VARCHAR(255),
    object_otherprovince VARCHAR(255),
    object_otherpostalcode VARCHAR(255),
    object_othercountry VARCHAR(255),
    object_middlename VARCHAR(255),
    object_department VARCHAR(255),
--
    PRIMARY KEY(object_id)
);

CREATE INDEX turba_owner_idx ON turba_objects (owner_id);

GRANT SELECT, INSERT, UPDATE, DELETE ON turba_objects TO horde; [nativecode=1064 ** 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 ';

CREATE INDEX turba_owner_idx ON turba_objects (owner_id);

GRANT SELECT, ' at line 75]"
  ["backtrace"]=>
  array(7) {
    [0]=>
    array(6) {
      ["file"]=>
      string(33) "C:\xampp\htdocs\horde\pear\DB.php"
      ["line"]=>
      int(966)
      ["function"]=>
      string(10) "PEAR_Error"
      ["class"]=>
      string(10) "PEAR_Error"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(5) {
        [0]=>
        string(22) "DB Error: syntax error"
        [1]=>
        int(-2)
        [2]=>
        int(1)
        [3]=>
        int(1024)
        [4]=>
        string(2974) "CREATE TABLE turba_objects (
    object_id VARCHAR(32) NOT NULL,
    owner_id VARCHAR(255) NOT NULL,
    object_type VARCHAR(255) DEFAULT 'Object' NOT NULL,
    object_uid VARCHAR(255),
    object_members BLOB,
    object_lastname VARCHAR(255),
    object_alias VARCHAR(32),
    object_email VARCHAR(255),
    object_homestreet VARCHAR(255),
    object_homestreet3 VARCHAR(255),
    object_workstreet VARCHAR(255),
    object_workstreet3 VARCHAR(255),
    object_homephone VARCHAR(25),
    object_workphone VARCHAR(25),
    object_cellphone VARCHAR(25),
    object_workfax VARCHAR(25),
    object_title VARCHAR(255),
    object_company VARCHAR(255),
    object_notes TEXT,
    object_pgppublickey TEXT,
    object_smimepublickey TEXT,
    object_freebusyurl VARCHAR(255),
    object_firstname VARCHAR(255),
    object_homecity VARCHAR(255),
    object_homeprovince VARCHAR(255),
    object_homepostalcode VARCHAR(255),
    object_homecountry VARCHAR(255),
    object_homestreet2 VARCHAR(255),
    object_workstreet2 VARCHAR(255),
    object_workcity VARCHAR(255),
    object_workprovince VARCHAR(255),
    object_workpostalcode VARCHAR(255),
    object_workcountry VARCHAR(255),
    object_website VARCHAR(255),
    object_birthday VARCHAR(255),
    object_nickname VARCHAR(255),
    object_office VARCHAR(255),
    object_jobtitle VARCHAR(255),
    object_profession VARCHAR(255),
    object_manager VARCHAR(255),
    object_assistant VARCHAR(255),
    object_suffix VARCHAR(255),
    object_spouse VARCHAR(255),
    object_anniversary VARCHAR(255),
    object_email2 VARCHAR(255),
    object_email3 VARCHAR(255),
    object_category VARCHAR(255),
    object_assistantphone VARCHAR(25),
    object_workphone2 VARCHAR(25),
    object_callback VARCHAR(255),
    object_carphone VARCHAR(25),
    object_companyphone VARCHAR(25),
    object_homephone2 VARCHAR(25),
    object_homefax VARCHAR(25),
    object_isdn VARCHAR(255),
    object_otherphone VARCHAR(25),
    object_otherfax VARCHAR(25),
    object_pager VARCHAR(25),
    object_primaryphone VARCHAR(25),
    object_radio VARCHAR(255),
    object_telex VARCHAR(255),
    object_ttytdd VARCHAR(255),
    object_otherstreet VARCHAR(255),
    object_otherstreet2 VARCHAR(255),
    object_otherstreet3 VARCHAR(255),
    object_othercity VARCHAR(255),
    object_otherprovince VARCHAR(255),
    object_otherpostalcode VARCHAR(255),
    object_othercountry VARCHAR(255),
    object_middlename VARCHAR(255),
    object_department VARCHAR(255),
--
    PRIMARY KEY(object_id)
);

CREATE INDEX turba_owner_idx ON turba_objects (owner_id);

GRANT SELECT, INSERT, UPDATE, DELETE ON turba_objects TO horde; [nativecode=1064 ** 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 ';

CREATE INDEX turba_owner_idx ON turba_objects (owner_id);

GRANT SELECT, ' at line 75]"
      }
    }
    [1]=>
    array(6) {
      ["file"]=>
      string(35) "C:\xampp\htdocs\horde\pear\PEAR.php"
      ["line"]=>
      int(569)
      ["function"]=>
      string(8) "DB_Error"
      ["class"]=>
      string(8) "DB_Error"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(4) {
        [0]=>
        int(-2)
        [1]=>
        int(1)
        [2]=>
        int(1024)
        [3]=>
        string(2974) "CREATE TABLE turba_objects (
    object_id VARCHAR(32) NOT NULL,
    owner_id VARCHAR(255) NOT NULL,
    object_type VARCHAR(255) DEFAULT 'Object' NOT NULL,
    object_uid VARCHAR(255),
    object_members BLOB,
    object_lastname VARCHAR(255),
    object_alias VARCHAR(32),
    object_email VARCHAR(255),
    object_homestreet VARCHAR(255),
    object_homestreet3 VARCHAR(255),
    object_workstreet VARCHAR(255),
    object_workstreet3 VARCHAR(255),
    object_homephone VARCHAR(25),
    object_workphone VARCHAR(25),
    object_cellphone VARCHAR(25),
    object_workfax VARCHAR(25),
    object_title VARCHAR(255),
    object_company VARCHAR(255),
    object_notes TEXT,
    object_pgppublickey TEXT,
    object_smimepublickey TEXT,
    object_freebusyurl VARCHAR(255),
    object_firstname VARCHAR(255),
    object_homecity VARCHAR(255),
    object_homeprovince VARCHAR(255),
    object_homepostalcode VARCHAR(255),
    object_homecountry VARCHAR(255),
    object_homestreet2 VARCHAR(255),
    object_workstreet2 VARCHAR(255),
    object_workcity VARCHAR(255),
    object_workprovince VARCHAR(255),
    object_workpostalcode VARCHAR(255),
    object_workcountry VARCHAR(255),
    object_website VARCHAR(255),
    object_birthday VARCHAR(255),
    object_nickname VARCHAR(255),
    object_office VARCHAR(255),
    object_jobtitle VARCHAR(255),
    object_profession VARCHAR(255),
    object_manager VARCHAR(255),
    object_assistant VARCHAR(255),
    object_suffix VARCHAR(255),
    object_spouse VARCHAR(255),
    object_anniversary VARCHAR(255),
    object_email2 VARCHAR(255),
    object_email3 VARCHAR(255),
    object_category VARCHAR(255),
    object_assistantphone VARCHAR(25),
    object_workphone2 VARCHAR(25),
    object_callback VARCHAR(255),
    object_carphone VARCHAR(25),
    object_companyphone VARCHAR(25),
    object_homephone2 VARCHAR(25),
    object_homefax VARCHAR(25),
    object_isdn VARCHAR(255),
    object_otherphone VARCHAR(25),
    object_otherfax VARCHAR(25),
    object_pager VARCHAR(25),
    object_primaryphone VARCHAR(25),
    object_radio VARCHAR(255),
    object_telex VARCHAR(255),
    object_ttytdd VARCHAR(255),
    object_otherstreet VARCHAR(255),
    object_otherstreet2 VARCHAR(255),
    object_otherstreet3 VARCHAR(255),
    object_othercity VARCHAR(255),
    object_otherprovince VARCHAR(255),
    object_otherpostalcode VARCHAR(255),
    object_othercountry VARCHAR(255),
    object_middlename VARCHAR(255),
    object_department VARCHAR(255),
--
    PRIMARY KEY(object_id)
);

CREATE INDEX turba_owner_idx ON turba_objects (owner_id);

GRANT SELECT, INSERT, UPDATE, DELETE ON turba_objects TO horde; [nativecode=1064 ** 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 ';

CREATE INDEX turba_owner_idx ON turba_objects (owner_id);

GRANT SELECT, ' at line 75]"
      }
    }
    [2]=>
    array(6) {
      ["file"]=>
      string(40) "C:\xampp\htdocs\horde\pear\DB\common.php"
      ["line"]=>
      int(1903)
      ["function"]=>
      string(10) "raiseError"
      ["class"]=>
      string(4) "PEAR"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(7) {
        [0]=>
        NULL
        [1]=>
        int(-2)
        [2]=>
        NULL
        [3]=>
        NULL
        [4]=>
        string(2974) "CREATE TABLE turba_objects (
    object_id VARCHAR(32) NOT NULL,
    owner_id VARCHAR(255) NOT NULL,
    object_type VARCHAR(255) DEFAULT 'Object' NOT NULL,
    object_uid VARCHAR(255),
    object_members BLOB,
    object_lastname VARCHAR(255),
    object_alias VARCHAR(32),
    object_email VARCHAR(255),
    object_homestreet VARCHAR(255),
    object_homestreet3 VARCHAR(255),
    object_workstreet VARCHAR(255),
    object_workstreet3 VARCHAR(255),
    object_homephone VARCHAR(25),
    object_workphone VARCHAR(25),
    object_cellphone VARCHAR(25),
    object_workfax VARCHAR(25),
    object_title VARCHAR(255),
    object_company VARCHAR(255),
    object_notes TEXT,
    object_pgppublickey TEXT,
    object_smimepublickey TEXT,
    object_freebusyurl VARCHAR(255),
    object_firstname VARCHAR(255),
    object_homecity VARCHAR(255),
    object_homeprovince VARCHAR(255),
    object_homepostalcode VARCHAR(255),
    object_homecountry VARCHAR(255),
    object_homestreet2 VARCHAR(255),
    object_workstreet2 VARCHAR(255),
    object_workcity VARCHAR(255),
    object_workprovince VARCHAR(255),
    object_workpostalcode VARCHAR(255),
    object_workcountry VARCHAR(255),
    object_website VARCHAR(255),
    object_birthday VARCHAR(255),
    object_nickname VARCHAR(255),
    object_office VARCHAR(255),
    object_jobtitle VARCHAR(255),
    object_profession VARCHAR(255),
    object_manager VARCHAR(255),
    object_assistant VARCHAR(255),
    object_suffix VARCHAR(255),
    object_spouse VARCHAR(255),
    object_anniversary VARCHAR(255),
    object_email2 VARCHAR(255),
    object_email3 VARCHAR(255),
    object_category VARCHAR(255),
    object_assistantphone VARCHAR(25),
    object_workphone2 VARCHAR(25),
    object_callback VARCHAR(255),
    object_carphone VARCHAR(25),
    object_companyphone VARCHAR(25),
    object_homephone2 VARCHAR(25),
    object_homefax VARCHAR(25),
    object_isdn VARCHAR(255),
    object_otherphone VARCHAR(25),
    object_otherfax VARCHAR(25),
    object_pager VARCHAR(25),
    object_primaryphone VARCHAR(25),
    object_radio VARCHAR(255),
    object_telex VARCHAR(255),
    object_ttytdd VARCHAR(255),
    object_otherstreet VARCHAR(255),
    object_otherstreet2 VARCHAR(255),
    object_otherstreet3 VARCHAR(255),
    object_othercity VARCHAR(255),
    object_otherprovince VARCHAR(255),
    object_otherpostalcode VARCHAR(255),
    object_othercountry VARCHAR(255),
    object_middlename VARCHAR(255),
    object_department VARCHAR(255),
--
    PRIMARY KEY(object_id)
);

CREATE INDEX turba_owner_idx ON turba_objects (owner_id);

GRANT SELECT, INSERT, UPDATE, DELETE ON turba_objects TO horde; [nativecode=1064 ** 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 ';

CREATE INDEX turba_owner_idx ON turba_objects (owner_id);

GRANT SELECT, ' at line 75]"
        [5]=>
        string(8) "DB_Error"
        [6]=>
        bool(true)
      }
    }
    [3]=>
    array(6) {
      ["file"]=>
      string(39) "C:\xampp\htdocs\horde\pear\DB\mysql.php"
      ["line"]=>
      int(898)
      ["function"]=>
      string(10) "raiseError"
      ["class"]=>
      string(9) "DB_common"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(5) {
        [0]=>
        int(-2)
        [1]=>
        NULL
        [2]=>
        NULL
        [3]=>
        NULL
        [4]=>
        string(235) "1064 ** 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 ';

CREATE INDEX turba_owner_idx ON turba_objects (owner_id);

GRANT SELECT, ' at line 75"
      }
    }
    [4]=>
    array(6) {
      ["file"]=>
      string(39) "C:\xampp\htdocs\horde\pear\DB\mysql.php"
      ["line"]=>
      int(327)
      ["function"]=>
      string(15) "mysqlRaiseError"
      ["class"]=>
      string(8) "DB_mysql"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(0) {
      }
    }
    [5]=>
    array(6) {
      ["file"]=>
      string(40) "C:\xampp\htdocs\horde\pear\DB\common.php"
      ["line"]=>
      int(1216)
      ["function"]=>
      string(11) "simpleQuery"
      ["class"]=>
      string(8) "DB_mysql"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(1) {
        [0]=>
        string(2725) "CREATE TABLE turba_objects (
    object_id VARCHAR(32) NOT NULL,
    owner_id VARCHAR(255) NOT NULL,
    object_type VARCHAR(255) DEFAULT 'Object' NOT NULL,
    object_uid VARCHAR(255),
    object_members BLOB,
    object_lastname VARCHAR(255),
    object_alias VARCHAR(32),
    object_email VARCHAR(255),
    object_homestreet VARCHAR(255),
    object_homestreet3 VARCHAR(255),
    object_workstreet VARCHAR(255),
    object_workstreet3 VARCHAR(255),
    object_homephone VARCHAR(25),
    object_workphone VARCHAR(25),
    object_cellphone VARCHAR(25),
    object_workfax VARCHAR(25),
    object_title VARCHAR(255),
    object_company VARCHAR(255),
    object_notes TEXT,
    object_pgppublickey TEXT,
    object_smimepublickey TEXT,
    object_freebusyurl VARCHAR(255),
    object_firstname VARCHAR(255),
    object_homecity VARCHAR(255),
    object_homeprovince VARCHAR(255),
    object_homepostalcode VARCHAR(255),
    object_homecountry VARCHAR(255),
    object_homestreet2 VARCHAR(255),
    object_workstreet2 VARCHAR(255),
    object_workcity VARCHAR(255),
    object_workprovince VARCHAR(255),
    object_workpostalcode VARCHAR(255),
    object_workcountry VARCHAR(255),
    object_website VARCHAR(255),
    object_birthday VARCHAR(255),
    object_nickname VARCHAR(255),
    object_office VARCHAR(255),
    object_jobtitle VARCHAR(255),
    object_profession VARCHAR(255),
    object_manager VARCHAR(255),
    object_assistant VARCHAR(255),
    object_suffix VARCHAR(255),
    object_spouse VARCHAR(255),
    object_anniversary VARCHAR(255),
    object_email2 VARCHAR(255),
    object_email3 VARCHAR(255),
    object_category VARCHAR(255),
    object_assistantphone VARCHAR(25),
    object_workphone2 VARCHAR(25),
    object_callback VARCHAR(255),
    object_carphone VARCHAR(25),
    object_companyphone VARCHAR(25),
    object_homephone2 VARCHAR(25),
    object_homefax VARCHAR(25),
    object_isdn VARCHAR(255),
    object_otherphone VARCHAR(25),
    object_otherfax VARCHAR(25),
    object_pager VARCHAR(25),
    object_primaryphone VARCHAR(25),
    object_radio VARCHAR(255),
    object_telex VARCHAR(255),
    object_ttytdd VARCHAR(255),
    object_otherstreet VARCHAR(255),
    object_otherstreet2 VARCHAR(255),
    object_otherstreet3 VARCHAR(255),
    object_othercity VARCHAR(255),
    object_otherprovince VARCHAR(255),
    object_otherpostalcode VARCHAR(255),
    object_othercountry VARCHAR(255),
    object_middlename VARCHAR(255),
    object_department VARCHAR(255),
--
    PRIMARY KEY(object_id)
);

CREATE INDEX turba_owner_idx ON turba_objects (owner_id);

GRANT SELECT, INSERT, UPDATE, DELETE ON turba_objects TO horde;"
      }
    }
    [6]=>
    array(6) {
      ["file"]=>
      string(40) "C:\xampp\htdocs\horde\admin\sqlshell.php"
      ["line"]=>
      int(59)
      ["function"]=>
      string(5) "query"
      ["class"]=>
      string(9) "DB_common"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(1) {
        [0]=>
        string(2725) "CREATE TABLE turba_objects (
    object_id VARCHAR(32) NOT NULL,
    owner_id VARCHAR(255) NOT NULL,
    object_type VARCHAR(255) DEFAULT 'Object' NOT NULL,
    object_uid VARCHAR(255),
    object_members BLOB,
    object_lastname VARCHAR(255),
    object_alias VARCHAR(32),
    object_email VARCHAR(255),
    object_homestreet VARCHAR(255),
    object_homestreet3 VARCHAR(255),
    object_workstreet VARCHAR(255),
    object_workstreet3 VARCHAR(255),
    object_homephone VARCHAR(25),
    object_workphone VARCHAR(25),
    object_cellphone VARCHAR(25),
    object_workfax VARCHAR(25),
    object_title VARCHAR(255),
    object_company VARCHAR(255),
    object_notes TEXT,
    object_pgppublickey TEXT,
    object_smimepublickey TEXT,
    object_freebusyurl VARCHAR(255),
    object_firstname VARCHAR(255),
    object_homecity VARCHAR(255),
    object_homeprovince VARCHAR(255),
    object_homepostalcode VARCHAR(255),
    object_homecountry VARCHAR(255),
    object_homestreet2 VARCHAR(255),
    object_workstreet2 VARCHAR(255),
    object_workcity VARCHAR(255),
    object_workprovince VARCHAR(255),
    object_workpostalcode VARCHAR(255),
    object_workcountry VARCHAR(255),
    object_website VARCHAR(255),
    object_birthday VARCHAR(255),
    object_nickname VARCHAR(255),
    object_office VARCHAR(255),
    object_jobtitle VARCHAR(255),
    object_profession VARCHAR(255),
    object_manager VARCHAR(255),
    object_assistant VARCHAR(255),
    object_suffix VARCHAR(255),
    object_spouse VARCHAR(255),
    object_anniversary VARCHAR(255),
    object_email2 VARCHAR(255),
    object_email3 VARCHAR(255),
    object_category VARCHAR(255),
    object_assistantphone VARCHAR(25),
    object_workphone2 VARCHAR(25),
    object_callback VARCHAR(255),
    object_carphone VARCHAR(25),
    object_companyphone VARCHAR(25),
    object_homephone2 VARCHAR(25),
    object_homefax VARCHAR(25),
    object_isdn VARCHAR(255),
    object_otherphone VARCHAR(25),
    object_otherfax VARCHAR(25),
    object_pager VARCHAR(25),
    object_primaryphone VARCHAR(25),
    object_radio VARCHAR(255),
    object_telex VARCHAR(255),
    object_ttytdd VARCHAR(255),
    object_otherstreet VARCHAR(255),
    object_otherstreet2 VARCHAR(255),
    object_otherstreet3 VARCHAR(255),
    object_othercity VARCHAR(255),
    object_otherprovince VARCHAR(255),
    object_otherpostalcode VARCHAR(255),
    object_othercountry VARCHAR(255),
    object_middlename VARCHAR(255),
    object_department VARCHAR(255),
--
    PRIMARY KEY(object_id)
);

CREATE INDEX turba_owner_idx ON turba_objects (owner_id);

GRANT SELECT, INSERT, UPDATE, DELETE ON turba_objects TO horde;"
      }
    }
  }
  ["callback"]=>
  NULL
}

----- Original Message ----
From: Struggle Tribe <digitalstruggle at yahoo.com>
To: turba at lists.horde.org
Sent: Friday, July 20, 2007 3:36:21 AM
Subject: [turba] Trouble Importing Address Fields


====
Clipped text
====
...

Please help me figure out what to do here, folks.  Should I run my contacts database through another program before I import its data into Turba?  I tried a lot of things before joining this mailing list and emailing you all.  I even tried following the directions to add more Outlook-like fields here:  http://wiki.horde.org/TurbaOutlook2003 with no success (though the page wasn't displaying earlier today and I didn't see the "addresslink" vs "address" tip).  Is there an easier way to just add a view contact fields to match up in the import process?

I really appreciate all of your effort.  Horde is very impressive.  I'm really looking forward to Hermes.

Thanks!
Christian





       
____________________________________________________________________________________
Get the free Yahoo! toolbar and rest assured with the added security of spyware protection.
http://new.toolbar.yahoo.com/toolbar/features/norton/index.php
-- 
Turba mailing list - Join the hunt: http://horde.org/bounties/#turba
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: turba-unsubscribe at lists.horde.org





      ____________________________________________________________________________________
Luggage? GPS? Comic books? 
Check out fitting gifts for grads at Yahoo! Search
http://search.yahoo.com/search?fr=oni_on_mail&p=graduation+gifts&cs=bz


More information about the turba mailing list