Dude, what happened to your query?
  • veisisveisis June 2009

    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

  • justinjustin June 2009

    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

    justin

    SmarterInvoices.com :: Simple Invoices hosting | Kelly.org.au :: Simple Invoices custom development | justin.kelly.org.au
  • veisisveisis June 2009

    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.

Add a Comment

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