Thanks for your thoughts. I've no doubt this is a MSSQL problem. We're
using MSSQL2005 and I'm not familiar with the new layout so it maybe
something I've done. We do have a reliable version of Moodle running on
MySQL but we would like to talk to the DB using some MS tools and the
job seems more difficult when the DB is MySQL, hence trying Moodle
running on MSSQL.
I'll try the moodle forums, many thanks.
Steven
-----Original Message-----
From: Virtual Learning Environments [mailto:[log in to unmask]] On
Behalf Of Tony Delahunty
Sent: 16 January 2007 16:37
To: [log in to unmask]
Subject: Re: [VLES] Moodle on MSSQL error
Hard to say for sure, and the Moodle.org Forums are definitely the best
place to get help with this kind of thing; but I'd guess MSSQL is more
the issue than PHP. The vast majority of Moodle installations are still
on Mysql, often I think becaue they gave up, after stumbling on problems
when trying to install with some other DBMS. You could try installing
MySQL and then repeat your Moodle install with that to at least isolate
your issue to MSSQL; and then decide how important it is to use your
preferred database setup. You could also try the PHP upgrade if you've
not already got loads of stuff running under your current version: it's
probably not that complex to upgrade.
Tony
________________________________
From: Virtual Learning Environments on behalf of Steven Wood
Sent: Tue 16/01/2007 12:19
To: [log in to unmask]
Subject: [VLES] Moodle on MSSQL error
Hi all,
I'm using the latest Moodle build (1.7) with PHP 5.1.4 and Apache on a
Windows 2003 server running MSSQL 2005. The initial installation went
well (install.php) but after I accept the GPL licence and the
/admin/index.php page is shown for the first time, the error 'A problem
occurred inserting current version into databases' is shown. Looking at
the database all the tables have been created and the database user is
owner of the db. I don't think this is a permissions problem. According
to the Moodle forums this error has been seen on Linux and using Mysql
but unfortunately the fix was upgrade the version of PHP 5.1.4 which
I've been using all along. Can anyone shed any light on this error?
Many thanks
Steven Wood
Network Manager
Oldham Sixth Form College
-------------------------------------------------------------------
This email is from Oldham Sixth Form College, but expresses the views
of the sender and not necessarily the views of the college. The email
and any files transmitted with it are confidential to the intended
recipient at the e-mail address to which it has been addressed. It may
not be disclosed or used by any other than that addressee, nor may it
be copied in any way. If received in error, please notify
[log in to unmask] quoting the name of the sender.
This message has been scanned for viruses by F-Secure Anti-Virus.
Please note that we cannot accept any responsibility for any
transmitted viruses. It is, therefore, your responsibility to scan
attachments (if any).
***************** List information: ***************** Remember - replies
go by default to the entire list. Access the list via the web on
http://www.jiscmail.ac.uk/lists/vle.html To unsubscribe, email
[log in to unmask] with the message: leave vle
***************** List information: *****************
Remember - replies go by default to the entire list.
Access the list via the web on http://www.jiscmail.ac.uk/lists/vle.html
To unsubscribe, email [log in to unmask] with the message: leave
vle
-------------------------------------------------------------------
This email is from Oldham Sixth Form College, but expresses the views
of the sender and not necessarily the views of the college. The email
and any files transmitted with it are confidential to the intended
recipient at the e-mail address to which it has been addressed. It may
not be disclosed or used by any other than that addressee, nor may it
be copied in any way. If received in error, please notify
[log in to unmask] quoting the name of the sender.
This message has been scanned for viruses by F-Secure Anti-Virus.
Please note that we cannot accept any responsibility for any
transmitted viruses. It is, therefore, your responsibility to scan
attachments (if any).
***************** List information: *****************
Remember - replies go by default to the entire list.
Access the list via the web on http://www.jiscmail.ac.uk/lists/vle.html
To unsubscribe, email [log in to unmask] with the message: leave vle
|