Loading...
 
Skip to main content

Database update errors on new trunk

  • Tracker item actions
Trackers
Items
Status
Closed
Subject
Database update errors on new trunk
Version
18.x
18.x Regression
Category
  • Regression
Feature
Console / Command Line
Resolution status
New
Submitted by
Bernard Sfez / Tiki Specialist
Lastmod by
Bernard Sfez / Tiki Specialist
Rating
(0)
Description

Errors on database update after a brand new trunk install Revision: 63992

Copy to clipboard
Macintosh-2:trunk Bernard$ php console.php d:u

Warning: Illegal string offset 'galleryId' in /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/installer/schema/20101126_fgal_add_gallerie_user_tiki.php on line 30

Call Stack:
    0.0015     247624   1. {main}() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/console.php:0
    0.3273   23818600   2. Symfony\Component\Console\Application->run() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/console.php:80
    0.3385   24111848   3. Symfony\Component\Console\Application->doRun() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/vendor_bundled/vendor/symfony/console/Application.php:125
    0.3388   24113152   4. Symfony\Component\Console\Application->doRunCommand() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/vendor_bundled/vendor/symfony/console/Application.php:224
    0.3389   24113752   5. Symfony\Component\Console\Command\Command->run() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/vendor_bundled/vendor/symfony/console/Application.php:888
    0.3399   24126888   6. Tiki\Command\UpdateCommand->execute() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/vendor_bundled/vendor/symfony/console/Command/Command.php:264
    0.3426   24127800   7. Installer->update() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/lib/core/Tiki/Command/UpdateCommand.php:38
    4.1942   24906584   8. Installer->installPatch() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/installer/installlib.php:129
    4.1947   24912832   9. upgrade_20101126_fgal_add_gallerie_user_tiki() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/installer/installlib.php:174


Warning: Illegal string offset 'galleryId' in /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/installer/schema/20101210_fgal_add_wiki_attachments_tiki.php on line 30

Call Stack:
    0.0015     247624   1. {main}() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/console.php:0
    0.3273   23818600   2. Symfony\Component\Console\Application->run() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/console.php:80
    0.3385   24111848   3. Symfony\Component\Console\Application->doRun() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/vendor_bundled/vendor/symfony/console/Application.php:125
    0.3388   24113152   4. Symfony\Component\Console\Application->doRunCommand() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/vendor_bundled/vendor/symfony/console/Application.php:224
    0.3389   24113752   5. Symfony\Component\Console\Command\Command->run() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/vendor_bundled/vendor/symfony/console/Application.php:888
    0.3399   24126888   6. Tiki\Command\UpdateCommand->execute() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/vendor_bundled/vendor/symfony/console/Command/Command.php:264
    0.3426   24127800   7. Installer->update() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/lib/core/Tiki/Command/UpdateCommand.php:38
    4.3763   24925600   8. Installer->installPatch() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/installer/installlib.php:129
    4.3768   24931912   9. upgrade_20101210_fgal_add_wiki_attachments_tiki() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/installer/installlib.php:174


Warning: PDOStatement::execute(): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lang' in 'where clause' in /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/lib/core/TikiDb/Pdo.php on line 77

Call Stack:
    0.0015     247624   1. {main}() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/console.php:0
    0.3273   23818600   2. Symfony\Component\Console\Application->run() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/console.php:80
    0.3385   24111848   3. Symfony\Component\Console\Application->doRun() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/vendor_bundled/vendor/symfony/console/Application.php:125
    0.3388   24113152   4. Symfony\Component\Console\Application->doRunCommand() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/vendor_bundled/vendor/symfony/console/Application.php:224
    0.3389   24113752   5. Symfony\Component\Console\Command\Command->run() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/vendor_bundled/vendor/symfony/console/Application.php:888
    0.3399   24126888   6. Tiki\Command\UpdateCommand->execute() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/vendor_bundled/vendor/symfony/console/Command/Command.php:264
    0.3426   24127800   7. Installer->update() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/lib/core/Tiki/Command/UpdateCommand.php:38
    5.1030   25058928   8. Installer->installPatch() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/installer/installlib.php:129
    5.1038   25087912   9. pre_20110727_tracker_multilingual_convert_tiki() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/installer/installlib.php:180
    5.1051   25094912  10. TikiDb_Table->deleteMultiple() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/installer/schema/20110727_tracker_multilingual_convert_tiki.php:46
    5.1051   25095488  11. TikiDb->queryException() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/lib/core/TikiDb/Table.php:109
    5.1051   25095664  12. TikiDb_Pdo->query() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/lib/core/TikiDb.php:72
    5.1051   25095664  13. TikiDb_Pdo->_query() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/lib/core/TikiDb/Pdo.php:118
    5.1051   25097632  14. PDOStatement->execute() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/lib/core/TikiDb/Pdo.php:77


                                           
  [TikiDb_Exception]                       
  Unknown column 'lang' in 'where clause'  
                                           

database:update [--auto-register]


I re ran it and it changed for

Copy to clipboard
Macintosh-2:trunk Bernard$ php console.php d:u

Warning: PDOStatement::execute(): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lang' in 'where clause' in /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/lib/core/TikiDb/Pdo.php on line 77

Call Stack:
    0.0029     247624   1. {main}() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/console.php:0
    0.3364   23818896   2. Symfony\Component\Console\Application->run() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/console.php:80
    0.3489   24112240   3. Symfony\Component\Console\Application->doRun() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/vendor_bundled/vendor/symfony/console/Application.php:125
    0.3492   24113544   4. Symfony\Component\Console\Application->doRunCommand() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/vendor_bundled/vendor/symfony/console/Application.php:224
    0.3492   24114144   5. Symfony\Component\Console\Command\Command->run() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/vendor_bundled/vendor/symfony/console/Application.php:888
    0.3504   24127280   6. Tiki\Command\UpdateCommand->execute() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/vendor_bundled/vendor/symfony/console/Command/Command.php:264
    0.3532   24128192   7. Installer->update() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/lib/core/Tiki/Command/UpdateCommand.php:38
    1.1695   24643456   8. Installer->installPatch() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/installer/installlib.php:129
    1.1703   24672440   9. pre_20110727_tracker_multilingual_convert_tiki() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/installer/installlib.php:180
    1.1719   24679376  10. TikiDb_Table->deleteMultiple() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/installer/schema/20110727_tracker_multilingual_convert_tiki.php:46
    1.1720   24679952  11. TikiDb->queryException() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/lib/core/TikiDb/Table.php:109
    1.1720   24680128  12. TikiDb_Pdo->query() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/lib/core/TikiDb.php:72
    1.1720   24680128  13. TikiDb_Pdo->_query() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/lib/core/TikiDb/Pdo.php:118
    1.1721   24682096  14. PDOStatement->execute() /Users/Bernard/Documents/Shocksite/www/htdocs/trunk/lib/core/TikiDb/Pdo.php:77


                                           
  [TikiDb_Exception]                       
  Unknown column 'lang' in 'where clause'  
                                           

database:update [--auto-register]
Importance
7
Easy to solve?
5
Priority
35
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
6456
Created
Sunday 24 September, 2017 06:20:07 UTC
by Bernard Sfez / Tiki Specialist
LastModif
Tuesday 05 December, 2017 15:27:08 UTC


Show PHP error messages