I'm very excited about this new release. However, the challenges of installing the new version of open atrium 2 and the quirky bits of drupal are frustrating. Based on other submitted issues, it seems like I'm not the only person having problems with installation. I've followed most of the advice supplied in the drupal and open atrium forums.

My installation aborts about 65% of the way through the "Install Profile" step.

I get this error:
An AJAX HTTP request terminated abnormally. Debugging information follows. Path: http://portal.lumigrow.com/openatrium2/install.php?profile=openatrium&locale=en&id=1&op=do StatusText: ResponseText: ReadyState: 4

Server Stats
Apache/2.2
PHP Version 5.3.20
mysql 5.0.77

PHP settings added:
php_value max_execution_time 3000
php_value max_input_time 6000
php_value upload_max_filesize 50M
php_value post_max_size 50M
php_value memory_limit 512M
php_value display_errors on
php_value mysql.connect_timeout 360

I'm on a Mac running Chrome and Safari. I've followed the INSTALL.txt to the letter.

After seeing the error, I hit the URL again (http://portal.lumigrow.com/openatrium2/install.php?profile=openatrium&lo...) and am given an option to select a theme. However, the next screen is blank and I get a no data given in the browser. After I hit that install URL again, I get the following error:

SQLSTATE[42S02]: Base table or view not found: 1146 Table '608679_opena2.search_api_server' doesn't exist

Does the installation process know which files were not installed? I suspect that the installation timed out. What solutions are available for an installation that times out?

Comments

mpotter’s picture

You might try the max_allowed_packet in your MySQL settings. That seems to be the biggest problem with Mac OSX installs. (Also, your MySql version is a bit old and 5.5+ is recommended these days, or at least 5.1+. There were a lot of performance improvements since MySQL 5.0)

#2049215: Mysql server has gone away after installing

Also, unfortunately when the install fails Drupal doesn't know which files were not installed. You should wipe our your database and restart the install.php from scratch.

phKU’s picture

Before each attempt, please try to also restore the file structure from the original distribution archive, because OA install process may also updates the files, see Instalation troubles while retrying after hang-up.

khayam shah’s picture

hello there

i am using
Apache/2.2
PHP Version 5.3.20
mysql 5.1.33

PHP settings added:
php_value max_execution_time 3000
php_value max_input_time 6000
php_value upload_max_filesize 50M
php_value post_max_size 50M
php_value memory_limit 512M
php_value display_errors on
php_value mysql.connect_timeout 360

wamp server firfox browser

when am istalling openatrium i am facing this error
plz guide me in simple words
how can i fix this error

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'openatrium.search_api_server' doesn't exist

waiting for your kind replyy ....... its most urgent plz

mpotter’s picture

Issue summary: View changes
Status: Active » Closed (cannot reproduce)

You need to reinstall the latest version of Open Atrium. It adds a task to the installer to rebuild the index tables. That's completely different than the original post. Closing this until a procedure to reproduce the original post is posted.

pixelbricks’s picture

Status: Closed (cannot reproduce) » Active

Original poster here.

I downloaded the new package, openatrium-7.x-2.03 and started a new fresh install. I also updated by PHP version and mySQL.

Rackspace Environment
Apache/2.2.13
PHP Version 5.4.10
mysql 5.1.61

php_value max_execution_time 3000
php_value max_input_time 6000
php_value upload_max_filesize 50M
php_value post_max_size 50M
php_value memory_limit 512M
php_value display_errors on
php_value mysql.connect_timeout 360

Here is the error that came up for me after submitting the site configuration settings:

Fatal error: Call to undefined function field_attach_load() in /mnt/stor12-wc2-dfw1/608679/portal.lumigrow.com/web/content/openatrium-7.x-2.03/includes/entity.inc on line 321

The settings.php file did appear in my /sites/default folder with the DB settings and I got 32 rows in my database. Any thoughts on where I got stuck?

Is there an alternate install path I could take? For instance, is it possible for me to install drupal first and then add open atrium on top of that? It's frustrating seeing a potential for a great solution but not being able to get it installed.

mpotter’s picture

Did you try setting your max_allowed_packet in your MySql my.cnf file as mentioned in #1. Still not able to reproduce any problems installing to local Macs here.

Did it finish installing all the modules? There currently isn't any way to install Drupal first and add Open Atrium unless you are an expert at drush make and installing module patches.

khayam shah’s picture

hello there alll

i was install open atrium last day

now i open http:\\localhost\openatrium

it cant open this page it open after refresh
wamp server home page

what can i do plz guide me ......

pixelbricks’s picture

I've investigated changing my max_allowed_packet setting but my cloud sites hosting package at rackspace does not allow for that level of change.

I might be SOL on rackspace for now. If you have any thoughts or suggestions, let me know.

khayam shah’s picture

please reply me soon why i am unable to open openatrium home page ?
i install openatrium successfully ....
when i open opernatrium home page it open wamp server home page
i am trying it at local server

pixelbricks’s picture

Version: 7.x-2.0 » 7.x-2.04

I've tried again with the new version, 2.04, just to see if it works. Was not able to up my max packets allowed setting. Database connected and created 31 tables, but then it skips the module installation in the installation profile. When I reload the install URL, I get this error.

Fatal error: Call to undefined function field_attach_load() in /mnt/stor12-wc2-dfw1/608679/portal.lumigrow.com/web/content/openatrium-7.x-2.04/includes/entity.inc on line 321

pixelbricks’s picture

More information. I dropped my 31 tables left my settings file intact and tried the installation procedure again.

This time I got this error:

An AJAX HTTP error occurred. HTTP Result Code: 200 Debugging information follows. Path: http://portal.lumigrow.com/openatrium-7.x-2.04/install.php?profile=openatrium&locale=en&id=1&op=do StatusText: OK ResponseText: Home | Drupal @import url("http://portal.lumigrow.com/openatrium-7.x-2.04/modules/system/system.theme.css?0"); @import url("http://portal.lumigrow.com/openatrium-7.x-2.04/modules/system/system.menus.css?0"); @import url("http://portal.lumigrow.com/openatrium-7.x-2.04/modules/system/system.messages.css?0"); @import url("http://portal.lumigrow.com/openatrium-7.x-2.04/modules/system/system.base.css?0"); @import url("http://portal.lumigrow.com/openatrium-7.x-2.04/modules/field/theme/field.css?0"); @import url("http://portal.lumigrow.com/openatrium-7.x-2.04/modules/node/node.css?0"); @import url("http://portal.lumigrow.com/openatrium-7.x-2.04/modules/user/user.css?0"); @import url("http://portal.lumigrow.com/openatrium-7.x-2.04/profiles/openatrium/modules/contrib/views/css/views.css?0"); @import url("http://portal.lumigrow.com/openatrium-7.x-2.04/modules/system/system.admin.css?0"); @import url("http://portal.lumigrow.com/openatrium-7.x-2.04/modules/system/system.maintenance.css?0"); @import url("http://portal.lumigrow.com/openatrium-7.x-2.04/profiles/openatrium/modules/contrib/ctools/css/ctools.css?0"); @import url("http://portal.lumigrow.com/openatrium-7.x-2.04/profiles/openatrium/openatrium.css?0"); @import url("http://portal.lumigrow.com/openatrium-7.x-2.04/themes/seven/reset.css?0"); @import url("http://portal.lumigrow.com/openatrium-7.x-2.04/themes/seven/style.css?0"); Home Installation tasksChoose profile(done)Choose language(done)Verify requirements(done)Set up database(done)Install profile(active)Configure siteFinished Table cache_update already exists.

This time around, I got 50 tables built in the database.

mpotter’s picture

pixelbricks: what is the max_allowed_packets set to on rackspace? Can't imagine a good hosting company like that having it set too low. It only needs to be 32M or so.

khayam shah’s picture

@mpotter

plz reply ans of my question

Only local images are allowed.

pixelbricks’s picture

Here's my setting:
max_allowed_packet 16777216

rackspace cloud sites doesn't allow you to configure this particular setting, unfortunately.

mpotter’s picture

pixelbricks: not sure what else to suggest. You can try the new 2.06 version to be released tomorrow, but I'm not aware of any changes to the installer. Unfortunately Drupal just needs a lot of memory and resources to install this many modules all at once. If you still have trouble you'll need to contact rackspace and see if they can temporarily increase this limit just so you can get past the install (and to verify that's the actual problem and not something else).

mpotter’s picture

Also, just a note to everybody: I can't really debug individual hosting or install problems here. You need to have a hosting environment that can handle a large Drupal distribution. If you have trouble installing locally or with your hosting, you can always try Open Atrium 2 on Pantheon where all of these kind of hosting issues are fixed. OA2 uses a *lot* of Drupal modules so it's going to take more resources than a plain Drupal 7 install.

But my free community support time is limited and I'd like to focus on specific Open Atrium 2 problems that I can fix rather than providing general Drupal help.

If you have a fix/patch that helps OA2 install more easily on other hosting platforms, I'm happy to review them. But I don't have the time or resources to test OA2 on all possible platforms, sorry.

Thanks for your patience and understanding.

mpotter’s picture

Status: Active » Closed (works as designed)
Argus’s picture

Issue tags: +OA-installation

Tagging for documentation purposes.