Database query error - Create event

Hello, sorry for my bad English.

If i am in the Adminmenu and want to create an Event i become the Message: Database query error


In the Browseradresfield ist this Link: http://www.my-domain.de/m/events/administration/create

I dont know what to do now.

Can me help one?

Quote · 30 Mar 2010

I can help but i need to know what the error is

Open inc/classes/BxDolDb.php file

find

define( 'DB_FULL_DEBUG_MODE', false );

change it to

define( 'DB_FULL_DEBUG_MODE', true );

This change will tell you what the DB error is and then post it here

Looking for Help? http://www.boonex.com/kevinmitnick
Quote · 30 Mar 2010

Hey, thanks :-)


This is the Error:

Database query error
Query:
SELECT COUNT(*) FROM `bx_files_main` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_files_main`.`Owner` left JOIN `bx_files_types` ON `bx_files_types`.`Type`=`bx_files_main`.`Type` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_files_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `sys_categories` ON `sys_categories`.`ID`=`bx_files_main`.`ID` WHERE 1 AND `bx_files_main`.`Status` ='approved' AND `sys_categories`.`Category` ='Events' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_files' AND `bx_files_main`.`Owner` ='1' AND `sys_categories`.`Type` ='bx_files'
Mysql error:
Table 'usr_web0_1.bx_files_main' doesn't exist

Found error in the file '/var/www/web0/html/inc/classes/BxDolSearch.php' at line 511.
Called 'db_value' function with erroneous argument #0.
----------------------------------------------------------------------------------------------------------------------------------

function getCount () {
$aJoins = $this->getJoins(false);
$sqlQuery =  "SELECT COUNT(*) FROM `{$this->aCurrent['table']}` {$aJoins['join']} " . $this->getRestriction() . " {$aJoins['groupBy']}";
return (int)db_value($sqlQuery);
}

--------------------------------------------------------------------------------------------------------------------------------------

This is Line 511: return (int)db_value($sqlQuery);


Quote · 30 Mar 2010

Hello i am again :-)


I have Found the Failure.


What i have done?

1. I have deinstalled file-modul and Group Modul.

2. I have installed them again and then insalled the Eventmodul new.


Now it is all o.k. :-) :-) :-)

Thanke you for youre help in this hard Night :-)

A Vote here i have done for you :-)

Best regards Fettermann ;-)

Quote · 30 Mar 2010

lol I was about to tell you the same :)

I'm glad you figure that out yourself n thanks for the vote

Looking for Help? http://www.boonex.com/kevinmitnick
Quote · 30 Mar 2010
 
 
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.