Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Installation on 1and1 managed server failing at database installation
 
flufftronix
Member
 
Avatar
Total Posts:  45
Joined:  2007-11-09
Philly, PA
 

Mage_Eav_Exception Object
(
    
[_messages:protected] => Array
        (
        )

    
[message:protected] => Wrong entity ID
    [string
:private] => 
    
[code:protected] => 0
    [file
:protected] => /homepages/45/d239407752/htdocs/app/Mage.php
    [line
:protected] => 369
    [trace
:private] => Array
        (
            
[0] => Array
                (
                    
[file] => /homepages/45/d239407752/htdocs/app/code/core/Mage/Eav/Model/Entity/Setup.php
                    [line] 
=> 97
                    [function] 
=> exception
                    [class] 
=> Mage
                    [type] 
=> ::
                    
[args] => Array
                        (
                            
[0] => Mage_Eav
                            [1] 
=> Wrong entity ID
                        
)

                )

            
[1] => Array
                (
                    
[file] => /homepages/45/d239407752/htdocs/app/code/core/Mage/Eav/Model/Entity/Setup.php
                    [line] 
=> 134
                    [function] 
=> getEntityTypeId
                    [class] 
=> Mage_Eav_Model_Entity_Setup
                    [type] 
=> ->
                    
[args] => Array
                        (
                            
[0] => customer
                        
)

                )

            
[2] => Array
                (
                    
[file] => /homepages/45/d239407752/htdocs/app/code/core/Mage/Eav/Model/Entity/Setup.php
                    [line] 
=> 60
                    [function] 
=> addAttributeSet
                    [class] 
=> Mage_Eav_Model_Entity_Setup
                    [type] 
=> ->
                    
[args] => Array
                        (
                            
[0] => customer
                            [1] 
=> Default
                        )

                )

            
[3] => Array
                (
                    
[file] => /homepages/45/d239407752/htdocs/app/code/core/Mage/Eav/Model/Entity/Setup.php
                    [line] 
=> 488
                    [function] 
=> addEntityType
                    [class] 
=> Mage_Eav_Model_Entity_Setup
                    [type] 
=> ->
                    
[args] => Array
                        (
                            
[0] => customer
                            [1] 
=> Array
                                (
                                    
[entity_model] => customer/customer
                                    [table] 
=> customer/entity
                                    [increment_model] 
=> eav/entity_increment_numeric
                                    [increment_per_store] 
=> 
                                    
[attributes] => Array
                                        (
                                            
[website_id] => Array
                                                (
                                                    
[type] => static
                                                    
[label] => Create In
                                                    [input] 
=> select
                                                    [source] 
=> customer/customer_attribute_source_website
                                                    [backend] 
=> customer/customer_attribute_backend_website
                                                    [sort_order] 
=> 1
                                                
)

                                            
[store_id] => Array
                                                (
                                                    
[type] => static
                                                    
[label] => Create In
                                                    [input] 
=> select
                                                    [source] 
=> customer/customer_attribute_source_store
                                                    [backend] 
=> customer/customer_attribute_backend_store
                                                    [visible] 
=> 
                                                    
[sort_order] => 2
                                                
)

                                            
[created_in] => Array
                                                (
                                                    
[type] => varchar
                                                    [label] 
=> Created From
                                                    [sort_order] 
=> 3
                                                
)

                                            
[firstname] => Array
                                                (
                                                    
[label] => First Name
                                                    [sort_order] 
=> 4
                                                
)

                                            
[lastname] => Array
                                                (
                                                    
[label] => Last Name
                                                    [sort_order] 
=> 5
                                                
)

                                            
[email] => Array
                                                (
                                                    
[type] => static
                                                    
[label] => Email
                                                    [class] 
=> validate-email
                                                    [sort_order] 
=> 6
                                                
)

                                            
[group_id] => Array
                                                (
                                                    
[type] => static
                                                    
[input] => select
                                                    [label] 
=> Customer Group
                                                    [source] 
=> customer/customer_attribute_source_group
 
Magento Community Magento Community
Magento Community
Magento Community
 
flufftronix
Member
 
Avatar
Total Posts:  45
Joined:  2007-11-09
Philly, PA
 

Hmm I guess the whole page doesn’t fit, this is probably the important part

exception 'Mage_Core_Exception' with message 'Error in file: "/homepages/45/d239407752/htdocs/app/code/core/Mage/Customer/sql/customer_setup/mysql4-install-0.8.0.php" - Wrong entity ID' in /homepages/45/d239407752/htdocs/app/Mage.php:369
Stack trace
:
#0 /homepages/45/d239407752/htdocs/app/code/core/Mage/Core/Model/Resource/Setup.php(277): Mage::exception('Mage_Core', 'Error in file: ...')
#1 /homepages/45/d239407752/htdocs/app/code/core/Mage/Core/Model/Resource/Setup.php(157): Mage_Core_Model_Resource_Setup->_modifyResourceDb('install', '', '0.8.2')
#2 /homepages/45/d239407752/htdocs/app/code/core/Mage/Core/Model/Resource/Setup.php(144): Mage_Core_Model_Resource_Setup->_installResourceDb('0.8.2')
#3 /homepages/45/d239407752/htdocs/app/code/core/Mage/Core/Model/Resource/Setup.php(111): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 /homepages/45/d239407752/htdocs/app/code/core/Mage/Core/Model/Config.php(180): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 /homepages/45/d239407752/htdocs/app/code/core/Mage/Core/Model/App.php(205): Mage_Core_Model_Config->init(NULL)
#6 /homepages/45/d239407752/htdocs/app/Mage.php(399): Mage_Core_Model_App->init('default', 'store', NULL)
#7 /homepages/45/d239407752/htdocs/app/Mage.php(419): Mage::app('default', 'store', NULL)
#8 /homepages/45/d239407752/htdocs/index.php(29): Mage::run('default')
#9 {main}

I’ve tried the install twice, no problems other than this. I do meet the system requirements; made sure about mysql after reading some other posts on here. Any ideas?

 
Magento Community Magento Community
Magento Community
Magento Community
 
flufftronix
Member
 
Avatar
Total Posts:  45
Joined:  2007-11-09
Philly, PA
 

Just an update, I’ve retried now with both the installer tarball and the full package, same exact error. I know the 1.0 release is right around the corner but if anyone’s got a moment to look at this, I’m sure it’s going to come up often as 1&1;’s a pretty popular host and their managed server plans are pretty popular too..

Here’s my phpinfo:
http://krudmart.fluffronix.com/info.php

And the error can be seen in its entirety here:
http://krudmart.flufftronix.com

My .htaccess file is install standard, with the exception of the 1&1;line being uncommented. I was running FastCGI but just disabled it, no difference there either.

 
Magento Community Magento Community
Magento Community
Magento Community
 
flufftronix
Member
 
Avatar
Total Posts:  45
Joined:  2007-11-09
Philly, PA
 

Further investigation.. tried running the mysql in that mysql installation file and came up with this error:

Error

SQL query
:

--
-- 
Table structure for table `admin_assert`
--
CREATE TABLE `admin_assert` (
`
assert_idint10 unsigned NOT NULL AUTO_INCREMENT ,
`
assert_typevarchar20 NOT NULL default '',
`
assert_datatext,
PRIMARY KEY ( `assert_id` )
ENGINE MYISAM DEFAULT CHARSET utf8 COMMENT 'ACL Asserts' AUTO_INCREMENT =1

MySQL said
Documentation
#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8 COMMENT='ACL Asserts' AUTO_INCREMENT=1' at
 
Magento Community Magento Community
Magento Community
Magento Community
 
Airforce111
Sr. Member
 
Avatar
Total Posts:  100
Joined:  2008-01-31
 

Heya, just curious…

What version is your mysql?

 
Magento Community Magento Community
Magento Community
Magento Community
 
flufftronix
Member
 
Avatar
Total Posts:  45
Joined:  2007-11-09
Philly, PA
 
Airforce111 - 28 March 2008 02:48 PM

Heya, just curious…

What version is your mysql?

Well, I figured it was 5.0.32 because that’s what phpinfo lists. However, according to the 1&1;admin section only version 4 databases are installable! Weird that you can’t pick which version to use. Help ticket placed, hopefully this is the problem as it’s pretty easy to fix.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Airforce111
Sr. Member
 
Avatar
Total Posts:  100
Joined:  2008-01-31
 

I’m not sure about managed servers, but for shared hosts on 1and1, they let you choose MySQL 4 or 5. I’d only tested magento on MySQL 5 on 1and1, so I have no idea what kind of effect you would get using magento on MySQL 4.

Although in the sys requirements, it does mention magento works on MySQL 4.1.20+ smile

 
Magento Community Magento Community
Magento Community
Magento Community
 
sherrie
Moderator
 
Avatar
Total Posts:  1655
Joined:  2007-12-14
Waterloo, ON
 

This is actually written by someone who already posted in this thread, but it may be helpful ...

Installation Guide for 1and1.com Hosting:
http://www.magentocommerce.com/boards/viewthread/3462/

 
Magento Community Magento Community
Magento Community
Magento Community
 
flufftronix
Member
 
Avatar
Total Posts:  45
Joined:  2007-11-09
Philly, PA
 
sherrie - 28 March 2008 07:20 PM

This is actually written by someone who already posted in this thread, but it may be helpful ...

Installation Guide for 1and1.com Hosting:
http://www.magentocommerce.com/boards/viewthread/3462/

Thanks, I had actually seen this already. My client’s on a managed dedicated server though and not shared hosting, which at least in this regard makes things a little more complicated. You’d think having a dedicated would make it a lot easier, but since it’s a managed server where 1&1;does backups, software versioning, etc. there’s not have a ton of flexibility (like choosing your MySQL version apparently) or even direct access to server logs.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Airforce111
Sr. Member
 
Avatar
Total Posts:  100
Joined:  2008-01-31
 

Yea, their managed servers are like that apparently. It’s almost identical to the shared servers except you’re the only one on it XD. I tried acccessing your info.php and links, but they don’t work.

Um, maybe try deleting the whole DB and making a new one (I found 1and1 sometimes have an ill mysql server and switching the DB to another server fixes the issue… unless on the dedi it’s localhost, still worth a try). Then unpack your compressed file remotely (ex: ssh) and run the install again. I’m kinda interested in seeing if you can get it running on their dedicated. smile

 
Magento Community Magento Community
Magento Community
Magento Community
 
flufftronix
Member
 
Avatar
Total Posts:  45
Joined:  2007-11-09
Philly, PA
 

Just got off the phone with 1&1; apparently managed dedicated servers all run MySQL 4.0.97, no budging. Gonna switch over to a proper dedicated server with root access once my client calls in verification.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Airforce111
Sr. Member
 
Avatar
Total Posts:  100
Joined:  2008-01-31
 

yea, 4.0.97 isn’t good enough apparently, since specs dictate MySQL 4.1.20+. Dedicated root sounds like a good place to go, if your client doesn’t mind paying extra for 3rd pt maintenance/upkeep or doesn’t care ^^;

 
Magento Community Magento Community
Magento Community
Magento Community
 
tunersedge
Jr. Member
 
Avatar
Total Posts:  16
Joined:  2008-01-29
 

Dude...I have a 1&1;account, and I can select either 4.0 or 5.0. Do this: go to your database admin page. Click “new database”. Right under the field where it asks you to name it, there is a selection button for 4.0 or 5.0. Make sure you click on 5.0. I just tried installing Magento 1.0 on a mysql 4.0 DB and got the same “Wrong entity ID” error that you did. I’m installing onto a 5.0 DB now, will post back with results. I expect that it will work just fine.

 
Magento Community Magento Community
Magento Community
Magento Community
 
tunersedge
Jr. Member
 
Avatar
Total Posts:  16
Joined:  2008-01-29
 

Yep...5.0 worked fine.

Your switch up to a dedicated root access server where you can add 5.0 will do it for you.

Enjoy!

 
Magento Community Magento Community
Magento Community
Magento Community
 
flufftronix
Member
 
Avatar
Total Posts:  45
Joined:  2007-11-09
Philly, PA
 
tunersedge - 01 April 2008 07:07 AM

Dude...I have a 1&1;account, and I can select either 4.0 or 5.0. Do this: go to your database admin page. Click “new database”. Right under the field where it asks you to name it, there is a selection button for 4.0 or 5.0. Make sure you click on 5.0. I just tried installing Magento 1.0 on a mysql 4.0 DB and got the same “Wrong entity ID” error that you did. I’m installing onto a 5.0 DB now, will post back with results. I expect that it will work just fine.

The option to pick which version is absent from managed dedicated servers. So bizarre that you can do that on shared accounts and not dedicated servers which cost more than 10x as much.. whatever. Root server works fine.

 
Magento Community Magento Community
Magento Community
Magento Community
 
markl
Member
 
Total Posts:  39
Joined:  2008-04-18
 

Hi,

I know this is an old post, but wanted to ask what you guys think of 1and root servers? How’s the performance? I have one of my basic sites on shared hosting at 1and1, but now need to install Magento. I had hoped for a managed server, but from what you’ve said, root access seems to be the way to go. I’m a complete numpty when it comes to Linux, so do you think I could go for a root server and get away with using the control panel for 99% of what I need to do?

Cheers,

Mark

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