Import failing with table creation

[joshuaiz]

Hello,

Was really excited to try Studio so I exported a site from LOCAL then tried to import. The import finishes but with an error at trying to create the table for wp_ewwwio_images and not all of the database is imported.

I tried with the EWWW Image Optimizer plugin disabled as well and same issue.

See here:

[2025-12-21T04:57:55.420Z][info][main] Importing /var/folders/6j/q5kj63997t91y3rkzj62f1lc0000gn/T/studio_backupfs0pW2/app/sql/ebethallan_2025-11-17_CLEANED.sql
[2025-12-21T04:57:57.639Z][erro][main] Error during import of /var/folders/6j/q5kj63997t91y3rkzj62f1lc0000gn/T/studio_backupfs0pW2/app/sql/ebethallan_2025-11-17_CLEANED.sql: �[31;1mError:�[0m Could not execute statement: CREATE TABLE `wp_ewwwio_images` (
  `id` bigint UNSIGNED NOT NULL,
  `attachment_id` bigint UNSIGNED DEFAULT NULL,
  `gallery` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `resize` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `path` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `converted` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `image_size` int UNSIGNED DEFAULT NULL,
  `orig_size` int UNSIGNED DEFAULT NULL,
  `backup` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `level` int UNSIGNED DEFAULT NULL,
  `pending` tinyint(1) NOT NULL DEFAULT '0',
  `updates` int UNSIGNED DEFAULT NULL,
  `updated` timestamp NOT NULL DEFAULT (now()) ON UPDATE CURRENT_TIMESTAMP,
  `trace` blob,
  `retrieve` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `resized_width` smallint UNSIGNED DEFAULT NULL,
  `resized_height` smallint UNSIGNED DEFAULT NULL,
  `resize_error` tinyint UNSIGNED DEFAULT NULL,
  `webp_size` int UNSIGNED DEFAULT NULL,
  `webp_error` tinyint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci
[2025-12-21T04:57:59.091Z][erro][main] Error occurred in handler for 'importSite': Error: Database import failed: �[31;1mError:�[0m Could not execute statement: CREATE TABLE `wp_ewwwio_images` (
  `id` bigint UNSIGNED NOT NULL,
  `attachment_id` bigint UNSIGNED DEFAULT NULL,
  `gallery` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `resize` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `path` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `converted` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `image_size` int UNSIGNED DEFAULT NULL,
  `orig_size` int UNSIGNED DEFAULT NULL,
  `backup` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `level` int UNSIGNED DEFAULT NULL,
  `pending` tinyint(1) NOT NULL DEFAULT '0',
  `updates` int UNSIGNED DEFAULT NULL,
  `updated` timestamp NOT NULL DEFAULT (now()) ON UPDATE CURRENT_TIMESTAMP,
  `trace` blob,
  `retrieve` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `resized_width` smallint UNSIGNED DEFAULT NULL,
  `resized_height` smallint UNSIGNED DEFAULT NULL,
  `resize_error` tinyint UNSIGNED DEFAULT NULL,
  `webp_size` int UNSIGNED DEFAULT NULL,
  `webp_error` tinyint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci
    at LocalImporter.importDatabase (/Applications/Studio.app/Contents/Resources/app.asar/dist/main/index.js:14468:17)
    at async LocalImporter.import (/Applications/Studio.app/Contents/Resources/app.asar/dist/main/index.js:14508:9)
    at async importBackup (/Applications/Studio.app/Contents/Resources/app.asar/dist/main/index.js:15923:12)
    at async importSite (/Applications/Studio.app/Contents/Resources/app.asar/dist/main/index.js:17073:20)
    at async Session.<anonymous> (node:electron/js2c/browser_init:2:107107)
[2025-12-21T04:58:08.754Z][info][main] Stopping server with ID f50248a2-7ee3-4469-842d-8bb1d2cd7c68

Would love to get this resolved. Any ideas?

[joshuaiz]

Figured it out. For anyone else:

Do a find/replace in your SQL file for DEFAULT (now()) → DEFAULT CURRENT_TIMESTAMP

There was only the one instance in my db. That solved it.

[wojtekn]

@joshuaiz, thanks for reporting the issue and for sharing the workaround.

I will reopen it, as I believe the query using the DEFAULT (now()) expression should also work, so this appears to be a bug.

I reported it in SQLite plugin repository: WordPress/sqlite-database-integration#300