"Database Query Error"

whenever someone joins, they get that message anyone know why?

Edit /inc/classes/BxDolDb.php and change:

define( 'DB_FULL_DEBUG_MODE', false );

to

define( 'DB_FULL_DEBUG_MODE', true );

and post the full error here.

Found error in the file '/home/biggaden/public_html/nocursesinverses.com/inc/classes/BxDolProfilesController.php' at line 124.
Called 'db_res' function with erroneous argument #0.

I think I tried to do this:

==============================================================================================

MOD: Auto - Friend by Prolaznik

==============================================================================================

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

                                   Installation 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Files to edit join.php

look for this code around line 268-269

$aProfile1 = $this->oPF->getProfileFromValues($this->aValues[0]);

list($iId1, $sStatus1) = $oPC->createProfile($aProfile1);

add this code bellow 

$dump = db_res("INSERT INTO sys_friend_list SET `ID` = '{$iId1}', `Profile` = 2, `Check` = 1");

THE PROFILE NUMBER IS YOUR DEFAULT FRIEND/TOM (MYSPACE.COM)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

                                                                      Prolaznik

                                                                      prolaznik@Net-Zabava.com

                                                                         http://Net-Zabava.com                                    

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

I WONDER IF THAT HAS SOMETHING TO DO WITH IT? 

Mysql error:
Unknown column '' in 'field list'

It means you are trying to insert a field that does not exist in your Profiles table.

Check the fields you're trying to insert and compare these with the fields in your Profiles table.

You might need to add the field manually

', `DateOfBirth` = '', `Headline` = 'this is only a test', `Country` = 'US', `City` = 'rex', `Couple` = 0, `Tags` = '', `zip` = '', `EmailNotify` = 0, `Height` = '', `Weight` = '', `Income` = '', `Occupation` = '', `Religion` = '', `Education` = '', `RelationshipStatus` = '', `Hobbies` = '', `Interests` = '', `Ethnicity` = '', `FavoriteSites` = '', `FavoriteMusic` = '', `FavoriteFilms` = '', `FavoriteBooks` = '', `FirstName` = '', `LastName` = '', `State` = '', `` = '', `LangID` = 1

Item in red looks like it is your culprit. Check your Builders - Profiles Builder - Join Page. Compare the fields for your Join page to the fields in your error. Hopefully you find the offending one.

This is how I have it set up.

This is my 'Join Page' (I think it might be 'Photo' I think I tried to edited it to be 'Mandatory')

OK, that is a start - so, if it were my site and I were having the problem you are having, I would remove each profile field one by one till i found the one that was the culprit. So, move the profile photo field block down to the inactive section, and try to register and see what happens.

Again, this is what I would do and there may be an easier way, but I hope it helps.

I noticed that empty 'block' how can I delete it, because there is no text to click on for me to edit it?

You can delete it from the sys_profile_fields table in the database.  Also make sure the field doesn't exist in the Profiles table.

Remember to clear Dolphin's cache whenever the database is manually edited.

Where do I find this 'Profile Table' you are referring to? And you mean the database in my 'cPanel'?

In the database for your Dolphin install.  In cPanel you would go to phpMyAdmin.  The table is sys_profile_fields. You may want to backup your database in case of an oops. The problem is finding the correct entry to remove.  I am assuming that in this case you will want to look for one that has no entry for the name.

Working! Thank you, "Nathan", "Denre" and "Geek_Girl". I did what you said "ProfessorSr" and that worked (the description block was the culprit) I'll have to figure out why it's glitched, I'm going to have to see if the other Description blocks work.