SQL error on install
  • rouleroule February 2010

    Hi,

    Sorry for my english, i'm french and i speak a very bad english.
    I just come to install your soft and first, the creation of the database did not work, so i had to import the .sql file.
    After, i could create some user, but on the Home > Dashboard (and on some other place like on the redirect after invoice creation) i've this message :
    Fatal error: Call to a member function bindValue() on a non-object in /home/myfolder/include/sql_queries.php on line 109

    Can you help me please ?

    Configuration :
    PHP Version 5.2.0-8+etch16
    MySQL : 5.0.32-Debian_7etch12-log
    xslt, gd 2 are ok.

  • rouleroule February 2010

    Please someone could help me ?

  • rouleroule February 2010

    Another problem (i think it's the same one) :
    There have been no users created. Click the 'Add User' button above to create one -> whereas there's at list one user because in the config.ini i put :
    authentication.enabled = true
    Before i create a user and i can access with this user login and pass, but on the user page i've this message : There have been no users created. Click the 'Add User' button above to create one
    ...
    I think there's a pb of communication whith the Mysql database. My config.ini like that (for the part i've modified) :
    database.adapter = pdo_mysql
    database.utf8 = true
    database.params.host = localhost
    database.params.username = login
    database.params.password = pass
    database.params.dbname = dbname
    database.params.port = 3306

    authentication.enabled = true

  • rouleroule February 2010

    I don't want to do Leeloo on the fifth element but :
    Please....Help... ;)

  • rouleroule February 2010

    FYI database.params.password is only composed of letters (alphanumeric could make mistake?) !

  • rouleroule February 2010

    OMG nobody can help me ? Please !

  • sbrsbr February 2010

    Hi Roule is it a windows box ur installing on? Then you could try and remove current install and then install Wamp, wich is a compilation of mysql, php and apache.
    If you go for this solution and then place the simpleinvoices in the c:\wamp rootfolder, then ur ready to go.

  • rouleroule February 2010

    Hello sbr, and thx for your answer !
    But my install is on a debian Unix server and not on Windows...

  • sbrsbr February 2010

    isnt there a guide on how to do this? ive found this http://www.howtoforge.com/simple_invoices_debian_etch perhaps it can guide you a bit?

  • rouleroule February 2010

    Hi sbr

    my install was exactly like this howto...
    I don't understand...

  • rouleroule February 2010

    I'm trying to install again SimpleInvoices on another directory, whith another database and access...
    When i try to install database (whith the automaticaly install) i've this error :

    Fatal error: Uncaught exception 'Zend_Acl_Exception' with message 'Resource 'install' not found' in /home/julien/www/fact/library/Zend/Acl.php:347 Stack trace: #0 /home/julien/www/fact/library/Zend/Acl.php(751): Zend_Acl->get('install') #1 /home/julien/www/fact/include/check_permission.php(7): Zend_Acl->isAllowed('administrator', 'install', NULL) #2 /home/julien/www/fact/include/init.php(177): include_once('/home/julien/...') #3 /home/julien/www/fact/index.php(26): require_once('/home/julien/ev...') #4 {main} thrown in /home/julien/www/fact/library/Zend/Acl.php on line 347

    An idea ?

  • rouleroule February 2010

    My second installation blocked as the first one...The automaticaly install of database didn't work, so i've to import the sql file with phpmyadmin.
    After this install, when i create a new user with simpleinvoices, the user is insert correctly in the database but on simpleinvoices, i always have the message :
    There have been no users created. Click the 'Add User' button above to create one

    It's the same for invoices, customers...

  • justinjustin February 2010

    hey guys

    sorry for the delay - been busy

    re "Fatal error: Call to a member function bindValue"
    - try and isntall php5.3
    -- theres a bug with some version of php5.2 re this

    re users
    - can you do a 'select * from si_users" and post the results here

    cheers

    justin

    SmarterInvoices.com :: Simple Invoices hosting | Kelly.org.au :: Simple Invoices custom development | justin.kelly.org.au
  • rouleroule February 2010

    Hi Justin,

    I think the problems came from php version, my serveur is both on php4 & php5...
    I've installed SI on my mac, with MAMP & it works perfectly, so i'll use it on the local way ;)

    i'll try to update your french translation who's not very correct,

    Congratulation for this perfect soft !!!

  • sbrsbr February 2010

    Great to see it works out, just one thought, when creating the db did you name it as the default name? think its simpleinvoices !?!

  • justinjustin February 2010

    thanks roule for the update!! - and thanks again sbr

    cheers

    justin

    SmarterInvoices.com :: Simple Invoices hosting | Kelly.org.au :: Simple Invoices custom development | justin.kelly.org.au
  • dddddd March 2010

    Hello roule,

    do you use latest version of simple invoices in frenhc ? I've tried it without success (so that's why the translation hasn't evolved as well !)

    thanks
    dd

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Categories