By feeper on
After installing CiviCRM, downloaded from CiviCRM.org. After completing the manual install and editing the configuration file I receive nothing but blank pages on every request to the site. I am using Drupal 4.7, MySQL 5, PHP 5 and IIS 5.
My PHP.ini file has the memory set to 32 MB (have tried 64MB). All folders requested in the configuration file have been created and granted read write access. Proper settings were entered for the database connection.
Any suggestions would be appreciated.
Comments
Any solutions
Has anybody found a solution to this??
I installed CiviCRM with
I installed CiviCRM with Drupal 4.7 successfully using FTP, File Manager, Control Panel and PHPMyAdmin. I posted specific directions on how to do it that are pretty easy to follow. You can probably find the post using search. I also posted the directions on the CiviCRM Blog page. The title is something like How to install CiviCRM 1.5 on Drupal 4.7 Without using Command Line.
Hmmm, still get blank pages
I followed your instruction on the civicrm blog, I am still getting blank pages after I initialize the civicrm module.
Not sure what this means because I could not find references to the error in civicrm.settings.php. After I get in to Administer -> Modules - civicrm is checked and the error message appears above the module selections:
* warning: include_once(sites/default/civicrm.settings.php) [function.include-once]: failed to open stream: No such file or directory in C:\Inetpub\wwwroot\drupalsite\modules\civicrm\drupal\civicrm.module on line 34.
* warning: include_once() [function.include]: Failed opening 'sites/default/civicrm.settings.php' for inclusion (include_path='.;C:\php5\pear') in C:\Inetpub\wwwroot\drupalsite\modules\civicrm\drupal\civicrm.module on line 34.
Any suggestions?
Thanks.
My guess is that one of your
My guess is that one of your files isn't where it's supposed to be.
First, make sure you have created those folders in the civicrm folder (crm_docs, persist, upload and templates_c)
Make sure you changed the name of civicrm.settings.php.sample to civicrm.settings.php and that you put a copy of that file into the drupal/sites/default folder
Also, make sure that you import BOTH of the mysql files that I refer to in the instructions.
You also need to move civicrm.module into drupal/modules
Go ahead and check and make sure all these things are in order because I suspect that's probably what the problem is.
The other possibility is that you may have put the wrong info in the config.php file. The first set of database information is for your drupal installation. The second is for your CiviCRM database. Make sure you didn't mix those up, too.
I'll check back in a little bit to see how you made out.
Oh...and make sure you used the ./modules/drupal/etc... paths in your civicrm.settings.php file because trying to use absolute paths tend to give a lot of trouble with this installation. The ./ method works really well. You can just copy and paste the exact paths in my instructions as long as you put those 4 folders right where I say to in the instructions.
Crazy
My err. I noticed one thing that one step I hadn't noticed...copy the civicrm.module to ./module. AFter I did that it fixed the issue with the blank pages.
Now the problem I am having is I have to use the mysqli function to access the database, which I have changed to reflect. I use my hosing service for the drupal site and have my own server for the mysql database.
I have checked the settings for civicrm and it shows the login/password correct and it is @ my server and the correct database name is present.
warning: mysqli_connect() [function.mysqli-connect]: (28000/1045): Access denied for user 'civicrm'@'hosting service address'(using password: YES) in C:\Inetpub\wwwroot\drupal\modules\civicrm\packages\DB\mysqli.php on line 322.
CiviCRM
Sorry. A non-recoverable error has occurred.
Return to CiviCRM menu.
This message is from the CiviCRM page on my drupal site. I have tried both Mysqli and Mysql. Any suggestions? I appreciate your help on this!
I had a similar error on my main drupal site when I first set it up, but that was due to a mix up with the login and server name (was typing off of a piece of paper with my caffiene driven hand writing, stupid me). It appears that this is not the reason for an almost identical error.
Are you installing CiviCRM
Are you installing CiviCRM on the same database as Drupal? (might not be a good idea in case CiviCRM decides to burp back at you and you have to delete and start over, lol)
You should at least start off putting it on it's own DB and making sure the DB user has full permissions with the DB.
There must be something off with your database settings or database user not having the necessary priveleges. Exactly how are you setting up your databases? I do everything using FTP, CPanel, File Manager and PHPMyAdmin...so I'm not sure how much help I can be if you're using a method I'm not familiar with. I can try, though.
Continued..
I have CiviCRM on its own database. The user names have permission (I had to check because I didn't remember giving privileges to the schema for the user name, but I did.
I have set up the database using mysql admin by importing the sql files into the schema, no errors. The tools I used were FTP, MySQL Admin and MS Visual Studio to edit the php files. The methods I have used are similar, if not exact. The steps followed were yours to a T.
I have even tried to use the root access for the database - it has rights to all schemas. Received more errors I wish to count, so obviously it was not meant to do that.
I am receiving this error in the array:
[user_info] => [nativecode=Access denied for user 'civicrmdb'@'web-02.hostingservice.com'. I don't see where it would be getting the hostingservice address from ( I do not reference localhost anywhere ). I do not get any errors from the drupal database, only the civicrm.
Hmmm... What do you have for
Hmmm...
What do you have for paths in your civicrm.settings.php file? Not the actual URL paths, but the other ones? Did you use the './modules/etc' method or absolute paths?
Also, can you check to see how many items you have in your CiviCRM database? I believe you should have 92, if I remember correctly.
Also, check the permissions for the civicrm.config.php file. Maybe it's not writeable (same with your drupal config.php file)...that could potentially be the problem. After checking that stuff try running update.php (drupalfolder/update.php). It might be that because you had a few false starts getting this module installed that your database just needs updating. It's worth a shot...
I think I know what the
I think I know what the problem may be after re-reading your posts.
You copied the civicrm.module file into the ./modules folder.
You are supposed to copy it into the /modules folder.
You have two modules folder...and the civicrm.module file has to be in the second one.
Go ahead and try moving it and see if that fixes the problem.
You lost me :P
There is two modules folders? The only one I knew of is: drupalsite/modules.
Where is the other one?
lol...when you use the
lol...when you use the './modules/etc...' method to get this miserable installation done it creates another modules folder called ./modules....hehe. They are both in the same directory...and the ./modules one is the first one you see. I did the same thing with some files. I uploaded a tar file of a module and unzipped it and went to enable it and it was nowhere to be found. It took me about 15 minutes to realize what I'd done, lol.
That might be your problem...I'm crossing my fingers for you...hehe.
I have 93
My database has 93 records
./modules/etc is the method that I used, i didn't touch the absolute paths.
Read Write is the permissions for the civicrm.config.php and drupal settings. All have CHMOD 666. I ran update.php to no avail.
I am still bothered by the root of the problem - meaning it is calling the hosting server instead of the specified address of my server to call MySQL. It doesn't make sense that the drupal database is called exactly the same way as what is in the Civic settings. I am hoping to get this working on my own server for the time being. The hosting service is currently going through the process of getting MySQL on their own server ( this may fix it ), but of course I need this site fully functional before that happens.
Can you think of any other reason why this would be calling the MySQL server this way?
Okay, I checked my CiviCRM
Okay, I checked my CiviCRM databases and it is 93 items...so you have all the sql data where it has to be.
The only three things I can think of is:
1. civicrm.module being in the wrong folder
2. civicrm.settings.php database settings being mixed up (you have to enter the drupal db info in the first configuration area and civicrm db info in the second area)
3. permissions on config.php files having to be set at 777 temporarily
I'm guessing it's more likely that either 1 or 2 are the issues.
Hmmm K
Thought I had it fixed (had enabled civimail) Removed it and it came up to the civicrm page (access denied), refreshed and back to new errors now.
I will post them tomorrow, need sleep. Thanks for the help!
lol, okay...I'll check back
lol, okay...I'll check back tomorrow. :)
Error
Wait it is tomorrow :P after this I am going...
warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in C:\Inetpub\wwwroot\modules\civicrm\CRM\Core\BAO\UFGroup.php on line 887.
warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in C:\Inetpub\wwwroot\modules\civicrm\CRM\Core\BAO\UFGroup.php on line 887.
No longer getting an SQL error. Hopefully this is progress.
Okay...the UF (I
Okay...the UF (I think...hehe) is reference to your Drupal Database.
Take a look at the code below and notice the "UF" info...check all the configurations with UF in the line of code. Make sure they are right. Also...did you remember to create those 4 folders in your main civicrm folder and set them to write? (templates_c, persist, upload and crm_docs) These have to be created manually, so if you didn't do that it will cause errors.
Pay CLOSE attention in defining the database information. The first defines is for your DRUPAL database and the second is for your CIVICRM database. You can put them in the same database if you really want to but I strongly advise against it. If something goes wrong and they are on separate databases then you can remove CiviCRM without breaking your Drupal installation. Use two separate databases and then if they don’t work right together it will be much easier to deal with it.
________________________________________________________________________
define( 'ENABLE_COMPONENTS', 'CiviContribute,CiviMember,CiviMail' );
define( 'CIVICRM_UF' , 'Drupal' );
define( 'CIVICRM_UF_VERSION' , '4.7' );
define( 'CIVICRM_UF_URLVAR' , 'q' );
define( 'CIVICRM_UF_DSN' , 'mysql://DRUPALdb_user:password@mysqlhost/yourDRUPAL_db?new_link=true' );
define( 'CIVICRM_UF_USERSTABLENAME', 'users' );
global $civicrm_root;
$civicrm_root = './modules/civicrm';
define( 'CIVICRM_TEMPLATE_COMPILEDIR', './modules/civicrm/templates_c/' );
define( 'CIVICRM_UPLOADDIR' , './modules/civicrm/upload/' );
define( 'CIVICRM_IMAGE_UPLOADDIR' , './modules/civicrm/persist/');
define( 'CIVICRM_CUSTOM_FILE_UPLOADDIR' , '.modules/civicrm/crm_docs/' );
define( 'CIVICRM_UF_BASEURL' , ‘http://your site.com/drupal/' );
define( 'CIVICRM_UF_RESOURCEURL' , 'http://your site.com/drupal/modules/civicrm/' );
define( 'CIVICRM_IMAGE_UPLOADURL' , 'http://www.your site.com/drupal/modulues/civicrm/persist/' );
define( 'CIVICRM_MYSQL_VERSION', 4.1 );
define( 'CIVICRM_DSN' , 'mysql://CIVICRMdb_user:password@yourmysqlhost/CIVICRMdb_civicrm?new_link=true' );
Same error as another person
I seen this thread - http://drupal.org/node/89698
This person ended up with the same error I have now...wonder if it was fixed.
They never came back so it
They never came back so it was either fixed or they threw their computer out the window and broke it and can't post. :)
Back
Okay, here is more detail about that error. First let me just recap what I have done.
Using: MySQL 5
PHP: PHP 5
Server: IIS6 (on both servers)
Created civicrm folder under /modules - uploaded civcrm there.
Uploaded civicrm.settings - /sites/default/ & /modules/
Created folders for civicrm in /modules/civicrm/ - templates_c, upload, persist & crm_docs.
Double check my database settings in the civicrm.settings file - they are correct and my drupal database is the UF and the second line for database settings is my civicrm database. The logins and passwords are correct and are pointing to my mysql server (separate from my hosting. Have tried setting the permissions higher for the civicrm.settings file.
The same error appears about the UF, but this is what shows up near the bottom of the page:
Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -2
[message] => DB Error: syntax error
[mode] => 16
[debug_info] => SELECT id, name
FROM civicrm_state_province
WHERE ( country_id IN () )
ORDER BY name
[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 ') )
ORDER BY name' at line 4]
[type] => DB_Error
[user_info] => SELECT id, name
FROM civicrm_state_province
WHERE ( country_id IN () )
ORDER BY name
[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 ') )
ORDER BY name' at line 4]
[to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT id, name
FROM civicrm_state_province
WHERE ( country_id IN () )
ORDER BY name
[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 ') )
ORDER BY name' at line 4]"]
Hmmm...did you leave a copy
Hmmm...did you leave a copy of the civicrm.settings.php in the civicrm folder or did you just move that file into the drupal/sites/default/ folder?
If you didn't leave one in the civicrm folder, copy one there and see if that helps.
If that isn't the issue then did you write anything other than the paths and database settings in the civicrm.settings.php file? If you did, try uploading a new copy of that from your civicrm download and edit ONLY the databases and paths. Upload the new file and put a copy in both the civicrm folder and the drupal/sites/default/ folder.
Run update.php and see if that helps. If it doesn't, you might have to dump the civicrm database and recreate it and import those two mysql files again.
If all that fails you can try to upload civicrm tables right onto your drupal database by changing the settings to have both database configurations point to the drupal database and import your mysql files there.
Are you only allowed one database on your host or something? I'm just curious why you don't have both databases in the same place.
I host both databases
I have both databases on my own server. The only other thing that I changed was the country codes as I am in Canada - Changed from US to CA. I will try leaving these at US and only change the database and folder settings.
There are two copy's of the config file, one in sites/default/ and the other in /modules/civicrm.
update.php did not do anything for me. I have tried to rebuild the database and received new error messages in regards to the country/province - hence why I am going to try setting them back to US.
Will post the results.
Here are the results after changing to the US:
Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -2
[message] => DB Error: syntax error
[mode] => 16
[debug_info] => SELECT id, name
FROM civicrm_state_province
WHERE ( country_id IN () )
ORDER BY name
[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 ') )
ORDER BY name' at line 4]
[type] => DB_Error
[user_info] => SELECT id, name
FROM civicrm_state_province
WHERE ( country_id IN () )
ORDER BY name
[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 ') )
ORDER BY name' at line 4]
[to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT id, name
FROM civicrm_state_province
WHERE ( country_id IN () )
ORDER BY name
[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 ') )
ORDER BY name' at line 4]"]
)
This is the exact error that I receive when it was set to CA. So no change there.
your indications are much simpler but...
I have followed your instructions, bu receive:
I am getting this:
Parse error: syntax error, unexpected T_STRING in /home2/mydrupalo/public_html/orale/form/sites/default/civicrm.settings.php on line 155
line 155 is:
define( 'CIVICRM_UF_BASEURL' , 'http://orale.mydrupalo.org/form/' );
i solved it on a freh site + i was using two diferent db users...
Yep, I strongly suspect the
Yep, I strongly suspect the problem is with the country code you changed. All those other configurations that are optional should wait until you get CiviCRM up and working. I would also ask one of the CiviCRM developers exactly how you should tweak the country code. I haven't done that since I'm in the US, so I can't really help you with that.
having a similar problem with CiviCRM
I keep getting the following error when adding test accounts.
warning: array_key_exists(): The second argument should be either an array or an object in C:\apache2triad\htdocs\irp\modules\civicrm\CRM\Core\BAO\UFGroup.php on line 867.
I have tried altering the settings.php file several times and haven't gotten anywhere. Any suggestions?
Did you get it working?
Did you get it working? You're awfully quiet, lol...
Wait...I just saw where you edited your post...and I missed it.
You must have messed up the code when you edited that area of the civicrm.settings.php file. Get a fresh copy of the civicrm.settings.php.sample file and edit just the database and path info and replace your old civicrm.settings.php files (in civicrm folder and in drupal/sites/default folder) with the new one.
At this point that's the only thing I can think of that would fix the problem. You seem to have gotten everything else in order, so I would think this will fix it, especially with the errors you're getting.
Not yet..taking a step away from it for a bit
Trying the fresh copy now...will let you know.
okies...
okies...
You've been gone awhile...
Either it worked and you are exploring the installation or you got fed up and hurled the 'puter out the window.
I wonder which one it is, lol? :)
Same problem on new server
I'm running into the same problem, as well as some "permissions denied" for a couple of other modules. Everything worked fine on the virtual dedicated machine I was running on. I just moved everything over to a dedicated CentOS box - and am now getting all these errors.
As I haven't changed any file/folder permissions for the Drupal installation, I'm wondering if it has to do with group permissions on the new server.
-s
Sean Larkin
Not resolved
Moved everything over to another server that has its own mysql server - used all the settings that you had....two copies of the settings.php file - one in the civicrm folder and the other under the sites folder. I am however receiving a new error.
Parse error: syntax error, unexpected '.', expecting '(' in /home/uppercan/public_html/test/modules/civicrm/civicrm.module on line 134
Any thoughts ladycentaur?
Thanks