CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • civicrm-2.2.0-joomla post Installation errors
Pages: [1]

Author Topic: civicrm-2.2.0-joomla post Installation errors  (Read 2979 times)

karenann

  • I post occasionally
  • **
  • Posts: 110
  • Karma: 2
  • CiviCRM version: 4.7.3
  • CMS version: Joomla 3.4.8
  • MySQL version: 5.5.48-cll
  • PHP version: 5.4.41
civicrm-2.2.0-joomla post Installation errors
March 16, 2009, 01:24:24 pm
can anyone help with the following errors:
Joomla 1.5.8 / MySQL 4.1.22 / PHP Version 5.2.5

Uploaded and installed unzipped files to folder:
/home/tscprot/public_html/administrator/components/com_installer/com_civicrm
Chmod 777 on:
/home/tscprot/public_html/joomla/administrator/components/
/home/tscprot/public_html/joomla/components/
/home/tscprot/public_html/media
The FTP layer is turned off.

Here are the errors after the installation:
Warning: zip_read() expects parameter 1 to be resource, integer given in /home/tscprot/public_html/libraries/joomla/filesystem/archive/zip.php on line 234

Warning: zip_close() expects parameter 1 to be resource, integer given in /home/tscprot/public_html/libraries/joomla/filesystem/archive/zip.php on line 250

Warning: fopen(/home/tscprot/public_html/administrator/components/com_civicrm/civicrm/templates/CRM/common/civicrm.settings.php.tpl) [function.fopen]: failed to open stream: No such file or directory in /home/tscprot/public_html/libraries/joomla/filesystem/file.php on line 239

Warning: fopen(/home/tscprot/public_html/administrator/components/com_civicrm/civicrm/templates/CRM/common/civicrm.settings.php.tpl) [function.fopen]: failed to open stream: No such file or directory in /home/tscprot/public_html/libraries/joomla/filesystem/file.php on line 239

Warning: require_once(DB.php) [function.require-once]: failed to open stream: No such file or directory in /home/tscprot/public_html/administrator/components/com_civicrm/configure.php on line 117

Fatal error: require_once() [function.require]: Failed opening required 'DB.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/tscprot/public_html/administrator/components/com_civicrm/configure.php on line 117
============================
I see the component CiviCRM. When i go to CiviCRm home I get 2 errors:

Warning: require_once(CRM/Core/Config.php) [function.require-once]: failed to open stream: No such file or directory in /home/tscprot/public_html/administrator/components/com_civicrm/admin.civicrm.php on line 17

Fatal error: require_once() [function.require]: Failed opening required 'CRM/Core/Config.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/tscprot/public_html/administrator/components/com_civicrm/admin.civicrm.php on line 17

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: civicrm-2.2.0-joomla post Installation errors
March 16, 2009, 02:42:31 pm

this has come up in the past and seems like its a bug with php zip file handling. You should uninstall the component and try using the installation with the "-alt" version (civicrm-2.2.0-joomla-alt.zip)

lobo


A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

ken

  • I live on this forum
  • *****
  • Posts: 916
  • Karma: 53
    • City Bible Forum
  • CiviCRM version: 4.6.3
  • CMS version: Drupal 7.36
  • MySQL version: 5.5.41
  • PHP version: 5.3.10
Re: civicrm-2.2.0-joomla post Installation errors
March 16, 2009, 11:33:54 pm
Dear karenann,

If you're using a 64-bit processor and PHP 5.2.xx then you've fallen foul of a bug in the PHP native zip libraries. There's a fix in the PHP pipeline, but in the meantime the *-alt option Lobo suggests works fine.

Ken

karenann

  • I post occasionally
  • **
  • Posts: 110
  • Karma: 2
  • CiviCRM version: 4.7.3
  • CMS version: Joomla 3.4.8
  • MySQL version: 5.5.48-cll
  • PHP version: 5.4.41
Re: civicrm-2.2.0-joomla post Installation errors
March 17, 2009, 04:14:58 pm
Thanks, appreciate the responses. I tried the install with the 2.2.0 -alt version.
When I do the installation from folder I get:
JFolder::create: Could not create directory
Component Install: Failed to create directory.: "/home/dsaopro/public_html/administrator/components/com_civicrm"

Since it could not create the folder in components, I did a chmod 777 in the components folder, same error. Any ideas?

ken

  • I live on this forum
  • *****
  • Posts: 916
  • Karma: 53
    • City Bible Forum
  • CiviCRM version: 4.6.3
  • CMS version: Drupal 7.36
  • MySQL version: 5.5.41
  • PHP version: 5.3.10
Re: civicrm-2.2.0-joomla post Installation errors
March 17, 2009, 05:57:16 pm
The component install error 'could not create directory' means that you need to uninstall the CiviCRM component first.

If this is an upgrade (rather than a fresh install), you need to be careful when uninstalling that you don't delete the CiviCRM tables. (If it's a fresh install then you don't care.) Check out the warnings on the CiviCRM documentation page for upgrading ( http://wiki.civicrm.org/confluence/display/CRMDOC/Upgrade+Joomla+Sites+to+2.2 ).

Ken

FatherShawn

  • Ask me questions
  • ****
  • Posts: 372
  • Karma: 25
    • C3 Design
  • CiviCRM version: 4.2.11
  • CMS version: Drupal 7.23
  • MySQL version: 5.5.32
  • PHP version: 5.3.10
Re: civicrm-2.2.0-joomla post Installation errors
March 18, 2009, 06:48:21 am
karenann-

I noted in your post that your server is using mySQL 4.  I don't know if it's part of your problem, but wanted to point out that civiCRM expects mySQL 5: http://wiki.civicrm.org/confluence/display/CRMDOC/Joomla+Installation+Guide

- Shawn
Lead Developer, C3 Design.
Twitter: @FatherShawn

karenann

  • I post occasionally
  • **
  • Posts: 110
  • Karma: 2
  • CiviCRM version: 4.7.3
  • CMS version: Joomla 3.4.8
  • MySQL version: 5.5.48-cll
  • PHP version: 5.4.41
Re: civicrm-2.2.0-joomla post Installation errors
March 23, 2009, 03:10:12 pm
Hello many helping hands.
I have since upgraded mySQl and am now at: 5.0.67

Starting a clean install using the following version, unzipped and installed from the folder:
.... public_html/administrator/components/com_installer/com_civicrm
civicrm-2.2.0-joomla-alt.zip
Gives me the following new error - I'd rather not chmod my administrator/components folder, any other suggestions?
JFolder::create: Could not create directory
Component Install: Failed to create directory.: "/home/dsao/public_html/administrator/components/com_civicrm"

FatherShawn

  • Ask me questions
  • ****
  • Posts: 372
  • Karma: 25
    • C3 Design
  • CiviCRM version: 4.2.11
  • CMS version: Drupal 7.23
  • MySQL version: 5.5.32
  • PHP version: 5.3.10
Re: civicrm-2.2.0-joomla post Installation errors
March 23, 2009, 05:03:50 pm
Is /home/dsao/public_html/administrator/components/ owned by what ever user the web server is running under?  It should be writable to that user but not to the world.
Lead Developer, C3 Design.
Twitter: @FatherShawn

karenann

  • I post occasionally
  • **
  • Posts: 110
  • Karma: 2
  • CiviCRM version: 4.7.3
  • CMS version: Joomla 3.4.8
  • MySQL version: 5.5.48-cll
  • PHP version: 5.4.41
Re: civicrm-2.2.0-joomla post Installation errors
March 24, 2009, 10:25:53 am
Hello FatherShawn:

yes it is, ownership is good, writeable is good. I have no other issues installing other components, just civicrm.
Also tried with alt and standard version same problem.

timbreese

  • Guest
Re: civicrm-2.2.0-joomla post Installation errors
April 01, 2009, 01:27:26 pm
I am also having post installation errors. I did not have many records yet in the earlier version so I decided to try to uninstall and delete the MySQL CiviCRM tables since I was having problems installing with either version of 2.2.0. My server is running PHP 5.2.6 and MySQL 4.1.22-standard

After what I hoped would be a clean install I got a success message after installing the alt version but when I go to open CiviCRM I get this error message:

DB Error: syntax error

Database Error Code: 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 '(MINUTE, cache_date, NOW()) > 0 )' at line 7, 1064

Error Details:

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

       
Code: [Select]
=> -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] =>
DELETE     g
FROM       civicrm_group_contact_cache g
INNER JOIN civicrm_contact c ON c.id = g.contact_id
WHERE      g.group_id IN (
    SELECT id
    FROM   civicrm_group
    WHERE  TIMESTAMPDIFF(MINUTE, cache_date, NOW()) > 0   
)
 [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 '(MINUTE, cache_date, NOW()) > 0   
)' at line 7]
    [type] => DB_Error
    [user_info] =>
DELETE     g
FROM       civicrm_group_contact_cache g
INNER JOIN civicrm_contact c ON c.id = g.contact_id
WHERE      g.group_id IN (
    SELECT id
    FROM   civicrm_group
    WHERE  TIMESTAMPDIFF(MINUTE, cache_date, NOW()) > 0   
)
 [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 '(MINUTE, cache_date, NOW()) > 0   
)' at line 7]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="
DELETE     g
FROM       civicrm_group_contact_cache g
INNER JOIN civicrm_contact c ON c.id = g.contact_id
WHERE      g.group_id IN (
    SELECT id
    FROM   civicrm_group
    WHERE  TIMESTAMPDIFF(MINUTE, cache_date, NOW()) > 0   
)
 [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 '(MINUTE, cache_date, NOW()) > 0   
)' at line 7]"]
)


Can you help?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: civicrm-2.2.0-joomla post Installation errors
April 01, 2009, 02:04:49 pm

civicrm 2.x require mysql 5.x. you will need to upgrade your mysql

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

timbreese

  • Guest
Re: civicrm-2.2.0-joomla post Installation errors
April 01, 2009, 03:52:53 pm
My server administrator said that they do not plan on upgrading to MySQL 5 for a while... I guess I can re-install the older version of CiviCRM.

karenann

  • I post occasionally
  • **
  • Posts: 110
  • Karma: 2
  • CiviCRM version: 4.7.3
  • CMS version: Joomla 3.4.8
  • MySQL version: 5.5.48-cll
  • PHP version: 5.4.41
Re: civicrm-2.2.0-joomla post Installation errors
March 04, 2010, 12:31:04 pm
Tim, is it worth your while changing to a differerent service provider?

By the way, my issues are resolved, it was, interestingly enough a browser issue that was impeding certain components. Firefox works best.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • civicrm-2.2.0-joomla post Installation errors

This forum was archived on 2017-11-26.