Menu

#55 Error importing Processes

open
nobody
Installer (12)
5
2012-09-14
2009-09-19
Anonymous
No

Unable to get past step one of the Wizard Installer, so I am trying the Manual Installation listed in the Bug Tracker.

While importing the processes file to MySQL, I received the following error:

SQL query:

DELIMITER $$ CREATE FUNCTION SET_CLASS_RANK_MP (
mp_id int
) RETURNS int( 11 ) BEGIN DECLARE done INT DEFAULT 0;

MySQL said: Documentation

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER $$

CREATE FUNCTION SET_CLASS_RANK_MP(
mp_id int
) RETURNS int(11' at line 1

This is the error message I am receiving in the Wizard:
Couldn't connect to database server: localhost:3306

Possible causes are:

  1. MySQL is not installed. Try downloading from MySQL Website
  2. Username or Password or MySQL Configuration is incorrect
  3. Php.ini is not properly configured. Search for MySQL in php.ini

Discussion

  • Raymond Val

    Raymond Val - 2009-09-21
    1. What version are you using? What OS? What websever?
    2. Can you please indicate what your settings are for when using the wizard and the environment.
    3. What are you using to import the processes files into MySQL (command line, phpmyadmin, etc.)?
     
  • Kristy

    Kristy - 2009-09-25

    Using 4.5.0, with Linux webserver, using Windows XP on local computer
    I am using the Import through phpmyadmin for the procedures, not processes, file. I have the Addresses table installed. I have also added the info to the data.php file for manual installation. But, when I go to reset_auto_increment, I get a blank white page.

    Created login for SourceForge, and I couldn't find this earlier---so I created another topic or "artifact". Just found where you had replied to this! Thank you!

     

Log in to post a comment.

MongoDB Logo MongoDB