Try the Demo

Magento Forum

   
ran magento connect, store disappears
 
manish
Jr. Member
 
Total Posts:  9
Joined:  2008-06-22
 

hi,

i recently ran magento connect after almost a year and a half of not much use. my store has disappeared, i have not taken any back, though i have mysql db.. can i re-install the same? foll is the error i get:

Zend_Db_Statement_Exception Object
(
[_chainedException:protected] => PDOException Object
(
[message:protected] => SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘icefaqs_magento.customer_eav_attribute’ doesn’t exist
[string:private] =>
[code:protected] => 42S02
[file:protected] => /home/icefaqs/public_html/magento/lib/Zend/Db/Statement/Pdo.php
[line:protected] => 228
[trace:private] => Array
(
[0] => Array
(
[file] => /home/icefaqs/public_html/magento/lib/Zend/Db/Statement/Pdo.php
[line] => 228
[function] => execute
[class] => PDOStatement
[type] => ->
[args] => Array
(
[0] => Array
(
)

)

)

[1] => Array
(
[file] => /home/icefaqs/public_html/magento/lib/Zend/Db/Statement.php
[line] => 300
[function] => _execute
[class] => Zend_Db_Statement_Pdo
[type] => ->
[args] => Array
(
[0] => Array
(
)

)

)

[2] => Array
(
[file] => /home/icefaqs/public_html/magento/lib/Zend/Db/Adapter/Abstract.php
[line] => 468
[function] => execute
[class] => Zend_Db_Statement
[type] => ->
[args] => Array
(
[0] => Array
(
)

)

)

[3] => Array
(
[file] => /home/icefaqs/public_html/magento/lib/Zend/Db/Adapter/Pdo/Abstract.php
[line] => 238
[function] => query
[class] => Zend_Db_Adapter_Abstract
[type] => ->
[args] => Array
(
[0] => SELECT `main`.*, `additional`.* FROM `eav_attribute` AS `main`
INNER JOIN `customer_eav_attribute` AS `additional` ON main.attribute_id=additional.attribute_id WHERE (main.attribute_code=’birthdate’) AND (main.entity_type_id=’1’)
[1] => Array
(
)

)

)

[4] => Array
(
[file] => /home/icefaqs/public_html/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 333
[function] => query
[class] => Zend_Db_Adapter_Pdo_Abstract
[type] => ->
[args] => Array
(
[0] => SELECT `main`.*, `additional`.* FROM `eav_attribute` AS `main`
INNER JOIN `customer_eav_attribute` AS `additional` ON main.attribute_id=additional.attribute_id WHERE (main.attribute_code=’birthdate’) AND (main.entity_type_id=’1’)
[1] => Array
(
)

)

)

[5] => Array
(
[file] => /home/icefaqs/public_html/magento/lib/Zend/Db/Adapter/Abstract.php
[line] => 725
[function] => query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => Varien_Db_Select Object
(
[_bind:protected] => Array
(
)

[_adapter:protected] => Varien_Db_Adapter_Pdo_Mysql Object
(
[_transactionLevel:protected] => 0
[_connectionFlagsSet:protected] => 1
[_ddlCache:protected] => Array
(
)

[_bindParams:protected] => customer
[_bindIncrement:protected] => 0
[_debug:protected] =>
[_logQueryTime:protected] => 0.05
[_logAllQueries:protected] =>
[_logCallStack:protected] =>
[_debugFile:protected] => var/debug/sql.txt
[_debugIoAdapter:protected] =>
[_debugTimer:protected] => 0
[_cacheAdapter:protected] => Varien_Cache_Core Object
(
[_backend:protected] => Zend_Cache_Backend_File Object
(
[_options:protected] => Array
(
[cache_dir] => /home/icefaqs/public_html/magento/var/cache/
[file_locking] => 1
[read_control] => 1
[read_control_type] => crc32
[hashed_directory_level] => 1
[hashed_directory_umask] => 511
[file_name_prefix] => mage
[cache_file_umask] => 384
[metadatas_array_max_size] => 100
)

[_metadatasArray:protected] => Array
(
[218_CORE_CACHE_OPTIONS] => Array
(
[hash] => -1571559392
[mtime] => 1271866955
[expire] => 9999999999
[tags] => Array
(
[0] => 218_MAGE
)

)

)

[_directives:protected] => Array
(
[lifetime] => 7200
[logging] =>
[logger] =>
)

)

[_options:protected] => Array
(
[write_control] => 1
[caching] => 1
[cache_id_prefix] => 218_
[automatic_serialization] =>
[automatic_cleaning_factor] => 0
[lifetime] => 7200
[logging] =>
[logger] =>
[ignore_user_abort] =>
)

[_specificOptions:protected] => Array
(
)

[_lastId:private] => 218_CORE_CACHE_OPTIONS
[_extendedBackend:protected] => 1
[_backendCapabilities:protected] => Array
(
[automatic_cleaning] => 1
[tags] => 1
[expired_read] => 1
[priority] =>
[infinite_lifetime] => 1
[get_list] => 1
)

)

[_isDdlCacheAllowed:protected] =>
[_pdoType:protected] => mysql
[_numericDataTypes:protected] => Array
(
[0] => 0
[1] => 1
[2] => 2
[INT] => 0
[INTEGER] => 0
[MEDIUMINT] => 0
[SMALLINT] => 0
[TINYINT] => 0
[BIGINT] => 1
[SERIAL] => 1
[DEC] => 2
[DECIMAL] => 2
[DOUBLE] => 2
[DOUBLE PRECISION] => 2
[FIXED] => 2
[FLOAT] => 2
)

[_defaultStmtClass:protected] => Zend_Db_Statement_Pdo
[_config:protected] => Array
(
[model] => mysql4
[initStatements] => SET NAMES utf8
[type] => pdo_mysql
[host] => localhost
[username] => icefaqs_icefaqs
[password] => hanuman
[dbname] => icefaqs_magento
[active] => 1
[charset] =>
[persistent] =>
[options] => Array
(
[caseFolding] => 0
[autoQuoteIdentifiers] => 1
)

[driver_options] => Array
(
)

)

[_fetchMode:protected] => 2
[_profiler:protected] => Zend_Db_Profiler Object
(
[_queryProfiles:protected] => Array
(
)

[_enabled:protected] =>
[_filterElapsedSecs:protected] =>
[_filterTypes:protected] =>
)

[_defaultProfilerClass:protected] => Zend_Db_Profiler
[_connection:protected] => PDO Object
(
)

[_caseFolding:protected] => 0
[_autoQuoteIdentifiers:protected] => 1
[_allowSerialization:protected] => 1
[_autoReconnectOnUnserialize:protected] =>
)

[_parts:protected] => Array
(
[straightjoin] =>
[distinct] =>
[columns] => Array
(
[0] => Array
(
[0] => main
[1] => *
[2] =>
)

[1] => Array
(
[0] => additional
[1] => *
[2] =>
)

)

[union] => Array
(
)

[from] => Array
(
[main] => Array
(
[joinType] => from
[schema] =>
[tableName] => eav_attribute
[joinCondition] =>
)

[additional] => Array
(
[joinType] => inner join
[schema] =>
[tableName] => customer_eav_attribute
[joinCondition] => main.attribute_id=additional.attribute_id
)

)

[where] => Array
(
[0] => (main.attribute_code=’birthdate’)
[1] => AND (main.entity_type_id=’1’)
)

[group] => Array
(
)

[having] => Array
(
)

[order] => Array
(
)

[limitcount] =>
[limitoffset] =>
[forupdate] =>
)

[_tableCols:protected] => Array
(
)

)

[1] => Array
(
)

)

)

[6] => Array
(
[file] => /home/icefaqs/public_html/magento/app/code/core/Mage/Eav/Model/Entity/Setup.php
[line] => 791
[function] => fetchRow
[class] => Zend_Db_Adapter_Abstract
[type] => ->
[args] => Array
(
[0] => Varien_Db_Select Object
(
[_bind:protected] => Array
(
)

[_adapter:protected] => Varien_Db_Adapter_Pdo_Mysql Object
(
[_transactionLevel:protected] => 0
[_connectionFlagsSet:protected] => 1
[_ddlCache:protected] => Array
(
)

[_bindParams:protected] => customer
[_bindIncrement:protected] => 0
[_debug:protected] =>
[_logQueryTime:protected] => 0.05
[_logAllQueries:protected] =>
[_logCallStack:protected] =>
[_debugFile:protected] => var/debug/sql.txt
[_debugIoAdapter:protected] =>
[_debugTimer:protected] => 0
[_cacheAdapter:protected] => Varien_Cache_Core Object
(
[_backend:protected] => Zend_Cache_Backend_File Object
(
[_options:protected] => Array
(
[cache_dir] => /home/icefaqs/public_html/magento/var/cache/
[file_locking] => 1
[read_control] => 1
[read_control_type] => crc32
[hashed_directory_level] => 1
[hashed_directory_umask] => 511
[file_name_prefix] => mage
[cache_file_umask] => 384
[metadatas_array_max_size] => 100
)

[_metadatasArray:protected] => Array
(
[218_CORE_CACHE_OPTIONS] => Array
(
[hash] => -1571559392

 
Magento Community Magento Community
Magento Community
Magento Community
 
manish
Jr. Member
 
Total Posts:  9
Joined:  2008-06-22
 

no replies. issue still not resolved. is there a way i can use the same mysql database on another site?

 
Magento Community Magento Community
Magento Community
Magento Community
 
kab8609
Guru
 
Avatar
Total Posts:  708
Joined:  2009-04-07
Cleveland
 

Did you backup your database before you used Magento Connect? If so, just reinstall the same version you had on before. Looks like you tried to jump from 1.1 or 1.2 to 1.4 which is not good.

 Signature 

Kris Brown
Magento Certified Developer

I work at Briteskies, a Magento Solutions Partner.

Magento CE Sites Built to Date for Clients: 26
Magento EE Sites Built to Date for Clients: 5
Magento Extensions Built to Date for Clients: 13

Don’t edit core code...

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top