CiviCRM Community Forums (archive)

most likely that is the issue.

Can u ensure that your DSN all start with mysqli rather than mysql. You might want to take a look at configure.php and hack that to make it work with mysqli (and let us know what u hacked)

lobo

DSN == database string that allows us to access your db

I'm not sure why u r getting that error so cant be too helpful. If you know a php developer, they might be able to help out.

lobo

Sorry about your frustration. The problem is that we do not use, and don't have experience with the PHP mysqli extension which I believe you are running. The error you're getting indicates that our database connection library (PEAR) is not able to connect to your instance of MySQL to load civicrm_41.mysql. This is the script which actually creates all the CiviCRM tables in our Joomla DB.

A few things you might try...

1. If you want to try and make things work with the PHP mysqli extension - you can post the related settings here and that my give us some ideas as to what's wrong. From the civicrm.settings.php file in administrator/components/com_civicrm - copy and paste these two settings after obscuring the passwords:
CIVICRM_UF_DSN (this tells CiviCRM how to connect to the Joomla DB)
CIVICRM_DSN (this tells CiviCRM how to connect to the DB that contains it's own tables - it should be the same as CIVICRM_UF_DSN for Joomla installs)

My settings look like this (user and pw changed):
define( 'CIVICRM_UF_DSN'     , 'mysql://dbuser:pw@localhost/joomla_1?new_link=true' );
define( 'CIVICRM_DSN'          , 'mysql://dbuser:pw@localhost/joomla_1?new_link=true' );

A wild guess is that you might need to change 'mysql://...' to 'mysqli://...' in these settings.

In any case, I would guess that the loading of the data structure failed - so you could try loading the two mysql scripts manually into (a backup copy of...) your Joomla DB via phpMyAdmin:
civicrm/sql/civicrm_41.mysql
civicrm/sql/civicrm_generated.mysql

If none of this works - hopefully others here have experience w/ mysqli and can chime in - and Googling on mysqli and your error could be useful.

I'm posting in here since I had a similar error....but I'm having the feeling I know the answer already 
but just to see if it could be something else (hope dies last, as the saying goes) I'll post it here:

Install Successful

CiviCRM has been successfully installed.
Installation: Succesful
Cannot execute -- * -- * -- * -- * 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: DB Error: syntax error

The Server where my database is on has an older version of MySQL: 3.23.58-max-nt
and since i already read in here that civicrm needs at least MySQL 4.1   I guess that's what my problem is
can I manually insert the table, would civicrm work if I did ?

Thank you!
I transfered the page to another server as far as I an tell (just started to play around with the settings) it works fine now.

In any case, I would guess that the loading of the data structure failed - so you could try loading the two mysql scripts manually into (a backup copy of...) your Joomla DB via phpMyAdmin:
civicrm/sql/civicrm_41.mysql
civicrm/sql/civicrm_generated.mysql

Well, I tried this and it created and updated the tables. Without doing any of the other things in that post I still get the same errors when trying to use CiviCRM:

Warning: include_once(civicrm.settings.php) [function.include-once]: failed to open stream: No such file or directory in /home/*****/www/www/administrator/components/com_civicrm/admin.civicrm.php on line 7

Warning: include_once() [function.include]: Failed opening 'civicrm.settings.php' for inclusion (include_path='.:/usr/local/php5/lib/php') in /home/*****/www/www/administrator/components/com_civicrm/admin.civicrm.php on line 7

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

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

And the same message when I uninstall and reinstall it. Now I have lots of tables with no apparent way to connect them. It must be a simple link at this point. No?