No Database Selected
  • January 1970 Edit

    Just Installed 20070929 beta
    Following error when trying to access Simple invoices.

    Dude, what happened to your query?:

    SELECT value from si_system_defaults s WHERE ( s.name = 'language')
    No database selectedNo database selected

    What am i doing wrong? lol

  • justinjustin October 2007

    Hey SpaceGoat

    most likely is that Simple Invoices cant connect to the db

    check config/config.php and make sure that database information is correct

    Cheers

    Justin

    SmarterInvoices.com :: Simple Invoices hosting | Kelly.org.au :: Simple Invoices custom development | justin.kelly.org.au
  • SpaceGoatSpaceGoat October 2007

    Hi Justin,

    I have that fixed... db was all ok but i had edited more than need be in the config file.
    I have come across a few other problems.
    Firstly i have installed everything and followed all instructions however i can't export to PDF it exports nothing... a blank PDF .... also word document is all over the place and has no formatting.
    The other issue is when i click on New invoice - Consulting it says that there are no Billers, Customers and no Invoice Pref's the others work fine but that one does not?
    I am also unable to add a biller, it says that there was some problem. I can't edit the ones there either so i have been manually editing it in the database using MySql.

    Any ideas on these probs?

    Cheers

  • justinjustin October 2007

    Hey

    re pdf
    - does the demo paeg work where you can attempt to pdf google.com?
    ?
    re add biller
    refer: http://simpleinvoices.org/forum/topic.php?id=338 - you might have a similar issue

    re New Invoice - Consulting
    - does this error occur in the other invoice types?

    please details
    - server os
    - php/apache/mysql versions
    - etc..

    Cheers

    Justin

    SmarterInvoices.com :: Simple Invoices hosting | Kelly.org.au :: Simple Invoices custom development | justin.kelly.org.au
  • SpaceGoatSpaceGoat October 2007

    Hi Justin,

    re Add Biller - That did not sole the problem.

    re pdf - Demo works fine

    re New invoice - consulting - The others work fine

    Details:

    Server: Linux Apache/1.3.39
    PHP: 5.2.0
    MySql: 5.0.27-standard

  • justinjustin October 2007

    Hey

    question: did you change the db_prefix in config.php?

    re word document
    - yep - the export is very basic - theres no special formatting for word etc - it just dumps html in a .doc file and lets word sort it out

    re pdf
    - only thing i can think of is some permissions issues
    - try chmod -Rv 777 * in the simple invoices dir
    -- yes i know thats a security issue - just want to see if it works

    Cheers

    Justin

    SmarterInvoices.com :: Simple Invoices hosting | Kelly.org.au :: Simple Invoices custom development | justin.kelly.org.au

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