+ Post New Thread
Results 1 to 1 of 1
Virtual Learning Platforms Thread, Our Moodle Problem in Technical; ...
  1. #1
    pritchardavid's Avatar
    Join Date
    Sep 2009
    Location
    South Ockendon, Thurrock, United Kingdom
    Posts
    932
    Thank Post
    18
    Thanked 64 Times in 58 Posts
    Rep Power
    26

    Our Moodle Problem




    Problem



    ·
    Last week
    we had an automatic upgrade on Moodle



    ·
    Everytime
    we tried to do the upgrade it would come back with an error saying “can not
    upgrade due to Upgrade_log already existing.



    ·
    Searched
    for upgrade_log but couldn’t find it on webserver



    ·
    Searched
    online for diagnosis via moodle site but didn’t have much luck concerning the
    error.



    ·
    Came
    across one person who had the same issue and they fixed it by doing a fresh
    install.



    ·
    Backed up
    our data and tried to do a fresh install but had a problem with our dump file,
    it had an error.



    ·
    The
    original error had error code 1045 which was referring to a root password, I
    managed to sort that



    ·
    Tried
    again and came up with another error “ERROR 1064 (42000) at line 10665: You
    have an error in your SQL syntax”



    ·
    Been
    trying to fix this but not have any luck. Tried what was suggested on http://www.ehow.com/how_2036644_import-sql-database.html
    with the command line but it had the same issue.



    ·
    Currently trying http://www.phpmag.ru/2009/08/02/mysql-error-1064-42000-when-importing-sql-dumps/
    Everytime I put in a command I keep getting the ERROR 1064 (42000)



    ·
    ERROR
    1064 (42000): 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 '' at line 1





    Any ideas would be good guys

    Its my work colleague that dealing with this problem, so if any question you need answered, i'll have to ask him

    Thanks
    Last edited by pritchardavid; 3rd February 2011 at 09:28 AM.

SHARE:
+ Post New Thread

Similar Threads

  1. Moodle Install Problem
    By Kekerusey in forum Virtual Learning Platforms
    Replies: 3
    Last Post: 21st December 2010, 12:37 PM
  2. Moodle Problem
    By pritchardavid in forum Virtual Learning Platforms
    Replies: 5
    Last Post: 8th November 2010, 04:46 PM
  3. Moodle - Problem
    By wesleyw in forum Virtual Learning Platforms
    Replies: 8
    Last Post: 9th November 2006, 09:07 AM
  4. Moodle Problem.
    By Quackers in forum Virtual Learning Platforms
    Replies: 3
    Last Post: 18th September 2006, 03:42 PM
  5. Moodle Problem
    By jamieallonby in forum Virtual Learning Platforms
    Replies: 2
    Last Post: 16th May 2006, 06:54 AM

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
  •