Upgrade 3.0.8 to 3.6.5 problems

[Bozo.s]

I just tried to upgrade VB but I'm getting few type of errors with mysql.

VB 3.0.8 was on MySQL4, before upgrading I moved database to MySQL5.

These are error messages I get

#1 - I had to add datatype field manualy. Why?

Database error in vBulletin :

Invalid SQL:
SELECT varname, value, datatype FROM setting;

MySQL Error : Unknown column 'datatype' in 'field list'
Error Number : 1054
Date : Friday, April 6th 2007 @ 05:38:40 AM
Script : http://***/install/upgrade.php
Referrer :
IP Address :
Username :
Classname : vb_database#2 - Sql query passed after I removed my custom template rows in database. Was that necessary for this action?

Database error in vBulletin 3.0.15:

Invalid SQL:

ALTER TABLE template
ADD product VARCHAR(25) NOT NULL;

MySQL Error : Duplicate entry 'forumhome_compact_forumbit_level1_-2' for key 2
Error Number : -1
Date : Friday, April 6th 2007 @ 06:49:57 AM
Script : http://***/install/upgrade_350b1.php?step=1
Referrer : http://***/install/upgrade_350b1.php
IP Address :
Username :
Classname : vb_database#3 - Another problem with field adding, it passed after I deleted all rows from adminhelp

Database error in vBulletin 3.0.15:

Invalid SQL:

ALTER TABLE adminhelp
ADD product VARCHAR(25) NOT NULL;

MySQL Error : Duplicate entry 'forumpermission-duplicate-overwrite' for key 2
Error Number : -1
Date : Friday, April 6th 2007 @ 09:11:38 AM
Script : http://***/install/upgrade_350b1.php?step=1
Referrer :
IP Address :
Username :
Classname : vb_database#4 - Problem with language import, unknown columns, with some reason php cut column name to 7 characters eg. 'forumdi' instead of 'forumdisplay' etc...

Database error in vBulletin 3.6.5:

Invalid SQL:
UPDATE language SET title = title, phrasegroup_wol = 'a:143:{s:23:\"activating_registration\";s:23:\"Activating Registration\";s:25:\"admin_control_panel_login\";s:25:\"Admin Control Panel ...

MySQL Error : Unknown column 'phrasegroup_forumdi' in 'field list'
Error Number : 1054
Date : Friday, April 6th 2007 @ 01:47:46 PM
Script : http://***/install/finalupgrade.php?step=3
Referrer :
IP Address :
Username :
Classname : vb_database