+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 17
Coding Thread, Moodle died - help with PHP/MYSQL needed in Coding and Web Development; Something has gone wrong with our Moodle, we think it might be something to do with PHP/MYSQL can somebody please ...
  1. #1

    Join Date
    May 2011
    Posts
    11
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Moodle died - help with PHP/MYSQL needed

    Something has gone wrong with our Moodle, we think it might be something to do with PHP/MYSQL can somebody please help.

    layton.blackpool.sch.uk/moodle

    Thanks

  2. #2
    bodminman's Avatar
    Join Date
    Apr 2007
    Location
    Sunny Suffolk
    Posts
    1,163
    Thank Post
    734
    Thanked 224 Times in 116 Posts
    Rep Power
    90
    Hi Matt,
    when was it last working OK and what if anything has happened since? ie: updates/changes etc.

  3. #3

    Join Date
    May 2011
    Posts
    11
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi,
    It was working this morning, tried updating PHP ready for a Moodle 2 test install and then had problems ever since. The MYSQL service doesn't want to start on the server.

  4. #4

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,821
    Thank Post
    272
    Thanked 1,140 Times in 1,036 Posts
    Rep Power
    350
    Are we talking windows or linux?

  5. #5

    Join Date
    May 2011
    Posts
    11
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    It's set up on Windows Small Business Server 2003. Convinced it's something to do with MYSQL tables or PHP. If you go to the website you will also see what I mean.

    http://www.layton.blackpool.sch.uk
    http://www.layton.blackpool.sch.uk/moodle

  6. #6

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,821
    Thank Post
    272
    Thanked 1,140 Times in 1,036 Posts
    Rep Power
    350
    Does seem to be php related but sorry i've got no experience of hosting it on windows - have never even tried to install!

  7. #7

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,962
    Thank Post
    1,208
    Thanked 1,074 Times in 765 Posts
    Rep Power
    332
    @mattjporter:

    Did you take a backup before you upgraded the PHP version?

    If so you could uninstall the latest PHP and re-install the last version then import your backup to overwrite the moodle files.

    It is PHP related but not worked on windows version.

    Good luck

  8. #8

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,413
    Thank Post
    642
    Thanked 964 Times in 664 Posts
    Blog Entries
    2
    Rep Power
    327
    The server is sending PHP files as text documents - i.e. it doesn't know that they should be processed via the PHP interpreter. At this stage, it has nothing to do with MySQL (even though it may or may not be working).

    It sounds like upgrading PHP didn't work fully, or at all. Have a look at and use one of these instructions to try and get it working again:

    How To Install PHP on IIS 6.0 » IIS Admin Blog
    Using FastCGI to Host PHP Applications on IIS 6.0 : Host Applications on the Microsoft Web Platform : Running PHP Applications on IIS : The Official Microsoft IIS Site

    Side note: due to the error, your passwords are exposed. Optionally change the webroot to somewhere safe, so that Joomla/Moodle aren't made available until fixed; but change your MySQL passwords for the Joomla/Moodle users.

  9. #9

    Join Date
    May 2011
    Posts
    11
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Webman

    I have followed the second guide through right to the end and all the php coding that was appearing on the Moodle is now replaced by:

    Error: Database connection failed.

    It is possible that the database is overloaded or otherwise not running properly.

    The site administrator should also check that the database details have been correctly specified in config.php

    I still can't get into the MySQL?

    The website still has all of the code on still

    http://www.layton.blackpool.sch.uk
    http://www.layton.blackpool.sch.uk/moodle

  10. #10

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,413
    Thank Post
    642
    Thanked 964 Times in 664 Posts
    Blog Entries
    2
    Rep Power
    327
    OK. Looks like you got PHP installed and working - that's good. But now Joomla and Moodle can't connect to MySQL. Either:

    a) MySQL is not running or a firewall is interfering with it.
    b) MySQL is running, you changed the passwords for the MySQL users, but didn't update the config files for Joomla and Moodle.
    c) PHP hasn't got the MySQL extension enabled or installed.

    To check for (A) - look for the MySQL service, and search event viewer/log files for any errors relating to MySQL.
    For (B), just edit the config files for Joomla and Moodle, updating the password to the one that you changed it to for both applications.
    And (C), you need to find out if the extension is installed. To do this, create a new PHP file with the following contents and save it in the webroot somewhere, as info.php:

    Code:
    <?php phpinfo() ?>
    Then browse to that file. Ctrl + F to look for 'mysql' - there should be an entry there for it, about half way down the page, with a table underneath with the version and some settings.

  11. #11

    Join Date
    May 2011
    Posts
    11
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    The MySQL service will not start, when trying to start it, the following error is given:

    Could not start the MySQL service on Local Computer.
    Error 1067: The process terminated unexpectedly.

  12. #12

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,413
    Thank Post
    642
    Thanked 964 Times in 664 Posts
    Blog Entries
    2
    Rep Power
    327
    Are there any entries made in the event viewer when you attempt to start it?

  13. #13

    Join Date
    May 2011
    Posts
    11
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    There are a number of entries each time i try to start the service:

    Warning
    Event Type: Warning
    Event Source: MySQL
    Event Category: None
    Event ID: 100
    Date: 17/05/2011
    Time: 10:43:17
    User: N/A
    Computer: MAIL
    Description:
    The description for Event ID ( 100 ) in Source ( MySQL ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Changed limits: max_open_files: 2048 max_connections: 800 table_cache: 619

    Error
    Event Type: Error
    Event Source: MySQL
    Event Category: None
    Event ID: 100
    Date: 17/05/2011
    Time: 10:43:17
    User: N/A
    Computer: MAIL
    Description:
    The description for Event ID ( 100 ) in Source ( MySQL ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Error message file 'D:\server\mysql\share\english\errmsg.sys' had only 475 error messages,
    but it should contain at least 641 error messages.
    Check that the above file is the right version for this program!

    Information
    Event Type: Information
    Event Source: MySQL
    Event Category: None
    Event ID: 100
    Date: 17/05/2011
    Time: 10:43:17
    User: N/A
    Computer: MAIL
    Description:
    The description for Event ID ( 100 ) in Source ( MySQL ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Plugin 'FEDERATED' is disabled.

    Error
    Event Type: Error
    Event Source: MySQL
    Event Category: None
    Event ID: 100
    Date: 17/05/2011
    Time: 10:43:17
    User: N/A
    Computer: MAIL
    Description:
    The description for Event ID ( 100 ) in Source ( MySQL ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

    Error
    Event Type: Error
    Event Source: MySQL
    Event Category: None
    Event ID: 100
    Date: 17/05/2011
    Time: 10:43:18
    User: N/A
    Computer: MAIL
    Description:
    The description for Event ID ( 100 ) in Source ( MySQL ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Aborting

    Information
    Event Type: Information
    Event Source: MySQL
    Event Category: None
    Event ID: 100
    Date: 17/05/2011
    Time: 10:43:19
    User: N/A
    Computer: MAIL
    Description:
    The description for Event ID ( 100 ) in Source ( MySQL ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event:

  14. #14

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,413
    Thank Post
    642
    Thanked 964 Times in 664 Posts
    Blog Entries
    2
    Rep Power
    327
    What about the contents of the mysql.err file in the MySQL data directory?

  15. #15

    Join Date
    May 2011
    Posts
    11
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    110517 10:43:17 [Note] Plugin 'FEDERATED' is disabled.
    d:\server\mysql\bin\mysqld: Unknown error 1146
    110517 10:43:17 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
    110517 10:43:18 InnoDB: Started; log sequence number 0 44233
    d:\server\mysql\bin\mysqld: Too many arguments (first extra is '=defaults-file=d:\server\mysql\bin\my.ini').
    Use --verbose --help to get a list of available options
    110517 10:43:18 [ERROR] Aborting

    110517 10:43:18 InnoDB: Starting shutdown...
    110517 10:43:19 InnoDB: Shutdown completed; log sequence number 0 44233
    110517 10:43:19 [Note]

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. PHP/MySQL
    By Silvor in forum Coding
    Replies: 2
    Last Post: 12th May 2010, 02:52 PM
  2. Best Site to learn php and mysql?
    By My220x in forum Coding
    Replies: 11
    Last Post: 23rd April 2008, 08:58 AM
  3. Can't get mysql and PHP to play together on IIS
    By dagza in forum Web Development
    Replies: 5
    Last Post: 20th January 2008, 03:38 PM
  4. PHP MYSQL Hit counter
    By Nij.UK in forum Web Development
    Replies: 9
    Last Post: 15th November 2006, 09:11 AM
  5. php MySql
    By iking in forum Books and Manuals
    Replies: 0
    Last Post: 11th July 2005, 03:35 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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