#4 MySQL error during upgrade


When running database.1.1.1-1.1.2.sql I get:

#1305 - PROCEDURE Batavi_Database_Name.upsertLanguageToken does not exist


  • Ronald van den Blink

    • assigned_to: nobody --> dimitryb
  • Ronald van den Blink

    Hi, can you please provide us with all the standards like Mysql version, if InnoDB is enabled etc?

    Assigning ticket to our techlead to check.

  • Dimitry Butko

    Dimitry Butko - 2011-04-18

    Dear, Pallieter,

    somehow your installation of Batavi misses quite vital stored procedure.
    you can create it manually like:

    CREATE PROCEDURE `upsertLanguageToken`(
    tKey varchar(255) CHARACTER SET 'utf8',
    tValue varchar(255) CHARACTER SET 'utf8',
    tGroup varchar(255) CHARACTER SET 'utf8',
    tLanguageCode varchar(255) CHARACTER SET 'utf8'
    DECLARE lang_id INT;

    IF tLanguageCode <> '' THEN
    SELECT languages_id INTO lang_id
    FROM btv_languages
    WHERE code = tLanguageCode
    LIMIT 1;
    IF lang_id IS NOT NULL THEN
    INSERT INTO btv_languages_definitions
    (languages_id, content_group, definition_key, definition_value)
    (lang_id, tGroup, tKey, tValue)
    ON DUPLICATE KEY UPDATE definition_value = tValue;
    END IF;
    END IF;

  • Dimitry Butko

    Dimitry Butko - 2011-04-18
    • assigned_to: dimitryb --> rvdblink
    • status: open --> open-fixed
  • Dimitry Butko

    Dimitry Butko - 2011-04-18

    Please, let me know if that fixes the problem?!

  • Nobody/Anonymous

    Adding that stored procedure solved the problem. The upgrade has been completed.

  • Dimitry Butko

    Dimitry Butko - 2011-04-18
    • status: open-fixed --> closed-fixed
  • Dimitry Butko

    Dimitry Butko - 2011-04-18

    thx! this stored procedures definition will be present in all further upgrades.


Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks