database query error, PLEASE HELP...

Ive been stuck on this for awhile, and cant get passed it, and my hosting company escalated the ticket and remoted in and can do nothing for me as they have no clue what is going on.  Locally, my site is perfect just what i wanted, but when uploading to my hosting co (tmd) and going to my site, it errors out. my site is www.209connect.com the error is right on the page, if youve ever seen this please help as its really setting me back. Thanks in advance all =)

 

Query: SELECT COUNT(`Profiles`.`ID`) FROM `Profiles` WHERE `Profiles`.`Status` = 'Active' and (`Profiles`.`Couple` = 0 or `Profiles`.`Couple` > `Profiles`.`ID`)

My sql error: Found error in the file '/home/thblockr/public_html/templates/base/scripts/BxBaseIndexPageView.php' at line 363.
Called 'db_value' function with erroneous argument #0.

Quote · 15 Mar 2011

There is only one thing i can think of. But it's a long shot. Most people don't try to do this but i have to ask any way.

Have you made any changes to profile fields recently? Specifically removing fields that dolphin pretty much requires. In this case the couple field.

Just a stab in the dark.

I have not seen this specific database error before.

https://www.deanbassett.com
Quote · 15 Mar 2011

I have added new profile fields recently yes, but never changed the pre defined fields. Couples field is still there.

Quote · 15 Mar 2011

i did notice that my couple profile box is under misc. on the right hand side instead of under active on the left hand side, does that matter??

Quote · 15 Mar 2011

 

i did notice that my couple profile box is under misc. on the right hand side instead of under active on the left hand side, does that matter??

If it's in the active section it should not matter.

Normally it is the first one under General info on the join form section.

As i said, just a stab in the dark, i am unsure of the problem.


https://www.deanbassett.com
Quote · 15 Mar 2011

anyone else have any ideas???

Quote · 16 Mar 2011

Solved, reinstalled and started over.

Quote · 17 Mar 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.