Author Topic: Joomla 1.5.6 and CiviCRM 2.1 alpha 2 (Read 3135 times)

fezzicnex · August 14, 2008, 11:25:27 am

Problem Description:
I want to install CiviCRM as a Joomla! component on GoDaddy Shared Hosting, but it doesn’t work and I’m so confused as to how anyone got this to work. Please, please help me get this to work.

Log/Error Messages:
Blank Screen after seeming successful installation

Actions Taken To Resolve:
I created a php5.ini file and an .htaccess file to handle the timeouts, but it doesn’t seem to help. I know for sure that the php5.ini is working because my phpinfo() file seems to link to it and updated accordingly. I’ve been trying for 2 days, reading countless forums but I can’t seem to install CiviCRM and its become very disappointing. Please help.

php5.ini:

Code: [Select]

register_globals = off
allow_url_fopen = off
mysql.connect_timeout = 60
expose_php = Off

max_input_time = 600
max_execution_time 6000
memory_limit = 64M

variables_order = "EGPCS"
extension_dir = ./
upload_tmp_dir = /tmp
precision = 12
rg_emulation=off
SMTP = relay-hosting.secureserver.net
url_rewriter.tags = "a=href,area=href,frame=src,input=src,form=,fieldset="

[Zend]
zend_optimizer.optimization_level=15
zend_extension=zend/ZendOptimizer.so
zend_extension_ts=zend/TS/ZendOptimizer.so
zend_extension=zend/ZendExtensionManager.so
zend_extension_ts=zend/ZendExtensionManager_TS.so

.htaccess:

Code: [Select]

AddHandler x-httpd-php5 .php .php5
AddHandler x-httpd-php .php4

Diagnostic Information
Joomla! Version: Joomla! 1.5.6 Production/Stable [ Vusani ] 12-August-2008 22:00 GMT
configuration.php: Writable (Mode: 644 ) | RG_EMULATION: N/A
Architecture/Platform: Linux 2.4.21-53.ELsmp ( i686) | Web Server: Apache ( pisigmachi.com ) | PHP Version: 5.2.5
PHP Requirements: register_globals: Disabled | magic_quotes_gpc: Enabled | safe_mode: Disabled | MySQL Support: Yes | XML Support: Yes | zlib Support: Yes
mbstring Support (1.5): Yes | iconv Support (1.5): Yes | save.session_path: Not Writable[color] | Max.Execution Time: 30 seconds | File Uploads: Enabled
MySQL Version: 5.0.45-log ( p50mysql169.secureserver.net via TCP/IP )

Extended Information:
SEF: Disabled (without ReWrite) | FTP Layer: Disabled | htaccess: Implemented
PHP/suExec: User and Web Server accounts are the same. (PHP/suExec probably installed)
PHP Environment: API: cgi-fcgi | MySQLi: Yes | Max. Memory: 64M | Max. Upload Size: 2M | Max. Post Size: 8M | Max. Input Time: 600 | Zend Version: 2.2.0
Disabled Functions:
MySQL Client: 5.0.18 ( latin1)

lcdweb · August 14, 2008, 11:45:34 am

GoDaddy hosting sucks. (sorry to put it so bluntly)

I just ran through this on a site (installing Civi on GoDaddy) and the only way I could manage to do it was to install everything manually. If you do a search of forums you'll find a post on how to install manually. Despite altering the php settings, I couldn't get around either a timeout error or incomplete installation.

fezzicnex · August 14, 2008, 11:59:15 am

ok then, in your opinion what is the best (or one of the best) hosting services? maybe i'll switch

lcdweb · August 14, 2008, 12:08:10 pm

this is *my* opinion only...

For cheap shared hosting: Bluehost.com -- they're not going to blow you away with speed, but I have a number of CiviCRM installations running just fine on their environment.

If you're a 501(c)3 not for profit, you may be able to get free hosting at: Thinkhost.com (control panel is not as robust as cPanel, which is what Bluehost uses, but I think their servers are a little better/faster.)

VPS: eApps.com -- there's a noticeable improvement in site performance, even with the $10/mo option, over shared hosting. You need a little better knowledge of linux hosting, but they are basically a "managed" VPS solution, so it's not as though you need to become a network admin. They have a large sliding scale of hosting levels available, so there's a lot of room for growth. And the $20/mo option includes a JRE environment, which would be required for CiviReport/Birt

-Brian

fezzicnex · August 14, 2008, 09:24:48 pm

Thanks for the advice, but before i made the switch. i decided to look at and try what this forum had to offer: http://forum.civicrm.org/index.php/topic,4357.0.html

So i now have joomla installed on my local machine and i tryed installing civicrm here but i still have problems. Any ideas?

This is the error i received:

Quote

Cannot execute CREATE TABLE civicrm_cache ( id int unsigned NOT NULL AUTO_INCREMENT , group_name varchar(255) NOT NULL COMMENT 'group name for cache element, useful in cleaning cache elements', path varchar(255) COMMENT 'Unique path name for cache element', data text COMMENT 'data associated with this path', component_id int unsigned COMMENT 'Component that this menu item belongs to', created_date datetime COMMENT 'When was the cache item created', expired_date datetime COMMENT 'When should the cache item expire' , PRIMARY KEY ( id ) , UNIQUE INDEX UI_group_path( group_name , path ) , CONSTRAINT FK_civicrm_cache_component_id FOREIGN KEY (component_id) REFERENCES civicrm_component(id) ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci: DB Error: unknown error

This is the Apache Error Log:

Code: [Select]

[Thu Aug 14 23:55:49 2008] [error] [client 127.0.0.1] PHP Warning:  include_once(civicrm.settings.php) [<a href='function.include-once'>function.include-once</a>]: failed to open stream: No such file or directory in W:\\www\\Joomla\\administrator\\components\\com_civicrm\\admin.civicrm.php on line 14, referer: http://localhost/Joomla/administrator/index.php
[Thu Aug 14 23:55:49 2008] [error] [client 127.0.0.1] PHP Warning:  include_once() [<a href='function.include'>function.include</a>]: Failed opening 'civicrm.settings.php' for inclusion (include_path='.;/usr/local/PHP/includes;/usr/local/PHP/pear;/home/admin/www/plugins/pear/PEAR') in W:\\www\\Joomla\\administrator\\components\\com_civicrm\\admin.civicrm.php on line 14, referer: http://localhost/Joomla/administrator/index.php
[Thu Aug 14 23:55:49 2008] [error] [client 127.0.0.1] PHP Warning:  require_once(PEAR.php) [<a href='function.require-once'>function.require-once</a>]: failed to open stream: No such file or directory in W:\\www\\Joomla\\administrator\\components\\com_civicrm\\admin.civicrm.php on line 16, referer: http://localhost/Joomla/administrator/index.php
[Thu Aug 14 23:55:49 2008] [error] [client 127.0.0.1] PHP Fatal error:  require_once() [<a href='function.require'>function.require</a>]: Failed opening required 'PEAR.php' (include_path='.;/usr/local/PHP/includes;/usr/local/PHP/pear;/home/admin/www/plugins/pear/PEAR') in W:\\www\\Joomla\\administrator\\components\\com_civicrm\\admin.civicrm.php on line 16, referer: http://localhost/Joomla/administrator/index.php

My Info below change from before since i'm testing on my local pc.

Diagnostic Information
Joomla! Version: Joomla! 1.5.6 Production/Stable [ Vusani ] 12-August-2008 22:00 GMT
configuration.php: Not Writable (Mode: 444 ) | RG_EMULATION: N/A
Architecture/Platform: Windows NT 5.1 ( i586) | Web Server: Apache/2.0.59 (Win32) DAV/2 PHP/5.2.3 ( localhost ) | PHP Version: 5.2.3
PHP Requirements: register_globals: Disabled | magic_quotes_gpc: Enabled | safe_mode: Disabled | MySQL Support: Yes | XML Support: Yes | zlib Support: Yes
mbstring Support (1.5): Yes | iconv Support (1.5): Yes | save.session_path: Writable | Max.Execution Time: 6000 seconds | File Uploads: Enabled
MySQL Version: 5.0.41-community-nt ( localhost via TCP/IP )

Extended Information:
SEF: Disabled (without ReWrite) | FTP Layer: Disabled | htaccess: Not Implemented
PHP/suExec: User and Web Server accounts are not the same. (PHP/suExec probably not installed)
PHP Environment: API: apache2handler | MySQLi: Yes | Max. Memory: 128M | Max. Upload Size: 40M | Max. Post Size: 100M | Max. Input Time: 600 | Zend Version: 2.2.0
Disabled Functions:
MySQL Client: 5.0.37 ( latin1 )

aspagarino · August 22, 2008, 01:43:09 pm

fezzicnex,

I was getting the exact same error and someone else in this forum proposed to run a phpMyAdmin SQL with the following statement:

Code: [Select]

CREATE TABLE civicrm_cache ( id int unsigned NOT NULL AUTO_INCREMENT , group_name varchar(255) NOT NULL COMMENT 'group name for cache element, useful in cleaning cache elements', path varchar(255) COMMENT 'Unique path name for cache element', data text COMMENT 'data associated with this path', component_id int unsigned COMMENT 'Component that this menu item belongs to', created_date datetime COMMENT 'When was the cache item created', expired_date datetime COMMENT 'When should the cache item expire' , PRIMARY KEY ( id ) , UNIQUE INDEX UI_group_path( group_name(100) , path(100) ) , CONSTRAINT FK_civicrm_cache_component_id FOREIGN KEY (component_id) REFERENCES civicrm_component(id) )

The only difference is the index part on the original SQL in the side: UNIQUE INDEX UI_group_path( group_name(100) , path(100) )... instead of UNIQUE INDEX UI_group_path( group_name , path ).

This creates the Table however does not fix the other Warning problems, I am now getting the same errors that you are reporting in your error log. Let me know if you overcome all the Warnings... of course we can always install this on a different server.

CiviCRM Community Forums (archive)

News:

Author Topic: Joomla 1.5.6 and CiviCRM 2.1 alpha 2 (Read 3135 times)

fezzicnex

Joomla 1.5.6 and CiviCRM 2.1 alpha 2

lcdweb

Re: Joomla 1.5.6 and CiviCRM 2.1 alpha 2

fezzicnex

Re: Joomla 1.5.6 and CiviCRM 2.1 alpha 2

lcdweb

Re: Joomla 1.5.6 and CiviCRM 2.1 alpha 2

fezzicnex

Re: Joomla 1.5.6 and CiviCRM 2.1 alpha 2

aspagarino

Re: Joomla 1.5.6 and CiviCRM 2.1 alpha 2