From CMS -> Static Blocks -> "Onze partners" -> [Insert/Edit Image] -> Image URL -> [Browse] it is not possible to create a new folder to store images in.
SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘DATABASE_NAME.core_directory_storage’ doesn’t exist
Error in the Log files:
[Mon Apr 18 20:57:55 2011] [error] [client IP Address Server] client denied by server configuration: /home/SITENAME/public_html/app/etc/local.xml
How can we solve this?
Regards
Beuvema
3 answers
This table was missing (in the JM_Adamite version I downloaded on 20110411) causing the error: (
CREATE TABLE IF NOT EXISTS `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 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`),
CONSTRAINT `FK_DIRECTORY_PARENT_ID` FOREIGN KEY (`parent_id`)
REFERENCES `PREFIX_core_directory_storage` (`directory_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=’Directory storage’;
Remove "PREFIX_" if no prefix is used in your database!
Might be usefull to more people…
Regards
Beuvema
Seems to be a known issue at Magento…
http://www.magentocommerce.com/board…thread/219878/
Regards
Beuvema
Hi Beuvema!
We have checked and see our demo has this error. I reported this bug and our coder will fix it:
http://pm.joomlart.com/browse/JMTCADAMITE-52
Thanks for your report and solution.