CiviCRM Community Forums (archive)

Hello,

I am trying to install Civicrm and our webmaster will not increase the php.ini settings. The max execution time is set to 30 seconds and it times out (to the blank page) after 30 seconds every time.

I have tried playing around with php.ini files & .htaccess files. Creating php.ini files in the various directoried has no effect (I don't have rights to restart the daemon but suspect that their security settings (safemode etc) would render it useless anyway). Php settings are shown at http://www.circus.org.nz/joomla/phpinfo.php.

When I edit .htaccess Joomla stops working & gives me an error page. This is the line I have been trying to add.

php_value max_execution_time 100

I have tried to do a manual install. I am not sure exactly which sql scripts to load but am thinking:

civicrm_41.mysql
civicrm_data.en_AU.mysql
civicrm_add_domain.en_AU.mysql

However, when I try to load up the sql through PHPMyadmin I get the following error:

CREATE TABLE civicrm_country(

id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Country Id',
name varchar( 64 ) COMMENT 'Country Name',
iso_code char( 2 ) COMMENT 'ISO Code',
country_code varchar( 4 ) COMMENT 'National prefix to be used when dialing TO this country.',
idd_prefix varchar( 4 ) COMMENT 'International direct dialing prefix from within the country TO another country',
ndd_prefix varchar( 4 ) COMMENT 'Access prefix to call within a country to a different area',
PRIMARY KEY ( id ) ,
UNIQUE INDEX UI_name_iso_code( name, iso_code )
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci
MySQL said: 

#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 'DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci' at line 30
I really want to give up on this but if CiviCRM works as well as I think it might it would make so much difference to the viability of our Charitable Trust. I can't find anything else out there that seems to be going to work for us. I've spent 5 hours this evening after putting my toddler to bed on this and I'm at my wits end. It works well on my home PC except for the speed which I'm hoping will be OK on a server

You are correct - it's php4. I need to use CiviCRM 1.8 or change hosting service (we are currently hosted for free by the City Council). I am going to try 1.8 but they have pulled all the documentation along with the support!

Yeah, I gave up after wasting much time on it. I have forked out $$ from my own pocket to get some proper hosting....  The free web hosting we have is upgrading in a couple of months but we can't wait for that.