CiviCRM Community Forums (archive)

My CiviCRM 1.9.13019 (I can't upgrade to 2, as we are running mySQL 4.1.22) installation gives me the following error message when I try to add an email address or other address info to a contact record:

Sorry. A non-recoverable error has occurred.

Database Error Code: Unknown column 'is_bulkmail' in 'field list', 1054

Return to home page.

Error Details:


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

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_email (location_id , email , is_primary , is_bulkmail ) VALUES ( 361 , 'michael.mayberry@staples.com' ,  1 ,  0 )  [nativecode=1054 ** Unknown column 'is_bulkmail' in 'field list']
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_email (location_id , email , is_primary , is_bulkmail ) VALUES ( 361 , 'michael.mayberry@staples.com' ,  1 ,  0 )  [nativecode=1054 ** Unknown column 'is_bulkmail' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_email (location_id , email , is_primary , is_bulkmail ) VALUES ( 361 , 'michael.mayberry@staples.com' ,  1 ,  0 )  [nativecode=1054 ** Unknown column 'is_bulkmail' in 'field list']"]
)



I searched the forums here and found this post:

http://forum.civicrm.org/index.php/topic,1755.0.html

It indicated I should retry running the sql upgrade script from 1.8 to 1.9.

I tried to running that script.  I use Navicat to do that rather than phpMyAdmin, but that always works just fine.  However, when I ran the script, the screen that shows the result of the query showed nothing.  I tested trying to enter an email address in contact record and saving it and of course I got the same error message as I described above.

So, to be safe, I ran the script for upgrading from 1.7 to 1.8 first to see what would happen.  That gave me a query result that said "OK".  Then I ran the 1.8 to 1.9 script again, and STILL got no result displayed, and still got the error when I tried to enter and save an email address in a contact record.



Does anyone know what I should do?  What's wrong with the table structures that nothing new is happening with the 1.8-1.9 upgrade script, yet there is clearly something deficient about the table structure?  How do I fix it?

Help would be greatly appreciated, as this means we really can't actually use our CiviCRM system now, as we can't enter any new information!

[/code]