Forum » Pomoč in nasveti » Magento Sample data error
Magento Sample data error
liquidenis ::
Lep pozdrav,
imam težave z samo inštalacijo Magenta. Ko ustvarim podatkovno bazo in importam .sql file (sample product data) z uradne magento strani me inštalacija magenta ne spusti skozi. Izpiše mi :
Opazu sem tudi da mi po importanju .sql fila phpmyadmin ne izpiše sporočila - queries uploaded ampak mi prikaže belo stran vendar ko kliknem spet na podatkovno bazo mi naloži tabele ampak po napaki sklepam da ne vseh. Gostovaje imam urejeno pri domenci. Če uporabim prazno podatkovno bazo me inštalacija spusti skozi
imam težave z samo inštalacijo Magenta. Ko ustvarim podatkovno bazo in importam .sql file (sample product data) z uradne magento strani me inštalacija magenta ne spusti skozi. Izpiše mi :
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database1.index_process' doesn't exist, query was: SELECT `index_process`.`indexer_code` FROM `index_process`
Trace:
#0 /var/www/vhosts/DOMENA/httpdocs/magento/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/vhosts/DOMENA/httpdocs/magento/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /var/www/vhosts/DOMENA/httpdocs/magento/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /var/www/vhosts/DOMENA/httpdocs/magento/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `index_p...', Array)
#4 /var/www/vhosts/DOMENA/httpdocs/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `index_p...', Array)
#5 /var/www/vhosts/DOMENA/httpdocs/magento/lib/Zend/Db/Adapter/Abstract.php(794): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#6 /var/www/vhosts/DOMENA/httpdocs/magento/app/code/core/Mage/Index/Model/Resource/Setup.php(66): Zend_Db_Adapter_Abstract->fetchCol(Object(Varien_Db_Select))
#7 /var/www/vhosts/DOMENA/httpdocs/magento/app/code/core/Mage/Index/Model/Resource/Setup.php(45): Mage_Index_Model_Resource_Setup->_syncIndexes()
#8 /var/www/vhosts/DOMENA/httpdocs/magento/app/code/core/Mage/Core/Model/Resource/Setup.php(235): Mage_Index_Model_Resource_Setup->applyUpdates()
#9 /var/www/vhosts/DOMENA/httpdocs/magento/app/code/core/Mage/Core/Model/App.php(428): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#10 /var/www/vhosts/DOMENA/httpdocs/magento/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Model_App->_initModules()
#11 /var/www/vhosts/DOMENA/httpdocs/magento/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#12 /var/www/vhosts/DOMENA/httpdocs/magento/index.php(83): Mage::run('', 'store')
#13 {main}
Opazu sem tudi da mi po importanju .sql fila phpmyadmin ne izpiše sporočila - queries uploaded ampak mi prikaže belo stran vendar ko kliknem spet na podatkovno bazo mi naloži tabele ampak po napaki sklepam da ne vseh. Gostovaje imam urejeno pri domenci. Če uporabim prazno podatkovno bazo me inštalacija spusti skozi
liquidenis ::
Če kdo ugotovi problem in mi da pravo rešitev mu častim Paysafe card v vrednosti 10e :)
Excavator ::
Poskusi v command line:
php ./shell/indexer.php -reindexall
potem
rm -rf var/cache/*
Ali pa v databasu
CREATE TABLE IF NOT EXISTS `index_process` (
`process_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Process Id',
`indexer_code` varchar(32) NOT NULL COMMENT 'Indexer Code',
`status` varchar(15) NOT NULL DEFAULT 'pending' COMMENT 'Status',
`started_at` timestamp NULL DEFAULT NULL COMMENT 'Started At',
`ended_at` timestamp NULL DEFAULT NULL COMMENT 'Ended At',
`mode` varchar(9) NOT NULL DEFAULT 'real_time' COMMENT 'Mode',
PRIMARY KEY (`process_id`),
UNIQUE KEY `UNQ_INDEX_PROCESS_INDEXER_CODE` (`indexer_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Index Process' AUTO_INCREMENT=10 ;
--
-- Dumping data for table `index_process`
--
INSERT INTO `index_process` (`process_id`, `indexer_code`, `status`, `started_at`, `ended_at`, `mode`) VALUES
(1, 'catalog_product_attribute', 'pending', '2014-05-03 00:20:11', '2014-05-03 00:20:11', 'real_time'),
(2, 'catalog_product_price', 'pending', '2014-05-03 00:20:12', '2014-05-03 00:20:12', 'real_time'),
(3, 'catalog_url', 'pending', '2014-05-03 00:29:34', '2014-05-03 00:29:34', 'real_time'),
(4, 'catalog_product_flat', 'pending', '2014-05-03 00:20:12', '2014-05-03 00:20:12', 'real_time'),
(5, 'catalog_category_flat', 'pending', '2014-05-03 00:11:40', '2014-05-03 00:11:40', 'real_time'),
(6, 'catalog_category_product', 'pending', '2014-05-03 00:29:34', '2014-05-03 00:29:34', 'real_time'),
(7, 'catalogsearch_fulltext', 'pending', '2014-05-03 00:29:34', '2014-05-03 00:29:34', 'real_time'),
(8, 'cataloginventory_stock', 'pending', '2014-05-03 00:20:11', '2014-05-03 00:20:11', 'real_time'),
(9, 'tag_summary', 'pending', '2014-05-03 00:20:12', '2014-05-03 00:20:12', 'real_time');
php ./shell/indexer.php -reindexall
potem
rm -rf var/cache/*
Ali pa v databasu
CREATE TABLE IF NOT EXISTS `index_process` (
`process_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Process Id',
`indexer_code` varchar(32) NOT NULL COMMENT 'Indexer Code',
`status` varchar(15) NOT NULL DEFAULT 'pending' COMMENT 'Status',
`started_at` timestamp NULL DEFAULT NULL COMMENT 'Started At',
`ended_at` timestamp NULL DEFAULT NULL COMMENT 'Ended At',
`mode` varchar(9) NOT NULL DEFAULT 'real_time' COMMENT 'Mode',
PRIMARY KEY (`process_id`),
UNIQUE KEY `UNQ_INDEX_PROCESS_INDEXER_CODE` (`indexer_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Index Process' AUTO_INCREMENT=10 ;
--
-- Dumping data for table `index_process`
--
INSERT INTO `index_process` (`process_id`, `indexer_code`, `status`, `started_at`, `ended_at`, `mode`) VALUES
(1, 'catalog_product_attribute', 'pending', '2014-05-03 00:20:11', '2014-05-03 00:20:11', 'real_time'),
(2, 'catalog_product_price', 'pending', '2014-05-03 00:20:12', '2014-05-03 00:20:12', 'real_time'),
(3, 'catalog_url', 'pending', '2014-05-03 00:29:34', '2014-05-03 00:29:34', 'real_time'),
(4, 'catalog_product_flat', 'pending', '2014-05-03 00:20:12', '2014-05-03 00:20:12', 'real_time'),
(5, 'catalog_category_flat', 'pending', '2014-05-03 00:11:40', '2014-05-03 00:11:40', 'real_time'),
(6, 'catalog_category_product', 'pending', '2014-05-03 00:29:34', '2014-05-03 00:29:34', 'real_time'),
(7, 'catalogsearch_fulltext', 'pending', '2014-05-03 00:29:34', '2014-05-03 00:29:34', 'real_time'),
(8, 'cataloginventory_stock', 'pending', '2014-05-03 00:20:11', '2014-05-03 00:20:11', 'real_time'),
(9, 'tag_summary', 'pending', '2014-05-03 00:20:12', '2014-05-03 00:20:12', 'real_time');
Zgodovina sprememb…
- spremenil: Excavator ()
sumoborac ::
Ker je SQL import precej dolg ti zadeva crkne umes priuvozu preko phpmyadmin
Pobrisi celotno bazo, ustvari iz nule in uvozi SQL preko cli
mysql -u username -p database_name < file.sql
Pobrisi celotno bazo, ustvari iz nule in uvozi SQL preko cli
mysql -u username -p database_name < file.sql
Prid sm al pa tm ostan...
Vredno ogleda ...
Tema | Ogledi | Zadnje sporočilo | |
---|---|---|---|
Tema | Ogledi | Zadnje sporočilo | |
» | Potovanje po vesolju...Oddelek: Znanost in tehnologija | 5683 (2005) | 111111111111 |
» | Magento - Sistem ne pošilja email-ovOddelek: Izdelava spletišč | 939 (758) | BlueBerry |
» | Nastavitev domeneOddelek: Omrežja in internet | 1362 (993) | someone7 |
» | [PHP]Zajem slike iz direktorijaOddelek: Programiranje | 1229 (1146) | KernelPanic |
» | Apache/2.0.47 direktorijiOddelek: Omrežja in internet | 1140 (1016) | tx-z |