Simple Invoices logo
HOME | DOWNLOAD | BLOG | FORUM | DEMO
Not signed in (Sign In)

Support: Dude, what happened to your query?

Bottom of Page

1 to 3 of 3

  1.  
    • CommentAuthorveisis
    • CommentTimeJun 28th 2009
     permalink
    Dude, what happened to your query?:

    SELECT l.*, u.user_name FROM si_log l INNER JOIN si_users u ON (u.user_id = l.userid) WHERE l.timestamp BETWEEN :start AND :end ORDER BY l.timestamp

    Table 'simple_invoices.si_users' doesn't exist

    this is what i get in database log.

    installed version simpleinvoices.2009.1.beta4-3
    • CommentAuthorjustin
    • CommentTimeJun 28th 2009
     permalink
    hey veisis

    - is there a specific page you are getting this error?
    - did you upgrade Simple Invoices from a previous version to 2009.1 beta 4?
    - etc.. if you could post some more details it would be appreciated

    cheers

    justinSmarterInvoices.com Simple Invoices hosting :: SixHQ.com Simple Invoices custom development
    • CommentAuthorveisis
    • CommentTimeJun 29th 2009
     permalink
    1. I found it in page "index.php?module=reports&view=database_log".
    "index.php?module=reports&view=report_debtors_owing_by_customer" and this site also contains an error but I saw only the

    following message: "OOOOPS, THERE'S AN ERROR HERE. There's an error on your SQL query. This error message was generated by

    phpReports."

    2. fresh installed copy of simpleinvoices.2009.1.beta4-3.

    3. I took a small investigation and found that this query is written for simpleinvoices_20080629. This query can be found in

    modules\reports\database_log.php line 16 to 20.

    Some off topic
    And why do you use so many decimal places in database for example in table si_invoice_items column unit_price (there are six

    but only two are needed)?

    P.S.

    Sorry for my bad language.

1 to 3 of 3

  1.