مشكلة عند عملية الترقية من 3.8.7 إلى 4.0.2
بالتحديد في الخطوه التاسعه
هذا ملخص المشكلة:
مو الحل من هذه المشكله؟؟
بالتحديد في الخطوه التاسعه
هذا ملخص المشكلة:
database error in vbulletin 3.8.7:
Invalid sql:
(select 'package' as classtype, package.packageid as typeid, package.packageid as packageid,
package.productid as productid, if(package.productid = 'vbulletin', 1, product.active) as enabled,
package.class as class, -1 as isaggregator
from package as package
left join product as product
on product.productid = package.productid
where product.active = 1
or package.productid = 'vbulletin'
)
union
(select 'contenttype' as classtype, contenttypeid as typeid, contenttype.packageid as packageid,
1, 1, contenttype.class as class , contenttype.isaggregator
from contenttype as contenttype
inner join package as package on package.packageid = contenttype.packageid
left join product as product on product.productid = package.productid
where product.active = 1
or package.productid = 'vbulletin' );
mysql error : Illegal mix of collations (latin1_general_ci,implicit) and (latin1_swedish_ci,implicit) for operation '='
error number : 1267
request date : Thursday, december 29th 2011 @ 01:53:15 am
error date : Thursday, december 29th 2011 @ 01:53:16 am
script : http://maj-izki.com/upload1/install/upgrade_400a1.php?step=9
referrer : http://maj-izki.com/upload1/install/upgrade_400a1.php?step=8
ip address : 82.178.119.226
username :
Classname : Vb_database
mysql version : 5.0.91-log
مو الحل من هذه المشكله؟؟