Jump to ContentJump to Navigation/Login
` ` ` ` ` `

Login
[Register]

Subscribe to Updates

Occasional ATutor release updates


Services

Members Online

No Members Logged In

(4 guests in past 15 min.)

Web Accessibility Course

Access Understanding Web Accessibility to learn about accessibility, or Register to take the course for FREE.

Home > Forums > ATutor Bug Reports > command to change, default value of allow test export to 1 in at content table

Support Forums

ATutor Bug Reports

command to change, default value of allow_test_export to 1 in at_content table


You must be signed-in to post.

AuthorSubject
  Page: 1
sachin
Subject: command to change, default value of allow_test_export to 1 in at_content tableQuote this post in your reply
Hi Greg,

I got the at_content table.

Please send me the mysql command to change the
default value of allow_test_export to '1' in
at_content table.

Thank you.

With regards
Sachin
Posted: 2009-06-04 07:37:45
greg

Avatar for greg
Subject: Re: command to change, default value of allow_test_export to 1 in at_content tableQuote this post in your reply
You do not need a mysql command. Use phpMyAdmin to make changes.
Posted: 2009-06-04 09:14:32
sachin
Subject: Re: command to change, default value of allow_test_export to 1 in at_content tableQuote this post in your reply
Hi Greg,

Thanks a lot.

yesterday I got the procedure to view at_content
table in text mode. Therefore I asked for mysql
command to type in text.

today I got at_content table in graphical mode.

Thanks once again.

now the problem is if i give 1 in "allow_test_export"
"value" column it does'nt accept it instead it gives
error.

please help.

with regards
sachin
Posted: 2009-06-05 06:39:54
greg

Avatar for greg
Subject: Re: command to change, default value of allow_test_export to 1 in at_content tableQuote this post in your reply
To make tests exportable you set the value in the content editor under the Tests & Survey tab. Tests can then be exported with content packages.

There is no way for students to export test otherwise.

Again, changing the value to "1" is quite straight forward with phpMyAdmin, but here what the SQL might look like.


<?php

ALTER TABLE `at_content` CHANGE `allow_test_export` `allow_test_export` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '1'
?>
Posted: 2009-06-05 08:32:41
sachin
Subject: Re: command to change, default value of allow_test_export to 1 in at_content tableQuote this post in your reply
Hi Greg,

I gave directly in at_content table the value of
"allow_test_export" to 1.

It is not accepting the value while giving directly.

It gives error.

why is that so.

with regards
Sachin
Posted: 2009-06-05 09:56:37
greg

Avatar for greg
Subject: Re: command to change, default value of allow_test_export to 1 in at_content tableQuote this post in your reply
I can't say why you are experiencing a problem. It works fine for me.

You should be using the the content editor to set this value. Avoid editing the database directly. These values are not intended to be edited directly, and we can't really devote time to helping you do that.
Posted: 2009-06-05 10:01:45
 Page: 1

You must be signed-in to post.