Installation errors in a fresh server

Permalink
Hi guys!
I've been trying to install Concrete 5.7.3.1 several times on my server (hosted by Domain.com) originally I was trying inside a folder and I was getting an error at the user admin's installation process...

Then I just clean up everything, everything, even the databases, and decompressed the files in the root folder, following the instructions, I created again a fresh database, set up all the permissions in the folders indicated and the install process pass through the user admin but stop again after the blocks....

I don't know what else to do! if you can give me a hand on this I'll really appreciate it!
a HUGE thanks!

Here is the error:

An exception occurred while executing 'insert into Features (feHandle, feScore, feHasCustomClass, pkgID) values (?, ?, ?, ?)' with params ["title", "1", 0, 0]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'title' for key 'feHandle'.
Trace:
#0 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(702): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'insert into Fea...', Array) #1 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/src/Database/Connection/Connection.php(68): Doctrine\DBAL\Connection->executeQuery('insert into Fea...', Array) #2 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/src/Feature/Feature.php(100): Concrete\Core\Database\Connection\Connection->Execute('insert into Fea...', Array) #3 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/src/Backup/ContentImporter.php(836): Concrete\Core\Feature\Feature::add('title', '1', false, false) #4 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/src/Backup/ContentImporter.php(84): Concrete\Core\Backup\ContentImporter->importFeatures(Object(SimpleXMLElement)) #5 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/src/Backup/ContentImporter.php(60): Concrete\Core\Backup\ContentImporter->doImport(Object(SimpleXMLElement)) #6 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/src/Package/StartingPointPackage.php(102): Concrete\Core\Backup\ContentImporter->importContentFile('/hermes/bosoraw...') #7 [internal function]: Concrete\Core\Package\StartingPointPackage->install_gathering() #8 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/controllers/install.php(286): call_user_func(Array) #9 [internal function]: Concrete\Controller\Install->run_routine('elemental_full', 'install_gatheri...') #10 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/src/Controller/AbstractController.php(156): call_user_func_array(Array, Array) #11 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/src/Routing/ControllerRouteCallback.php(25): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array) #12 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/src/Routing/Router.php(59): Concrete\Core\Routing\ControllerRouteCallback->execute(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Routing\Route), Array) #13 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/src/Support/Facade/Facade.php(116): Concrete\Core\Routing\Router->execute(Object(Concrete\Core\Routing\Route), Array) #14 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/src/Application/Application.php(342): Concrete\Core\Support\Facade\Facade::__callStatic('execute', Array) #15 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/src/Application/Application.php(342): Concrete\Core\Support\Facade\Route::execute(Object(Concrete\Core\Routing\Route), Array) #16 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/bootstrap/start.php(196): Concrete\Core\Application\Application->dispatch(Object(Concrete\Core\Http\Request)) #17 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/dispatcher.php(36): require('/hermes/bosoraw...') #18 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/index.php(2): require('/hermes/bosoraw...') #19 {main}

EDIT:
Again, fresh SQL database, now this error:

An exception occurred while executing 'insert into PageTypeComposerControlTypes (ptComposerControlTypeHandle, ptComposerControlTypeName, pkgID) values (?, ?, ?)' with params ["core_page_property", "Built-In Properties", 0]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'core_page_property' for key 'ptComposerControlTypeHandle'.
Trace:
#0 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(702): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'insert into Pag...', Array) #1 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/src/Database/Connection/Connection.php(68): Doctrine\DBAL\Connection->executeQuery('insert into Pag...', Array) #2 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/src/Page/Type/Composer/Control/Type/Type.php(71): Concrete\Core\Database\Connection\Connection->Execute('insert into Pag...', Array) #3 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/src/Backup/ContentImporter.php(511): Concrete\Core\Page\Type\Composer\Control\Type\Type::add('core_page_prope...', 'Built-In Proper...', NULL) #4 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/src/Backup/ContentImporter.php(79): Concrete\Core\Backup\ContentImporter->importPageTypeComposerControlTypes(Object(SimpleXMLElement)) #5 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/src/Backup/ContentImporter.php(60): Concrete\Core\Backup\ContentImporter->doImport(Object(SimpleXMLElement)) #6 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/src/Package/StartingPointPackage.php(107): Concrete\Core\Backup\ContentImporter->importContentFile('/hermes/bosoraw...') #7 [internal function]: Concrete\Core\Package\StartingPointPackage->install_page_types() #8 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/controllers/install.php(286): call_user_func(Array) #9 [internal function]: Concrete\Controller\Install->run_routine('elemental_full', 'install_page_ty...') #10 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/src/Controller/AbstractController.php(156): call_user_func_array(Array, Array) #11 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/src/Routing/ControllerRouteCallback.php(25): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array) #12 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/src/Routing/Router.php(59): Concrete\Core\Routing\ControllerRouteCallback->execute(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Routing\Route), Array) #13 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/src/Support/Facade/Facade.php(116): Concrete\Core\Routing\Router->execute(Object(Concrete\Core\Routing\Route), Array) #14 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/src/Application/Application.php(342): Concrete\Core\Support\Facade\Facade::__callStatic('execute', Array) #15 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/src/Application/Application.php(342): Concrete\Core\Support\Facade\Route::execute(Object(Concrete\Core\Routing\Route), Array) #16 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/bootstrap/start.php(196): Concrete\Core\Application\Application->dispatch(Object(Concrete\Core\Http\Request)) #17 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/concrete/dispatcher.php(36): require('/hermes/bosoraw...') #18 /hermes/bosoraweb098/b1637/dom.daniacorp/public_html/index.php(2): require('/hermes/bosoraw...') #19 {main}

View Replies:
BethCM replied on at Permalink Reply
BethCM
When you say that you're starting with a fresh install, are you dropping the tables (empty database) or just emptying the tables? If the latter you need to drop all the tables first.

Where your script shows a question mark for a value, is that just your effort to hide the information or are you actually trying to input ? as dummy values into the database?

The error you are seeing is normally caused if you try to input data into a field that is auto incremented. Any field that has auto incremented data (typically an ID) should not have a value assigned to it.

Also, is this a fresh install or are you trying to import an existing database? I'm guessing it's an import.
daniacorp replied on at Permalink Reply
Hi BethCM!
Thank you for your response, my answers below:

I dropped the tables, also as an alternative I dropped the SQL database completely, even created a new one with a different name.

EDIT: I have just one SQL database, every time I tried again, I dropped the first and created the new one.

The question mark in the script comes from the error, I just copy/paste the error from the message here. I dunno where exactly could I input some values in the database since the database is freshly created from scratch, also in the Concrete installation theres not any field where to put values beside the SQL server, database name, user and psw from the database and email and psw for the admin.

It's a fresh install, empty server, fresh SQL database, first time trying to use Concrete, the pre-installation check from Concrete is all ok, Domain.com host my server.

Thank you for your time! Hope this info helps to find out what its happening!
BethCM replied on at Permalink Reply
BethCM
The error messages are the same and result from an attempt to enter key values that are not unique. Concrete5 by default does not do this.

Just to confirm your steps:
1. Download Concrete5.
2. Create Database, create user, assign user to database (if required to do so).
3. Extract / Upload c5 file to server.
4. Via your website domain you enter the database login info and hit "Install".
5. That's when you get these errors?

If that is the case and there are no issues with the hosts database accepting Concrete5 then I wonder if your download of Concrete5 was corrupt. Could you try removing the files from the server and trying to install C5 from scratch using a new downloaded file. Again, I only suggest this as C5 doesn't by default try and enter non-unique keys.
I'd be tempted to contact your host and just confirm that their database is suitable for C5. I can't see why it wouldn't be but then I've seen some really bad default hosting set ups.

You shouldn't have to manually change the folder permissions but since you are, what values are you setting? 664? 777?
daniacorp replied on at Permalink Reply
Hi BethCM!
Yes, my answers below:

1. Download Concrete5
Yes, several times, from my office and home, last version and the prior version.

2. Create Database, create user, assign user to database (if required to do so).
Did it, several times, always dropping the old database before create the new one.

3. Extract / Upload c5 file to server.
Yes, two ways, extracting locally on my Mac and then uploading, or extracting using the server cPanel tool to decompress.

4. Via your website domain you enter the database login info and hit "Install".
Yes, did it two ways, with all the concrete required files and folders inside a folder or at the root level, the installer start, I select the language (english), then it shows the check test which goes all ok and then fill up all the form's fields with the data required, then install, then at some point of the installation comes the error!

5. That's when you get these errors?
Yes, when it's installing the last version, when is in a folder (i.e. mysite.com/home/) the error shows in or right after the "adding admin user", when the installation is on the root folder (i.e. mysite.com/) the error shows up after the blocks. With the prior version the error comes a few seconds after the installation bar starts.

I downloaded and tried to install it from the office, and from home, I thought the same, probably a corrupt file but I lost the count of how many times I downloaded it again and again...

I don't see at any moment in the installation process any field to put any value keys, all the form is filled with the info required. Also when Concrete5 checks if everything its ok for install all the checkmarks are green and ok.

The folder permissions I tried different ways also, once without touch them (default is 755), then at 777, also and just in case, re-applying the 755 permissions on all the folders mentioned in the guide.

:?

I don't really understand why :S the only thing I haven't tried yet is to do it from a PC but since I'm able to decompress the zip file at the server-side I don't think its the case...
BethCM replied on at Permalink Reply
BethCM
I'm afraid then that this sounds like a problem with the host.

I would contact them (domain.com has a chat option) and confirm that their service meets the requirements listed here:
http://www.concrete5.org/documentation/developers/5.7/installation/...

I've installed multiple versions of C5 with various hosts (in various countries too) and only seen that issue when I hadn't started with a completely empty database.

Sorry I can't be of more help.
daniacorp replied on at Permalink Reply
BethCM,

A very HUGE Thank you for all your time on this, I'll contact them again and post here any result!

Thanks!