2008-07-22 03:00:18
I used upgrade from 1.5 to 1.6.1 but some alteration failed,here is the list:
Error
* Table AT_groups alteration failed.
* Table AT_resource_categories alteration failed.
* Table AT_links_categories alteration failed.
* Table AT_resource_links alteration failed.
* Table AT_links alteration failed.
other alterations done succesfully
I use farsi language in Atutor,is it for that?
so what's the solution?
2008-07-22 09:39:06
The upgrade from 1.5 to 1.6.1 seems to be working fine when we just tested it locally.
Does your database user have ALTER table permission?
Have you made any changes to the tables listed above?
2008-07-23 01:16:10
only these alterations failed so i think if it could alter others it has permissions.
No we didn't make any change to tables.
can I send these tables to u to see what's the problem,I need to upgrade really!
thanks
2008-07-23 09:42:21
Hello,
I have just tried an upgrade from 1.5.0 to 1.6.1, and I don't see your errors.
Try restoring your database and update again. You might have refreshed your browser and made the installer to update your database for the second time.
2008-07-27 23:13:32
yes without farsi language and my own database content (I mean with an empty database) I also can upgrade,but with farsi and with my database it has problem
no I don't refresh my database! It cause errors at first upgrade attempt.
can I send anything to u for more help? e.g. my database or something else?
regard
2008-07-27 23:19:28
no I don't refresh my *browser
2008-07-28 12:19:30
Try converting a couple of your courses to UTF-8 manually with the conversion utility, and let us know what happens. Perhaps the conversion utility in ATutor, the same as atutor.ca, is having trouble with the old farsi character set.
http://www.atutor.ca/atutor/translate/convert.php
2008-07-29 01:49:04
I use this zip file for conversion tools but it said :
"No file selected. Only ZIP files are allowed. Must be named atutor_version.zip"
2008-07-29 10:25:26
There is nothing in the zip file.
Install the UTF-8 conversion module on your system, and use it to convert content.
http://www.atutor.ca/atutor/modules/index.php
2008-08-02 02:58:32
I tried to install it but I can't
when I used index.php on my browser it did not do any action and said Done!
please help me for installing it
does it need any change on index.php for AT_INCLUDE_PATH which is define to '../../include/' ?
2008-08-02 09:20:02
You should not need to change anything to install the module. It should install like any other module.
See the install screen for the module for system requirements.
2008-08-04 00:42:32
I can't use this module because I use 1.5.0 version of atutor,I use www.atutor.ca/atutor/translate/convert.php and get atutor_1_5_fa_utf-8 but it didn't solve the problem.
Something interesting is that the AT_groups table which upgrade process failed to alter is totaly empty,so I think it's not about UTF8.
2008-08-14 16:44:27
Right :-( You're using 1.5.
Were you able to restore the system back to 1.5?
If yes, from the original 1.5, try upgrading to 1.5.5. If that works, then try upgrading to 1.6.1. You can find older versions of ATutor at sourceforge.net
2008-08-15 18:19:31
I wanna use another method for upgrade
backup existing database (version 1.5)
fresh install (version 1.6.1)
manual copy data from old database to new database using sql cammands
does it work?
2008-08-15 23:33:32
for those fields which their type is utf8 in 1.6.1 and was not utf8 in 1.5 what should I do,I think using sql command for transfer data from old database to new one isn't enough?
[reply][b]In reply to:[/b]
I wanna use another method for upgrade
backup existing database (version 1.5)
fresh install (version 1.6.1)
manual copy data from old database to new database using sql cammands
does it work?
[op]forums/view.php?fid=7;pid=14578;page=1#14842[/op][/reply]
2008-08-19 03:25:25
no , upgrading to 1.5.5 causes same alteration errors :(
* Table AT_groups alteration failed.
* Table AT_resource_categories alteration failed.
* Table AT_links_categories alteration failed.
* Table AT_resource_links alteration failed.
* Table AT_links alteration failed.
2008-08-19 12:25:19
hi,
can you tell me what your links_categories structures are?
thanks.
2008-08-19 23:07:51
AT_links_categories :
cat_id mediumint(8) UNSIGNED auto_increment
owner_type tinyint(4)
owner_id mediumint(8) UNSIGNED
name varchar(100) latin1_swedish_ci
parent_id mediumint(8) UNSIGNED
2008-08-20 00:30:06
upgrading from 1.5 to 1.5.5 causes errors too
I wonder 1st in feedback it said e.g. "Table AT_members altered successfully." then in error list it said 2 times "Table AT_members alteration failed."
I attach feedback and errors which I got
what's the problem?
2008-08-21 16:28:34
It appears to me that your table structure is not of 1.5. It seems like it has been upgraded before or some sort.
Please replace this file into your 1.6.1's
install/db
And try upgrading your 1.5 to 1.6.1 again, tell me how it goes.
2008-08-22 23:39:26
unfotunately it gave same error:
* Table AT_groups alteration failed.
* Table AT_resource_categories alteration failed.
* Table AT_links_categories alteration failed.
* Table AT_resource_links alteration failed.
* Table AT_links alteration failed.
2008-08-24 12:55:29
Thanks for the feedback. Can you try to replace this file again and tell me how it goes.
Into install/db
2008-08-24 15:56:00
sorry but which file?
2008-08-24 20:16:05
Did I uploaded it as private? Here you go again. Thanks
2008-08-25 04:50:29
thanks for your attentions.
4 ones of errors got corrected, but still following one is existed :
* Table AT_groups alteration failed.
2008-08-25 09:10:58
Thanks for going through this process with me.
Can you try this file again and let me know how it goes.
2008-08-25 14:26:43
thank you so much Harris
installation completed with no error,but after that it said "ATutor does not appear to be installed. Continue on to the installation." and redirected to "not_installed.php" instead of going to log in page!
2008-08-25 14:42:49
When you did your upgrade from atutor 1.5 to 1.6.1, did you put the ATutor_161 in the same level as ATutor_15?
C:\xampp\htdocs\ATutor_15 <-- old one
C:\xampp\htdocs\ATutor_161 <-- new one
Then, run localhost/ATutor_161
And choose "Upgrade".
2008-08-25 14:45:48
If this is an IIS system, check your /include/config.inc.php
Make sure the AT_CONTENT_DIR is setup correctly.
On windows, it could be the case that you have to use double slashes like this:
define('AT_CONTENT_DIR', 'C:\\xampp\\htdocs\\ATutor_161\\content\\');
2008-08-25 14:47:37
yes I did
2008-08-25 14:48:56
no , I use Fedora 5
2008-08-25 14:50:20
Is the config file readable? Also, the content folder has to be set to 777
That error will occur when ATutor cannot find the content folder.
2008-08-25 14:52:33
yes during upgrade process I do that
2008-08-25 14:57:39
can you try going into
http://localhost/ATutor_161/content/
Does it give you a blank page or a 404
2008-08-25 15:12:36
I think I found the problem,I have 0 byte free space on my hard drive and I going to free up some space and upgrade again
I'll tell you the result
thanks again
2008-08-25 15:14:16
I think I found the problem as I have 0 byte free space on my hard drive :P
I'm going to free up some space and do upgrade again and tell you the results
thanks again
2008-08-25 16:05:04
finally I logged in successfully!! :D
1-converting process through upgrade done successfully but anything which is in farsi (such as course content , user names ,etc) don't appear correctly , they appear as unreadable characters!
I mean atutor pages are readable but contents of database no
what should I do?
2-content directory on new version doesn't contain contents (such as pdf,ppt,etc) files,it contains only their directory like this : /Atutor/content/184/
I have ppt file on <184> on older version but <184> on new one is empty,should I copy them manually?
2008-08-25 16:13:50
[b]1-converting process through upgrade done successfully but anything which is in farsi (such as course content , user names ,etc) don't appear correctly , they appear as unreadable characters!
I mean atutor pages are readable but contents of database no
what should I do? [/b]
1.6.1 should convert them during one of the upgrade step. It should tell you that each course has its associated language (which is set inside the course property - primary language), and then from there, the upgrade step will convert all the contents to UTF8.
[b]2-content directory on new version doesn't contain contents (such as pdf,ppt,etc) files,it contains only their directory like this : /Atutor/content/184/
I have ppt file on <184> on older version but <184> on new one is empty,should I copy them manually? [/b]
Yes, copy them manually over please. We are investigating the reason that causes this problem on some of the installations.
[reply][b]In reply to:[/b]
finally I logged in successfully!! :D
1-converting process through upgrade done successfully but anything which is in farsi (such as course content , user names ,etc) don't appear correctly , they a...
[op]forums/view.php?fid=7;pid=14578;page=3#14916[/op][/reply]
2008-08-25 16:20:47
1-yes it said converting to UTF8 succeeded , I wonder why this problem occurred , as I mentioned user names are unreadable too!
do you have any suggestion?
2008-08-25 16:24:03
Were your courses' primary language all set to Farsi? If not, it will assume it's converting from the default to UTF-8, which is English in this case.
2008-08-25 16:30:35
I don't understand your question,I mean how it should be set to Farsi? anyway before converting process it recognize each char-set, such as 8859,etc
does it help?
2008-08-25 16:38:30
Oh, log in as Instructor -> Pick a course -> Manage -> Primary Language
Choose the language for this course, Farsi, for your case.
Then, during the upgrade step, it will treat all the content related to this course as Farsi character for the conversion.
ISO-8859-1 is the charset for English.
2008-08-25 16:41:12
I'll do that and tell you the results,thanks
2008-08-26 03:16:08
some course's Primary Language before upgrade was Farsi but 1.6.1 make them unreadable.
of course some user names are unreadable
what can I do?
2008-08-26 09:59:20
It could be that the content wasn't saved in the Farsi char-set at that time. You will have to try and find out which char-set the contents was saved in to convert it correctly. If nothing works, I afraid you will have to copy and paste the content over to the new system.
If you have a 1.5 course backup that has Farsi content in it, I can try importing onto my local 1.5 and see what the problem is.
As for user names, unfortunately, there is no way to convert it because we don't have an algorithm to determine which language each individual user is using. So, the user will have to change their own first name, last name themselves under 1.6.1.
[reply][b]In reply to:[/b]
some course's Primary Language before upgrade was Farsi but 1.6.1 make them unreadable.
of course some user names are unreadable
what can I do?
[op]forums/view.php?fid=7;pid=14578;page=3#14924[/op][/reply]
2008-08-27 03:19:12
I have this problem during upgrade from 1.5.5 to 1.6.1 with farsi contents.
I think the best way is to change the encoding of the data manually. Do the following steps:
1.use phpMyAmin to export your database data
2.open the dump file in UltraEdit editor and change the encoding by File->Conversion ->"utf8 to Unicode" convert it again to "Unicode to utf8( ASCII editing)" and save the dump file.
3.open the dump file with notepad to sure about the true conversion. Farsi characters should be readable in notepad.
4. empty your tables and import the dump file into the database.
Note: be sure that your database default "character set" set to utf8.
I hope it will be useful.
2008-08-27 08:43:39
This may work, though you should not open the file in Notepad. It has a tendency to add in invisible foreign characters that will break the display when viewed in ATutor.