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
Database Error
Re: Database Error
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!
Help motivate us to continue by showing your appreciation!
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
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.
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!
Help motivate us to continue by showing your appreciation!