Using macros, and the SQL commands on the SQL commands sheet in the spreadsheet, I stripped out everything that I didn't want, and formatted all the SQL statements so that they would work. I noticed that the comma delimiters weren't recognised by excel for the tables, so I copied the table cells to text editor, saved it as a CSV, opened it up in excel and copied all the cells from there to cell a1 again, overwriting the existing table names. I copied THE ENTIRE WINDOW'S TEXT and pasted it into cell a1 of the moodle sheet in the excel worksheet I will be uploading soon Using phpMyAdmin (It's important that you use phpMyAdmin for this step as the excel file i will upload when I've finished tweaking the macros, relies on the formatting that phpMyAdmin uses) I opened the print view of every table in the database, you can do this by selecting all the tables in database view and using the listbox at the bottom of the screen to select print view. I fixed it in the following way (Purists block your ears, you'll hear a fair few Microsoft names in the next couple of minutes. It appears that 1.8 will run OK with a Unicode database that has fields and tables in general, or at least mine didn't break until I tried to upgrade to 1.9! I guess this came about because I had some issues early in my 1.8 days and had to do a fair bit of restoration from old backups, and hacking the database. It turned out that my database was INDEED in UTF8 General. I had a similar issue.I discovered it trying to upgrade from 1.8.4 to 1.9 beta, the upgrade stalled when unicode wasn't found. this all started when i tried an update to 1.9 and it terminated in an error - do you think that's how i got into this mess in the first place and if so, would the best/only thing to do be to go back to 1.7? So, i'm thinking i'll do the "go back to 1.7 to get to 1.8/9 thing. When i get done with this, the tables are all there, they show in phpymadmin as having the utf8_general_ci collation sequence, but moodle still believes the database is not a unicode database. sql file creates every table in whatever collation the original table was (utf8_unicode_ci)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |