Database Error

Ask your questions regarding TimeTrex installation here.
Locked
ravenrtc
Posts: 2
Joined: Mon Aug 28, 2006 6:27 pm

Database Error

Post by ravenrtc »

Hi

I have no prior experience with postgresql, so I am not quite sure how to interpret this error:

[Sun Aug 27 21:36:19 2006] [error] PHP Fatal error: Uncaught exception 'ADODB_Exception' with message 'postgres7 error: [-1: ERROR: current transaction is aborted, commands ignored until end of transaction block] in adodb_throw(CREATE SEQUENCE public.company_id_seq START 1, )\n' in /home/yngroup/public_html/staff/classes/adodb/adodb-exceptions.inc.php:78\nStack trace:\n#0 /home/yngroup/public_html/staff/classes/adodb/adodb.inc.php(221): adodb_throw('postgres7', 'adodb_throw', -1, 'ERROR: current...', 'CREATE SEQUENCE...', false, Object(ADODB_postgres7))\n#1 /home/yngroup/public_html/staff/classes/adodb/adodb.inc.php(886): ADODB_TransMonitor('postgres7', 'EXECUTE', -1, 'ERROR: current...', 'CREATE SEQUENCE...', false, Object(ADODB_postgres7))\n#2 /home/yngroup/public_html/staff/classes/adodb/adodb.inc.php(861): ADOConnection->_Execute('CREATE SEQUENCE...', false)\n#3 /home/yngroup/public_html/staff/classes/adodb/adodb.inc.php(954): ADOConnection->Execute('CREATE SEQUENCE...')\n#4 /home/yngroup/public_html/staff/classes/modules/core/Factory.class.php(729): ADOConnec in /home/yngroup/public_html/staff/classes/adodb/adodb-exceptions.inc.php on line 78

I get this error after a blank page shows up just after submitting the information for the database during installation.

Any help would be appreicated!
Thanks,
Matthew

EDIT: Running PHP 5.1.5, postgresql 8.1
mikeb
Posts: 709
Joined: Thu Jul 27, 2006 11:58 am

Re: Database Error

Post by mikeb »

ravenrtc wrote:Hi

I have no prior experience with postgresql, so I am not quite sure how to interpret this error:

[Sun Aug 27 21:36:19 2006] [error] PHP Fatal error: Uncaught exception 'ADODB_Exception' with message 'postgres7 error: [-1: ERROR: current transaction is aborted, commands ignored until end of transaction block] in adodb_throw(CREATE SEQUENCE public.company_id_seq START 1, )\n' in /home/yngroup/public_html/staff/classes/adodb/adodb-exceptions.inc.php:78\nStack trace:\n#0 /home/yngroup/public_html/staff/classes/adodb/adodb.inc.php(221): adodb_throw('postgres7', 'adodb_throw', -1, 'ERROR: current...', 'CREATE SEQUENCE...', false, Object(ADODB_postgres7))\n#1 /home/yngroup/public_html/staff/classes/adodb/adodb.inc.php(886): ADODB_TransMonitor('postgres7', 'EXECUTE', -1, 'ERROR: current...', 'CREATE SEQUENCE...', false, Object(ADODB_postgres7))\n#2 /home/yngroup/public_html/staff/classes/adodb/adodb.inc.php(861): ADOConnection->_Execute('CREATE SEQUENCE...', false)\n#3 /home/yngroup/public_html/staff/classes/adodb/adodb.inc.php(954): ADOConnection->Execute('CREATE SEQUENCE...')\n#4 /home/yngroup/public_html/staff/classes/modules/core/Factory.class.php(729): ADOConnec in /home/yngroup/public_html/staff/classes/adodb/adodb-exceptions.inc.php on line 78

I get this error after a blank page shows up just after submitting the information for the database during installation.

Any help would be appreicated!
Thanks,
Matthew

EDIT: Running PHP 5.1.5, postgresql 8.1

Unfortunately that error doesn't give us much information. You might want to check the PostgreSQL logs, see if anything additional is in there. My guess is its a permission problem. At the bottom of the Database setup page, did you enter the superuser information, "postgres" and the postgres user password?
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!
ravenrtc
Posts: 2
Joined: Mon Aug 28, 2006 6:27 pm

Post by ravenrtc »

Well, this is what I see in PostgreSQL when I run the install script.

Code: Select all

NOTICE:  CREATE TABLE will create implicit sequence "absence_policy_id_seq" for serial column "absence_policy.id"
NOTICE:  CREATE TABLE will create implicit sequence "accrual_id_seq" for serial column "accrual.id"
NOTICE:  CREATE TABLE will create implicit sequence "accrual_balance_id_seq" for serial column "accrual_balance.id"
NOTICE:  CREATE TABLE will create implicit sequence "accrual_policy_id_seq" for serial column "accrual_policy.id"
NOTICE:  CREATE TABLE will create implicit sequence "authentication_id_seq" for serial column "authentication.id"
NOTICE:  CREATE TABLE will create implicit sequence "authorizations_id_seq" for serial column "authorizations.id"
NOTICE:  CREATE TABLE will create implicit sequence "bank_account_id_seq" for serial column "bank_account.id"
NOTICE:  CREATE TABLE will create implicit sequence "branch_id_seq" for serial column "branch.id"
NOTICE:  CREATE TABLE will create implicit sequence "bread_crumb_id_seq" for serial column "bread_crumb.id"
NOTICE:  CREATE TABLE will create implicit sequence "company_id_seq" for serial column "company.id"
NOTICE:  CREATE TABLE will create implicit sequence "company_deduction_id_seq" for serial column "company_deduction.id"
NOTICE:  CREATE TABLE will create implicit sequence "company_deduction_pay_stub_entry_account_id_seq" for serial column "company_deduction_pay_stub_entry_account.id"
NOTICE:  CREATE TABLE will create implicit sequence "cron_id_seq" for serial column "cron.id"
NOTICE:  CREATE TABLE will create implicit sequence "department_id_seq" for serial column "department.id"
NOTICE:  CREATE TABLE will create implicit sequence "department_branch_id_seq" for serial column "department_branch.id"
NOTICE:  CREATE TABLE will create implicit sequence "department_branch_user_id_seq" for serial column "department_branch_user.id"
NOTICE:  CREATE TABLE will create implicit sequence "exception_id_seq" for serial column "exception.id"
NOTICE:  CREATE TABLE will create implicit sequence "exception_policy_id_seq" for serial column "exception_policy.id"
NOTICE:  CREATE TABLE will create implicit sequence "exception_policy_control_id_seq" for serial column "exception_policy_control.id"
NOTICE:  CREATE TABLE will create implicit sequence "help_id_seq" for serial column "help.id"
NOTICE:  CREATE TABLE will create implicit sequence "help_group_id_seq" for serial column "help_group.id"
NOTICE:  CREATE TABLE will create implicit sequence "help_group_control_id_seq" for serial column "help_group_control.id"
NOTICE:  CREATE TABLE will create implicit sequence "hierarchy_control_id_seq" for serial column "hierarchy_control.id"
NOTICE:  CREATE TABLE will create implicit sequence "hierarchy_object_type_id_seq" for serial column "hierarchy_object_type.id"
NOTICE:  CREATE TABLE will create implicit sequence "hierarchy_share_id_seq" for serial column "hierarchy_share.id"
NOTICE:  CREATE TABLE will create implicit sequence "holiday_id_seq" for serial column "holiday.id"
NOTICE:  CREATE TABLE will create implicit sequence "holiday_policy_id_seq" for serial column "holiday_policy.id"
NOTICE:  CREATE TABLE will create implicit sequence "holiday_policy_recurring_holiday_id_seq" for serial column "holiday_policy_recurring_holiday.id"
NOTICE:  CREATE TABLE will create implicit sequence "holidays_id_seq" for serial column "holidays.id"
NOTICE:  CREATE TABLE will create implicit sequence "log_id_seq" for serial column "log.id"
NOTICE:  CREATE TABLE will create implicit sequence "meal_policy_id_seq" for serial column "meal_policy.id"
NOTICE:  CREATE TABLE will create implicit sequence "message_id_seq" for serial column "message.id"
NOTICE:  CREATE TABLE will create implicit sequence "other_field_id_seq" for serial column "other_field.id"
NOTICE:  CREATE TABLE will create implicit sequence "over_time_policy_id_seq" for serial column "over_time_policy.id"
NOTICE:  CREATE TABLE will create implicit sequence "pay_period_id_seq" for serial column "pay_period.id"
NOTICE:  CREATE TABLE will create implicit sequence "pay_period_schedule_id_seq" for serial column "pay_period_schedule.id"
NOTICE:  CREATE TABLE will create implicit sequence "pay_period_schedule_user_id_seq" for serial column "pay_period_schedule_user.id"
NOTICE:  CREATE TABLE will create implicit sequence "pay_stub_id_seq" for serial column "pay_stub.id"
NOTICE:  CREATE TABLE will create implicit sequence "pay_stub_amendment_id_seq" for serial column "pay_stub_amendment.id"
NOTICE:  CREATE TABLE will create implicit sequence "pay_stub_entry_id_seq" for serial column "pay_stub_entry.id"
NOTICE:  CREATE TABLE will create implicit sequence "pay_stub_entry_account_id_seq" for serial column "pay_stub_entry_account.id"
NOTICE:  CREATE TABLE will create implicit sequence "pay_stub_entry_account_link_id_seq" for serial column "pay_stub_entry_account_link.id"
NOTICE:  CREATE TABLE will create implicit sequence "permission_id_seq" for serial column "permission.id"
NOTICE:  CREATE TABLE will create implicit sequence "policy_group_id_seq" for serial column "policy_group.id"
NOTICE:  CREATE TABLE will create implicit sequence "policy_group_over_time_policy_id_seq" for serial column "policy_group_over_time_policy.id"
NOTICE:  CREATE TABLE will create implicit sequence "policy_group_premium_policy_id_seq" for serial column "policy_group_premium_policy.id"
NOTICE:  CREATE TABLE will create implicit sequence "policy_group_round_interval_policy_id_seq" for serial column "policy_group_round_interval_policy.id"
NOTICE:  CREATE TABLE will create implicit sequence "policy_group_user_id_seq" for serial column "policy_group_user.id"
NOTICE:  CREATE TABLE will create implicit sequence "premium_policy_id_seq" for serial column "premium_policy.id"
NOTICE:  CREATE TABLE will create implicit sequence "punch_id_seq" for serial column "punch.id"
NOTICE:  CREATE TABLE will create implicit sequence "punch_control_id_seq" for serial column "punch_control.id"
NOTICE:  CREATE TABLE will create implicit sequence "recurring_holiday_id_seq" for serial column "recurring_holiday.id"
NOTICE:  CREATE TABLE will create implicit sequence "recurring_ps_amendment_id_seq" for serial column "recurring_ps_amendment.id"
NOTICE:  CREATE TABLE will create implicit sequence "recurring_ps_amendment_user_id_seq" for serial column "recurring_ps_amendment_user.id"
NOTICE:  CREATE TABLE will create implicit sequence "recurring_schedule_control_id_seq" for serial column "recurring_schedule_control.id"
NOTICE:  CREATE TABLE will create implicit sequence "recurring_schedule_template_id_seq" for serial column "recurring_schedule_template.id"
NOTICE:  CREATE TABLE will create implicit sequence "recurring_schedule_template_control_id_seq" for serial column "recurring_schedule_template_control.id"
NOTICE:  CREATE TABLE will create implicit sequence "recurring_schedule_user_id_seq" for serial column "recurring_schedule_user.id"
NOTICE:  CREATE TABLE will create implicit sequence "request_id_seq" for serial column "request.id"
NOTICE:  CREATE TABLE will create implicit sequence "roe_id_seq" for serial column "roe.id"
NOTICE:  CREATE TABLE will create implicit sequence "round_interval_policy_id_seq" for serial column "round_interval_policy.id"
NOTICE:  CREATE TABLE will create implicit sequence "round_policy_id_seq" for serial column "round_policy.id"
NOTICE:  CREATE TABLE will create implicit sequence "schedule_id_seq" for serial column "schedule.id"
NOTICE:  CREATE TABLE will create implicit sequence "schedule_policy_id_seq" for serial column "schedule_policy.id"
NOTICE:  CREATE TABLE will create implicit sequence "station_id_seq" for serial column "station.id"
NOTICE:  CREATE TABLE will create implicit sequence "station_user_id_seq" for serial column "station_user.id"
NOTICE:  CREATE TABLE will create implicit sequence "system_setting_id_seq" for serial column "system_setting.id"
NOTICE:  CREATE TABLE will create implicit sequence "user_id_seq" for serial column "user.id"
NOTICE:  CREATE TABLE will create implicit sequence "user_date_id_seq" for serial column "user_date.id"
NOTICE:  CREATE TABLE will create implicit sequence "user_date_total_id_seq" for serial column "user_date_total.id"
NOTICE:  CREATE TABLE will create implicit sequence "user_deduction_id_seq" for serial column "user_deduction.id"
NOTICE:  CREATE TABLE will create implicit sequence "user_default_id_seq" for serial column "user_default.id"
NOTICE:  CREATE TABLE will create implicit sequence "user_default_company_deduction_id_seq" for serial column "user_default_company_deduction.id"
NOTICE:  CREATE TABLE will create implicit sequence "user_generic_data_id_seq" for serial column "user_generic_data.id"
NOTICE:  CREATE TABLE will create implicit sequence "user_pay_period_total_id_seq" for serial column "user_pay_period_total.id"
NOTICE:  CREATE TABLE will create implicit sequence "user_preference_id_seq" for serial column "user_preference.id"
NOTICE:  CREATE TABLE will create implicit sequence "user_tax_id_seq" for serial column "user_tax.id"
NOTICE:  CREATE TABLE will create implicit sequence "user_title_id_seq" for serial column "user_title.id"
NOTICE:  CREATE TABLE will create implicit sequence "user_wage_id_seq" for serial column "user_wage.id"
NOTICE:  CREATE TABLE will create implicit sequence "pay_period_time_sheet_verify_id_seq" for serial column "pay_period_time_sheet_verify.id"
NOTICE:  CREATE TABLE will create implicit sequence "company_user_count_id_seq" for serial column "company_user_count.id"
WARNING:  there is already a transaction in progress
mikeb
Posts: 709
Joined: Thu Jul 27, 2006 11:58 am

Post by mikeb »

Unfortuantely that log does not show anything out of the ordinary either. The warning at the end is just that, a warning, it shouldn't cause the script to stop or throw an error at all.

Was there more to the log then that by chance?

You could try enabling debug mode, bumping the verbosity up to 11 in the timetrex.ini.php file right before you click "Next" on the database settings page. To continue through the installer the verbosity has to be 10 or less.
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!
Locked