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?
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..
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.
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
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.
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+
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.
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.
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.
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 ^^;
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.
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.
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?
