CiviCRM Community Forums (archive)

Hi there,
Sorry I've been posting a lot, but it seems like every single function doesn't work for me on CiviCRM right now (I'm pretty new, so I don't know if it worked when I had 1.8 since I didn't use it then).

So, I have Joomla 1.0.13 with CiviCRM 1.9.11960 and my host is Powweb.  The website itself is http://www.nationalnalsa.org

I gave up on the import - I tried and tried everything you guys suggested and nothing worked, and finally time amount of looking into the import issue got so great that I just decided to enter everything by hand.  That took about 8 hours, and I had spent about 15 hours trying to solve the import problem.  (I tried to import throught MySQL and phpadmin, but I don't know how to construct SQL scripts to import the data into the various tables.)

So, now that I have my data entered, and memberships entered, I wanted to set up a front-end view so that ppl could #1 see all the chapters who were and are members and their chapter membership dates and status. 

So, I fiddled around a bit, and no matter how I messed with the profiles, I couldn't get any membership information or fields to come in.  So, I figured maybe I just needed to assign these chapters to static groups so that I could put at least something up online.  Now, I am able to get to the manage groups front page, but whenever I try to add a group or edit one of my two existing groups (clicking on either "new group" or "settings", I get an error page that says the following (below).  Any suggestions on what to do?

Thanks
Marilyn
-------

     Sorry. A non-recoverable error has occurred.

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

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => UPDATE  civicrm_group  SET domain_id = 1 , name = 'Law_Schools' , title = 'Law Schools' , description = 'Potential and Actual NALSA Chapters' , is_active = 1 , visibility = 'Public User Pages and Listings' , group_type = NULL   WHERE (  civicrm_group.id = 1 )   [nativecode=1054 ** Unknown column 'group_type' in 'field list']
    [type] => DB_Error
    [user_info] => UPDATE  civicrm_group  SET domain_id = 1 , name = 'Law_Schools' , title = 'Law Schools' , description = 'Potential and Actual NALSA Chapters' , is_active = 1 , visibility = 'Public User Pages and Listings' , group_type = NULL   WHERE (  civicrm_group.id = 1 )   [nativecode=1054 ** Unknown column 'group_type' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE  civicrm_group  SET domain_id = 1 , name = 'Law_Schools' , title = 'Law Schools' , description = 'Potential and Actual NALSA Chapters' , is_active = 1 , visibility = 'Public User Pages and Listings' , group_type = NULL   WHERE (  civicrm_group.id = 1 )   [nativecode=1054 ** Unknown column 'group_type' in 'field list']"]
)