Tasks Manager

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

Previous topic - Next topic

gevv

Hi,

Nice mod. Thanks @Diego Andrés

Turkish translation.
ElkArte is a modern, powerful community building forum software. https://www.elkarte.net/

Shades.

SMF 2.1.1
Tasks Manager 1.1.3

Sorry @Diego Andrés! O:)

It won't let me delete Tasks categories! It pops up and asks "Are you sure you want to delete this category? This will make the relevant projects or tasks uncategorized."
You cannot view this attachment.

But then takes me to the edit screen and then a full circle back to the category list where the category I tried to delete is still there.
You cannot view this attachment.
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

The url is wrong, will update package in a bit and will include Turkish translation.

Thanks

SMF Tricks - Free & Premium Responsive Themes for SMF.

Diego Andrés

1.1.4 - 20 March 2022
  • Translation Turkish translation provided by @gevv
  • Bug Fix Fixed wrong links when deleting categories.

SMF Tricks - Free & Premium Responsive Themes for SMF.

Shades.

Quote from: Diego Andrés on March 20, 2022, 06:05:11 PM1.1.4 - 20 March 2022
  • Translation Turkish translation provided by @gevv
  • Bug Fix Fixed wrong links when deleting categories.
Superb! Great mod @Diego Andrés! 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.

Uh oh I ran into another error. O:)

When going to Booking>Time Log or Book Time I get this error:

Quote'mysite.tk.task_name' isn't in GROUP BY
File: /home2/*****/public_html/*****/Sources/TasksManager/Tasks.php
Line: 544

QuoteError
Type of error
Database
Error message
Database Error: 'mysite.tk.task_name' isn't in GROUP BY



SELECT

tk.task_id, tk.task_name, tk.task_cat_id, tk.project_id,

tk.start_date, tk.end_date, tk.task_desc, tk.task_status_id, tk.estimated_hrs,

c.category_name, s.status_name, p.project_title, SUM(ts.hours_worked) AS hours_worked, SUM(ts.minutes_worked) AS minutes_worked, t.id_topic

FROM swb4_taskspp_tasks AS tk

LEFT JOIN swb4_topics AS t ON (t.tasks_task_id = tk.task_id)

LEFT JOIN swb4_taskspp_timesheet AS ts ON (ts.task_id = tk.task_id)

LEFT JOIN swb4_taskspp_projects AS p ON (p.project_id = tk.project_id)

LEFT JOIN swb4_taskspp_task_categories AS c ON (c.task_cat_id = tk.task_cat_id)

LEFT JOIN swb4_taskspp_project_status AS s ON (s.status_id = tk.task_status_id)

GROUP BY tk.task_id, c.category_name, s.status_name, p.project_title, t.id_topic

ORDER BY tk.task_id DESC

LIMIT 0, 25
File
/home2/*****/public_html/*****/Sources/TasksManager/Tasks.php
Line
544
URL of page causing the error
https://*****.com/index.php?action=tasksmanager;area=booking;sa=log

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/Tasks.php on line 544
#2: getTasks()
Called from /home2/*****/public_html/*****/Sources/TasksManager/Book.php on line 59
#3: main()
Called from /home2/*****/public_html/*****/Sources/Subs.php on line 6057
#4: call_helper()
Called from /home2/*****/public_html/*****/Sources/TasksManager/View.php on line 219
#5: main()
Called from /home2/*****/public_html/*****/index.php on line 187

QuoteError
Type of error
Database
Error message
Database Error: 'mysite.tk.task_name' isn't in GROUP BY



SELECT

tk.task_id, tk.task_name, tk.task_cat_id, tk.project_id,

tk.start_date, tk.end_date, tk.task_desc, tk.task_status_id, tk.estimated_hrs,

c.category_name, s.status_name, p.project_title, SUM(ts.hours_worked) AS hours_worked, SUM(ts.minutes_worked) AS minutes_worked, t.id_topic

FROM swb4_taskspp_tasks AS tk

LEFT JOIN swb4_topics AS t ON (t.tasks_task_id = tk.task_id)

LEFT JOIN swb4_taskspp_timesheet AS ts ON (ts.task_id = tk.task_id)

LEFT JOIN swb4_taskspp_projects AS p ON (p.project_id = tk.project_id)

LEFT JOIN swb4_taskspp_task_categories AS c ON (c.task_cat_id = tk.task_cat_id)

LEFT JOIN swb4_taskspp_project_status AS s ON (s.status_id = tk.task_status_id)

GROUP BY tk.task_id, c.category_name, s.status_name, p.project_title, t.id_topic

ORDER BY tk.task_id DESC

LIMIT 0, 25
File
/home2/*****/public_html/*****/Sources/TasksManager/Tasks.php
Line
544
URL of page causing the error
https://*****.com/index.php?action=tasksmanager;area=booking;sa=booktime
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/Tasks.php on line 544
#2: getTasks()
Called from /home2/*****/public_html/*****/Sources/TasksManager/Book.php on line 59
#3: main()
Called from /home2/*****/public_html/*****/Sources/Subs.php on line 6057
#4: call_helper()
Called from /home2/*****/public_html/*****/Sources/TasksManager/View.php on line 219
#5: 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

shawnb61

Mysql version? Or is it MariaDB?

Older mysql versions (and current mariadb) want a lot of unnecessary items in the group by.

The fix is typically to add all non-aggregate items in the select clause to the group by.
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Shades.

Quote from: shawnb61 on March 20, 2022, 09:10:38 PMMysql version? Or is it MariaDB?

Older mysql versions (and current mariadb) want a lot of unnecessary items in the group by.

The fix is typically to add all non-aggregate items in the select clause to the group by.
MySQL 5.6 PHP 7.4

The mod works great like it is and I don't really need the Booking part myself I was just testing it out. But I guess sooner or later I'm gonna have to upgrade to another host with a bigger MySQL version!?
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

shawnb61

Yep.  Mysql 5.7 doesn't behave that way, but 5.6 does.

Since SMF supports 5.6, I suspect the query needs to change. 
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Diego Andrés

I'm just gonna dump all of the columns there in all of those before I need to go look for a rope instead of a query  :laugh:

SMF Tricks - Free & Premium Responsive Themes for SMF.

shawnb61

I just ran into this on some custom stuff used in my forum that I'm bringing forward into 2.1.  My host is still on 5.6...  (I may submit it as a mod - an attachment browser w/tags & filters to help peruse attachments.)
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Diego Andrés

#51
@Shades. test?

You cannot view this attachment.

SMF Tricks - Free & Premium Responsive Themes for SMF.

Shades.

Quote from: Diego Andrés on March 21, 2022, 03:16:16 AM@Shades. test?

You cannot view this attachment.
Uploaded and getting:

QuoteUnknown column 'ttk.task_id' in 'field list'
File: /home2/*****/public_html/*****/Sources/TasksManager/Tasks.php
Line: 544

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

#53
typo
You cannot view this attachment.

SMF Tricks - Free & Premium Responsive Themes for SMF.

Shades.

Quote from: Diego Andrés on March 21, 2022, 02:32:07 PMtypo
You cannot view this attachment.
:laugh: Now getting:

QuoteUnknown column 'k.task_status_id' in 'field list'
File: /home2/shades75/public_html/shadesweb/Sources/TasksManager/Tasks.php
Line: 544
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

#55
:D

You cannot view this attachment.

SMF Tricks - Free & Premium Responsive Themes for SMF.

Shades.

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

Great!

1.1.5 - 21 March 2022
  • Bug Fix Fixed some more group by 'issues'.

SMF Tricks - Free & Premium Responsive Themes for SMF.

Diego Andrés

1.1.7 - 09 October 2022
  • New Feature New field to add comments in bookings.
  • Bug Fix Fixed tasks filter in booking action.

1.1.6 - 19 August 2022
  • Bug Fix Fixed issue with who actions/hook.


SMF Tricks - Free & Premium Responsive Themes for SMF.

mickjav

#59
Hi Getting Following Error On First view of Time Log.

You cannot view this attachment.

I have fixed my copy by adding the field 

Advertisement: