I was told that I could flag new features on 5.0.21. I believe that I have a problem with mysql and heard that this might help. I have only heard of this and we both didn't know how or if it would work. Any clues? I am completely lost and don't blame anyone if this looses them too.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
my.cnf
- Thread starter mikel25
- Start date
TonyGroves
Programmer
You're not the only one who's lost. Can you explain your problem a bit better please?
- Thread starter
- #3
Sorry, let me begin saying that I am very new to mysql. I had recently upgraded from a iMac running OS X and mysql 4.1.21 to a PC on Win XP running mysql 5.0.21. In this transition, the site I am working on no longer works the same in that when I want to remove items I can't. I checked the php coding and it looked right and worked except for this little issue. So I was told that if I could find a way to flag the new features in mysql 5.0.21, then the site would run as if it were a older version of mysql. We didn't know a way to do this or if it were possible, so I thought that I would ask if anyone knew how to.
TonyGroves
Programmer
MySQL 5.0.21 should be totally backwards-compatible with 4.1.21 (except possibly for some obscure deprecated features). If you're finding that you can't do things you used to be able to do before, then it's probably a user-permissions problem. Have you checked that the user concerned has delete permissions on the table in question?
- Thread starter
- #5
- Thread starter
- #7
I don't see any missing tables. Everything seems to be right. Man this thing has been buggin me for days now. It just that the site works perfectly in the older version of mysql on the iMac. Maybe it's not mysql. I'm all confused now. Thanks for the help.
TonyGroves
Programmer
As lgarner pointed out, the best way to find out what the problem is is to run the same query in a generic MySQL interface where error messages will be shown. Get your PHP script to print out the query that it sends to MySQL, then using a program such as the MySQL command-line client (or a GUI program such as MySQL Query Browser), connect to the database using the same user's credentials, and run the query. If it doesn't work, then the error message will explain why.
Also, you can check user permissions simply by running a query on the mysql.user table: "SELECT * FROM mysql.user".
Also, you can check user permissions simply by running a query on the mysql.user table: "SELECT * FROM mysql.user".
- Thread starter
- #9
Ok, I went and turned on debug on the moodle site that I'm working on. Hopefully this will shed some light on my problem. This is what I get before I decide to remove my file...
(mysql): SELECT * FROM mdl_config WHERE name = 'unicodedb' LIMIT 1
(mysql): SET NAMES 'utf8'
(mysql): SELECT * FROM mdl_config
(mysql): SELECT * FROM mdl_course WHERE category = '0' LIMIT 100
(mysql): SELECT * FROM mdl_course_modules WHERE id = '8' LIMIT 100
(mysql): SELECT * FROM mdl_assignment WHERE id = '7' LIMIT 100
(mysql): SELECT * FROM mdl_course WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_course WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' AND course = '2' LIMIT 1
(mysql): SELECT * FROM mdl_course_categories WHERE id = '1' LIMIT 100
(mysql): SELECT * FROM mdl_course_categories WHERE id IN (1,1) ORDER BY depth DESC
(mysql): SELECT * FROM mdl_user_admins WHERE userid = '2' LIMIT 1 (mysql): SELECT * FROM mdl_course_modules WHERE id = '8' LIMIT 100
(mysql): SELECT * FROM mdl_course WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_assignment WHERE id = '7' LIMIT 100
(mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' AND course = '2' LIMIT 1
(mysql): SELECT section,visible,summary FROM mdl_course_sections WHERE course = '2' ORDER BY section
test 1
Jump to...Assignment 2
You are here,
* Sam
* ts1
* Assignments
* Assignment
(mysql): SELECT COUNT(*) FROM mdl_message WHERE useridto = '4' AND timecreated > '0'
(mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' AND course = '2' LIMIT 1
(mysql): SELECT * FROM mdl_assignment_submissions WHERE assignment = '7' AND userid = '4' LIMIT 100
(mysql): SELECT * FROM mdl_cache_text WHERE md5key = '471658ff2bebf4b0da7817e30d9b8e75' LIMIT 1
(mysql): SHOW COLUMNS FROM mdl_cache_text
(mysql): UPDATE mdl_cache_text SET md5key = '471658ff2bebf4b0da7817e30d9b8e75', formattedtext = '', timemodified = '1151699071' WHERE id = '3'
Available from: Wednesday, 21 June 2006, 01:15 PM
Due date: Tuesday, 27 June 2006, 11:05 AM
(mysql): SELECT * FROM mdl_assignment_submissions WHERE assignment = '7' AND userid = '4' LIMIT 100
(mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' AND course = '2' LIMIT 1
(mysql): SELECT * FROM mdl_assignment_submissions WHERE assignment = '7' AND userid = '4' LIMIT 100
text.gifassignment1.txt [19 bytes][Remove]
Submission status: Draft
(mysql): SELECT * FROM mdl_user WHERE id = '4' AND username = 'guest' LIMIT 1
Step 1: Attach file(s) to assignment (Max size: 16MB)
Step 2: Submit assignment for marking.
Once the assignment is sent for marking, you will no longer be able to delete or attach file(s).
(mysql): SELECT * FROM mdl_user WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_user WHERE id = '4' AND username = 'guest' LIMIT 1
(mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' LIMIT 1
------------------------------------------------------------
this is what I get when I click on remove...
(mysql): SELECT * FROM mdl_config WHERE name = 'unicodedb' LIMIT 1
(mysql): SET NAMES 'utf8'
(mysql): SELECT * FROM mdl_config
(mysql): SELECT * FROM mdl_course WHERE category = '0' LIMIT 100
(mysql): SELECT * FROM mdl_course_modules WHERE id = '8' LIMIT 100
(mysql): SELECT * FROM mdl_assignment WHERE id = '7' LIMIT 100
(mysql): SELECT * FROM mdl_course WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_course WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' AND course = '2' LIMIT 1
(mysql): SELECT * FROM mdl_course_categories WHERE id = '1' LIMIT 100
(mysql): SELECT * FROM mdl_course_categories WHERE id IN (1,1) ORDER BY depth DESC
(mysql): SELECT * FROM mdl_user_admins WHERE userid = '2' LIMIT 1
(mysql): SELECT * FROM mdl_course_modules WHERE id = '8' LIMIT 100
(mysql): SELECT * FROM mdl_course WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_assignment WHERE id = '7' LIMIT 100
(mysql): SELECT * FROM mdl_assignment_submissions WHERE assignment = '7' AND userid = '4' LIMIT 100
(mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' AND course = '2' LIMIT 1
(mysql): SELECT section,visible,summary FROM mdl_course_sections WHERE course = '2' ORDER BY section
test 1
Jump to...Assignment 2
You are here,
* Sam
* ts1
* Assignments
* Assignment
(mysql): SELECT COUNT(*) FROM mdl_message WHERE useridto = '4' AND timecreated > '0'
(mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' AND course = '2' LIMIT 1
(mysql): SELECT * FROM mdl_assignment_submissions WHERE assignment = '7' AND userid = '4' LIMIT 100
You about to delete this file:
assignment1.txt
Are you absolutely sure you want to delete this file?
(mysql): SELECT * FROM mdl_user WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_user WHERE id = '4' AND username = 'guest' LIMIT 1
(mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' LIMIT 1
-----------------------------------------------------------
and then when I agree to removing the file I get this...
(mysql): SELECT * FROM mdl_config WHERE name = 'unicodedb' LIMIT 1
(mysql): SET NAMES 'utf8'
(mysql): SELECT * FROM mdl_config
(mysql): SELECT * FROM mdl_course WHERE category = '0' LIMIT 100
(mysql): SELECT * FROM mdl_course_modules WHERE id = '8' LIMIT 100
(mysql): SELECT * FROM mdl_assignment WHERE id = '7' LIMIT 100
(mysql): SELECT * FROM mdl_course WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_course WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' AND course = '2' LIMIT 1
(mysql): SELECT * FROM mdl_course_categories WHERE id = '1' LIMIT 100
(mysql): SELECT * FROM mdl_course_categories WHERE id IN (1,1) ORDER BY depth DESC
(mysql): SELECT * FROM mdl_user_admins WHERE userid = '2' LIMIT 1
(mysql): SELECT * FROM mdl_course_modules WHERE id = '8' LIMIT 100
(mysql): SELECT * FROM mdl_course WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_assignment WHERE id = '7' LIMIT 100
(mysql): SELECT * FROM mdl_assignment_submissions WHERE assignment = '7' AND userid = '4' LIMIT 100
(mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' AND course = '2' LIMIT 1
(mysql): SELECT section,visible,summary FROM mdl_course_sections WHERE course = '2' ORDER BY section
test 1
Jump to...Assignment 2
You are here,
* Sam
* ts1
* Assignments
* Assignment
(mysql): SELECT COUNT(*) FROM mdl_message WHERE useridto = '4' AND timecreated > '0'
(mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' AND course = '2' LIMIT 1
(mysql): SELECT * FROM mdl_assignment_submissions WHERE assignment = '7' AND userid = '4' LIMIT 100
(mysql): SHOW COLUMNS FROM mdl_assignment_submissions (mysql): UPDATE mdl_assignment_submissions SET assignment = '7', userid = '4', timecreated = '1150920994', timemodified = '0', numfiles = '-1', data1 = 'Draft', data2 = '', grade = '-1', comment = '', format = '0', teacher = '0', timemarked = '0', mailed = '0' WHERE id = '6'
File has been deleted.
(mysql): SELECT * FROM mdl_user WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_user WHERE id = '4' AND username = 'guest' LIMIT 1
(mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' LIMIT 1
-----------------------------------------------------------
and then this is what I get when I click on the back to assignment button...
(mysql): SELECT * FROM mdl_config WHERE name = 'unicodedb' LIMIT 1
(mysql): SET NAMES 'utf8'
(mysql): SELECT * FROM mdl_config
(mysql): SELECT * FROM mdl_course WHERE category = '0' LIMIT 100
(mysql): SELECT * FROM mdl_course_modules WHERE id = '8' LIMIT 100
(mysql): SELECT * FROM mdl_assignment WHERE id = '7' LIMIT 100
(mysql): SELECT * FROM mdl_course WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_course WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' AND course = '2' LIMIT 1
(mysql): SELECT * FROM mdl_course_categories WHERE id = '1' LIMIT 100
(mysql): SELECT * FROM mdl_course_categories WHERE id IN (1,1) ORDER BY depth DESC
(mysql): SELECT * FROM mdl_user_admins WHERE userid = '2' LIMIT 1
(mysql): SELECT * FROM mdl_course_modules WHERE id = '8' LIMIT 100
(mysql): SELECT * FROM mdl_course WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_assignment WHERE id = '7' LIMIT 100
(mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' AND course = '2' LIMIT 1
(mysql): SELECT section,visible,summary FROM mdl_course_sections WHERE course = '2' ORDER BY section
test 1
Jump to...Assignment 2
You are here,
* Sam
* ts1
* Assignments
* Assignment
mysql): SELECT COUNT(*) FROM mdl_message WHERE useridto = '4' AND timecreated > '0'
(mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' AND course = '2' LIMIT 1
(mysql): SELECT * FROM mdl_assignment_submissions WHERE assignment = '7' AND userid = '4' LIMIT 100
(mysql): SELECT * FROM mdl_cache_text WHERE md5key = '471658ff2bebf4b0da7817e30d9b8e75' LIMIT 1
(mysql): SHOW COLUMNS FROM mdl_cache_text
(mysql): UPDATE mdl_cache_text SET md5key = '471658ff2bebf4b0da7817e30d9b8e75', formattedtext = '', timemodified = '1151700058' WHERE id = '3'
Available from: Wednesday, 21 June 2006, 01:15 PM
Due date: Tuesday, 27 June 2006, 11:05 AM
(mysql): SELECT * FROM mdl_assignment_submissions WHERE assignment = '7' AND userid = '4' LIMIT 100
(mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' AND course = '2' LIMIT 1
(mysql): SELECT * FROM mdl_assignment_submissions WHERE assignment = '7' AND userid = '4' LIMIT 100
text.gifassignment1.txt [19 bytes][Remove]
Submission status: Draft
(mysql): SELECT * FROM mdl_user WHERE id = '4' AND username = 'guest' LIMIT 1
Step 1: Attach file(s) to assignment (Max size: 16MB)
Step 2: Submit assignment for marking.
Once the assignment is sent for marking, you will no longer be able to delete or attach file(s).
(mysql): SELECT * FROM mdl_user WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_user WHERE id = '4' AND username = 'guest' LIMIT 1
(mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' LIMIT 1
this is the end of it. I still have my file there after trying to remove it. Hopefully someone can understand this because I don't know what to make of most of it. Thanks.
(mysql): SELECT * FROM mdl_config WHERE name = 'unicodedb' LIMIT 1
(mysql): SET NAMES 'utf8'
(mysql): SELECT * FROM mdl_config
(mysql): SELECT * FROM mdl_course WHERE category = '0' LIMIT 100
(mysql): SELECT * FROM mdl_course_modules WHERE id = '8' LIMIT 100
(mysql): SELECT * FROM mdl_assignment WHERE id = '7' LIMIT 100
(mysql): SELECT * FROM mdl_course WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_course WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' AND course = '2' LIMIT 1
(mysql): SELECT * FROM mdl_course_categories WHERE id = '1' LIMIT 100
(mysql): SELECT * FROM mdl_course_categories WHERE id IN (1,1) ORDER BY depth DESC
(mysql): SELECT * FROM mdl_user_admins WHERE userid = '2' LIMIT 1 (mysql): SELECT * FROM mdl_course_modules WHERE id = '8' LIMIT 100
(mysql): SELECT * FROM mdl_course WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_assignment WHERE id = '7' LIMIT 100
(mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' AND course = '2' LIMIT 1
(mysql): SELECT section,visible,summary FROM mdl_course_sections WHERE course = '2' ORDER BY section
test 1
Jump to...Assignment 2
You are here,
* Sam
* ts1
* Assignments
* Assignment
(mysql): SELECT COUNT(*) FROM mdl_message WHERE useridto = '4' AND timecreated > '0'
(mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' AND course = '2' LIMIT 1
(mysql): SELECT * FROM mdl_assignment_submissions WHERE assignment = '7' AND userid = '4' LIMIT 100
(mysql): SELECT * FROM mdl_cache_text WHERE md5key = '471658ff2bebf4b0da7817e30d9b8e75' LIMIT 1
(mysql): SHOW COLUMNS FROM mdl_cache_text
(mysql): UPDATE mdl_cache_text SET md5key = '471658ff2bebf4b0da7817e30d9b8e75', formattedtext = '', timemodified = '1151699071' WHERE id = '3'
Available from: Wednesday, 21 June 2006, 01:15 PM
Due date: Tuesday, 27 June 2006, 11:05 AM
(mysql): SELECT * FROM mdl_assignment_submissions WHERE assignment = '7' AND userid = '4' LIMIT 100
(mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' AND course = '2' LIMIT 1
(mysql): SELECT * FROM mdl_assignment_submissions WHERE assignment = '7' AND userid = '4' LIMIT 100
text.gifassignment1.txt [19 bytes][Remove]
Submission status: Draft
(mysql): SELECT * FROM mdl_user WHERE id = '4' AND username = 'guest' LIMIT 1
Step 1: Attach file(s) to assignment (Max size: 16MB)
Step 2: Submit assignment for marking.
Once the assignment is sent for marking, you will no longer be able to delete or attach file(s).
(mysql): SELECT * FROM mdl_user WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_user WHERE id = '4' AND username = 'guest' LIMIT 1
(mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' LIMIT 1
------------------------------------------------------------
this is what I get when I click on remove...
(mysql): SELECT * FROM mdl_config WHERE name = 'unicodedb' LIMIT 1
(mysql): SET NAMES 'utf8'
(mysql): SELECT * FROM mdl_config
(mysql): SELECT * FROM mdl_course WHERE category = '0' LIMIT 100
(mysql): SELECT * FROM mdl_course_modules WHERE id = '8' LIMIT 100
(mysql): SELECT * FROM mdl_assignment WHERE id = '7' LIMIT 100
(mysql): SELECT * FROM mdl_course WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_course WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' AND course = '2' LIMIT 1
(mysql): SELECT * FROM mdl_course_categories WHERE id = '1' LIMIT 100
(mysql): SELECT * FROM mdl_course_categories WHERE id IN (1,1) ORDER BY depth DESC
(mysql): SELECT * FROM mdl_user_admins WHERE userid = '2' LIMIT 1
(mysql): SELECT * FROM mdl_course_modules WHERE id = '8' LIMIT 100
(mysql): SELECT * FROM mdl_course WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_assignment WHERE id = '7' LIMIT 100
(mysql): SELECT * FROM mdl_assignment_submissions WHERE assignment = '7' AND userid = '4' LIMIT 100
(mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' AND course = '2' LIMIT 1
(mysql): SELECT section,visible,summary FROM mdl_course_sections WHERE course = '2' ORDER BY section
test 1
Jump to...Assignment 2
You are here,
* Sam
* ts1
* Assignments
* Assignment
(mysql): SELECT COUNT(*) FROM mdl_message WHERE useridto = '4' AND timecreated > '0'
(mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' AND course = '2' LIMIT 1
(mysql): SELECT * FROM mdl_assignment_submissions WHERE assignment = '7' AND userid = '4' LIMIT 100
You about to delete this file:
assignment1.txt
Are you absolutely sure you want to delete this file?
(mysql): SELECT * FROM mdl_user WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_user WHERE id = '4' AND username = 'guest' LIMIT 1
(mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' LIMIT 1
-----------------------------------------------------------
and then when I agree to removing the file I get this...
(mysql): SELECT * FROM mdl_config WHERE name = 'unicodedb' LIMIT 1
(mysql): SET NAMES 'utf8'
(mysql): SELECT * FROM mdl_config
(mysql): SELECT * FROM mdl_course WHERE category = '0' LIMIT 100
(mysql): SELECT * FROM mdl_course_modules WHERE id = '8' LIMIT 100
(mysql): SELECT * FROM mdl_assignment WHERE id = '7' LIMIT 100
(mysql): SELECT * FROM mdl_course WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_course WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' AND course = '2' LIMIT 1
(mysql): SELECT * FROM mdl_course_categories WHERE id = '1' LIMIT 100
(mysql): SELECT * FROM mdl_course_categories WHERE id IN (1,1) ORDER BY depth DESC
(mysql): SELECT * FROM mdl_user_admins WHERE userid = '2' LIMIT 1
(mysql): SELECT * FROM mdl_course_modules WHERE id = '8' LIMIT 100
(mysql): SELECT * FROM mdl_course WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_assignment WHERE id = '7' LIMIT 100
(mysql): SELECT * FROM mdl_assignment_submissions WHERE assignment = '7' AND userid = '4' LIMIT 100
(mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' AND course = '2' LIMIT 1
(mysql): SELECT section,visible,summary FROM mdl_course_sections WHERE course = '2' ORDER BY section
test 1
Jump to...Assignment 2
You are here,
* Sam
* ts1
* Assignments
* Assignment
(mysql): SELECT COUNT(*) FROM mdl_message WHERE useridto = '4' AND timecreated > '0'
(mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' AND course = '2' LIMIT 1
(mysql): SELECT * FROM mdl_assignment_submissions WHERE assignment = '7' AND userid = '4' LIMIT 100
(mysql): SHOW COLUMNS FROM mdl_assignment_submissions (mysql): UPDATE mdl_assignment_submissions SET assignment = '7', userid = '4', timecreated = '1150920994', timemodified = '0', numfiles = '-1', data1 = 'Draft', data2 = '', grade = '-1', comment = '', format = '0', teacher = '0', timemarked = '0', mailed = '0' WHERE id = '6'
File has been deleted.
(mysql): SELECT * FROM mdl_user WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_user WHERE id = '4' AND username = 'guest' LIMIT 1
(mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' LIMIT 1
-----------------------------------------------------------
and then this is what I get when I click on the back to assignment button...
(mysql): SELECT * FROM mdl_config WHERE name = 'unicodedb' LIMIT 1
(mysql): SET NAMES 'utf8'
(mysql): SELECT * FROM mdl_config
(mysql): SELECT * FROM mdl_course WHERE category = '0' LIMIT 100
(mysql): SELECT * FROM mdl_course_modules WHERE id = '8' LIMIT 100
(mysql): SELECT * FROM mdl_assignment WHERE id = '7' LIMIT 100
(mysql): SELECT * FROM mdl_course WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_course WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' AND course = '2' LIMIT 1
(mysql): SELECT * FROM mdl_course_categories WHERE id = '1' LIMIT 100
(mysql): SELECT * FROM mdl_course_categories WHERE id IN (1,1) ORDER BY depth DESC
(mysql): SELECT * FROM mdl_user_admins WHERE userid = '2' LIMIT 1
(mysql): SELECT * FROM mdl_course_modules WHERE id = '8' LIMIT 100
(mysql): SELECT * FROM mdl_course WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_assignment WHERE id = '7' LIMIT 100
(mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' AND course = '2' LIMIT 1
(mysql): SELECT section,visible,summary FROM mdl_course_sections WHERE course = '2' ORDER BY section
test 1
Jump to...Assignment 2
You are here,
* Sam
* ts1
* Assignments
* Assignment
mysql): SELECT COUNT(*) FROM mdl_message WHERE useridto = '4' AND timecreated > '0'
(mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' AND course = '2' LIMIT 1
(mysql): SELECT * FROM mdl_assignment_submissions WHERE assignment = '7' AND userid = '4' LIMIT 100
(mysql): SELECT * FROM mdl_cache_text WHERE md5key = '471658ff2bebf4b0da7817e30d9b8e75' LIMIT 1
(mysql): SHOW COLUMNS FROM mdl_cache_text
(mysql): UPDATE mdl_cache_text SET md5key = '471658ff2bebf4b0da7817e30d9b8e75', formattedtext = '', timemodified = '1151700058' WHERE id = '3'
Available from: Wednesday, 21 June 2006, 01:15 PM
Due date: Tuesday, 27 June 2006, 11:05 AM
(mysql): SELECT * FROM mdl_assignment_submissions WHERE assignment = '7' AND userid = '4' LIMIT 100
(mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' AND course = '2' LIMIT 1
(mysql): SELECT * FROM mdl_assignment_submissions WHERE assignment = '7' AND userid = '4' LIMIT 100
text.gifassignment1.txt [19 bytes][Remove]
Submission status: Draft
(mysql): SELECT * FROM mdl_user WHERE id = '4' AND username = 'guest' LIMIT 1
Step 1: Attach file(s) to assignment (Max size: 16MB)
Step 2: Submit assignment for marking.
Once the assignment is sent for marking, you will no longer be able to delete or attach file(s).
(mysql): SELECT * FROM mdl_user WHERE id = '2' LIMIT 100 (mysql): SELECT * FROM mdl_user WHERE id = '4' AND username = 'guest' LIMIT 1
(mysql): SELECT * FROM mdl_user_teachers WHERE userid = '4' LIMIT 1
this is the end of it. I still have my file there after trying to remove it. Hopefully someone can understand this because I don't know what to make of most of it. Thanks.
TonyGroves
Programmer
Sorry, that's too much to provide us with any useful information. You'll have to identify the statement that's causing the problem, and let us know what the error message says.
- Status