This page details the various options in the Simple Invoices config file ( config/config.ini )
database.adapter = pdo_mysql database.utf8 = true database.params.host = localhost database.params.username = root database.params.password = database.params.dbname = simple_invoices database.params.port = 3306
The 'database.' section details your database connection details.
| Options | Description |
|---|---|
| adapter | Default is 'pdo_mysql' |
| utf8 | Default is 'true'. If you have problems with inputted data with non-latin characters set this to false and retry |
| host | Enter the server name that your Simple Invoices database is on. This is normally 'localhost' |
| username | The username to connect to your database |
| password | The password for the above user |
| dbname | Enter the name of the database you are using for Simple Invoices ie. 'simpleinvoices' |
| port | The default MySQL port is 3306. If your instance is different enter it here |
authentication.enabled = false authentication.http =
| Options | Description |
|---|---|
| .enabled | Authentication is disabled by default, Enter 'true' to turn it on. Note: the default username is '[email protected]' and password is 'demo' |
| .http | entre 'true' to use Apaches .htpasswd system. Note: its up to you to create the .htpasswd file |
export.spreadsheet = xls export.wordprocessor = doc export.pdf.screensize = 800 export.pdf.papersize = A4 export.pdf.leftmargin = 15 export.pdf.rightmargin = 15 export.pdf.topmargin = 15 export.pdf.bottommargin = 15
| Options | Description |
|---|---|
| .spreadsheet | Enter 'xls' for MS Excel export, use 'ods' for Open Document export |
| .wordprocessor | Enter 'doc' for MS Word export, use 'odt' for Open Document export |
| .pdf.screensize | Screen resolution for PDF |
| .pdf.papersize | Papersize for PDF. Can be A4, Letter, etc.. |
| .pdf.leftmargin | Left indent margin width |
| .pdf.rightmargin | Right indent margin width |
| .pdf.topmargin | Top indent margin width |
| .pdf.bottommargin | Bottom indent margin width |
local.locale = en-gb local.precision = 2
| Options | Description |
|---|---|
| .locale | This sets the location dependent (date, money, numbers, etc..) formatting used in Simple Invoices, refer: http://unicode.org/cldr/data/diff/supplemental/languages_and_territories.html for list of all locales |
| .precision | This is the number of decimal places to format numbers with. Default is 2 |
email.host = localhost email.smtp_auth = false email.username = email.password = email.smtpport = 25 email.secure = email.ack = false
| Options | Description |
|---|---|
| .host | The server name of your outgoing email server. This is normally 'localhost' |
| .smtp_auth | Enter 'true' if yoour out going email server requies a username and password to send |
| .username | The username if smtp_auth is 'true' |
| .password | The password if smtp_auth is 'true' |
| .smtpport | The port number for the mail server. Default is 25, use 465 for secure ssl |
| .secure | Email security type, default is '', others are 'ssl' or 'tls' |
| .ack | If you want a read receipt of the email set this to 'true' |
debug.level = All
The debug level used within Simple Invoices
| Options | Description |
|---|---|
| None | Off |
| All | On |
debug.error_reporting = 0
This sets the PHP error reporting level, refer: http://au.php.net/manual/en/function.error-reporting.php for full PHP list
Main ones to use are
| Error_reporting level | Description |
|---|---|
| 0 | Turn off errors |
| -1 | Show all errors - same as E_ALL |
| E_STRICT | PHP interoperability and compatibility errors |
| E_ERROR | Show simple running errors |
phpSettings.date.timezone = UTC
Set this to your timezone, UTC is the default. Refer: http://au.php.net/manual/en/timezones.php for the list of all timezones
phpSettings.display_startup_errors = 0 phpSettings.display_errors = 0
This sets the php settings for displaying errors
| Options | Description |
|---|---|
| 0 | Off |
| 1 | On |
version.name = 2009.1
Details the version of Simple Invoices that you are using
If $environment is not = “production” then this allows you to have another local config file for your dev or other purposes ie. dev.config.ini
any config.ini setting in this extra file(which wont be kept in svn) will overwrite config.ini values
this way everyone can have there own conf setting without messing with anyones setting
/* RELEASE TODO: make sure $environment is set back to live */ $environment = "dev"; //test,staging,dev,live etc.. define("TB_PREFIX","si_"); // default table prefix si_ - Old variable: $tb_prefix = "si_";
Links: Frequently Asked Questions | Help
Discussion
Fatal error: Undefined class constant 'MYSQL_ATTR_INIT_COMMAND' in C:\wamp\www\simpleinvoices\include\class\db.php on line 53
Look at your config.ini file look for pdo_mysqldatabase.utf8 and make it false. it should work
Same problem : Fatal error: Undefined class constant 'MYSQL_ATTR_INIT_COMMAND' in C:\wamp\www\simpleinvoices\include\class\db.php on line 53
I m tring to configure, but still not done.
How to create MySQL blank database? Please help me i am newbee in this.
Although database.adapter defaults to
'pdo_mysql', if we try the value'mysql', it fails. There are many old servers that do not have any PDO. Any workarounds?Fatal error: Uncaught exception 'Zend_Config_Exception' with message 'Section 'production' cannot be found in ./config/config.ini'
Fatal error: Uncaught exception 'Zend_Config_Exception' with message 'Section 'production' cannot be found in ./config/config.ini'
I have problem Fatal error: Undefined class constant 'MYSQL_ATTR_INIT_COMMAND' in C:\wamp\www\simpleinvoices\include\class\db.php on line 53 . and Look at your config.ini file look for pdo_mysqldatabase.utf8 and make it false. it should work Solved Fatal error: Undefined class constant 'MYSQL_ATTR_INIT_COMMAND' this problem but another problem generated is
Could not connect to the Simple Invoices database - i set correct username and password in config.ini
Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request.
Que hago?
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, webmaster@localhost and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log.
what should i do now.please help as soon as possible
I uploaded all the file after updated the config.ini . After opening the index page I'm getting an error message saying “Fatal error: Uncaught exception 'Zend_Config_Exception' with message 'Error parsing ./config/config.ini on line 10 ' in /home2/obtaineb/public_html/honeybeast_invoices/library/Zend/Config/Ini.php:181 Stack trace: #0 /home2/obtaineb/public_html/honeybeast_invoices/library/Zend/Config/Ini.php(201): Zend_Config_Ini→_parseIniFile('./config/config…') #1 /home2/obtaineb/public_html/honeybeast_invoices/library/Zend/Config/Ini.php(125): Zend_Config_Ini→_loadIniFile('./config/config…') #2 /home2/obtaineb/public_html/honeybeast_invoices/include/init.php(126): Zend_Config_Ini→__construct('./config/config…', 'production', true) #3 /home2/obtaineb/public_html/honeybeast_invoices/index.php(29): require_once('/home2/obtaineb…') #4 {main} thrown in /home2/obtaineb/public_html/honeybeast_invoices/library/Zend/Config/Ini.php on line 181” without quotes. Please tell me how to fix it.
The issues is fixed. The haven't mentioned the correct DB credentials.
Note: not all characters are allowed in the encryption key and the nonce key. Something was throwing an Zend error. Justin, please speak to which characters are/arenot allowed.
What is the problem here?
The following message is shown:
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
This is the full config.ini fie:
; Simple Invoices configuration file ; - refer http://www.simpleinvoices.org/config for all options
; Production site configuration data [production] database.adapter = pdo_mysql database.utf8 = false database.params.host = localhost database.params.username = root database.params.password = admin123 database.params.dbname = simple_invoices database.params.port =
authentication.enabled = false authentication.http =
export.spreadsheet = xls export.wordprocessor = doc export.pdf.screensize = 800 export.pdf.papersize = A4 export.pdf.leftmargin = 15 export.pdf.rightmargin = 15 export.pdf.topmargin = 15 export.pdf.bottommargin = 15
local.locale = en_GB local.precision = 2
email.host = localhost email.smtp_auth = false email.username = email.password = email.smtpport = 25 email.secure = email.ack = false
encryption.default.key = this_is_the_encryption_key_change_it nonce.key = this_should_be_random_and_secret_so_change_it nonce.timelimit = 3600
version.name = 2010.2 update 1 - stable debug.level = All debug.error_reporting = E_ERROR phpSettings.date.timezone = Europe/London phpSettings.display_startup_errors = 1 phpSettings.display_errors = 1 phpSettings.log_errors = 0 phpSettings.error_log = tmp/log/php.log
; Explicity confirm delete of line items from invoices? (yes/no) confirm.deleteLineItem = no
; Staging site configuration data inherits from production and ; overrides values as necessary [staging : production] database.params.dbname = simple_invoices_staging database.params.username = devuser database.params.password = devsecret
[dev : production] database.params.dbname = simple_invoices_dev debug.error_reporting = E_ALL phpSettings.display_startup_errors = 1 phpSettings.display_errors = 1
Zend Mail Protocol Exception: Permission denied i can not send the invoice by e-mail