Tasks Manager

Started by Diego Andrés, February 19, 2022, 11:18:08 PM

Previous topic - Next topic

Diego Andrés

Quote from: mickjav on March 06, 2022, 11:25:36 AMIf 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?

SMF Tricks - Free & Premium Responsive Themes for SMF.

mickjav

Quote from: Diego Andrés on March 07, 2022, 12:22:15 PM
Quote from: mickjav on March 06, 2022, 11:25:36 AMIf 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

Home of Chart Tracker Elite, Apollo & DJ 2020, Coming soon The Librarian.

Shades.

SMF 2.1.1
Tasks Manager v1.1

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

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:

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

QuoteError
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
ShadesWeb.com - Custom Logos - My Themes on SMF | My Themes on ShadesWeb
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

Diego Andrés

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

SMF Tricks - Free & Premium Responsive Themes for SMF.

Diego Andrés

1.1.1 - 17 March 2022
  • Bug Fix Fixed wrong index for tasks column in install file.


Quote from: mickjav on March 06, 2022, 11:25:36 AMIf 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.

SMF Tricks - Free & Premium Responsive Themes for SMF.

mickjav

Quote from: Diego Andrés on March 18, 2022, 12:03:28 AM1.1.1 - 17 March 2022
  • Bug Fix Fixed wrong index for tasks column in install file.


Quote from: mickjav on March 06, 2022, 11:25:36 AMIf 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  ;D  ;D
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

Home of Chart Tracker Elite, Apollo & DJ 2020, Coming soon The Librarian.

mickjav

Quote from: mickjav on March 07, 2022, 12:29:51 PM
Quote from: Diego Andrés on March 07, 2022, 12:22:15 PM
Quote from: mickjav on March 06, 2022, 11:25:36 AMIf 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

Home of Chart Tracker Elite, Apollo & DJ 2020, Coming soon The Librarian.

Shades.

Quote from: Diego Andrés on March 18, 2022, 12:03:28 AM1.1.1 - 17 March 2022
  • Bug Fix Fixed wrong index for tasks column in install file.


Quote from: mickjav on March 06, 2022, 11:25:36 AMIf 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

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

QuoteError
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
ShadesWeb.com - Custom Logos - My Themes on SMF | My Themes on ShadesWeb
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

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"

Home of Chart Tracker Elite, Apollo & DJ 2020, Coming soon The Librarian.

mickjav

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

NOTE this will only work if you have installed 1.01
// 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

Home of Chart Tracker Elite, Apollo & DJ 2020, Coming soon The Librarian.

Diego Andrés

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

SMF Tricks - Free & Premium Responsive Themes for SMF.

mickjav

Quote from: Diego Andrés on March 19, 2022, 11:58:11 AMThat'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

Home of Chart Tracker Elite, Apollo & DJ 2020, Coming soon The Librarian.

Diego Andrés

1.1.2 - 19 March 2022
  • Bug Fix Fixed projects issue.
  • Bug Fix Fixed 'who' actions bug.
  • Bug Fix Fixed issue with install file.

SMF Tricks - Free & Premium Responsive Themes for SMF.

Shades.

Clean SMF 2.1.1
Task Manager 1.1.2

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

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

QuoteError
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
ShadesWeb.com - Custom Logos - My Themes on SMF | My Themes on ShadesWeb
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

Diego Andrés

#34
Try with this file in Sources/TasksManager/

You cannot view this attachment.

SMF Tricks - Free & Premium Responsive Themes for SMF.

Shades.

Quote from: Diego Andrés on March 19, 2022, 02:52:01 PMTry with this file in Sources/TasksManager/

You cannot view this attachment.
Yes that worked thanks! 8)
ShadesWeb.com - Custom Logos - My Themes on SMF | My Themes on ShadesWeb
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

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.
ShadesWeb.com - Custom Logos - My Themes on SMF | My Themes on ShadesWeb
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

Diego Andrés

Ok both issues fixed.

Anything else mr mod tester  :laugh:
Before I upload

SMF Tricks - Free & Premium Responsive Themes for SMF.

Shades.

Quote from: Diego Andrés on March 19, 2022, 03:39:08 PMOk both issues fixed.

Anything else mr mod tester  :laugh:
Before I upload
LOL! That's all I can see right now! O:)  :laugh:
ShadesWeb.com - Custom Logos - My Themes on SMF | My Themes on ShadesWeb
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

Diego Andrés

1.1.3 - 19 March 2022
  • Bug Fix Fixed more issues with projects.
  • Bug Fix Fixed a bug in the category type selection.

SMF Tricks - Free & Premium Responsive Themes for SMF.

Advertisement: