Array
(
    [id] => 1
    [dateCreated] => 1
    [dateModified] => 
    [dateDeleted] => 
    [name] => Test List
    [description] => just testing the initial list
    [hash] => ,s klshs fhjkhskjh ksfkj sdfkjhsdf sdf 
    [defaultAddLocation] => 1
    [defaultUseLocation] => 1
)

Array
(
    [0] => Array
        (
            [id] => 1
            [name] => cat 1
            [description] => test category 1
            [image] => 
        )

    [1] => Array
        (
            [id] => 2
            [name] => cat 2
            [description] => test category 2
            [image] => icon2.png
        )

)

Array
(
    [0] => Array
        (
            [id] => 1
            [name] => Upstairs
            [description] => main inventory stock
        )

    [1] => Array
        (
            [id] => 2
            [name] => Downstairs
            [description] => Excess inventory
        )

)

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM item WHERE dateDeleted IS NULL AND parentID = '1'' at line 1