Fork me on GitHub

Error reading the database tables in Subjects module  Bottom

  • I already upgrade from 1.5 to 2.0, according to the installation manual included in version 2.0, including the execution of the query:

    Quote

    UPDATE PREFIX_modules
    SET pn_name='subjects', pn_displayname='subjects', pn_directory='subjects'
    WHERE pn_name='Subjects';


    The categories are fine, but when I go to the Subjects link (where the page structure and the pages definitions are) on the Administration section of the module, I get the following error:

    Quote

    Error when making a «select» in the database: SELECT nuke_subcategories.catid, nuke_subcategories.catname, nuke_subcategories.keywords FROM nuke_subcategories ORDER BY nuke_subcategories.catorder


    Of course, I backup and restore the pages folder, and give the 777 CHMOD permission to it.

    The problem is that I have more than 150 HTML pages in the database tables, and also in the server in the pages folder.

    I have the backup of the old Subjects 1.5 database tables, and are already in place in the database, and still the error message displays.

    I hope is a solution for this, or tell me if I did something wrong

    Thanks in advance.

This list is based on users active over the last 60 minutes.