Openpublish Drupal 6 installation error

Events happening in the community are now at Drupal community events on www.drupal.org.
motomc's picture

I'd like to install openpublish based on Drupal 6, but after the choosing language I receive the message "Fatal error: Maximum execution time of 300 seconds exceeded in D:\sites\testsite\www\includes\file.inc on line 937". (I changed the execution time from 120 sec to 300, but it didn't help).
I don't have any problems with installation of the last version based on Drupal 7.
Could anybody help me to solve my problem with Drupal 6?

Comments

OP needs a high

FanisTsiros's picture

OP needs a high value for the Maximum execution time (especially on windows).

Try a value more than 1000 and you should have success installing OP in a local environment. If this is a local testing install you should'nt have to worry about this. (I suppose you are trying to install on a windows system.)

After installing you may decrease the Maximum execution time value.

In my case, when i was trying to install i set Maximum execution time 1200 !

Thanks! Yes, it works, but

motomc's picture

Thanks! Yes, it works, but now I'v got a new problem

I have a message on admin page about error: "user warning: MySQL server has gone away query: UPDATE cache_update SET data = 'a:71:{s:5:\"admin\";a:23:{s:4:\"name\";s:5:\"admin\";s:4:\"info\";a:6:{s:4:\"name\";s:5:\"Admin\";s:7:\"package\";s:14:\"Administration\";s:7:\"version\";s:7:\"6.x-......." It's a very long message (it takes few screens) and I don't know what to do with it. I use a localhost.

so, I disabled Locale updater and this problem gone away.

Usually this is a MySql

FanisTsiros's picture

Usually this is a MySql problem with the "maximum allowed packet size"
You have to icrease this setting in your my.cnf file (mysql configuration file).

I'm having the same problem,

Num85's picture

I'm having the same problem, can anyone tell me where to edit the max execution time in file.inc? All I see on line 937 is:

"if (is_dir("$dir/$file") && $recurse) {"

max execution time is in your

FanisTsiros's picture

max execution time is in your php.ini file. This is a PHP setting not a Openpublish setting.

I'm on shared hosting and

Num85's picture

I'm on shared hosting and don't have access to the php.ini file, is there any other way of fixing this for shared hosting sites?

FanisTsiros's picture

Well this is the real problem with the OpenPublish. I am in a shared hosting too. I have never managed to install a standard Openpublish in my shared hosting. But finally i found a way to TRANSFER my site...

First i installed locally, then i migrated my site in my shared hosting. Openpublish needs too much resources especially during isntall.

I followed these steps to run my OpenPublish site (www.moriasnow.gr).

  1. I installed OpenPublish locally in my linux testing environment. Localy i changed php.ini, so i could install successfully.
  2. I made a full local mysql backup of the database with phpmyadmin.
  3. I transfered all OpenPublish files to my sharing hosting (remember to change "settings.php" file and "default" directory permissions before transfer, and again after the transfer back to the same permissions for security)
  4. I imported the database backup file in shared hosting.

I suppose you are comfortable with these steps, if not, Feel free to ask more info.

php ini

asikuy's picture

some php ini directives can be placed inside .htaccess.

I've heard some good things

Num85's picture

I've heard some good things about Pinchhost (http://www.pinchhost.com/) and was wondering if anyone had ever successfully managed to install openpublish on pinchhost's shared hosting plans? They say they support openpublish but am wondering if I will be able to get through the install process.

FanisTsiros - I'm a complete

Num85's picture

FanisTsiros - I'm a complete noob when it comes to installing locally on my computer, do you know of any guides or resources to help me do this?

Acquia's dev desktop

pkchoo's picture

I use Acquia's dev desktop to work on my sites locally. It's simple and works great.

http://www.acquia.com/downloads

I managed to install

Num85's picture

I managed to install openpublish locally and have it up and running now - can you tell me which files I need to edit and how (including the mysql database) in order to migrate the site?

There are is only one file to

FanisTsiros's picture

There are is only one file to edit. (settings.php)

I have never used Acquia's dev desktop, but i suppose "phpMyAdmin" is included. Also i suppose that your local server root is http://localhost and you have just installed Openpublish inside root. Try NOT to make any article postings or anything else yet. (you will have much time after the migration to play locally)

  1. Go to http://localhost/phpmyadmin or whatever addresss is phpmyadmin mysql administration tool.
  2. Select your (local) OpenPublish database, EXPORT the sql file and save it.

  3. Now use your shared hosting phpmyadmin tool to IMPORT your database.
    IMPORTING should be in a clean new database.
    This step should go smoothly, but sometimes fails because of a "MySQL server has gone away" Error.
    This is mainly caused by a very large query usually by the cache tables. To avoid these errors, try to not use your local isntallation, in order to avoid building the cache tables with too much data. If you encounter this error try to empty all cache tables from your local instalation with phpmyadmin and try to re-export re-import.

  4. Upload a fresh copy of Openpublish package on your shared hosting with ftp. There is no need to copy locally installed files.

  5. MAKE A COPY FIRST and then EDIT your LOCAL settings.php file (located in /sites/default/)
    Find and Set the variable "$db_url" inside settings.php file with the settings for your shared hosting :

$db_url = 'mysqli://username:password@localhost/databasename';

(change username, password and databasename with those for your shared hosting)

This is the only change you have to make !

UPLOAD settings.php file on your shared hosting inside /sites/default/ directory

REMEMBER TO SET settings.php FILE PERMISSIONS BACK TO 444

also "default" directory should have 555

That's all !

Maybe you have to go to /admin/settings/file-system and set new settings (if your local install was on windows these seetings have to change for linux )

good luck !

Thanks for your post - its a

Num85's picture

Thanks for your post - its a very helpful guide.
I have just one question - I installed OP in localhost/openpublish and plan on uploading to the root of my site - will I need to change anything else for this to work?

OpenPublish

Group organizers

Group categories

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds:

Hot content this week