Rosters Tab: An error occurred. Please contact your system administrator for help.

[GlenMcDonald]

I run the database through Xampp and was not able to run MySQL for an unknown reason. The error message suggested that the system shut down incorrectly. The version being run currently is 2.33.0

20240802 Screen Print of Error.pdf

I found a process from googling copy table from back up (I can't find the Youtube clip that helped me and I can't remembe exactly what I did). This enable me to run Xampp. The data seemed to be present but Jethro wouldn't run properly.

I was able to export the tables for back up. I then deleted the database and created a new one. I was able to run Jethro as a new installation to generate the tables in the database. I then imported the data for each of the tables. This enabled me to run the database. It seemed to work, other than the Rosters Tab on the drop down lists.

There was a reference to the one service code missing which I was able to add which enabled me to see "Define Roster Roles" with the list present.

However "Display roster assignments", "Edit Roster Assignments" and "Define Roster Views" all come up with errors as per the attached file.

Any assistance would be great. For all intent and purposes, it seems that all the data is still present.

[jefft]

Do you see any logs in C:\xampp\apache\logs\error.log or C:\xampp\php\logs\php_error_log?

Jethro's database isn't just plain tabular data. There's also a function called getCurrentUserID. It would be good to check it exists:

MariaDB [coastec_jethro]> show create function `getCurrentUserID`;
+------------------+----------+-------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+
| Function         | sql_mode | Create Function                                                                                                   | character_set_client | collation_connection | Database Collation |
+------------------+----------+-------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+
| getCurrentUserID |          | CREATE DEFINER=`jethro`@`localhost` FUNCTION `getCurrentUserID`() RETURNS int(11)
RETURN @current_user_id | utf8mb3              | utf8mb3_general_ci   | utf8mb4_bin        |
+------------------+----------+-------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+
1 row in set (0.000 sec)

Unless you ran mysqldump with --routines this won't have been preserved.

[GlenMcDonald]

Thank you for helping.

I have attached a copy of the Error Log C:\xampp\apache\logs\error.log

I have also found another error log in c:\xampp\mysql\data\mysql_error.log

When I look under PHP Admin at the database. In the tree, there is a branch called Functions, and located there is getCurrentUserID. I don't know how / where to search as you have done. Is this at the command prompt in the xampp directory (sorry, I know enough to get into trouble ...)

I didn't run mysqldump with |--routines. I had exported the tables in sql from PHP Admin for the database. I have compared the sql file to older sql files which I have used mysqldump and they do look very similar, but not exactly the same, but when I compare those difference in the table (with the structures), the data seems (atleast to me) to be the same. Sorry about my ignorance.|

Glen

On 2/08/2024 11:18 pm, Jeff Turner wrote:

Do you see any logs in |C:\xampp\apache\logs\error.log| or |C:\xampp\php\logs\php_error_log|?

Jethro's database isn't just plain tabular data. There's also a function called |getCurrentUserID|. It would be good to check it exists:

MariaDB [coastec_jethro]> show create functiongetCurrentUserID; +------------------+----------+-------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | Function | sql_mode | Create Function | character_set_client | collation_connection | Database Collation | +------------------+----------+-------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | getCurrentUserID | | CREATE DEFINER=jethro@localhost FUNCTIONgetCurrentUserID() RETURNSint(11) RETURN @current_user_id | utf8mb3 | utf8mb3_general_ci | utf8mb4_bin | +------------------+----------+-------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ 1 rowin set (0.000 sec)

Unless you ran mysqldump with |--routines| this won't have been preserved.

— Reply to this email directly, view it on GitHub https://github.com/tbar0970/jethro-pmm/issues/1066#issuecomment-2265442747, or unsubscribe https://github.com/notifications/unsubscribe-auth/AHXG4W3PU3D3CEGAFNBMNPDZPOEZTAVCNFSM6AAAAABL4R3EQSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDENRVGQ2DENZUG4. You are receiving this because you authored the thread.Message ID: @.***>

--

Rev Glen McDonald

Minister | Roxby Downs Christian Community Church

Church Office:

Corner Burgoyne St and Stuart Rd

Roxby Downs

Phone:

0433 077 330

/Serving the people ofRoxby Downs, Olympic Dam, /

/Andamooka and Woomera in Kokatha Country/ --------------jSMWLMr0t2NEZJQMYuqvlVrZ Content-Type: multipart/related; boundary="------------Jr3vilFu54EY6EvVHqHLU60I"

--------------Jr3vilFu54EY6EvVHqHLU60I Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit

<!DOCTYPE html>

Thank you for helping.

I have attached a copy of the Error Log C:\xampp\apache\logs\error.log

I have also found another error log in c:\xampp\mysql\data\mysql_error.log

When I look under PHP Admin at the database. In the tree, there is a branch called Functions, and located there is getCurrentUserID. I don't know how / where to search as you have done. Is this at the command prompt in the xampp directory (sorry, I know enough to get into trouble ...)

I didn't run mysqldump with --routines. I had exported the tables in sql from PHP Admin for the database. I have compared the sql file to older sql files which I have used mysqldump and they do look very similar, but not exactly the same, but when I compare those difference in the table (with the structures), the data seems (atleast to me) to be the same. Sorry about my ignorance.




Glen


On 2/08/2024 11:18 pm, Jeff Turner wrote:

Do you see any logs in C:\xampp\apache\logs\error.log or C:\xampp\php\logs\php_error_log?

Jethro's database isn't just plain tabular data. There's also a function called getCurrentUserID. It would be good to check it exists:

MariaDB [coastec_jethro]> show create function `getCurrentUserID`;
+------------------+----------+-------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+
| Function         | sql_mode | Create Function                                                                                                   | character_set_client | collation_connection | Database Collation |
+------------------+----------+-------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+
| getCurrentUserID |          | CREATE DEFINER=`jethro`@`localhost` FUNCTION `getCurrentUserID`() RETURNS int(11)
RETURN @current_user_id | utf8mb3              | utf8mb3_general_ci   | utf8mb4_bin        |
+------------------+----------+-------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+
1 row in set (0.000 sec)

Unless you ran mysqldump with --routines this won't have been preserved.

—
Reply to this email directly, view it on GitHub, or unsubscribe.
You are receiving this because you authored the thread.Message ID: <tbar0970/jethro-pmm/issues/1066/2265442747@github.com>

--

Rev Glen McDonald

Minister | Roxby Downs Christian Community Church

Church Office:	Corner Burgoyne St and Stuart Rd
	Roxby Downs
Phone:	0433 077 330