Task System (preliminary work)

**Congdar** · #1 10-27-2008, 02:31 PM

i didn't get that error unless it is in a different file, and my tasks table does have the repeatable column in it. The output I listed above was the entire log file except the first line: Starting Log: logs/eqemu_error_zone_3344.log

**joligario** · #2 10-27-2008, 03:15 PM

Run this:

Code:

SELECT id FROM tasks;

**Congdar** · #3 10-27-2008, 03:35 PM

returns 1 row id=12 Extraordinary Rodents

**Derision** · #4 10-27-2008, 03:50 PM

That's your problem then, you have entries in your activities table for tasks 1 through 11, but those tasks don't have entries in the task table.

**Congdar** · #5 10-27-2008, 03:57 PM

so, how'd they get there and how do I delete them if that's the fix?
all I did was source in the sql from svn, i didn't actually try and use the task system.

**Derision** · #6 10-27-2008, 04:09 PM

Code:

delete from activities where taskid < 12;

1_task_system.sql in SVN has the activities for my example tasks, but not the task rows for them, so anyone who has sourced this should execute this delete.

**Congdar** · #7 10-27-2008, 04:25 PM

should I clear out tasksets as well? is there a "reset" of this task system?

Why would I delete them as you suggest above? They were part of the svn sql additions. Were they changed/corrected at some point maybe after I had already done the imports? I'd like to have it set up the way you intended but it seems to not be working correctly for me.

the rules relating to the task system... I don't have any in my rules table as I'm taking the default from the code settings. Does there need to be a non-default change in the database rule_values to have them work correctly?