Your username here MUST MATCH your XenForo username (connected to your XF license).

    Once you have registered here, then you need to start a conversation at xenforo.com w/Bob and provide the following:
    1. Your XenForo License Validation Token
    2. The Domain Name associated with the License
    NOTE: Your account will be validated once ALL requirements are verified/met. Thank you for your patience.

Error when deleting an item

Discussion in 'Showcase Support' started by ibaker, Sep 19, 2016.

  1. ibaker

    ibaker Member AMS Showcase Pickem

    Using v2.6.4 I get the following error when trying to delete an item:

    Error Info

    Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'item_id' in 'where clause' - library\Zend\Db\Statement\Mysqli.php:77
    Generated By: Admin, A moment ago
    Stack Trace
    #0 C:\xampp\htdocs\rfcom\library\Zend\Db\Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('DELETE FROM `xf...')
    #1 C:\xampp\htdocs\rfcom\library\Zend\Db\Adapter\Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'DELETE FROM `xf...')
    #2 C:\xampp\htdocs\rfcom\library\Zend\Db\Adapter\Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('DELETE FROM `xf...')
    #3 C:\xampp\htdocs\rfcom\library\Zend\Db\Adapter\Abstract.php(661): Zend_Db_Adapter_Abstract->query('DELETE FROM `xf...')
    #4 C:\xampp\htdocs\rfcom\library\NFLJ\Showcase\DataWriter\Item.php(948): Zend_Db_Adapter_Abstract->delete('xf_nflj_showcas...', 'item_id = 14')
    #5 C:\xampp\htdocs\rfcom\library\XenForo\DataWriter.php(1793): NFLJ_Showcase_DataWriter_Item->_postDelete()
    #6 C:\xampp\htdocs\rfcom\library\NFLJ\Showcase\ControllerPublic\Showcase.php(2414): XenForo_DataWriter->delete()
    #7 C:\xampp\htdocs\rfcom\library\XenForo\FrontController.php(351): NFLJ_Showcase_ControllerPublic_Showcase->actionDelete()
    #8 C:\xampp\htdocs\rfcom\library\XenForo\FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #9 C:\xampp\htdocs\rfcom\index.php(13): XenForo_FrontController->run()
    #10 {main}
    Request State
    array(3) {
    ["url"] => string(49) "http://localhost/rfcom/aircraft/25-0032.14/delete"
    ["_GET"] => array(0) {
    ["_POST"] => array(3) {
    ["hard_delete"] => string(1) "1"
    ["_xfConfirm"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
  2. Bob

    Bob Developer Staff Member

    The table involved has a column named item_id, so if that is missing from that table, its going to throw that error. Can I get access to your DB to check the showcase tables to make sure they have ALL of the correct fields.
  3. ibaker

    ibaker Member AMS Showcase Pickem

    Thanks Bob, I had a similar problem that when upgrading from a real old version back in Feb and you had to manually adjust tables and fields etc...sounds like there is a lingering problem from old days when the mod was first released.

    There is only a few entries in it so I will just dump the whole thing, ensure db is clear of all mod tables and reinstall and start fresh with it...I have a different objective for the mod now anyway...thanks
  4. Bob

    Bob Developer Staff Member

    I don't mind checking things out (I rather enjoy it actually) :) You can hit me up in Private (conversation) any time and I will check things out for you to make sure everything is OK. I do it all the time for license holders that just want a piece of mind (addon "audit" if you will).
  5. ibaker

    ibaker Member AMS Showcase Pickem

    aaargh, just hit the uninstall...but as always, thanks Bob for your unparalleled support and assistance.

    Incidentally, I am creating a spin off site for Off Topic and will be getting a couple more of your addons for that
    Bob likes this.
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.