Firstly to answer your main question following is how joomla treats user data.
1. Joomla sees user data as one single task. So all fields are displayed in registration page.
2. Each component or plug-in extends this task and stores information separately in their own tables.
3. If standard joomla fields are used then they are stored in "_users" table.
4. If K2 fields are used then they are stored in "k2_users" table
5. If User Profile Plug-in fields are used then they are stored in "user_profiles" table.
Currently these are caused by bugs which are reported for joomla 3.1.1. Fixes are from joomla bug tracker and as a side note only 1 user has reported that some of his/her users received an emails where it is supposed to be for administrators only. So keep an eye for that please. Perhaps create a normal test user with a separate email account and check it.
For other users this is related to following topic or if you are using joomla 3.1.1 and have problems with registration.
https://www.gavick.com/forums/game-maga ... 26929.htmlThere were bugs in joomla 3.1.1 where they caused following errors.
1. After clicking register button you had a blank page with no error although submission goes through and data gets stored in database.
2. Your additional fields are coming from User Profile Plug-in which is a Joomla Core plug-in. This plug-in did not store any data due to a bug in code.
Following are fixes for above mentioned bugs.
File: components/com_users/models/registration.php
Line: 105-111 which is below
- Code: Select all
// get all admin users
$query = $db->getQuery(true);
$query->select($db->quoteName(array('name', 'email', 'sendEmail', 'id')))
->from($db->quoteName('#__users')
->where($db->quoteName('sendEmail') . ' = ' . 1));
$db->setQuery($query);
Replaced with below
- Code: Select all
// get all admin users
$query = $db->getQuery(true);
$query->select($db->quoteName(array('name', 'email', 'sendEmail', 'id')))
->from($db->quoteName('#__users'))
->where($db->quoteName('sendEmail') . ' = ' . 1);
$db->setQuery($query);
Line: 517 - 523 which is below.
- Code: Select all
// Get all admin users
$query = $db->getQuery(true);
$query->select($db->quoteName(array('name', 'email', 'sendEmail')))
->from($db->quoteName('#__users')
->where($db->quoteName('sendEmail') . ' = ' . 1));
$db->setQuery($query);
Replaced with below
- Code: Select all
// Get all admin users
$query = $db->getQuery(true);
$query->select($db->quoteName(array('name', 'email', 'sendEmail')))
->from($db->quoteName('#__users'))
->where($db->quoteName('sendEmail') . ' = ' . 1);
$db->setQuery($query);
File: plugins/user/profile/profile.php
Line: 340 which is below
- Code: Select all
->where($db->quoteName('userid') . ' = ' . (int) $userId)
Replaced with below
- Code: Select all
->where($db->quoteName('user_id') . ' = ' . (int) $userId)
I have renamed your edited file:
/templates/gk_game_magazine/html/com_k2/templates/register.php to "register_previous_norman.php" while testing/checking and reuploaded a fresh untouched copy from template download. So current register.php is a default one.
If you want your edited file simply delete current register.php and rename "register_previous_norman.php" back to "register.php".
I have disabled certain fields in User Profile Plugin. If you want them please re-enable them in plugin settings.
Joomla Admin > Extensions > Plug-in Manager > User Profile Plugin.
I have also enabled error logs in your CPanel which will be active for 24 hours and then disable itself for debugging purposes.
See you around...