R0.25 No Longer Supported

Joomdle and MSSQL

  • anton fluekiger
  • Topic Author
  • Offline
  • New Member
  • New Member
More
15 years 8 months ago - 15 years 8 months ago #1 by anton fluekiger
Joomdle and MSSQL was created by anton fluekiger
Hello

I try to install joomdle on a moodle which is working with MSSQL.

In notifications I have 16 script failures and I found no information into the web.
The sequence starts with the following sequence (see at the end of the mail.)
At the end the "2601: The statement has been terminated." is repeated 15 times in variations to the end.

My questions: Has anyone a clue what is happening?
Is Joomdle working with MSSQL?

Thank you for checking
Toni


(mssql): SELECT name FROM sysobjects WHERE lower(name) = 'mdl_joomdumm_id_pk' (mssql): SELECT name FROM sysobjects WHERE lower(name) = 'mdl_joomdumm_id2_pk' (mssql): CREATE TABLE mdl_joomdle_dummytable ( id BIGINT NOT NULL IDENTITY(1,1), CONSTRAINT mdl_joomdumm_id2_pk PRIMARY KEY (id) ) 2714: There is already an object named 'mdl_joomdle_dummytable' in the database.

ADOConnection._Execute(CREATE TABLE mdl_joomdle_dummytable (
id BIGINT NOT NULL IDENTITY(1,1),
CONSTRAINT mdl_joomdumm_id2_pk PRIMARY KEY (id)
), false) % line 891, file: adodb.inc.php
ADOConnection.Execute(CREATE TABLE mdl_joomdle_dummytable (
id BIGINT NOT NULL IDENTITY(1,1),
CONSTRAINT mdl_joomdumm_id2_pk PRIMARY KEY (id)
)) % line 89, file: dmllib.php
execute_sql(CREATE TABLE mdl_joomdle_dummytable (
id BIGINT NOT NULL IDENTITY(1,1),
CONSTRAINT mdl_joomdumm_id2_pk PRIMARY KEY (id)
), true) % line 2298, file: dmllib.php
execute_sql_arr(Array[14]) % line 635, file: ddllib.php
install_from_xmldb_file(C:\Soft\Moodle\server\moodle/auth/joomdle/db/install.xml) % line 137, file: adminlib.php

Scroll to previous warningErrorScroll to next warning
(mssql): INSERT INTO mdl_mnet_host2service(hostid, serviceid, publish) VALUES ('0', '4', '1') 2601: The statement has been terminated.

ADOConnection._Execute(INSERT INTO mdl_mnet_host2service(hostid, serviceid, publish) VALUES ('0', '4', '1'), false) % line 891, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO mdl_mnet_host2service(hostid, serviceid, publish) VALUES ('0', '4', '1')) % line 89, file: dmllib.php
execute_sql(INSERT INTO mdl_mnet_host2service(hostid, serviceid, publish) VALUES ('0', '4', '1'), true) % line 2298, file: dmllib.php
execute_sql_arr(Array[14]) % line 635, file: ddllib.php
install_from_xmldb_file(C:\Soft\Moodle\server\moodle/auth/joomdle/db/install.xml) % line 137, file: adminlib.php
Last edit: 15 years 8 months ago by anton fluekiger.

Please Log in or Create an account to join the conversation.

More
15 years 8 months ago #2 by Antonio Durán
Replied by Antonio Durán on topic Re: Joomdle and MSSQL
Hi.

This has nothing to do with MSSQL.

To solve it, look here:
www.joomdle.com/wiki/System_health_check...e_Web_Services_setup

Please Log in or Create an account to join the conversation.