How do you add the field "dateofbirth" if deleted

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.

Quote · 29 Jul 2014

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
Quote · 30 Jul 2014

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

Quote · 30 Jul 2014

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
Quote · 30 Jul 2014

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

Quote · 30 Jul 2014

the list on left is as follows

 

[Removed]

Quote · 30 Jul 2014

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
Quote · 30 Jul 2014

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?

Quote · 30 Jul 2014

/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
Quote · 30 Jul 2014

[Removed]

Quote · 30 Jul 2014

please delete the above info as soon as you get it

Quote · 30 Jul 2014

Removed. Please see my PM.

BoonEx Certified Host: Zarconia.net - Fully Supported Shared and Dedicated for Dolphin
Quote · 30 Jul 2014
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.