Simple Invoices logo
    • CommentAuthorimteddy
    • CommentTimeMar 4th 2008 edited
     permalink
    Hi,

    I've just installed and it works great.

    but I found following errors when some pages tries to display custom fields.


    Dude, what happened to your query?:

    SELECT * FROM si_customFields WHERE categorieID = 3;
    Table 'bambooinvoice.si_customFields' doesn't exist
    Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/demo/simpleinvoices/include/smarty/plugins/function.showCustomFields.php on line 21

    Above error occured from Product -> Manage Products -> Edit page.

    I found there is no table named customFields in db schema.

    Missing customFields table in db schema?
    • CommentAuthorjustin
    • CommentTimeMar 4th 2008 edited
     permalink
    hey imteddy,

    thanks for pointing this out - i can reproduce the error
    customFields is a new (and still unfinished) replacement for our current custom fields system

    a fix for this is to edit ./templates/default/products/details.tpl

    and delete line 41 and 89
    {showCustomFields categorieId="3" itemId=$smarty.get.id }

    let me know if you can find anymore bugs

    cheers

    justin
    • CommentAuthorjustin
    • CommentTimeMar 9th 2008 edited
     permalink
    Hey imteddy,

    just did a new release of Simple Invoices which fixes this problem

    https://sourceforge.net/project/showfiles.php?group_id=164303

    Cheers

    Justin