Jump to content

5.0.7 CMS Error when edited forum options

By sound

  • Status: Moved to Github

when editing forum options in the acp

got the below in support log

no 'record_id' in that table

SELECT record_id FROM ibf_cms_custom_database_5 AS cms_custom_database_5 WHERE category_id=94

Unknown column 'record_id' in 'SELECT'

query appears to be in movecommets.php

if ( isset( $data['categoryId'] ) )

{

$where = array( Db::i()->in( 'comment_record_id', iterator_to_array( Db::i()->select( 'record_id', "cms_custom_database_{$data['databaseId']}", array( "category_id=?", $data['categoryId'] ) ) ) ) );

}

else

    •

    User Feedback

    Recommended Comments

    Grand Master

    Marc

    Invision Community Team

    Please could you let me know which forum you were editing, and what items you were editing? I can then see if I can replicate this

    Mentor

    sound

    Clients

    hi

    sorry wasn't a forum it was a database, was tweaking the forum/comments setting

    page was

    /admin/?app=cms&module=databases&controller=databases&do=form&id=5

    I hit the Rebuild Comment Counts.

    afterwards the error was showing in the system log

    rest as above

    cheers

    Grand Master

    Marc

    Invision Community Team

    We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. 

    We look forward to further assisting you. 

    Mentor

    sound

    Clients
    (edited)

    my line of thinking is if you just look at that file

    as far as am aware you can see that its calling a non-existent field in the database table

    that right? if it is then that's the issue and that's a bug if not then its not a bug

    do you really need access ?

    Edited by sound

    Grand Master

    Marc

    Invision Community Team

    I am not able to replicate any issues on my end when performing the action you mention

    Mentor

    sound

    Clients

    the field in question is record_id the table is _custom_database_{$data['databaseId']}

    the support log on my site says that there is no such field in that database table

    the databaseschema file in the official cms directory from the latest version direct from invision also says no such field in that database table

    the file movecommets.php says there is such a field and tries to select it but fails

    I may be missing something here, let me know what if I am

    thanks

    Grand Master

    Marc

    Invision Community Team

    I see it, thanks