I have downloaded the master_2019.2.1 and when I load it tells me to update the database. When I do it after a few second I get this error:
SqlPatchManager::runSqlPatch() error. See error log for more information.
in php.log I see this:
/var/www/html/tmp/log # cat php.log
[25-Sep-2019 09:42:39 Europe/London] PdoDb - debugger(): ALTER TABLE <code>si_invoice_item_attachments</code> DROP INDEX <code>id</code>;ALTER TABLE <code>si_products_attributes</code> MODIFY <code>type_id</code> INT(11) UNSIGNED NULL;
[25-Sep-2019 09:42:39 Europe/London] PdoDb - query(): Execute error.Array
(
[0] => 42000
[1] => 1091
[2] => Can't DROP INDEX <code>id</code>; check that it exists
)
[25-Sep-2019 09:42:39 Europe/London] PdoDb - backtrace: Array
(
[0] => Array
(
[file] => /var/www/html/Inc/Claz/SqlPatchManager.php
[line] => 241
[function] => query
[class] => Inc\Claz\PdoDb
[object] => Inc\Claz\PdoDb Object
(
[caseStmts:Inc\Claz\PdoDb:private] =>
[debug:Inc\Claz\PdoDb:private] =>
[debug_label:Inc\Claz\PdoDb:private] =>
[debug_microtime:Inc\Claz\PdoDb:private] => 0
[distinct:Inc\Claz\PdoDb:private] =>
[excludedFields:Inc\Claz\PdoDb:private] => Array
(
)
[fauxPost:Inc\Claz\PdoDb:private] =>
[fieldPrefix:Inc\Claz\PdoDb:private] =>
[functions:Inc\Claz\PdoDb:private] =>
[groupBy:Inc\Claz\PdoDb:private] =>
[havings:Inc\Claz\PdoDb:private] =>
[joinStmts:Inc\Claz\PdoDb:private] =>
[keyPairs:Inc\Claz\PdoDb:private] =>
[lastCommand:Inc\Claz\PdoDb:private] =>
[limit:Inc\Claz\PdoDb:private] => 0
[noErrorLog:Inc\Claz\PdoDb:private] =>
[onDuplicateKey:Inc\Claz\PdoDb:private] =>
[orderBy:Inc\Claz\PdoDb:private] =>
[pdoDb:Inc\Claz\PdoDb:private] => PDO Object
(
)
[pdoDb2:Inc\Claz\PdoDb:private] => PDO Object
(
)
[saveLastCommand:Inc\Claz\PdoDb:private] =>
[selectAll:Inc\Claz\PdoDb:private] =>
[selectList:Inc\Claz\PdoDb:private] =>
[selectStmts:Inc\Claz\PdoDb:private] =>
[table_columns:Inc\Claz\PdoDb:private] =>
[table_constraints:Inc\Claz\PdoDb:private] =>
[table_engine:Inc\Claz\PdoDb:private] => InnoDB
[table_schema:Inc\Claz\PdoDb:private] => fear_invoices
[transaction:Inc\Claz\PdoDb:private] => 1
[usePost:Inc\Claz\PdoDb:private] => 1
[whereClause:Inc\Claz\PdoDb:private] =>
)
[type] => ->
[args] => Array
(
[0] => ALTER TABLE <code>si_invoice_item_attachments</code> DROP INDEX <code>id</code>;ALTER TABLE <code>si_products_attributes</code> MODIFY <code>type_id</code> INT(11) UNSIGNED NULL;
)
)
[1] => Array
(
[file] => /var/www/html/Inc/Claz/SqlPatchManager.php
[line] => 314
[function] => runSqlPatch
[class] => Inc\Claz\SqlPatchManager
[type] => ::
[args] => Array
(
[0] => 308
[1] => Array
(
[name] => Remove dup id key from invoice_item_attachments and fix products_attributes type_id data type
[patch] => ALTER TABLE <code>si_invoice_item_attachments</code> DROP INDEX <code>id</code>;ALTER TABLE <code>si_products_attributes</code> MODIFY <code>type_id</code> INT(11) UNSIGNED NULL;
[date] => 20190329
[source] => fearless359
)
)
)
[2] => Array
(
[file] => /var/www/html/index.php
[line] => 183
[function] => runPatches
[class] => Inc\Claz\SqlPatchManager
[type] => ::
[args] => Array
(
)
)
)
[25-Sep-2019 09:42:39 Europe/London] SqlPatchManager::runSqlPatch() - PdoDb - query(): Execute error. See error_log.Whis other logs should I be looking at? si.log is empty
Recent Comments