Trongate_users table

Comments for “Trongate_users table”

Posted by Charles Luck on Sunday 14th January 2024 at 18:16 GMT

I was cleaning up my test users, and I accidentally deleted all the Trongate_users rows including the admin code row.

Is there a way to recover that value?
Level One Member

Charles Luck

User Level: Level One Member

Date Joined: 18/06/2023

Posted by DaFa on Monday 15th January 2024 at 21:49 GMT

Hi Charles,

Yes, you can by going to Trongate on GitHub and then navigating to modules/welcome where you will find 'setup.sql' > https://github.com/trongate/trongate-framework/tree/master/modules/welcome
Then extract the 'Trongate_users' table from the SQL like so:
INSERT INTO `trongate_users` (`id`, `code`, `user_level_id`) VALUES
(1, 'Tz8tehsWsTPUHEtzfbYjXzaKNqLmfAUz', 1);
paste it into your favourite database manager - phpMyAdmin, Adminer, SQLyog, Navicat, etc...

Happy coding!

This comment was edited by DaFa on Monday 15th January 2024 at 21:51 GMT

Founding Member


User Level: Founding Member

Date Joined: 30/11/2018