Study Area Facebook粉絲團http://www.facebook.com/sataiwan
0 會員 與 1 訪客 正在閱讀本文。
移除掉, 自己抓 tar.gz 的回來 ./configure, make, mak install 就好了
先問一下...你為什麼要升級或是降級?... 理由是?...
select case when (vtiger_activity.status not like '') then vtiger_activity.status else vtiger_activity.eventstatus end as activitystatus,vtiger_activity.activitytype,vtiger_activity.subject,vtiger_activity.date_start,vtiger_activity.due_date,case when (vtiger_users.user_name not like '') then vtiger_users.user_name else vtiger_groups.groupname end as user_name, vtiger_activity.activityid, vtiger_activity.activitytype as type, vtiger_activity.priority, case when (vtiger_activity.status not like '') then vtiger_activity.status else vtiger_activity.eventstatus end as status, vtiger_crmentity.crmid,vtiger_contactdetails.contactid FROM vtiger_activity LEFT JOIN vtiger_activitycf ON vtiger_activitycf.activityid = vtiger_activity.activityid LEFT JOIN vtiger_cntactivityrel ON vtiger_cntactivityrel.activityid = vtiger_activity.activityid LEFT JOIN vtiger_contactdetails ON vtiger_contactdetails.contactid = vtiger_cntactivityrel.contactid LEFT JOIN vtiger_seactivityrel ON vtiger_seactivityrel.activityid = vtiger_activity.activityid LEFT OUTER JOIN vtiger_activity_reminder ON vtiger_activity_reminder.activity_id = vtiger_activity.activityid LEFT JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_activity.activityid LEFT JOIN vtiger_users ON vtiger_users.id = vtiger_crmentity.smownerid LEFT JOIN vtiger_groups ON vtiger_groups.groupid = vtiger_crmentity.smownerid LEFT OUTER JOIN vtiger_account ON vtiger_account.accountid = vtiger_contactdetails.accountid LEFT OUTER JOIN vtiger_leaddetails ON vtiger_leaddetails.leadid = vtiger_seactivityrel.crmid LEFT OUTER JOIN vtiger_account vtiger_account2 ON vtiger_account2.accountid = vtiger_seactivityrel.crmid LEFT OUTER JOIN vtiger_potential ON vtiger_potential.potentialid = vtiger_seactivityrel.crmid LEFT OUTER JOIN vtiger_troubletickets ON vtiger_troubletickets.ticketid = vtiger_seactivityrel.crmid LEFT OUTER JOIN vtiger_salesorder ON vtiger_salesorder.salesorderid = vtiger_seactivityrel.crmid LEFT OUTER JOIN vtiger_purchaseorder ON vtiger_purchaseorder.purchaseorderid = vtiger_seactivityrel.crmid LEFT OUTER JOIN vtiger_quotes ON vtiger_quotes.quoteid = vtiger_seactivityrel.crmid LEFT OUTER JOIN vtiger_invoice ON vtiger_invoice.invoiceid = vtiger_seactivityrel.crmid LEFT OUTER JOIN vtiger_campaign ON vtiger_campaign.campaignid = vtiger_seactivityrel.crmid WHERE vtiger_crmentity.deleted = 0 AND activitytype != 'Emails' LIMIT 0, 20
請問一下各位前輩目前我的ubuntu是10.04,Mysql是5.1.41我想請問怎麼升級?另外想請問有辦法降成5.0版嗎如有文章可以推薦我看一下,因為我上google查,好像都不是我要的