Hi,
I am a new Agavi user. I just followed the tutorial : http://www.agavi.org/documentation/tutorial/step5/the-database-manager.html I set up the file /app/config/database.xml to create a database connexion : <ae:configurations xmlns:ae="http://agavi.org/agavi/config/global/envelope/1.0";; xmlns="http://agavi.org/agavi/config/parts/databases/1.0";;> <ae:configuration> <databases default="pdo_mysql_main"> <database name="pdo_mysql_main" class="AgaviPdoDatabase"> <ae:parameter name="dsn">mysql:host=localhost;dbname=benchmark</ae:parameter> <ae:parameter name="username">root</ae:parameter> <ae:parameter name="password">root</ae:parameter> </database> <database name="propelom" class="AgaviPropelDatabase"> <ae:parameter name="config">%core.app_dir%/config/project-conf.php</ae:parameter> </database> </databases> </ae:configuration> </ae:configurations> I set up /app/config/settings.xml as follow : <settings> <setting name="app_name">Benchmark Agavi</setting> <setting name="available">true</setting> <setting name="debug">false</setting> <setting name="use_database">true</setting> <setting name="use_logging">false</setting> <setting name="use_security">true</setting> <setting name="use_translation">false</setting> </settings> I my model file, i open an new database connexion to request the database class Sii_PopulationManagerModel extends benchmark_agaviSiiBaseModel { public function retrieveAll() { $sql = 'SELECT idPopulation, effectif, anneeNaissance FROM population p ORDER BY anneeNaissance'; $stmt = $this->getContext()->getDatabaseManager()->getDatabase('pdo_mysql_main')->getConnection()->prepare($sql); $stmt->execute(); $populationsRowSet = $stmt->fetch(PDO::FETCH_ASSOC); ... } } When I open the web page, I get this message : Warning: require(/home/ebp/share/benchmark-agavi/app/config/project-conf.php): failed to open stream: No such file or directory in /home/ebp/share/benchmark-agavi/libs/agavi/database/AgaviPropelDatabase.class.php on line 172 Call Stack: 0.0009 315988 1. {main}() /home/ebp/share/benchmark-agavi/pub/index.php:0 4.6446 1284144 2. AgaviContext::getInstance() /home/ebp/share/benchmark-agavi/pub/index.php:23 4.6447 1285544 3. AgaviContext->initialize() /home/ebp/share/benchmark-agavi/libs/agavi/core/AgaviContext.class.php:274 4.9455 1616572 4. include('/home/ebp/share/benchmark-agavi/app/cache/config/factories.xml_development_web_69aae32eef99ca40bf7c9c316e9a218b6ceac608.php') /home/ebp/share/benchmark-agavi/libs/agavi/core/AgaviContext.class.php:307 4.9456 1621884 5. AgaviDatabaseManager->initialize() /home/ebp/share/benchmark-agavi/app/cache/config/factories.xml_development_web_69aae32eef99ca40bf7c9c316e9a218b6ceac608.php:53 5.1733 1634324 6. require('/home/ebp/share/benchmark-agavi/app/cache/config/databases.xml_development__dcf4b4d340933ac9a4058757038e9dd9b7c094a6.php') /home/ebp/share/benchmark-agavi/libs/agavi/database/AgaviDatabaseManager.class.php:142 5.1829 1706944 7. AgaviPropelDatabase->initialize() /home/ebp/share/benchmark-agavi/app/cache/config/databases.xml_development__dcf4b4d340933ac9a4058757038e9dd9b7c094a6.php:19 Fatal error: require(): Failed opening required '/home/ebp/share/benchmark-agavi/app/config/project-conf.php' (include_path='.:/usr/share/php') in /home/ebp/share/benchmark-agavi/libs/agavi/database/AgaviPropelDatabase.class.php on line 172 Call Stack: 0.0009 315988 1. {main}() /home/ebp/share/benchmark-agavi/pub/index.php:0 4.6446 1284144 2. AgaviContext::getInstance() /home/ebp/share/benchmark-agavi/pub/index.php:23 4.6447 1285544 3. AgaviContext->initialize() /home/ebp/share/benchmark-agavi/libs/agavi/core/AgaviContext.class.php:274 4.9455 1616572 4. include('/home/ebp/share/benchmark-agavi/app/cache/config/factories.xml_development_web_69aae32eef99ca40bf7c9c316e9a218b6ceac608.php') /home/ebp/share/benchmark-agavi/libs/agavi/core/AgaviContext.class.php:307 4.9456 1621884 5. AgaviDatabaseManager->initialize() /home/ebp/share/benchmark-agavi/app/cache/config/factories.xml_development_web_69aae32eef99ca40bf7c9c316e9a218b6ceac608.php:53 5.1733 1634324 6. require('/home/ebp/share/benchmark-agavi/app/cache/config/databases.xml_development__dcf4b4d340933ac9a4058757038e9dd9b7c094a6.php') /home/ebp/share/benchmark-agavi/libs/agavi/database/AgaviDatabaseManager.class.php:142 5.1829 1706944 7. AgaviPropelDatabase->initialize() /home/ebp/share/benchmark-agavi/app/cache/config/databases.xml_development__dcf4b4d340933ac9a4058757038e9dd9b7c094a6.php:19 Can somebody tell me why I get this message ? How to fix it ? Best regards, Xavier _______________________________________________ users mailing list [email protected] http://lists.agavi.org/mailman/listinfo/users
