+ Reply to Thread
Results 1 to 1 of 1

Thread: Cannot create stored procedures (v 1.9)

  1. #1
    Join Date
    Jan 2008
    Posts
    165

    Default Cannot create stored procedures (v 1.9)

    SOLVED: I switched to mysql-5.1.22 and stored procedure problem was solved. Apparently mysql-5.1.23 has a problem with stored procedures.


    Hi, I'm installing on a WAMP stack but install fails when creating stored procedures.
    I checked that the proc table does exist in my DB. The proc and and procs_priv tables are empty. I see no mysql logs. Not sure where to "check warnings". Any suggestions?

    Install log:
    Performing installation...
    Generating LocalSettings.php configuration file...
    Database type: MySQL
    Attempting to connect to database server as root...success.
    Connected to 5.1.23-rc-community
    Attempting to create database...
    Created database wikidb
    Creating tables... done.
    Granting user permissions to wikiuser on wikidb...success.
    Created sysop account Admin.
    Inserting wgDekiApiKey into config table...done.
    Setting storage path in config table...done.
    Setting Site Name int config table...done.
    Creating stored procedures... Query " CREATE PROCEDURE `perm_get_PageRestrictionFlags`( IN pageid INT UNSIGNED, OUT page_restriction_flags INT UNSIGNED ) BEGIN select rs.restriction_perm_flags into page_restriction_flags from pages as p join restrictions rs on p.page_restriction_id = rs.restriction_id where p.page_id = pageid; select ifnull(page_restriction_flags,0) into page_restriction_flags; END" failed with error code "Cannot create stored routine `perm_get_PageRestrictionFlags`. Check warnings".

    --
    Also, I tried to manually edit user privs via MYSQL ADMIN after install fails but the install script doesn't support this approach; you have to drop the DB/user and restart.

    ---
    Environment check:
    PHP 5.2.5 installed.
    Found database drivers for: MySQL.
    PHP server API is apache2handler.
    Have XML / Latin1-UTF-8 conversion support.
    Session save path (C:\DOCUME~1\preeves\LOCALS~1\Temp\php\session) appears to be valid.
    PHP's memory_limit is 128M.
    Apache version Apache/2.2.8.
    apache mod_rewrite enabled.
    apache mod_proxy enabled.
    MySQL enabled, client version: 5.0.45.
    curl enabled, version: 7.16.0.
    Found ImageMagick: c:\program files\imagemagick-6.3.9-q16\convert.exe; image thumbnailing will be enabled.
    Found ImageMagick: c:\program files\imagemagick-6.3.9-q16\identify.exe; image thumbnailing will be enabled.
    Found GD graphics library.
    Warning: html2ps was not found. html2ps is required for exporting to PDF.
    Warning: ps2pdf was not found. ps2pdf is required for exporting to PDF.
    Installation directory: C:\deki-hayes\web.
    Environment checked. You can install Deki Wiki.
    Last edited by bohappa; 03-24-2008 at 12:09 AM. Reason: Solved the problem.

+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts