•  
      request #8013 DB error ==> SELECT * FROM forgeconfig
    Infos
    #8013
    Lionel Faure (adminsys)
    2015-12-15 17:08
    2015-04-16 13:34
    8032
    Details
    DB error ==> SELECT * FROM forgeconfig
    After the laste upgrade I got this error :

    DB error ==> SELECT * FROM forgeconfig @@ /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php at line 95 in /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php on line 155, referer: https://**********/svn/?group_id=101

    [Thu Apr 16 12:22:26 2015] [error] [client 192.168.106.131] PHP Warning: Invalid argument supplied for foreach() in /usr/share/tuleap/src/common/Config/ConfigValueDatabaseProvider.php on line 36, referer: https://********/svn/?group_id=101
    Other
    Empty
    CentOS 6
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Empty
    Closed
    2015-12-15
    Attachments
    Empty
    References
    References list is empty

    Follow-ups

    User avatar
    • Status changed from New to Closed
    • Reported in version cleared values: 8.0
    • Close date set to 2015-12-15
    User avatar
    Very strange ... The forgeupgrade is not executed because it's marked as spiked ...

    The only solution is to remove this entry in DB (remove from forge_upgrade_bucket) and to relaunch the forgeupgrade script.
    User avatar
    Lionel Faure (adminsys)2015-04-16 14:39
    In fact there is no table forgeconfig

    The only occurence of forgeconfig in the whole database is in the table forge_upgrade_bucket

    it returns this :

    SELECT *
    FROM `tuleap`.`forge_upgrade_bucket`
    WHERE (
    CONVERT( `id`
    USING utf8 ) LIKE '%forgeconfig%'
    OR CONVERT( `script`
    USING utf8 ) LIKE '%forgeconfig%'
    OR CONVERT( `start_date`
    USING utf8 ) LIKE '%forgeconfig%'
    OR CONVERT( `end_date`
    USING utf8 ) LIKE '%forgeconfig%'
    OR CONVERT( `status`
    USING utf8 ) LIKE '%forgeconfig%'
    )
    LIMIT 0 , 30


    id int(11) unsigned 179
    script varchar(255) /usr/share/tuleap/src/db/mysql/updates/2015/201503271456_add_forgeconfig.php
    start_date datetime 2015-04-14 12:18:27
    end_date datetime 2015-04-14 12:18:27
    status tinyint(4) 3