Tasks Manager

[Diego Andrés]

If you have left the default 20 Entries And are filtering by Name Then if you have say 35 Tasks in your tasks table it may only show those tasks that start with the letters A-S and if you want to add time for a task that begins with T you can't as it wont be in the list

Do you want to remove the limit from the booking page for both the filter and the booking action?

[mickjav]

If you have left the default 20 Entries And are filtering by Name Then if you have say 35 Tasks in your tasks table it may only show those tasks that start with the letters A-S and if you want to add time for a task that begins with T you can't as it wont be in the list

Do you want to remove the limit from the booking page for both the filter and the booking action?

I think it would be better for the program to sort something else out as over time that list may end up with hundreds of items.

As I pointed out something that Gallery pro uses which works well even with 600 records as below.

Project One
--Task One
--Task two
Project two
--Task one

And So One

[Shades.]

SMF 2.1.1
Tasks Manager v1.1

@Diego Andrés I'm having a bad day I guess, sorry!

Tried to install this on my theme demo site so I can keep up with all my tasks and theme edits but got this error:

Key column 'topic_id' doesn't exist in table
File: /home2/*****/public_html/*****/*****/Packages/temp/install.php
Line: 355

Error
Type of error
Database
Error message
Database Error: Key column 'topic_id' doesn't exist in table
File
/home2/*****/public_html/*****/*****/Packages/temp/install.php
Line
355
URL of page causing the error
https://*****.*****.com/index.php?action=admin;area=packages;sa=install2;package=Tasks-Manager_v1.1.zip;pid=0

Backtrace information
#0: smf_db_error()
Called from /home2/*****/public_html/*****/*****/Sources/Subs-Db-mysql.php on line 494
#1: smf_db_query()
Called from /home2/*****/public_html/*****/*****/Sources/DbPackages-mysql.php on line 206
#2: smf_db_create_table()
Called from /home2/*****/public_html/*****/*****/Packages/temp/install.php on line 355
#3: require()
Called from /home2/*****/public_html/*****/*****/Sources/Packages.php on line 1064
#4: PackageInstall()
Called from /home2/*****/public_html/*****/*****/Sources/Subs.php on line 6001
#5: call_helper()
Called from /home2/*****/public_html/*****/*****/Sources/Packages.php on line 91
#6: Packages()
Called from /home2/*****/public_html/*****/*****/Sources/Admin.php on line 499
#7: AdminMain()
Called from /home2/*****/public_html/*****/*****/index.php on line 187

[Diego Andrés]

It's a bug, sort of. I forgot to remove that index from the tasks table.
Will update it in later 

[Diego Andrés]

1.1.1 - 17 March 2022

• Fixed wrong index for tasks column in install file.

If you have left the default 20 Entries And are filtering by Name Then if you have say 35 Tasks in your tasks table it may only show those tasks that start with the letters A-S and if you want to add time for a task that begins with T you can't as it wont be in the list

Will have a look at this next week, if you have any suggestion let me know.

[mickjav]

1.1.1 - 17 March 2022

• Fixed wrong index for tasks column in install file.

If you have left the default 20 Entries And are filtering by Name Then if you have say 35 Tasks in your tasks table it may only show those tasks that start with the letters A-S and if you want to add time for a task that begins with T you can't as it wont be in the list

Will have a look at this next week, if you have any suggestion let me know.

I do have a wishlist   
https://www.databasedreams.co.uk/support/index.php?topic=90.0

I've also added a new ERD But need to update it for Task_ID Etc My main wish would be the time entry Comment and logging of Members_ID So we can have the option to team work.

All the best mick

[mickjav]

If you have left the default 20 Entries And are filtering by Name Then if you have say 35 Tasks in your tasks table it may only show those tasks that start with the letters A-S and if you want to add time for a task that begins with T you can't as it wont be in the list

Do you want to remove the limit from the booking page for both the filter and the booking action?

I think it would be better for the program to sort something else out as over time that list may end up with hundreds of items.

As I pointed out something that Gallery pro uses which works well even with 600 records as below.

Project One
--Task One
--Task two
Project two
--Task one

And So One

This is the only suggestion I can add for the Problem with the Tasks list, Unless you limit the list to items not marked as completed but then you will need a way for the user to identify what Status They use for Completed tasks??

mick

P.S. The post above has a image attached

[Shades.]

1.1.1 - 17 March 2022

• Fixed wrong index for tasks column in install file.

If you have left the default 20 Entries And are filtering by Name Then if you have say 35 Tasks in your tasks table it may only show those tasks that start with the letters A-S and if you want to add time for a task that begins with T you can't as it wont be in the list

Will have a look at this next week, if you have any suggestion let me know.

Just an fyi on the latest download Tasks Manager v1.1.1 for SMF 2.1.1...

Error on install fresh install SMF 2.1.1

'*****_demo.p.project_title' isn't in GROUP BY
File: /home2/*****/public_html/*****/Sources/TasksManager/Projects.php
Line: 555

Error
Type of error
Database
Error message
Database Error: '*****_demo.p.project_title' isn't in GROUP BY
File
/home2/*****/public_html/*****/Sources/TasksManager/Projects.php
Line
555
URL of page causing the error
https://*****.com/index.php?action=tasksmanager

Backtrace information
#0: smf_db_error()
Called from /home2/*****/public_html/*****/Sources/Subs-Db-mysql.php on line 494
#1: smf_db_query()
Called from /home2/*****/public_html/*****/Sources/TasksManager/Projects.php on line 555
#2: getProjects()
Called from /home2/*****/public_html/*****/Sources/Subs-List.php on line 132
#3: createList()
Called from /home2/*****/public_html/*****/Sources/TasksManager/Projects.php on line 265
#4: list()
Called from /home2/*****/public_html/*****/Sources/Subs.php on line 5998
#5: call_helper()
Called from /home2/*****/public_html/*****/Sources/TasksManager/Projects.php on line 76
#6: main()
Called from /home2/*****/public_html/*****/Sources/Subs.php on line 5998
#7: call_helper()
Called from /home2/*****/public_html/*****/Sources/TasksManager/View.php on line 219
#8: main()
Called from /home2/*****/public_html/*****/index.php on line 187

[mickjav]

Tried to install Version 1.1.1 on my test Forum But have the install Index Error @Shades. has reported

I can see where in the install File the problem seems to be coming from but not sure how to correct it 

Also just noticed on my Support Site, This only seems to generate a error when viewing the Summery Page of a profile "See Image"

[mickjav]

I suspect removing the below from install.php will allow it to complete

NOTE this will only work if you have installed 1.01

Code Select Expand

// Add a tasks column for the topics
$smcFunc['db_add_column']('
{db_prefix}topics',
[
'name' => 'tasks_task_id',
'type' => 'mediumint',
'size' => 8,
'unsigned' => true,
'default' => 0,
'not_null' => false,
]
);
I Think it needs a check to see if the column exists

This worked on my Test forum

[Diego Andrés]

That'll break adding tasks to a topic.
The issue is from something else.
I'll have a look later.

[mickjav]

That'll break adding tasks to a topic.
The issue is from something else.
I'll have a look later.

That's the code I had to REMOVE to enable It to complete the install:)

Haven't found why this is happening https://www.simplemachines.org/community/index.php?msg=4116852

[Diego Andrés]

1.1.2 - 19 March 2022

• Fixed projects issue.
• Fixed 'who' actions bug.
• Fixed issue with install file.

[Shades.]

Clean SMF 2.1.1
Task Manager 1.1.2

Getting this error after install and clicking on the "Task Manager" link:

'*****.p.project_picture' isn't in GROUP BY
File: /home2/*****/public_html/*****/Sources/TasksManager/Projects.php
Line: 555

Error
Type of error
Database
Error message
Database Error: '*****.p.project_picture' isn't in GROUP BY
File
/home2/*****/public_html/*****/Sources/TasksManager/Projects.php
Line
555
URL of page causing the error
https://*****.com/index.php?action=tasksmanager

Backtrace information
#0: smf_db_error()
Called from /home2/*****/public_html/*****/Sources/Subs-Db-mysql.php on line 494
#1: smf_db_query()
Called from /home2/*****/public_html/*****/Sources/TasksManager/Projects.php on line 555
#2: getProjects()
Called from /home2/*****/public_html/*****/Sources/Subs-List.php on line 132
#3: createList()
Called from /home2/*****/public_html/*****/Sources/TasksManager/Projects.php on line 265
#4: list()
Called from /home2/*****/public_html/*****/Sources/Subs.php on line 5998
#5: call_helper()
Called from /home2/*****/public_html/*****/Sources/TasksManager/Projects.php on line 76
#6: main()
Called from /home2/*****/public_html/*****/Sources/Subs.php on line 5998
#7: call_helper()
Called from /home2/*****/public_html/*****/Sources/TasksManager/View.php on line 219
#8: main()
Called from /home2/*****/public_html/*****/index.php on line 187

[Diego Andrés]

Try with this file in Sources/TasksManager/

You cannot view this attachment.

[Shades.]

Try with this file in Sources/TasksManager/

You cannot view this attachment.

Yes that worked thanks!

[Shades.]

Looks like Project categories and task categories are the same!?

If I add a new category to either one they both appear in Task categories but not in Project categories.

[Diego Andrés]

Ok both issues fixed.

Anything else mr mod tester 
Before I upload

[Shades.]

Ok both issues fixed.

Anything else mr mod tester 
Before I upload

LOL! That's all I can see right now!  

[Diego Andrés]

1.1.3 - 19 March 2022

• Fixed more issues with projects.
• Fixed a bug in the category type selection.