Centura 1.5 and Oracle 8 or Oracle 9

張貼者 於

CTD 1.1.2 or 1.5.x and Oracle 8.1.5 ( Oracle 8i ) – Support Wiki

CTD and Oracle 8i
Description:
CTD Applications fail to connect to Oracle 8i (also called Oracle 8.1.5 or Oracle 8.1.6)
Solution:
There are actually two solutions to the problem.
You can install the Oracle NET8 client software from Oracle 8.0.5 and it will communicate correctly with Oracle 8i. You can also use the SQL*Net 2.3 client software from Oracle 7.
-OR-
Use the Oracle 8i (8.1.5 or 8.1.6) client software and manually add the following entry into the Registry at location:
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\
Add the following string value:
ORAOCI ORACLIENT8.DLL
and you will be able to successfully use the Oracle 8i (8.1.5 or 8.1.6) client software. You will still
need to run the VIEW8.ORA and PLSVIEW8.ORA scripts, logged on as “SYS", in order to use the
Database Explorer with Oracle 8i.
Note: This information only applies to Centura 32-bit applications, not to SQLWindows
16-bit applications, because the Oracle 8i client software is exclusively 32-bit.
Centura Customer Support

Attachments for content articles 中文檔名問題

張貼者 於

Attachments for content articles無法上傳中文檔名, 可以更改以下的程式碼內容做為修正。

我的系統是Windows , Apache 2.2.8, PHP 5.2.6, MySQL 5, Joomla! 1.5.9, 資料庫校對 utf8_general_ci

開啟

{joomla_install_dir}/components/com_attachments/helper.php

修改(約381行)

if (JFile::upload($_FILES[‘upload’][‘tmp_name’], $filename_sys)) {

修改為

if (JFile::upload($_FILES[‘upload’][‘tmp_name’], iconv(‘UTF-8′,’big5’,$filename_sys))) {

在下面的程式前(約443行)

if ( !JFile::exists($filename_sys) ) {

加入

$filename = iconv(‘UTF-8′,’big5’,$filename);
$filename_sys = iconv(‘UTF-8′,’big5’,$filename_sys);
也許資料庫建成big5就不會有這個問題吧! 不過, 現在不太可能會建big5的database了吧!

另外, 後記, 如果在fedora 12上安裝時, 則不需要做此更改。