-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Forum Rules