Bravo List
Register
Go Back   > Bravo List > Source Code > Active Trackers > BT.Manager (phpMyBitTorrent)
Reply
  #31  
Old Today, 00:50
joeroberts's Avatar
joeroberts joeroberts is offline
BT.Manager Owner
 
Join Date: Jan 2008
United States
Posts: 2,097
Default
what sql version are you using?
__________________
Do not ask me to help you work on your site that is not phpMyBitTorrent
Do not ask me to make a mod for any other source
Do not Ask me to setup your site.
I will no longer help you setup your site, there is a setup script if you have trouble with it post in the forum here or in BT.Managerô forum
My Current Demo is here http://demo.btmanager.org/
Reply With Quote
  #32  
Old Today, 06:12
wdq's Avatar
wdq wdq is offline
Senior Member
 
Join Date: Mar 2010
P2P
Posts: 41
Default
Quote:
Originally Posted by budgie View Post
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 ?
Reply With Quote
  #33  
Old Today, 06:51
M-jay's Avatar
M-jay M-jay is offline
VIP
 
Join Date: May 2018
Posts: 13
Default
Sql invalid datetime

That's sql mode allow zero dates or something - these should be null really
`date` datetime NULL,
Reply With Quote
  #34  
Old Today, 10:07
budgie's Avatar
budgie budgie is offline
Senior Member
 
Join Date: Nov 2020
Posts: 46
Default
Joe
using xampp-windows-x64-7.2.25-0-VC15-installer on pc testing it out before i add it to live host
Reply With Quote
  #35  
Old Today, 12:13
joeroberts's Avatar
joeroberts joeroberts is offline
BT.Manager Owner
 
Join Date: Jan 2008
United States
Posts: 2,097
Default
Quote:
Originally Posted by wdq View Post
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?
__________________
Do not ask me to help you work on your site that is not phpMyBitTorrent
Do not ask me to make a mod for any other source
Do not Ask me to setup your site.
I will no longer help you setup your site, there is a setup script if you have trouble with it post in the forum here or in BT.Managerô forum
My Current Demo is here http://demo.btmanager.org/
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT +2. The time now is 12:42. vBulletin skin by ForumMonkeys. Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2021, vBulletin Solutions Inc.