Application Scope
Development progress & changelog
Platform Apps
11 applications — economies, history, maps, AI, crypto, sports, music, movies, religion, food & more
Fixed broken nav links replaced with working Countries page links in all app pages.
Fixed country_data value column reference (value_text not value)
The country_data table uses value_text, not value. Fixed worldeconomies/country.php SQL query and grouping code.
Fixed Unknown column r.category in World Economies country page
The rankings table uses field_name/display_name (not category), value_numeric/value_formatted (not value), and has no total_ranked column. Fixed SQL query and all template references in worldeconomies/country.php.
Fixed collation mismatch in Crypto World countries & index pages
Resolved SQLSTATE[HY000] 1267 Illegal mix of collations error in cryptoworld/countries.php and index.php. Applied COLLATE utf8mb4_unicode_ci on affiliate_data.country_code (general_ci) to match countries.gec_code (unicode_ci). Also fixed in worldeconomies compare.php and rankings.php.
Fixed 3 GDP rankings showing 0 countries due to field_name mismatch between rankings table and sidebar.