Bravo List
Register
Go Back   > Bravo List > Source Code > Active Trackers > Torrent Trader
Reply
  #11  
Old 31st May 2021, 17:57
MicroMonkey's Avatar
MicroMonkey MicroMonkey is offline
Senior Member
 
Join Date: Jun 2016
P2P
Posts: 52
Default
you didnt already have this table? Thats wierd

`id` int(10) UNSIGNED NOT NULL
__________________
More torrenttrader stuff at https://torrenttrader.uk
Reply With Quote
  #12  
Old 31st May 2021, 18:36
Extremlym's Avatar
Extremlym Extremlym is offline
Senior Member
 
Join Date: Oct 2012
P2P
Posts: 102
Default
Quote:
Originally Posted by MicroMonkey View Post
you didnt already have this table? Thats wierd

`id` int(10) UNSIGNED NOT NULL
yes but it needed to add it again i spend 12h tryng to figure where the problem was ":__ and was verry simple:wal lbash::wal lbash::wal lbash:

Bump:
Quote:
Originally Posted by MicroMonkey View Post
you didnt already have this table? Thats wierd

`id` int(10) UNSIGNED NOT NULL



:| the error is back :|

Bump:
Quote:
Originally Posted by Extremlym View Post
yes but it needed to add it again i spend 12h tryng to figure where the problem was ":__ and was verry simple:wal lbash::wal lbash::wal lbash:

Bump:




:| the error is back :|

PHP Code:
-- Generation Time01 Iun 2021 la 10:31-- Versiune server5.7.34-- PHP Version5.6.40-50+ubuntu18.04.1+deb.sury.org+1SET SQL_MODE "NO_AUTO_VALUE_ON_ZERO";SET time_zone "+00:00";/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8mb4 */;---- Database: `backup`---- ------------------------------------------------------------ Structura de tabel pentru tabelul `torrents`--CREATE TABLE `torrents` (  `idint(100UNSIGNED NOT NULL,/././././......................................---- Indexes for table `torrents`--ALTER TABLE `torrents`  ADD PRIMARY KEY (`id`),  ADD UNIQUE KEY `info_hash` (`info_hash`),  ADD KEY `owner` (`owner`),  ADD KEY `visible` (`visible`),  ADD KEY `category_visible` (`category`,`visible`),  ADD KEY `id` (`id`),ALTER TABLE `torrentsADD FULLTEXT KEY `ft_search` (`search_text`,`ori_descr`);ALTER TABLE `torrentsADD FULLTEXT KEY `info_hash_2` (`info_hash`);---- AUTO_INCREMENT for dumped tables------ AUTO_INCREMENT for table `torrents`--ALTER TABLE `torrents`  MODIFY `idint(100UNSIGNED NOT NULL AUTO_INCREMENTAUTO_INCREMENT=13406265;/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */
Reply With Quote
  #13  
Old 1st June 2021, 12:54
MicroMonkey's Avatar
MicroMonkey MicroMonkey is offline
Senior Member
 
Join Date: Jun 2016
P2P
Posts: 52
Default
have you tried disabling mysql strict mode? sql_mode = 'NO_ENGINE_SUBSTITUTION';
__________________
More torrenttrader stuff at https://torrenttrader.uk
Reply With Quote
  #14  
Old 9th June 2021, 13:14
Extremlym's Avatar
Extremlym Extremlym is offline
Senior Member
 
Join Date: Oct 2012
P2P
Posts: 102
Default
Quote:
Originally Posted by MicroMonkey View Post
have you tried disabling mysql strict mode? sql_mode = 'NO_ENGINE_SUBSTITUTION';



theat was the problem THX m8



SHOW VARIABLES LIKE 'sql_mode';

SET GLOBAL sql_mode = 'NO_ENGINE_SUBSTITUTION';

Restart
Reply With Quote
  #15  
Old 15th June 2021, 00:29
MicroMonkey's Avatar
MicroMonkey MicroMonkey is offline
Senior Member
 
Join Date: Jun 2016
P2P
Posts: 52
Default
Making that change in phpmyadmin wont stay after a reboot. If you add the line as SUDO to your my.cnf, you should only ever have to restart it once, aside from regular server reboots, but it will always stay
add to the bottom of my.cnf by editing it using sudo nano /etc/mysql/my.cnf
Code:
[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION
restart mysql server
Code:
sudo service mysql restart
__________________
More torrenttrader stuff at https://torrenttrader.uk
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 01:51. vBulletin skin by ForumMonkeys. Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.