Publisher does not support the Fluid field type. Please do not contact asking when support will be available.

If you purchased an add-on from expressionengine.com, be sure to visit boldminded.com/claim to add the license to your account here on boldminded.com.

Ticket: Mysql error and other while trying to open preferences to add licence number etc

Status	Resolved
Add-on / Version	DataGrab 5.2.1
Severity
EE Version	6.4.16

Martijn Broeders

Mar 19, 2024


SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'field list':
SELECT `id`, `name`, `description`, `passkey`, `status`, `last_record`, `total_records`, `total_delete_records`, `last_delete_record`, `last_run`, `settings`, `order` FROM (`exp_datagrab`) WHERE `site_id` = 1 ORDER BY `order` ASC, `name` ASC

ee/legacy/database/drivers/mysqli/mysqli_connection.php:114
Stack Trace: Please include when reporting this error

    #0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(112): CI_DB_mysqli_connection->query()
    #1 ee/legacy/database/DB_driver.php(261): CI_DB_mysqli_driver->_execute()
    #2 ee/legacy/database/DB_driver.php(176): CI_DB_driver->simple_query()
    #3 ee/legacy/database/DB_active_rec.php(1083): CI_DB_driver->query()
    #4 user/addons/datagrab/mcp.datagrab.php(136): CI_DB_active_record->get()
    #5 [internal function]: Datagrab_mcp->index()
    #6 ee/ExpressionEngine/Controller/Addons/Addons.php(1533): call_user_func_array()
    #7 ee/ExpressionEngine/Controller/Addons/Addons.php(811): ExpressionEngine\Controller\Addons\Addons->getModuleSettings()
    #8 [internal function]: ExpressionEngine\Controller\Addons\Addons->settings()
    #9 ee/ExpressionEngine/Core/Core.php(266): call_user_func_array()
    #10 ee/ExpressionEngine/Core/Core.php(122): ExpressionEngine\Core\Core->runController()
    #11 ee/ExpressionEngine/Boot/boot.php(161): ExpressionEngine\Core\Core->run()
    #12 admin.php(153): require_once('...')
    #12 admin.php(153): require_once('...')

Environment Details: - Version: 5.2.1 - PHP Version: 7.4 - MySQL Version MariaDB 10.3 - OS: macOS 10.14 - Web Server: Apache 2.4

BoldMinded (Brian)

Hi, Martijn. Did you click the upgrade button?

BoldMinded (Brian)

Was this an upgrade from an existing install or a new install? It sounds like it might not have installed correctly. Try uninstalling and reinstalling.

BoldMinded (Brian)

Update: sounds like it was fixed with an uninstall and reinstall, and some artifacts from the old Ajw version still present. Closing ticket.