Btmanager 3.0.2 work progress

[joeroberts]

what sql version are you using?

[wdq]

Originally Posted by budgie

Creating Table bans...
Error Executing SQL Query -- -------------------------------------------------------- -- -- Table structure for table `torrent_bans` -- CREATE TABLE IF NOT EXISTS `torrent_bans` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `ban_userid` mediumint(8) NOT NULL DEFAULT '0', `ban_email` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '', `ipstart` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '', `ipend` int(10) unsigned NOT NULL DEFAULT '0', `ban_start` int(11) NOT NULL DEFAULT '0', `ban_end` int(11) NOT NULL DEFAULT '0', `ban_exclude` int(1) NOT NULL DEFAULT '0', `reason` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `ban_give_reason` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `date` datetime NOT NULL DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
Error ID: 1067
Error Message: Invalid default value for 'date'
A Fatal Error Occurred during Setup. Please Fix the above Error and try running the Setup again, or Refreshing your Browser.

What php and mysql version you have ?
Post the output of

Php -v
Mysql -v
Mariadb -v

PS:
Joe could you please give me a hint related to the permissions , not able to edit profile as user in group user with standard permissions. The error I am getting how much I try to change permissions is that
Your user does not have enough access to see members profiles.

But I want to edit my own profile...
Any idea comes to mind ?

[M-jay]

Sql invalid datetime

That's sql mode allow zero dates or something - these should be null really
`date` datetime NULL,

[xblade]

Joe
using xampp-windows-x64-7.2.25-0-VC15-installer on pc testing it out before i add it to live host

[joeroberts]

Originally Posted by wdq

PS:
Joe could you please give me a hint related to the permissions , not able to edit profile as user in group user with standard permissions. The error I am getting how much I try to change permissions is that
Your user does not have enough access to see members profiles.

But I want to edit my own profile...
Any idea comes to mind ?

are you trying as a user or a admin?

[wdq]

As a user cannot edit my profile, as admin I tried a lot of variants but still does not allow me to edit my profile as user , like change password and so on

[joeroberts]

ok start with editing groups
go to

Admin Panel->User Tab->UserGroup Management->Global Group Permissions
Select the group you want to edit
Also what them are you using?
also make sure that the link in the navbar has your user ID number in it

[wdq]

Originally Posted by joeroberts

ok start with editing groups
go to

Admin Panel->User Tab->UserGroup Management->Global Group Permissions
Select the group you want to edit
Also what them are you using?
also make sure that the link in the navbar has your user ID number in it

You just gave me the answer, it does not have the user I'd in is going straight to op=editprofile for everyone user , admin

Bump: Anyone can put me in the right direction with this?
I am not able to figure out why there is no id in the link .

[joeroberts]

Originally Posted by wdq

Anyone can put me in the right direction with this?
I am not able to figure out why there is no id in the link .

No id in the link is a good thing not a bad thing I am going to be doing some updates for data base today so maybe this well help

[xblade]

@joe will this update of db so i can test it out before adding to my live server using xampp-windows-x64-7.2.25