If you are getting the "Unknown column 'bsky_app' in 'field list" error in Kunena, here is the fix.
Also, here is the sql code to run from the video:
ALTER TABLE `#__kunena_users` ADD `bsky_app` VARCHAR(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `reddit`;
This is the forum post the fix was found in ► https://www.kunena.org/forum/k6-3-0-support-archive/168423-error-when-editing-user-profile#231258
#kunena_users #joomla #basicjoomla
00:00 - Introduction and Sponsored Message
00:30 - Identifying the Error
00:35 - Searching for a Solution
00:50 - Preparing to Run the SQL Code
01:13 - Modifying the SQL Code for Your Database
01:35 - Running the SQL Code
01:50 - Verifying the Fix
02:00 - Conclusion
Summary
Introduction: The video starts with a sponsored message from CyberSalt's Joomla training and mysites.guru.
Error Identification: The presenter encounters an error when trying to save a user profile in the Kunena Forum backend: "Unknown column 'bsky app' in 'field list'".
Solution Search: Upon researching, it is identified that running a specific SQL code can fix the issue.
Copying the Code: The presenter shows the SQL code needed to fix the error, which will be shared in the Joomla training cohort and the video description.
Accessing PHPMyAdmin: Instructions are given to log into your web host's control panel and access PHPMyAdmin.
Selecting the Database: Choose the database associated with your Joomla site.
SQL Tab: Navigate to the SQL tab within PHPMyAdmin.
Modifying the SQL Code: Change the database prefix in the SQL code to match your Joomla site's prefix. The presenter’s prefix is 'j6wa'.
Running the SQL Code: Execute the modified SQL code by clicking 'Go'.
Verification: After running the SQL code, return to the Joomla backend, save the user profile again, and confirm that the error is resolved.
Please send any feedback or bug reports or queries to;
Contact Tim Davis ►
Joomla Training Cohort ► https://cybersalt.com/jtc
Add comment