» »

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 :
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');

Zgodovina sprememb…

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
Prid sm al pa tm ostan...


Vredno ogleda ...

TemaSporočilaOglediZadnje sporočilo
TemaSporočilaOglediZadnje sporočilo
»

Potovanje po vesolju...

Oddelek: Znanost in tehnologija
465688 (2010) 111111111111
»

Magento - Sistem ne pošilja email-ov

Oddelek: Izdelava spletišč
9941 (760) BlueBerry
»

Nastavitev domene

Oddelek: Omrežja in internet
171362 (993) someone7
»

[PHP]Zajem slike iz direktorija

Oddelek: Programiranje
51231 (1148) KernelPanic
»

Apache/2.0.47 direktoriji

Oddelek: Omrežja in internet
121142 (1018) tx-z

Več podobnih tem