fix_db_theme.sql

-- SQL Script to remove 'premium' theme and reset to default
-- Run this in your database management tool (e.g., phpMyAdmin)

-- 1. Remove the old premium theme from the versions table (Registered Plugins)
DELETE FROM versions 
WHERE product_type = 'plugins.themes' 
AND product = 'premium';

-- 2. Reset all journals using 'premium' to the 'default' theme
UPDATE journal_settings 
SET setting_value = 'default' 
WHERE setting_name = 'themePluginPath' 
AND setting_value = 'premium';

-- 3. (Optional) Reset site-wide theme if set to premium
UPDATE site_settings 
SET setting_value = 'default' 
WHERE setting_name = 'themePluginPath' 
AND setting_value = 'premium';

-- 4. Flush the plugin cache (handled by OJS, but clearing the versions entry forces a reload)
-- You may also need to clear the _cache directory in your OJS installation manually.