- Posts: 3
R0.25 No Longer Supported
Joomdle and MSSQL
- anton fluekiger
- Topic Author
- Offline
- New Member
-
Less
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
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.
- Antonio Durán
-
- Offline
- Moderator
-
Less
More
- Posts: 7926
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
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.