database query error - cannot view or edit members...?

All was working fine, was tweaking the layout of new site Im working on, getting rid of a few blocks in members profiles.

Then, I go to add a description for a member, save it. Then goto view that member and I get the 'database query error' page.

Then, I notice I cannot view that members profile in any way, profile link, members link, in admin... nor can I make any changes to it.

 

Same happens for any members I make any changes on!

Otherwise, members and profile views work fine, until I make a single change then 'error'...

 

Not getting any site emails either bout it.!

Any ideas???

Quote · 16 Feb 2011

So provide us with full DB error here please

PS: If possible do not write me personally, please try to ask on the forum first
Quote · 16 Feb 2011

Thats the problem, Im not getting any error emails.

I just get taken to the default 'database query error' screen.

Quote · 16 Feb 2011

enable full debug mode, it will provide you with the database error.

Thats the problem, Im not getting any error emails.

I just get taken to the default 'database query error' screen.

 

When a GIG is not enough --> Terabyte Dolphin Technical Support - Server Management and Support
Quote · 16 Feb 2011

 

enable full debug mode, it will provide you with the database error.

Thats the problem, Im not getting any error emails.

I just get taken to the default 'database query error' screen.

 

Sounds like a good lead :-)

Where do I find option for this, in admin or on server?

 

Thanks

Quote · 16 Feb 2011

http://www.boonex.com/unity/googlesearch/search?q=database+error+full+debug+mode+on

 

use the search feature on the forums here, this has been discussed many times.

 

hope that helps.

 

enable full debug mode, it will provide you with the database error.

Thats the problem, Im not getting any error emails.

I just get taken to the default 'database query error' screen.

 

Sounds like a good lead :-)

Where do I find option for this, in admin or on server?

 

Thanks

 

When a GIG is not enough --> Terabyte Dolphin Technical Support - Server Management and Support
Quote · 17 Feb 2011

Thanks.

I did use the search feature, and found a previous thread about it, advice there was

 

Just edit your 'inc\db.inc.php ' file

and change

define( 'DB_FULL_DEBUG_MODE', false );

to

define( 'DB_FULL_DEBUG_MODE', true );

 

and you will got full error description

 

This was not correct, maybe an old version of Dolphin?

I found the file to edit in /inc/classes

Turns out it was the wall module for some reason started playing up?

Deleted and re-installed it, seems to be fine now.

 

Quote · 17 Feb 2011

Thought that fixed it, but its back.

Removing the wall module prevents the error, as soon as I re-install wall module, then try to edit anything on a members profile, it brings back error when I try to view  that member.

Get this error header below plus the contents of BxWallModule.php

using clean 7.0.5

Query:
SELECT Voter FROM `bx_wall_likes` WHERE `ItemID`='1' LIMIT 3
Mysql error:
Found error in the file '/modules/boonex/wall/classes/BxWallModule.php' at line 711.
Called 'db_res' function with erroneous argument #0.
Quote · 17 Feb 2011

 

Thought that fixed it, but its back.

Removing the wall module prevents the error, as soon as I re-install wall module, then try to edit anything on a members profile, it brings back error when I try to view  that member.

Get this error header below plus the contents of BxWallModule.php

using clean 7.0.5

 

Query:
SELECT Voter FROM `bx_wall_likes` WHERE `ItemID`='1' LIMIT 3
Mysql error:
Found error in the file '/modules/boonex/wall/classes/BxWallModule.php' at line 711.
Called 'db_res' function with erroneous argument #0.

make a ticket on support page

PS: If possible do not write me personally, please try to ask on the forum first
Quote · 17 Feb 2011

Hi SashaE, I opened a ticket with the info which was promptly CLOSED by IgorL saying that boonex do not offer support for modules purchased on Unity.

 

This in relation to the error that points to the WALL module.

 

This was on a paid ticket...!?

 

I have just re-submitted the same ticket 2nd time hoping someone will look at it properly!

Quote · 17 Feb 2011

daihlo,

yes that path you mention here is for an older version of dolphin, where the debug mode is set at now i believe as mentioned from Sashae, is the following:

 

Hello you'll need set full debug for db errors in inc/classes/BxDolDb.php.

 

 

Thanks.

I did use the search feature, and found a previous thread about it, advice there was

 

Just edit your 'inc\db.inc.php ' file

and change

define( 'DB_FULL_DEBUG_MODE', false );

to

define( 'DB_FULL_DEBUG_MODE', true );

 

and you will got full error description

 

This was not correct, maybe an old version of Dolphin?

I found the file to edit in /inc/classes

Turns out it was the wall module for some reason started playing up?

Deleted and re-installed it, seems to be fine now.

 

 

When a GIG is not enough --> Terabyte Dolphin Technical Support - Server Management and Support
Quote · 17 Feb 2011

I installed it.

It asked to remove the installation directory.

After I removed it and went to the site it doesn't display anything exept

Error
Database query error
Please Help
apsc
Quote · 15 Aug 2011
 
 
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.