Table 'hs_hr_config' already exists.

Technical Information on MySQL database

Moderator: Admin

Table 'hs_hr_config' already exists.

Postby akitikkx » Mon Mar 05, 2012 3:33 pm

I have not been able to install successfully as I keep getting the same error and have run out of ideas on what to do now
Installation aborted due to an error.

Click [Clean Up Install] to correct the error and try installing again.

Table 'hs_hr_config' already exists. Query: create table `hs_hr_config` ( `key` varchar(100) not null default '', `value` varchar(512) not null default '', primary key (`key`) ) engine=innodb default charset=utf8

Help would be appreciated
akitikkx
 
Posts: 2
Joined: Mon Mar 05, 2012 3:22 pm

Re: Table 'hs_hr_config' already exists.

Postby chameera » Tue Mar 06, 2012 9:46 am

Hi akitikkx,
It seems like your installation process has been interrupted, and due to some reason, it has been corrupted.
What you can do now is;
1. drop the database that you gave during the installation.
2. go to <orangeHrm-web-root-dir>/lib/confs using file browser and delete Conf.php file
3. access orangeHRM url through the browser and follow the installation instructions (fresh installation)

hope this might solve your problem.
chameera
 
Posts: 147
Joined: Tue Jan 31, 2012 10:29 am

Re: Table 'hs_hr_config' already exists.

Postby akitikkx » Wed Mar 07, 2012 2:09 pm

Thank you chameera for the response. I have tried what you just told me and I am still getting the same error. In fact I was monitoring the \lib\confs dir while installing and Conf.php was never created, there is only Conf.php-distribution and Conf-auto.php
akitikkx
 
Posts: 2
Joined: Mon Mar 05, 2012 3:22 pm

Re: Table 'hs_hr_config' already exists.

Postby chameera » Thu Mar 08, 2012 1:32 pm

then set write permission to conf dir
Code: Select all
chmod -R 777 lib/confs
chameera
 
Posts: 147
Joined: Tue Jan 31, 2012 10:29 am

Re: Table 'hs_hr_config' already exists.

Postby Selam » Fri Jun 01, 2012 12:15 pm

I encountered the same problem as u did. i read your post and i deleted the config.phpdistribution file and it worked. Thank u for the help.
Selam
 
Posts: 1
Joined: Fri Jun 01, 2012 12:11 pm

Re: Table 'hs_hr_config' already exists.

Postby Nahualtsintli » Wed Jun 06, 2012 4:00 am

I encountered the same problem, applied the fixes suggested (dropped created database, deleted Conf.php-distribution and changed lib/confs directory rigths) but didnt work.

I am running Windows 7 Professional.
I am running XAMP for windows ver 1.7.4 with PHP 5.3.5 and MySQL 5.5.8

Any ideas? :?:
Nahualtsintli
 
Posts: 4
Joined: Wed Jun 06, 2012 3:38 am

Re: Table 'hs_hr_config' already exists.

Postby chameera » Wed Jun 06, 2012 8:32 am

Nahualtsintli wrote:I encountered the same problem, applied the fixes suggested (dropped created database, deleted Conf.php-distribution and changed lib/confs directory rigths) but didnt work.

I am running Windows 7 Professional.
I am running XAMP for windows ver 1.7.4 with PHP 5.3.5 and MySQL 5.5.8

Any ideas? :?:


Hi Nahualtsintli,
don't delete Conf.php-distribution. just delete Conf.php. If you already delete Conf.php-distribution, restore it to lib/confs/
chameera
 
Posts: 147
Joined: Tue Jan 31, 2012 10:29 am

Re: Table 'hs_hr_config' already exists.

Postby pradheepayyanar » Fri Jun 08, 2012 2:55 pm

Dear All

i have been trying to install the application and it shows always a blank page after database creation. after that when i refresh its always the same error thats being displayed. i tried all the options that has been told. how do we check the error message since its blank page.

Is there any alternative wherein we can deploy the script later

Regards
Pradheep
pradheepayyanar
 
Posts: 1
Joined: Fri Jun 08, 2012 2:48 pm

Re: Table 'hs_hr_config' already exists.

Postby Nahualtsintli » Mon Jun 18, 2012 9:54 pm

[quote="chameera"][quote="Nahualtsintli"]I encountered the same problem, applied the fixes suggested (dropped created database, deleted Conf.php-distribution and changed lib/confs directory rigths) but didnt work.

I am running Windows 7 Professional.
I am running XAMP for windows ver 1.7.4 with PHP 5.3.5 and MySQL 5.5.8

Any ideas? :?:[/quote]

Hi Nahualtsintli,
don't delete Conf.php-distribution. just delete Conf.php. If you already delete Conf.php-distribution, restore it to lib/confs/[/quote]

Hello Chameera,

These are the files I find in my lib\confs directory:
Conf.php-distribution
Conf-auto
log_settings
mailConf.php-distribution
sysConf

File Conf.php is not in my directory. What do you suggest? Rename Conf.php-distribution?
Nahualtsintli
 
Posts: 4
Joined: Wed Jun 06, 2012 3:38 am

Re: Table 'hs_hr_config' already exists.

Postby Nahualtsintli » Mon Jun 18, 2012 10:02 pm

pradheepayyanar wrote:Dear All

i have been trying to install the application and it shows always a blank page after database creation. after that when i refresh its always the same error thats being displayed. i tried all the options that has been told. how do we check the error message since its blank page.

Is there any alternative wherein we can deploy the script later

Regards
Pradheep


Hello pradheepayyanar,
in the blank page, if you refresh your browser (F5 in Windows Explorer), you may see the error message.
Nahualtsintli
 
Posts: 4
Joined: Wed Jun 06, 2012 3:38 am

Re: Table 'hs_hr_config' already exists.

Postby ravipandey » Fri Jul 06, 2012 12:40 am

hello pradheep,
please follow the following instruction. i am pretty sure it will wok.
Increase the maximum execution time in php.
Do the following and try again installing.

Open the php.ini file and locate the following line

max_execution_time = 30

Change the value to 60.
Restart the apache server application.
Now try installing the application again.
Before that make sure that there is no database with the name and having tables already created.

This should install the application without any error.

Post the result after trying.
ravipandey
 
Posts: 1
Joined: Fri Jul 06, 2012 12:31 am

Re: Table 'hs_hr_config' already exists.

Postby hbizoo » Tue Nov 06, 2012 12:04 pm

After increase the execution time in php.ini file it works for me...
hbizoo
 
Posts: 1
Joined: Tue Nov 06, 2012 12:01 pm

Re: Table 'hs_hr_config' already exists.

Postby mrmgomes » Mon Nov 12, 2012 5:04 pm

Changing PHP.ini max_execution_time to 60 did the trick for me. Thank you very much Ravi!


You know what I find annoying? People who come here asking for help, but when the solution is found no one ever comes back to leave a feedback in order to help other ppl out.

I guess there are no more replies after Ravi's post because it worked for everyone. Yet no one came back to say so.
When will people learn how to use a FORUM? Geez..
mrmgomes
 
Posts: 1
Joined: Mon Nov 12, 2012 5:00 pm

Re: Table 'hs_hr_config' already exists.

Postby aostarit » Wed Dec 12, 2012 7:39 am

Selam wrote:I encountered the same problem as u did. i read your post and i deleted the config.phpdistribution file and it worked. Thank u for the help.


i tried,it's work.
aostarit
 
Posts: 1
Joined: Wed Dec 12, 2012 7:31 am

Re: Table 'hs_hr_config' already exists.

Postby livcyxing » Sat Mar 09, 2013 4:57 pm

Changing PHP.ini max_execution_time to 60 did the trick for me. Thank you very much Ravi!
_________________
http://www.mmoggg.de/
http://www.saferunescapegold.com/
livcyxing
 
Posts: 2
Joined: Sat Mar 09, 2013 4:54 pm


Return to MySQL

Who is online

Users browsing this forum: No registered users and 0 guests