Dear All,
I've been trying to set up a moodle site so far unsuccessfully. The install script passes checks for safe mode etc, but the creation of tables gets stuck. The last successful tables were created for "Surveys" but nothing for "Wiki". This is my second attempt. The last time I got stuck at "Workshop".
I am using MySQL 5.? (not sure which version 5.0 maybe)
Thanks for any help
Bernadette
Hi Bernadette
If you successfuly installed Moodle on your PC, you may have an access to phpMyAdmin there. When you go there, you'll see a database (db) there. Click on the name of the database, e.g. mysql or moodle or any name you defined during the installation. It will open a list of all tables Moodle had installed into db. Click on Export link above of all tables that will open Export screen. Thick in Structure part of screen "Add DROP TABLE / DROP VIEW", "Add IF NOT EXISTS" and down below thick "Save as file" and press Go. This will export file with .sql extension containing whole db. Import process is more simple than export is. Go to your server's phpMyAdmin, click on the name of db you wish use for Moodle, find Import link (next to Export) and Browse your PC for finding .sql file. After selecting a proper .sql file, press Go. If everything goes fine, it will import your Moodle tables created on local PC into server.
Wish you good luck in creating the Moodle,
WhiteWolf
Hi Bernadette
Can you please post back the error messages you get on the screen. Also, which specific version of MySQL are you running and check that you're running MySQL with strict mode off. See the Installation notes about this.
Thanks
Ken
Here is the message:
No warnings - Scroll to the continue button
When I hit "home" I get the message "Upgrade already running in this session. Please wait." The page then keeps reloading itself.
I am running MySQL 5.0 with Safe Mode "Off". It's a first installation and when I used the install script it was all green until after the first few tables were created. The only "check" area was for unicode recommendable although utf8 is already enabled.
Thanks for being there! You guys are great
Bernadette
Hi Bernadette
A few more questions/suggestions and troubleshooting pointers:
... Can you restart with a fresh moodle 1.7-STABLE download. Drop the existing moodle database and create a new blank one (see http://docs.moodle.org/en/Installing_Moodle#Creating_an_empty_database). Using White Wolf's instructions (or if you have access to your server use mysqldump and mysql as in the Backup FAQ), restore your database from your PC onto the production system. Do you still get the same problems? Can you also please upload the output of your phpinfo (see here). This will help us to narrow down any PHP problems.
Thanks
Ken
Hi again Ken,
Well, I'm learning about scripts etc the hard way! Here is a copy of my phpinfo. As far as I could check so far, restrictions on my hosted site are:
100Mb Database memory, supports only MyISAM or InnoDB (whatever those types of tables are) and it uses PHP-4.4.4. They've also removed the "import" feature so I can't import the tables from my PC.
Their turnaround time for answers to questions is not great at the moment (1und1.de) so I'll dump the tables in my mysqladmin, it doesn't take long, and try again (and again, ...)
Regards
Bernadette
(Edited by Helen Foster - php info copied and pasted into attached text file - original submission Wednesday, 10 January 2007, 06:03 PM)
"They've also removed the "import" feature so I can't import the tables from my PC."
Is it possible??? I've heard this for the first time to disable an access to import function on mysql for user. Is it commercial webhosting?
What version of phpMyAdmin you use? I am using phpMyAdmin - 2.9.1.1 where SQL and Import are two different functions.
In version phpMyAdmin 2.6.2 import is made with SQL, I have also an other server with 2.9.1.1 and there are two different buttons for SQL and Import (just as you said)
Hosts may have "self made" versions too , I have seen at least one... but it was possible to install own version of phpMyAdmin instead of limited version.
Guys I'm close to giving up! Now I've been trying to export the database to a SQL file to import it to my site (thanks for the tip about the button!) but I keep getting an error: "Missing parameters: what
Missing parameters: export_type
Now what? Sigh!!!!
Hi Bernadette
The phpinfo page looks OK, with only the session.bug_compat_warn setting not as in the moodle requirements - but this should not effect the database. The version of mysql needs to be 4.1.12 or greater, so please check this. At the moment I'm seeing the installation stalling at the assignment table creation.
If you get stuck, email me your login details and I'll be happy to take a look.
Ken
I have the simular failur. I have just installed Moodle on a Win2003 server with IIS 6 and PHP.
PHP settings are :
(Edited by Mauno Korpelainen / MDLSITE-369 - php info copied and pasted into attached text file - original submission Wednesday, 17 January 2007, 01:17 AM)
I've just put that AddType x-mapp-php5 .php line in a .htaccess file, FTPed it to my moodle folder root on 1&1... et voila! Installation of 1.6 beta5 works like a charm. 
