NEXORA STORE — Product Save / Emoji Unicode FIX (2026-10-21)
==========================================================

PROBLEM
The Add Product form returns: "Product was NOT saved" with an incorrect string/emoji value message.
MySQL connection uses utf8mb4, but one or more existing database table/column collations use latin1 or utf8mb3.
This can happen even if Shop Button Emoji is blank because Description, Instructions or other text fields may contain Unicode.

OPTION 1 — ADMIN PANEL (PREFERRED)
1. Back up the full live MySQL database. You can use your cPanel backup/phpMyAdmin export.
2. Upload this version of the bot, keeping your own config and live database.
3. Sign in as the SUPER ADMIN.
4. Go to /admin/emoji_database_fix.php OR use the "Fix Database Emoji Support" button inside Add Product's red error banner.
5. Review the table collations. Tick "I backed up my MySQL database", type FIX, click Repair.
6. Wait for the success status, then return to Add Product and try again.

OPTION 2 — PHPMYADMIN
1. Back up your database (Export > SQL).
2. Select the existing bot database (NOT a new blank database).
3. Open SQL > paste/run migrations/2026_10_21_product_utf8mb4_repair.sql
4. If a table doesn't exist, skip ONLY that corresponding ALTER TABLE line.
5. Verify collation of products.name, products.full_description, products.instructions, and settings.setting_value.
6. Retry adding product.

IMPORTANT
- DO NOT import database.sql into an existing production DB. It is for new installations.
- The migration does not delete products, users, orders, or wallet balances.
- This package keeps the existing Shop buttons, pricing format, Developer API, Docs and broadcast flows unchanged.
- If your host refuses ALTER TABLE or says index too long, contact hosting support and provide the table/column names, not passwords.
- PHP lint is not a live database test. Host must perform the migration for the error to disappear.
- Rotate credentials stored in your config.php and admin defaults when deploying.
