Page 1 of 1

Confused by the Help re extra mysql fields

Posted: Mon Oct 02, 2017 10:09 am
by bburgess
Hi guys ;)

Sorry this has me confused in the help it states:

If you have added custom profile fields to any (or all) of the login objects then you must also create these fields in the database.
Custom profile fields must be named extra1, extra2, extra3 etc!
The following SQL query generates a table with 5 extra custom profile fields:

Code: Select all

CREATE TABLE `USERS` (
`id` int(10) NOT NULL auto_increment,
`username` varchar(50) NOT NULL,
`fullname` varchar(75) NOT NULL,
`password` varchar(50) NOT NULL,
`email` varchar(75) NOT NULL,
`active` tinyint(1) NOT NULL,
`code` varchar(75),
`extra1` varchar(100),
`extra2` varchar(100),
`extra3` varchar(100),
`extra4` varchar(100),
`extra5` varchar(100),
PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1;
Custom profile fields must be named extra1, extra2, extra3 etc! What does that mean please?

Cheers
BB

Re: Confused by the Help re extra mysql fields

Posted: Mon Oct 02, 2017 10:18 am
by Pablo
It means that the database fields and input fields need to be named like this. You cannot pick random names.

Re: Confused by the Help re extra mysql fields

Posted: Mon Oct 02, 2017 10:29 am
by bburgess
Pablo wrote:
Mon Oct 02, 2017 10:18 am
It means that the database fields and input fields need to be named like this. You cannot pick random names.
Thanks Pablo

I thought that is what it meant, but wanted to be sure, is this because its tied in with the PHP?

Cheers
BB

Re: Confused by the Help re extra mysql fields

Posted: Mon Oct 02, 2017 11:05 am
by Pablo
No, it is because all names (database fields, input field, scripts, admin tool) need to match.

Re: Confused by the Help re extra mysql fields

Posted: Mon Oct 02, 2017 11:26 am
by bburgess
Pablo wrote:
Mon Oct 02, 2017 11:05 am
No, it is because all names (database fields, input field, scripts, admin tool) need to match.
Thanks Pablo :) at some stage I will get to go through the tools code and not ask you dumb questions :D

Have a great day!

Cheers
BB