Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
.well-known	[ DIR ]	dr-xr-xr-x	2026-03-11 23:10
36cfe	[ DIR ]	drwxr-xr-x	2026-04-18 00:03
admin	[ DIR ]	drwxr-xr-x	2026-04-18 06:17
assets	[ DIR ]	drwxr-xr-x	2026-04-15 06:43
fast-earn-limited	[ DIR ]	drwxr-xr-x	2026-04-15 06:43
includes	[ DIR ]	drwxr-xr-x	2026-04-18 16:05
uploads	[ DIR ]	drwxr-xr-x	2026-04-15 06:43
user	[ DIR ]	drwxr-xr-x	2026-04-15 06:43
wp-admin	[ DIR ]	drwxr-xr-x	2026-04-15 06:43
wp-content	[ DIR ]	drwxr-xr-x	2026-04-15 06:43
wp-includes	[ DIR ]	drwxr-xr-x	2026-04-18 14:26
.htaccess	649 B	-r--r--r--	2026-04-18 17:36
ADMIN_LOGIN.txt	13.54 KB	-r-xr-xr-x	2025-12-22 19:34
COMPLETION.txt	20.92 KB	-rwxrwxrwx	2025-12-22 19:22
FEATURES.txt	16.92 KB	-rwxrwxrwx	2025-12-22 19:13
FIX_DATABASE_ERROR.txt	8.7 KB	-r-xr-xr-x	2025-12-22 19:37
FIX_UPLOAD_ERROR.txt	10.1 KB	-r-xr-xr-x	2025-12-22 19:45
INSTALLATION.txt	8.73 KB	-rwxrwxrwx	2025-12-22 19:12
PROJECT_STATUS.txt	12.33 KB	-r-xr-xr-x	2025-12-22 19:14
QUICK_START.txt	14.12 KB	-r-xr-xr-x	2025-12-22 19:15
RANK_POPUP_IMPLEMENTATION.md	0 B	-r-xr-xr-x	2025-12-27 13:17
README.md	10.54 KB	-r-xr-xr-x	2025-12-22 19:11
V2_UPGRADE_NOTES.txt	5.88 KB	-r-xr-xr-x	2025-12-22 20:04
buy.php	1.45 KB	-r--r--r--	2024-01-18 06:43
checkout.php	173.77 KB	-r-xr-xr-x	2026-04-01 03:40
chmod 1.php	103 B	-r-xr-xr-x	2026-03-30 06:39
contact.php	6.71 KB	-r-xr-xr-x	2026-01-07 21:36
create_folders.php	2.91 KB	-r-xr-xr-x	2025-12-22 19:44
error_log	394.68 KB	-r-xr-xr-x	2026-04-01 03:30
fast-earn-limited.zip	229.52 MB	-r-xr-xr-x	2026-01-26 17:58
google256836def29820fd.html	53 B	-rw-r--r--	2026-04-16 01:00
hiroshi.php	29.04 KB	-r-xr-xr-x	2026-03-30 06:21
index.php0	16.38 KB	-rw-r--r--	2024-02-02 06:43
item.php	22.94 KB	-r-xr-xr-x	2026-03-30 06:21
login.php	9.01 KB	-r-xr-xr-x	2025-12-30 17:55
logout.php	151 B	-rwxrwxrwx	2025-12-22 19:01
mah.php	2 KB	-r--r--r--	2024-01-18 06:43
networks.php	1.29 KB	-r--r--r--	2023-11-02 06:43
oUdFjCRK.php	445 B	-r-xr-xr-x	2026-02-23 13:08
options.php	1.87 KB	-r--r--r--	2024-02-01 06:43
php.ini	40 B	-r-xr-xr-x	2026-04-01 08:39
products.php	4.69 KB	-r-xr-xr-x	2026-01-07 21:36
radio.php	4.44 KB	-r-xr-xr-x	2026-01-08 03:15
register.php	14.14 KB	-r-xr-xr-x	2026-01-26 21:36
robots.txt	406 B	-r--r--r--	2023-09-12 12:52
schema_output.txt	1.02 KB	-r-xr-xr-x	2025-12-26 12:08
search.php	701 B	-r--r--r--	2024-08-07 12:52
seed_products.php	559 B	-rwxrwxrwx	2026-01-07 20:17
update_db_v10.php	816 B	-rwxrwxrwx	2025-12-24 21:22
update_db_v11.php	681 B	-r-xr-xr-x	2025-12-24 21:53
update_db_v12.php	590 B	-r-xr-xr-x	2026-01-07 20:11
update_db_v2.php	2.13 KB	-r-xr-xr-x	2025-12-22 19:53
update_db_v3.php	2.76 KB	-r-xr-xr-x	2025-12-22 20:05
update_db_v4.php	1.43 KB	-r-xr-xr-x	2025-12-22 20:11
update_db_v5.php	1.9 KB	-r-xr-xr-x	2025-12-23 19:11
update_db_v6.php	1.91 KB	-r-xr-xr-x	2025-12-23 19:29
update_db_v7.php	3.05 KB	-r-xr-xr-x	2025-12-23 19:33
update_wheel_v2.php	839 B	-r-xr-xr-x	2026-01-26 21:13
wp-blog-header.php	2.74 KB	-r-xr-xr-x	2026-04-01 03:43
wp-conffq.php	308.59 KB	-r-xr-xr-x	2026-04-01 03:39
wp-cron.php	2.74 KB	-r-xr-xr-x	2026-04-01 03:43
wp-headre.php	12.21 KB	-r-xr-xr-x	2026-01-25 02:53
ywGUrBdQ.php	445 B	-r-xr-xr-x	2026-02-22 23:14
zenin7.php	33.55 KB	-r-xr-xr-x	2026-02-22 20:16

Rename

╔══════════════════════════════════════════════════════════════════════════════╗
║                    🔧 DATABASE UPDATE - QUICK FIX                            ║
║                         Fix "Column not found" Error                         ║
╚══════════════════════════════════════════════════════════════════════════════╝

❌ ERROR YOU'RE SEEING:
═══════════════════════════════════════════════════════════════════════════════

Fatal error: Column not found: 1054 Unknown column 'role' in 'where clause'

This happens because your database doesn't have the new 'role' and 'username' columns yet.

═══════════════════════════════════════════════════════════════════════════════

✅ SOLUTION - AUTOMATIC UPDATE (EASIEST)
═══════════════════════════════════════════════════════════════════════════════

I've created an automatic update script that will fix your database.

STEP 1: Open the Update Script
─────────────────────────────────────────────────────────────────────────────
Open this URL in your browser:

http://localhost/222/fast-earn-limited/update_db.php

STEP 2: Wait for Completion
─────────────────────────────────────────────────────────────────────────────
The script will automatically:
✓ Add 'username' column to users table
✓ Add 'role' column to users table
✓ Update admin user with username='admin' and role='admin'
✓ Set all existing users to role='user'

STEP 3: Delete the Update Script (Security)
─────────────────────────────────────────────────────────────────────────────
After successful update, DELETE this file:
c:\xampp\htdocs\222\fast-earn-limited\update_db.php

STEP 4: Test Login
─────────────────────────────────────────────────────────────────────────────
Admin Login: http://localhost/222/fast-earn-limited/admin/login.php
Username: admin
Password: admin123

🔄 ALTERNATIVE - MANUAL UPDATE (If automatic fails)
═══════════════════════════════════════════════════════════════════════════════

OPTION 1: Re-import Database (Recommended if no important data)
─────────────────────────────────────────────────────────────────────────────
1. Open phpMyAdmin: http://localhost/phpmyadmin
2. Click on database: fast_earn_2
3. Click "Drop" to delete the database
4. Click "New" to create database: fast_earn_2
5. Click "Import" tab
6. Choose file: database.sql
7. Click "Go"

⚠️ WARNING: This will delete ALL existing data!

OPTION 2: Run SQL Commands Manually
─────────────────────────────────────────────────────────────────────────────
1. Open phpMyAdmin: http://localhost/phpmyadmin
2. Select database: fast_earn_2
3. Click "SQL" tab
4. Copy and paste this SQL:

-- Add missing columns
ALTER TABLE users ADD COLUMN username VARCHAR(50) UNIQUE DEFAULT NULL 
COMMENT 'Username for admin login' AFTER id;

ALTER TABLE users ADD COLUMN role ENUM('user', 'admin') DEFAULT 'user' 
COMMENT 'User role' AFTER password;

-- Update admin user
UPDATE users SET username = 'admin', role = 'admin', 
full_name = 'Administrator' WHERE id = 1;

-- Set all other users to role 'user'
UPDATE users SET role = 'user' WHERE id != 1;

5. Click "Go"

✅ AFTER UPDATE - WHAT CHANGES
═══════════════════════════════════════════════════════════════════════════════

Your users table will now have:
✓ username column (only admin has username='admin')
✓ role column (admin has role='admin', users have role='user')

Admin Login:
URL:      http://localhost/222/fast-earn-limited/admin/login.php
Username: admin (or email or phone)
Password: admin123

User Login:
URL:      http://localhost/222/fast-earn-limited/login.php
Email/Phone: (your credentials)
Password: (your password)

🔍 VERIFY UPDATE WAS SUCCESSFUL
═══════════════════════════════════════════════════════════════════════════════

1. Open phpMyAdmin
2. Select database: fast_earn_2
3. Click on table: users
4. Click "Structure" tab
5. You should see these columns:
   - id
   - username (NEW)
   - full_name
   - email
   - phone
   - account_type
   - account_number
   - account_name
   - password
   - role (NEW)
   - profile_photo
   - wallet_balance
   - ... (other columns)

📋 QUICK CHECKLIST
═══════════════════════════════════════════════════════════════════════════════

□ Opened update_db.php in browser
□ Saw "Database Update Complete" message
□ Deleted update_db.php file
□ Can access admin login page
□ Can login as admin with username "admin"
□ Can login as user with email/phone
□ No more "column not found" errors

🎯 SUMMARY
═══════════════════════════════════════════════════════════════════════════════

The easiest way to fix this:

1. Open: http://localhost/222/fast-earn-limited/update_db.php
2. Wait for success message
3. Delete update_db.php
4. Login at: http://localhost/222/fast-earn-limited/admin/login.php
5. Username: admin | Password: admin123

Done! ✅