I accidentally deleted 'dateofbirth' field and I see some vague directions on adding it back but I am a real noob and I need
step by step instructions. I'm trying to do it in phpMyAdmin and can't figure it out.
I accidentally deleted 'dateofbirth' field and I see some vague directions on adding it back but I am a real noob and I need step by step instructions. I'm trying to do it in phpMyAdmin and can't figure it out. |
Note: Backup your database first!
In phpMyAdmin, under the SQL tab, enter:
INSERT INTO `sys_profile_fields` VALUES(13, 'DateOfBirth', 'date', NULL, '', 18, 75, '', 'LKey', '', 0, '', 1, 1, 0, 20, 2, 20, 2, 20, 2, 17, 4, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 20, 3, 20, 3, 17, 3, 13, 0);
And then clear Dolphin's cache. BoonEx Certified Host: Zarconia.net - Fully Supported Shared and Dedicated for Dolphin |
As I said I'm a real noob....I clicked on MyPhpAdmin, then I clicked SQL, when I pasted: INSERT INTO `sys_profile_fields` VALUES(13, 'DateOfBirth', 'date', NULL, '', 18, 75, '', 'LKey', '', 0, '', 1, 1, 0, 20, 2, 20, 2, 20, 2, 17, 4, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 20, 3, 20, 3, 17, 3, 13, 0); Error came back with: #1046 - No database selected I'm not sure which database to select, I really need step by step Thanks |
First click on the database (from the list on the left) and then click on the SQL tab. Your Dolphin database name is in /inc/header.inc.php.
If you're still having troubles, feel free to PM me your information, and I'll take a look. BoonEx Certified Host: Zarconia.net - Fully Supported Shared and Dedicated for Dolphin |
Please read first message also. PS: I also tried clicking on sys_profile_fields and under SQL the following text is already there: (I didn't want to replace that with the script line you gave me)
SELECT * FROM `sys_profile_fields` WHERE 1 |
the list on left is as follows
[Removed] |
The database name is in /inc/header.inc.php - the /inc directory is under the main directory for Dolphin. Look in the file and find the database name line (around the middle of the file). That's the name of the database.
Yes, just replace the text in there with the SQL query I posted. If you're still running into difficulties, I can take a look. BoonEx Certified Host: Zarconia.net - Fully Supported Shared and Dedicated for Dolphin |
Under PhpMyAdmin I can't find /inc/header.inc.php Under file manager I found /inc/header.inc.php but don't know how to put the string in you gave me because under file manager there is no place to pick SQL and yes you can take a look...what information do you need? |
/inc is a directory for Dolphin. It would be under your site files.
To take a look, I'll need control panel access for your hosting (usually cPanel). BoonEx Certified Host: Zarconia.net - Fully Supported Shared and Dedicated for Dolphin |
[Removed] |
please delete the above info as soon as you get it |
Removed. Please see my PM. BoonEx Certified Host: Zarconia.net - Fully Supported Shared and Dedicated for Dolphin |