Bravo List - Btmanager 3.0.2 work progress

Bravo List (http://www.bvlist.com/index.php)

- BT.Manager (phpMyBitTorrent) (http://www.bvlist.com/forumdisplay.php?f=23)

- - Btmanager 3.0.2 work progress (http://www.bvlist.com/showthread.php?t=12318)

what sql version are you using?

Quote:

Originally Posted by budgie (Post 55594)

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

Code:

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 ?

Sql invalid datetime

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

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

Quote:

Originally Posted by wdq (Post 55596)

are you trying as a user or a admin?

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

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

Quote:

Originally Posted by joeroberts (Post 55601)

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 .

Quote:

Originally Posted by wdq (Post 55602)

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

@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