Error Database query error

Hi, i am all the sudden receiving this when i go into members in the admin

Dolphin 7.1.1

Anyone have a suggestion ?

regards

SGTB

We need the error message.  Check your site email for the error, or edit /inc/classes/BxDolDb.php and change:

define( 'DB_FULL_DEBUG_MODE', false );

to

define( 'DB_FULL_DEBUG_MODE', true );

Sorry about that,

Mysql error: Unknown column 'DateOfBirth' in 'where clause'

Found error in the file '/home/content/34/10379934/html/inc/classes/BxDolBrowse.php' at line 125.
Called 'db_value' function with erroneous argument #0.

Regards

SGTB

Looks like you removed the date of birth field from the profile fields in fields builder.

That seems to be the problem Deano....thank you

Regards

SGTB

I Am Getting The Same Error When I Go To Use The  "Add Group" Option.  Everything Else Under The Group Mod Is Working Fine.  But When I Go To Add Group I Get The : Database query error

What Should I Do?

We need the error message as mentioned in the second post of this topic.

First follow the steps above to enable database debugging, then post the full error.

Hello,

1-

I Am Getting The Same Error

I work with Dolphin 7.1.1

2-

when I change

define( 'DB_FULL_DEBUG_MODE', false );

 to

 define( 'DB_FULL_DEBUG_MODE', true );

I have this : (I moved a lot of lines)

"""""""""""""""""""""""""""""

""""""""""""""""""""""""""""

Array
(
    [1] => Array
        (
            [file] => /home/......
                )

        )

)

array (
  'enable_global_couple' => '',
  'votes' => 'on',
  'zodiac' => '',
  'anon_mode' => '',
  'reg_by_inv_only' => '',
  'enable_cmts_profile_delete' => '',
  'member_online_time' => '1',  'dbcs_DT_logguests' => '0',
)

Array
(
   
)

"""""""""""""""""""""""""""

""""""""""""""""""""""""""

any idea plz ?

thank you 

That error means the database table sys_sessions is damaged and needs to be repaired. Try to repair that table from phpMyAdmin or becuse this table only contains session data you can try emptying it with the sql command TRUNCATE TABLE `sys_sessions`

Hi, the following error is displayed when I select friends in a user who has no friends (Dolphin 7.1.5)

It would have been better to just start a new topic.  What your error is telling you is that the column "allow_view_friends_to" does not exist in the database table.  I think you tried installing a module but maybe missed a step.

You were suppose to run this query:

ALTER TABLE `Profiles` ADD `allow_view_friends_to` INT( 11 ) NOT NULL DEFAULT '3' AFTER `allow_view_to`;

If you go to your database tool, often phpMyAdmin on cPanel installs, you can run that query and it will fix your issue.

Hi,

i need Help

Found error in the file '/kunden/394138_30900/artaid/beta/modules/modzzz/listing/classes/BxListingDb.php' at line 1214.
Called 'getAll' function with erroneous argument #0.

Come on folks, database query errors are specific; as in this case.

Contact Modzzz for help, he is the developer of this module.

Modzzz, cause this database error.... 

The error is caused because of improper setup of the business listing module. In the Admin settings you have turned on integration with the Jobs module but you do not have the Jobs module installed. Go to the Settings for the business listing module and turn off the option that says "Jobs integration is activated".

I've got the 7.3 beta version, I installed, and the got database error again..  it's not the modzzz, hmm,  I think alexT need take a look into that...  

I switched back to 7.2.1, ... anyone who got the database error after 7.3 upgraded ?

 it is meant to test not to upgrade..its beta version..i created a post already on this

https://www.boonex.com/forums/topic/7-3-Database-query-error-on-installation.htm