The SimpleInvoices forum has moved to Google Plus - this forum is now read-only
PDO - MySQL problem
  • RealkingRealking March 2012

    Hi , I hadinstall the system I follow the steps
    I create a blank Db with utf8_ci collation every thing is ok
    I altered the config file like follow

    database.adapter = pdo_mysql
    database.utf8 = true
    database.params.host = 127.0.0.1
    database.params.username = root
    database.params.password = root
    database.params.dbname = simple_invoices
    database.params.port = 3306

    but I had the following error :-

    ===========================================
    Simple Invoices - PDO - MySQL problem
    ===========================================

    Your Simple Invoices installation can't use the
    database settings 'database.utf8'.

    To fix this please edit config/config.ini and
    set 'database.utf8' to 'false'

    ==========================================

    when I do like this and set 'database.utf8' to 'false'
    I had the following :-


    ===========================================
    Simple Invoices database connection problem
    ===========================================

    Could not connect to the Simple Invoices database

    For information on how to fix this pease refer to the following database error:
    --> could not find driver

    If this is an Access denied error please enter the correct database connection details config/config.ini

    Note: If you are installing Simple Invoices please follow the below steps:
    1. Create a blank MySQL database
    2. Enter the correct database connection details in the config/config.ini file
    3. Refresh this page

    ===========================================
    any one had an explanation ??

  • modirmodir March 2012

    Are you sure that you have pdo_mysql installed? Some system do only have pdo_mysqli or no PDO at all.

  • RealkingRealking March 2012

    I think i don't have if you could tell me how to install it on appache server on win7 it will be great

  • modirmodir March 2012

    Check once with phpinfo if you have it or not:
    http://php.net/manual/en/function.phpinfo.php

    Or what you already have and what not. Just to be sure.

  • RealkingRealking March 2012

    that's what i Found in phpinfo.php

    PDO

    PDO support enabled
    PDO drivers no value

  • RealkingRealking March 2012

    I think this means I don't have it

  • jfajfa April 2012

    I went through the problem described here when installing simple_invoices on a CentOs system.
    It was solved by installing, in addition to php-pdo, php-mysql (yum install php-mysql) and then restarting apache (/etc/init.d/httpd restart). Hope it helps.

Categories

Tagged