Unable to delete recurring schedules
-
- Posts: 34
- Joined: Wed Sep 12, 2007 2:50 pm
Unable to delete recurring schedules
I set a few employees to follow some recurring schedule templates I created.
However, when I attempt to delete any of the recurring schedules (not templates) it refreshes the page but nothing changes.
I also tried to change which template each employee follows, however, I was still unable to delete any records.
However, when I attempt to delete any of the recurring schedules (not templates) it refreshes the page but nothing changes.
I also tried to change which template each employee follows, however, I was still unable to delete any records.
Please follow the instructions in this post to enable debugging mode:
http://forums.timetrex.com/viewtopic.php?t=89
Then copy and paste the debug output here for further analysis.
http://forums.timetrex.com/viewtopic.php?t=89
Then copy and paste the debug output here for further analysis.
-
- Posts: 34
- Joined: Wed Sep 12, 2007 2:50 pm
(postgres7): select session_id,user_id,ip_address,created_date,updated_date from authentication WHERE session_id = ? AND ip_address = ? AND updated_date >= ? [ (session_id=>'9ef38455912e81ddbc88805e7f0cb9a2') (ip_address=>'127.0.0.1') (updated_date=>'1190045554') ]
________________________________________
________________________________________
(postgres7): update authentication set updated_date = ? where session_id = ? [ (updated_date=>'1190059954') (session_id=>'9ef38455912e81ddbc88805e7f0cb9a2') ]
________________________________________
________________________________________
(postgres7): select * from station where company_id = ? AND station_id = ? AND deleted = 0 [ (company_id=>'1') (station_id=>'a9c494f8beb1e9c1a04c3c68e647cbdd') ]
________________________________________
________________________________________
(postgres7): select * from cron WHERE deleted = 0 ORDER BY last_run_date DESC LIMIT 1
________________________________________
________________________________________
(postgres7): select d.severity_id as severity_id, count(*) as count from exception as a LEFT JOIN user_date as b ON a.user_date_id = b.id LEFT JOIN users as c ON b.user_id = c.id LEFT JOIN exception_policy as d ON a.exception_policy_id = d.id LEFT JOIN pay_period as e ON b.pay_period_id = e.id where b.user_id = ? AND b.date_stamp < ? AND e.status_id = ? AND NOT EXISTS ( select z.id from request as z where z.user_date_id = a.user_date_id AND z.status_id = 30 ) AND ( a.deleted = 0 AND b.deleted = 0 AND e.deleted=0) GROUP BY d.severity_id ORDER BY d.severity_id desc [ (user_id=>'5') (date_stamp=>'2007-09-17') (status_id=>'10') ]
________________________________________
________________________________________
(postgres7): select name FROM bread_crumb WHERE user_id = ? AND name = ? LIMIT 1 [ (user_id=>'5') (name=>'Recurring Schedule List') ]
________________________________________
________________________________________
(postgres7): UPDATE bread_crumb SET url = ?, created_date = ? WHERE user_id = ? AND name = ? [ (url=>'/interface/schedule/RecurringScheduleControlList.php?select_all=...') (created_date=>'1190059954') (user_id=>'5') (name=>'Recurring Schedule List') ]
________________________________________
________________________________________
(postgres7): select * from recurring_schedule_control as a where company_id = ? AND id = ? AND deleted = 0 [ (company_id=>'1') (id=>'1') ]
________________________________________
________________________________________
(postgres7): select a.* from recurring_schedule_user as a where a.recurring_schedule_control_id = ? [ (id=>'1') ]
________________________________________
________________________________________
(postgres7): select a.* from recurring_schedule_user as a where a.recurring_schedule_control_id = ? [ (id=>'1') ]
________________________________________
________________________________________
(postgres7): select * from recurring_schedule_control where id = ? AND deleted = 0 [ (id=>'1') ]
________________________________________
Fatal error: Call to a member function getCurrent() on a non-object in C:\Program Files\TimeTrex\timetrex\classes\modules\schedule\RecurringScheduleControlFactory.class.php on line 227
________________________________________
________________________________________
(postgres7): update authentication set updated_date = ? where session_id = ? [ (updated_date=>'1190059954') (session_id=>'9ef38455912e81ddbc88805e7f0cb9a2') ]
________________________________________
________________________________________
(postgres7): select * from station where company_id = ? AND station_id = ? AND deleted = 0 [ (company_id=>'1') (station_id=>'a9c494f8beb1e9c1a04c3c68e647cbdd') ]
________________________________________
________________________________________
(postgres7): select * from cron WHERE deleted = 0 ORDER BY last_run_date DESC LIMIT 1
________________________________________
________________________________________
(postgres7): select d.severity_id as severity_id, count(*) as count from exception as a LEFT JOIN user_date as b ON a.user_date_id = b.id LEFT JOIN users as c ON b.user_id = c.id LEFT JOIN exception_policy as d ON a.exception_policy_id = d.id LEFT JOIN pay_period as e ON b.pay_period_id = e.id where b.user_id = ? AND b.date_stamp < ? AND e.status_id = ? AND NOT EXISTS ( select z.id from request as z where z.user_date_id = a.user_date_id AND z.status_id = 30 ) AND ( a.deleted = 0 AND b.deleted = 0 AND e.deleted=0) GROUP BY d.severity_id ORDER BY d.severity_id desc [ (user_id=>'5') (date_stamp=>'2007-09-17') (status_id=>'10') ]
________________________________________
________________________________________
(postgres7): select name FROM bread_crumb WHERE user_id = ? AND name = ? LIMIT 1 [ (user_id=>'5') (name=>'Recurring Schedule List') ]
________________________________________
________________________________________
(postgres7): UPDATE bread_crumb SET url = ?, created_date = ? WHERE user_id = ? AND name = ? [ (url=>'/interface/schedule/RecurringScheduleControlList.php?select_all=...') (created_date=>'1190059954') (user_id=>'5') (name=>'Recurring Schedule List') ]
________________________________________
________________________________________
(postgres7): select * from recurring_schedule_control as a where company_id = ? AND id = ? AND deleted = 0 [ (company_id=>'1') (id=>'1') ]
________________________________________
________________________________________
(postgres7): select a.* from recurring_schedule_user as a where a.recurring_schedule_control_id = ? [ (id=>'1') ]
________________________________________
________________________________________
(postgres7): select a.* from recurring_schedule_user as a where a.recurring_schedule_control_id = ? [ (id=>'1') ]
________________________________________
________________________________________
(postgres7): select * from recurring_schedule_control where id = ? AND deleted = 0 [ (id=>'1') ]
________________________________________
Fatal error: Call to a member function getCurrent() on a non-object in C:\Program Files\TimeTrex\timetrex\classes\modules\schedule\RecurringScheduleControlFactory.class.php on line 227
This is very strange, is it possible for you to email support@timetrex.com a SQL dump of your database so we can try to replicate the issue here?
-
- Posts: 34
- Joined: Wed Sep 12, 2007 2:50 pm
-
- Posts: 34
- Joined: Wed Sep 12, 2007 2:50 pm
What I mean is:
I type in:
"pg_dumpall -h localhost -p 5433 -U timetrex -W > output.txt"
When it prompts for the password, I enter the password as found in the timetrex.ini.php file. It then returns the following:
I type in:
"pg_dumpall -h localhost -p 5433 -U timetrex -W > output.txt"
When it prompts for the password, I enter the password as found in the timetrex.ini.php file. It then returns the following:
So I assume I am using the wrong user/pass. I guess I need the superuser password, but I cannot recall setting one up.C:\Program Files\TimeTrex\postgresql\bin>pg_dumpall -h localhost -p 5433 -U timetrex -W > output.txt
Password:
pg_dumpall: query failed: ERROR: permission denied for relation g_authid
pg_dumpall: query was: SELECT rolname, rolsuper, rolinherit, rolcreaterole, rolcreatedb, rolcatupdate, rolcanlogin, rolconnlimit, rolpassword, rolvaliduntil, pg_catalog.shobj_description(oid, 'pg_authid') as rolcomment FROM pg_authid ORDERBY 1
-
- Posts: 34
- Joined: Wed Sep 12, 2007 2:50 pm
-
- Posts: 34
- Joined: Wed Sep 12, 2007 2:50 pm
I did use the windows installer, however I did not have the *.bat file you mentioned.shaunw wrote:How did you install TimeTrex? If you used the installer, there should be a backup_timetrex.bat file in the TimeTrex directory that you can just run.
Failing that, try this command instead:pg_dump -h localhost -p 5433 -U timetrex -W timetrex > output.sql
-
- Posts: 34
- Joined: Wed Sep 12, 2007 2:50 pm
You will need to use a command like this:
You will want to drop the current "timetrex" database first though, or create a new database to load it into, otherwise you will get conflicts.
Code: Select all
psql -h localhost -p 5433 -U timetrex -W timetrex < output.sql
-
- Posts: 34
- Joined: Wed Sep 12, 2007 2:50 pm
Sorry to be such a pain in the neck here, but here is what happened...
I ran
I ran
I went to run
I then attempted to run
what account do I need to use to create the database?
I ran
, no errors...dropdb -h localhost -p 5433 -U timetrex -W timetrex
I ran
and it stated "database timetrex does not exist"psql -h localhost -p 5433 -U timetrex -W timetrex < output.sql
I went to run
and it returned the error "permission denied to create database".createdb -h localhost -p 5433 -U timetrex -W timetrex
I then attempted to run
with the same permission denied error.createdb -h localhost -p 5433 timetrex
what account do I need to use to create the database?
Try creating the database with the "postgres" user:
Same password as the timetrex user.
Just so you know, doing a clean install with the exact same database while possible, is unlikely to make any difference.
Code: Select all
createdb -h localhost -p 5433 -U postgres -W timetrex
Just so you know, doing a clean install with the exact same database while possible, is unlikely to make any difference.
-
- Posts: 34
- Joined: Wed Sep 12, 2007 2:50 pm