#305 SQL Error in Aggregate Statistics

data
closed
nobody
reports (24)
5
2004-01-02
2003-06-09
Marc Lovelace
No

Upon viewing the Aggregate Stats for Work Orders or
Tickets grouped by Account, if one clicks on the number
of work orders/tickets link, an SQL error pops up
complaining about no account ID in the workorders table
or the tickets table.

Discussion

  • Logged In: YES
    user_id=6207

    What SQL Server are you running?

     
  • Bilel Remmache
    Bilel Remmache
    2003-07-14

    Logged In: YES
    user_id=820600

    SQL server: MySQL 4.0.13
    OS. : Windows XP
    Web server: Apache 2.0.46
    PHP4

    I get the error:
    Unknown column 'workorders.account_id' in 'where clause'

    In the same situation as described in the original message.
    I checked the columns of the workorders table in MySQL
    (using the command line) and I found out that it doesn't
    contain a field called accound_id.

    I checked the script createdb.sql in the scripts directory
    which I used to create the tables in the database and I didn't
    find this field there as well! This is probably the reason.

     
  • Bilel Remmache
    Bilel Remmache
    2003-07-14

    Logged In: YES
    user_id=820600

    By the way, I am using version 0.9.3 of DCL.

     
    • status: open --> closed
     
  • Logged In: YES
    user_id=6207

    Fixed in CVS