Skip to main content

Migration Guide

Guide for migrating between versions or from other plugins.

Version Migration​

Automatic Migration​

SigmaOrders automatically handles:

  • Config file updates (new options added)
  • Database schema migrations
  • Data preservation

No manual migration needed for most updates.

Manual Steps​

  1. Backup First

    cp -r plugins/SigmaOrders plugins/SigmaOrders.backup

  2. Update Plugin

    • Replace JAR file
    • Start server
    • Plugin migrates automatically

  3. Verify

    • Check console for migration messages
    • Test basic functionality
    • Review new config options

Config Migration​

Automatic Updates​

Config files are automatically updated:

  • New options added with defaults
  • Old options preserved
  • No data loss

Manual Review​

After update, review config for:

  • New options to configure
  • Deprecated options (if any)
  • Recommended settings

Database Migration​

SQLite to MySQL​

  1. Backup SQLite Database

    cp plugins/SigmaOrders/database.db database.db.backup

  2. Configure MySQL

    database:
      type: MYSQL
      mysql:
        host: localhost
        port: 3306
        database: sigma_orders
        username: your_user
        password: your_password

  3. Restart Server

    • Plugin creates MySQL tables
    • Old SQLite file kept as backup

Note: Data migration is not automatic. You may need to export/import data manually or start fresh.

From Other Plugins​

General Migration Steps​

  1. Export Data (if possible)

    • Export orders from old plugin
    • Save in compatible format

  2. Install SigmaOrders

    • Install plugin
    • Configure settings
    • Test functionality

  3. Import Data (if needed)

    • Use API to create orders
    • Or manual recreation

Specific Plugins​

Migration from specific plugins may require custom scripts. Contact support for assistance.

Rollback Procedure​

If migration causes issues:

  1. Stop Server
  2. Restore Backup 
    rm -rf plugins/SigmaOrders
    cp -r plugins/SigmaOrders.backup plugins/SigmaOrders
  3. Restore Database (if needed) 
    cp plugins/SigmaOrders.backup/database.db plugins/SigmaOrders/
  4. Start Server
  5. Report Issue

Testing Migration​

Pre-Migration Testing​

  1. Test on development server first
  2. Verify all functionality works
  3. Check data integrity
  4. Test edge cases

Post-Migration Verification​

  1. Verify orders load correctly
  2. Test order creation
  3. Test delivery system
  4. Test collection system
  5. Verify payments work
  6. Check statistics

Troubleshooting Migration​

Config Issues​

Symptoms: Config errors after update

Solutions:

  1. Check YAML syntax
  2. Restore from backup
  3. Review migration notes
  4. Check console for errors

Database Issues​

Symptoms: Data missing or corrupted

Solutions:

  1. Restore database backup
  2. Check migration logs
  3. Verify database integrity
  4. Contact support if needed

Performance Issues​

Symptoms: Slower after migration

Solutions:

  1. Check new config options
  2. Optimize database
  3. Review cache settings
  4. Consider MySQL if using SQLite