A-A+

Can’t read image folder after upgrate to 1.5.0.1

2011年08月01日 灵犀一指 Can’t read image folder after upgrate to 1.5.0.1已关闭评论 阅读 706 人 次

After upgrad, when insert image to description, the programm can’t read the Media folder any more, and always shows SQL data error.
can Any one solve this ?

es I think there is a small issue with one of the files probably Tree.php.  When it looks for the image directories, sub directories and files it looks for the table “ _core_directory_storage” but with the most recent upgrade this table seems not to be included.  I don’t know whether this is intentional or not as this table does not seem to be used!

Whatever, the net result is that any sub-directories which are created do not appear.

I have tried adding _core_directory_storage to all my DBs and it seems to work so if you back up your database you could run

SET FOREIGN_KEY_CHECKS=0;

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
-- --------------------------------------------------------

--
-- Table structure for table `{your prefix}_core_directory_storage`
--

CREATE TABLE IF NOT EXISTS `{your prefix}_core_directory_storage` (
`directory_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`path` varchar(255) NOT NULL DEFAULT '',
`upload_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`parent_id` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`directory_id`),
UNIQUE KEY `IDX_DIRECTORY_PATH` (`name`,`path`),
KEY `parent_id` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Directory storage' AUTO_INCREMENT=1 ;

--
-- Dumping data for table `{your prefix}_core_directory_storage`
--

--
-- Constraints for dumped tables
--

--
-- Constraints for table `{your prefix}_core_directory_storage`
--
ALTER TABLE `{your prefix}_core_directory_storage`
ADD CONSTRAINT `FK_DIRECTORY_PARENT_ID` FOREIGN KEY (`parent_id`) REFERENCES `{your prefix}_core_directory_storage` (`directory_id`) ON DELETE CASCADE ON UPDATE CASCADE;

SET FOREIGN_KEY_CHECKS=1;

OR go to

app/code/core/Mage/Cms/Model/Wysiwyg/Images/Storage.php—getDirsCollection

and comment out

$subDirectories = Mage::getModel('core/file_storage_directory_database')->getSubdirectories($path);

foreach ($subDirectories as $directory) {
$fullPath = rtrim($path, DS) . DS . $directory['name'];
if (!file_exists($fullPath)) {
mkdir($fullPath, 0777, true);
}
}

To change the base image directory go to

app/code/core/Mage/Cms/Model/Wysiwyg/Config.php

and change the constant IMAGE_DIRECTORY =

within my installation the table was created (upgrade from 1.4.1.1 to 1.5.1.0). But it didn’t work, too.
I just had to set in app/code/core/Mage/Cms/Model/Wysiwyg/Config.php

 

const IMAGE_DIRECTORY = 'wysiwyg';

to

const IMAGE_DIRECTORY = '.';

Cheers

标签:

评论已关闭!