Bravo List

Bravo List (http://www.bvlist.com/index.php)
-   Torrent Trader (http://www.bvlist.com/forumdisplay.php?f=29)
-   -   No ID. Server error, please report. (http://www.bvlist.com/showthread.php?t=12369)

MicroMonkey 31st May 2021 17:57

you didnt already have this table? Thats wierd

`id` int(10) UNSIGNED NOT NULL

Extremlym 31st May 2021 18:36

Quote:

Originally Posted by MicroMonkey (Post 55544)
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:wallbash::wallbash::wallbash::wallbash::wal lbash::wallbash::wallbash::wallbash::wallbash::wal lbash::wallbash::wallbash::wallbash::wallbash::wal lbash::wallbash:

Bump:
Quote:

Originally Posted by MicroMonkey (Post 55544)
you didnt already have this table? Thats wierd

`id` int(10) UNSIGNED NOT NULL




:| the error is back :|

Bump:
Quote:

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

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 */


MicroMonkey 1st June 2021 12:54

have you tried disabling mysql strict mode? sql_mode = 'NO_ENGINE_SUBSTITUTION';

Extremlym 9th June 2021 13:14

Quote:

Originally Posted by MicroMonkey (Post 55546)
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

MicroMonkey 15th June 2021 00:29

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


All times are GMT +2. The time now is 05:02.

Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.