#4 MySQL error during upgrade

closed-fixed
None
5
2011-04-18
2011-04-14
No

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

#1305 - PROCEDURE Batavi_Database_Name.upsertLanguageToken does not exist

Discussion

  • 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'
    )
    BEGIN
    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)
    VALUES
    (lang_id, tGroup, tKey, tValue)
    ON DUPLICATE KEY UPDATE definition_value = tValue;
    END IF;
    END IF;
    END

     
  • 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