0
Welcome Guest! Login
0 items Join Now

PDO::query() returned false

Last Post
Search Topic
    • TObject's Avatar
    • TObject
    • Newbie
    • Posts: 11
    • Thanks: 0

    PDO::query() returned false

    Posted 11 years 4 months ago
    • Hi, I keep getting the PDO::query() returned false database error in the logs, though everything seems to work ok from the web client point of view.

      Any ideas what is going on?

      Backtrace:
      PDO::execute() at \site\web\libraries\rokcommon\Doctrine\Connection.php
      Doctrine_Connection_Mysql::createTable() at \site\web\libraries\rokcommon\Doctrine\Export.php: 312
      Doctrine_Export_Mysql::_createMigrationTable() at \site\web\libraries\rokcommon\RokCommon\Doctrine\Migration.php: 199
      RokGallery_Doctrine_Migration::getCurrentVersion() at \site\web\libraries\rokcommon\RokCommon\Doctrine\Migration.php: 157
      RokGallery_Doctrine_Migration::__construct() at \site\web\components\com_rokgallery\lib\RokGallery\Doctrine.php: 31
      RokGallery_Doctrine::getInstance() at \site\web\components\com_rokgallery\lib\RokGallery\Doctrine.php: 22
      RokGallery_Doctrine::addModelPath() at \site\web\components\com_rokgallery\lib\RokGallery\Doctrine.php: 45
      main() at \site\web\modules\mod_rokgallery\include.php: 17
      renderModule() at \site\web\modules\mod_rokgallery\mod_rokgallery.php: 19
      JModuleHelper::renderModule() at \site\web\libraries\joomla\application\module\helper.php: 175
      JDocumentRendererModule::render() at \site\web\libraries\joomla\document\html\renderer\module.php: 107
      JDocumentRendererModule::render() at \site\web\libraries\joomla\document\html\renderer\modules.php: 39
      JDocumentRendererModules::getBuffer() at \site\web\libraries\joomla\document\html\html.php: 371
      JDocumentHTML::_renderTemplate() at \site\web\libraries\joomla\document\html\html.php: 655
      JDocumentHTML::render() at \site\web\libraries\joomla\document\html\html.php: 433
      JDocumentHTML::render() at \site\web\includes\application.php: 271
      main() at \site\web\index.php: 48

      Function information:
      PDO::query (
      'CREATE TABLE nfl2g_rokgallery_schema_version (version INT) ENGINE = INNODB'
      )

      System information:
      PHP Built On Windows NT 6.1 build 7601 (Windows Server 2008 R2 Web Server Edition Service Pack 1) i586
      Database Version 5.1.50-community
      Database Collation utf8_general_ci
      PHP Version 5.3.26
      Web Server Apache/2.2.22 (Win32) mod_ssl/2.2.22 OpenSSL/0.9.8x
      WebServer to PHP Interface cgi-fcgi
      Joomla! Version Joomla! 2.5.11 Stable [ Ember ] 26-April-2013 14:00 GMT
      Joomla! Platform Version Joomla Platform 11.4.0 Stable [ Brian Kernighan ] 03-Jan-2012 00:00 GMT
      All extensions are up to date.

      Sorry, I could not post it in the RockGallery forum, please move this thread if it does not belong here.

      Thank you.
    #991570
    • Who?'s Avatar
    • Who?
    • Preeminent Rocketeer
    • Posts: 25562
    • Thanks: 613
    • Joomla freelancer

    Re: PDO::query() returned false

    Posted 11 years 4 months ago
    • Can you confirm that you have InnoDB support enabled in your MySQL database server?
    • Check my services at: Mihha-Vision
    #991725
    • TObject's Avatar
    • TObject
    • Newbie
    • Posts: 11
    • Thanks: 0

    Re: PDO::query() returned false

    Posted 11 years 4 months ago
    • Dear Igor,

      Thank you for the reply.

      SELECT SUPPORT FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE = 'InnoDB';

      returns DEFAULT

      If I am not mistaken, that means InnoDB support is in fact enabled.
    #992417
    • TObject's Avatar
    • TObject
    • Newbie
    • Posts: 11
    • Thanks: 0

    Re: PDO::query() returned false

    Posted 11 years 4 months ago
    • BTW, the nfl2g_rokgallery_schema_version table already exists, so I am puzzled why it is trying to create it again.

      This nfl2g_rokgallery_schema_version table contains one row, where "version" column value is 2.

      Thanks
    #992429
    • Who?'s Avatar
    • Who?
    • Preeminent Rocketeer
    • Posts: 25562
    • Thanks: 613
    • Joomla freelancer

    Re: PDO::query() returned false

    Posted 11 years 4 months ago
    • Having InnoDB in MySQL database schema doesn't mean that PHP is actually configured to use it. Check your Joomla system information to see if you have proper support in PHP also
    • Check my services at: Mihha-Vision
    #992785
    • TObject's Avatar
    • TObject
    • Newbie
    • Posts: 11
    • Thanks: 0

    Re: PDO::query() returned false

    Posted 11 years 4 months ago
    • SELECT ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='nfl2g_rokgallery_schema_version';

      This query returns InnoDB

      Which PHP setting do I need to check?
    • Last Edit: 11 years 4 months ago by TObject.
    #992867
    • Who?'s Avatar
    • Who?
    • Preeminent Rocketeer
    • Posts: 25562
    • Thanks: 613
    • Joomla freelancer

    Re: PDO::query() returned false

    Posted 11 years 4 months ago
    • As I said 8) "Joomla system information" and check for pdo and innodb mentions
    • Check my services at: Mihha-Vision
    #992870
    • TObject's Avatar
    • TObject
    • Newbie
    • Posts: 11
    • Thanks: 0

    Re: PDO::query() returned false

    Posted 11 years 4 months ago
    • PDO
      PDO support enabled
      PDO drivers sqlite, mysql, pgsql, sqlite2


      innodb is not mentioned anywhere on my "Joomla system information" screens.
    #992873
    • Who?'s Avatar
    • Who?
    • Preeminent Rocketeer
    • Posts: 25562
    • Thanks: 613
    • Joomla freelancer

    Re: PDO::query() returned false

    Posted 11 years 4 months ago
    • Which version of RokGallery do you have on your site?
    • Check my services at: Mihha-Vision
    #992885
    • TObject's Avatar
    • TObject
    • Newbie
    • Posts: 11
    • Thanks: 0

    Re: PDO::query() returned false

    Posted 11 years 4 months ago
    • Version 2.10, according to the Joomla's "Extension Manager: Manage" page.
    #992897

Time to create page: 0.058 seconds