MantisBT - ATutor
View Issue Details
0003565ATutorInstallationpublic2008-09-11 04:532008-11-14 08:23
greg 
harris 
normalminoralways
closedfixed 
 
1.6.2 
SVN
0003565: ALTER db to UTF-8
Can the installer run the ALTER statement to switch the db char set to UTF-8, instead of requiring the user to run the cammand manually.

http://www.atutor.ca/view/7/15126/1.html [^]
No tags attached.
Issue History
2008-09-11 04:53gregNew Issue
2008-09-11 04:53gregAffects version => SVN
2008-10-02 07:16harrisNote Added: 0003208
2008-10-02 07:30harrisNote Added: 0003209
2008-10-02 08:08harrisStatusnew => assigned
2008-10-02 08:08harrisAssigned To => harris
2008-10-02 08:08harrisStatusassigned => resolved
2008-10-02 08:08harrisFixed in Version => 1.6.2
2008-10-02 08:08harrisResolutionopen => fixed
2008-10-02 08:08harrisNote Added: 0003210
2008-11-14 08:23gregStatusresolved => closed

Notes
(0003208)
harris   
2008-10-02 07:16   
I think, not many hosting company would grant the users the privileges to modify the database. Probably just the tables...


ref: http://dev.mysql.com/doc/refman/5.0/en/alter-database.html [^]
"To use ALTER DATABASE, you need the ALTER privilege on the database."
(0003209)
harris   
2008-10-02 07:30   
Change it to:

result = sql(alter db)

if !result:
  print error msg - need the alter privilege.
(0003210)
harris   
2008-10-02 08:08   
7992