search

chilek / lms

Lan Management System (LMS) public GIT repo
http://lms.org.pl
122 stars 132 forks source link

Błąd przywracania danych z kopii zapasowej #1480

Closed cyberavis closed 5 years ago

cyberavis commented 5 years ago

Przywracanie danych z kopii zapasowej kończy się wysłaniem danych do /dev/null I to właściwie tyle, bo w tym momencie wysypuje się cały system. Oczywiście chwilę przed tym baza danych wypluwa taką litanię błędów, że nawet nie ośmielę się tu wklejać. Nieraz z zapytań które w ogóle nie mają składni SQL.

Server version: 10.1.37-MariaDB-0+deb9u1 Debian 9.6

chilek commented 5 years ago

Nic nie wynika z tego co napisałeś.

cyberavis commented 5 years ago

Wynika tyle, że próba przywrócenia danych z kopii zapasowej (Administracja -> Kopie zapasowe) nie tyle że nie działa, co kończy się wyczyszczeniem całej bazy danych, bo z przywróceniem danych są jakieś problemy. Niestety nie mogę dojść gdzie ten błąd się znajduje dlatego tylko/aż taki opis. Dla przykładu próba przywrócenia kopii zapasowej prawie pustej bazy danych wyrzuca błąd:

Zapytanie: INSERT INTO netdevicemodels (id,netdeviceproducerid,name,alternative_name) VALUES ('1', '1', 'RB750', NULL),('2', '1', 'RB750UP', NULL),('3', '1', 'RB750GL', NULL),('4', '1', 'PowerBox', NULL),('5', '1', 'RB2011iL-IN', NULL),('6', '1', 'RB2011iL-RM', NULL),('7', '1', 'RB2011iLS-IN', NULL),('8', '1', 'RB2011UiAS-IN', NULL),('9', '1', 'RB2011UiAS-RM', NULL),('10', '1', 'RB1100AHx2', NULL),('11', '1', 'CCR1009-8G-1S', NULL),('12', '1', 'CCR1009-8G-1S-1S+', NULL),('13', '1', 'CCR1009-8G-1S-1S+PC', NULL),('14', '1', 'CCR1016-12S-1S+', NULL),('15', '1', 'CCR1016-12G', NULL),('16', '1', 'CCR1036-12G-4S', NULL),('17', '1', 'CCR1036-8G-2S+', NULL),('18', '1', 'CCR1036-12G-4S-EM', NULL),('19', '1', 'CCR1036-8G-2S+EM', NULL),('20', '1', 'RB1100AHx2-LM', NULL),('21', '1', 'RB750G', NULL),('22', '1', 'RB1000', NULL),('23', '1', 'RB1000U', NULL),('24', '1', 'RB1100', NULL),('25', '1', 'RB1100Hx2', NULL),('26', '1', 'RB1100AH', NULL),('27', '1', 'RB1200', NULL),('28', '1', 'RB260GS', NULL),('29', '1', 'RB260GSP', NULL),('30', '1', 'CRS109-8G-1S-2HnD-IN', NULL),('31', '1', 'CRS210-8G-2S+IN', NULL),('32', '1', 'CRS212-1G-10S-1S+IN', NULL),('33', '1', 'CRS125-24G-1S-IN', NULL),('34', '1', 'CRS125-24G-1S-RM', NULL),('35', '1', 'CRS125-24G-1S-2HnD-IN', NULL),('36', '1', 'CRS226-24G-2S+IN', NULL),('37', '1', 'CRS226-24G-2S+RM', NULL),('38', '1', 'RB250GS', NULL),('39', '1', 'NetMetal 5', NULL),('40', '1', 'SXT 5 ac', NULL),('41', '1', 'SXT SA5 ac', NULL),('42', '1', 'NetBox 5', NULL),('43', '1', 'SXT Lite2', NULL),('44', '1', 'SXT Lite5', NULL),('45', '1', 'Groove 52HPn', NULL),('46', '1', 'GrooveA 52HPn', NULL),('47', '1', 'SXT 2', NULL),('48', '1', 'SXT 5', NULL),('49', '1', 'BaseBox 2', NULL),('50', '1', 'BaseBox 5', NULL),('51', '1', 'OmniTIK U-5HnD', NULL),('52', '1', 'SXT HG5', NULL),('53', '1', 'SXT SA5', NULL),('54', '1', 'OmniTIK UPA-5HnD', NULL),('55', '1', 'Metal 9HPn', NULL),('56', '1', 'Metal 2SHPn', NULL),('57', '1', 'Metal 5SHPn', NULL),('58', '1', 'SEXTANT G 5HPnD', NULL),('59', '1', 'QRT 2', NULL),('60', '1', 'QRT 5', NULL),('61', '1', 'SXT Sixpack', NULL),('62', '1', 'SXT 5HnD', NULL),('63', '1', 'SXT G-5HnD', NULL),('64', '1', 'RB951-2n', NULL),('65', '1', 'mAP 2n', NULL),('66', '1', 'cAP 2n', NULL),('67', '1', 'RB951Ui-2HnD', NULL),('68', '1', 'RB951G-2HnD', NULL),('69', '1', 'RB2011UiAS-2HnD-IN', NULL),('70', '1', 'RB751U-2HnD', NULL),('71', '1', 'RB751G-2HnD', NULL),('72', '1', '911 Lite2', NULL),('73', '1', '911 Lite5', NULL),('74', '1', 'RB411L', NULL),('75', '1', '911 Lite5 dual', NULL),('76', '1', 'RB411', NULL),('77', '1', 'RB911G-2HPnD', NULL),('78', '1', 'RB450', NULL),('79', '1', 'RB411GL', NULL),('80', '1', 'RB911G-5HPnD', NULL),('81', '1', 'RB411U', NULL),('82', '1', 'RB911G-5HPacD', NULL),('83', '1', 'RB912UAG-2HPnD', NULL),('84', '1', 'RB912UAG-5HPnD', NULL),('85', '1', 'RB411AR', NULL),('86', '1', 'RB433UL', NULL),('87', '1', 'RB433', NULL),('88', '1', 'RB450G', NULL),('89', '1', 'RB411AH', NULL),('90', '1', 'RB922UAGS-5HPacD', NULL),('91', '1', 'RB850Gx2', NULL),('92', '1', 'RB433GL', NULL),('93', '1', 'RB433AH', NULL),('94', '1', 'RB953GS-5HnT-RP', NULL),('95', '1', 'RB493AH', NULL),('96', '1', 'RB435G', NULL),('97', '1', 'RB493G', NULL),('98', '1', 'RB800', NULL),('99', '1', 'RB433UAH', NULL),('100', '1', 'RB411UAHL', NULL),('101', '1', 'RB493', NULL),('102', '1', 'RB711-5Hn', NULL),('103', '1', 'RB711-2Hn', NULL),('104', '1', 'RB2011L', NULL),('105', '1', 'RB2011LS', NULL),('106', '1', 'RB433L', NULL),('107', '1', 'RB2011UiAS-2HnD', NULL),('108', '1', 'RB711-5Hn-U', NULL),('109', '1', 'RB411UAHR', NULL),('110', '1', 'RB433UAHL', NULL),('111', '1', 'RB711GA-5HnD', NULL),('112', '1', 'RB711A-5Hn-M', NULL),('113', '1', 'CCR1016-12G-BU', NULL),('114', '1', 'RB411R', NULL),('115', '1', 'RB711-5Hn-M', NULL),('116', '1', 'RB600A', NULL),('117', '1', 'Crossroads', NULL),('118', '1', 'RB411A', NULL),('119', '1', 'CA411-711', NULL),('120', '1', 'CA150', NULL),('121', '1', 'CA433U', NULL),('122', '1', 'CA493', NULL),('123', '1', 'CA800', NULL),('124', '1', 'CAOTS', NULL),('125', '1', 'CAOTU', NULL),('126', '1', 'S-RJ01', NULL),('127', '1', 'S-85DLC05D', NULL),('128', '1', 'S-31DLC20D', NULL),('129', '1', 'S-3553LC20D', NULL),('130', '1', 'S+85DLC03D', NULL),('131', '1', 'S+31DLC10D', NULL),('132', '1', 'S+2332LC10D', NULL),('133', '1', 'SFP+ 1m direct attach cable', NULL),('134', '1', 'SFP+ 3m direct attach cable', NULL),('135', '1', 'R11e-2HnD', NULL),('136', '1', 'R11e-2HPnD', NULL),('137', '1', 'R11e-5HnD', NULL),('138', '1', 'R11e-5HacD', NULL),('139', '1', 'R2SHPn', NULL),('140', '1', 'R5SHPn', NULL),('141', '1', 'R52nM', NULL),('142', '1', 'R52H', NULL),('143', '1', 'R52Hn', NULL),('144', '1', 'RB14e', NULL),('145', '1', 'RB14eU', NULL),('146', '1', 'RB44Ge', NULL),('147', '1', 'RB502', NULL),('148', '1', 'RB604', NULL),('149', '1', 'IAMP1E', NULL),('150', '1', 'R5H', NULL),('151', '1', 'R5nH', NULL),('152', '1', 'R2N', NULL),('153', '1', 'R52N', NULL),('154', '1', 'RB44GV', NULL),('155', '1', 'R52', NULL),('156', '1', 'IAMP1', NULL),('157', '1', 'FTC', NULL),('158', '1', 'Flex-guide', NULL),('159', '1', 'MMCX-RPSMA pigtail', NULL),('160', '1', '2.4Ghz Dipole', NULL),('161', '1', 'RB2011 mount', NULL),('162', '1', '48 to 24V PoE Converter', NULL),('163', '1', '18POW', NULL),('164', '1', '24HPOW', NULL),('165', '1', '48POW', NULL),('166', '1', '5VUSB', NULL),('167', '1', 'RBPOE', NULL),('168', '1', 'RBGPOE', NULL),('169', '1', 'ACUFL', NULL),('170', '1', 'ACMMCX', NULL),('171', '1', 'ACSWI', NULL),('172', '1', 'ACSWIM', NULL),('173', '1', 'Radome Cover Kit', NULL),('174', '1', 'mANT30 PA', NULL),('175', '1', 'mANT30', NULL),('176', '2', '3391-A', 'SR71A'),('177', '2', 'AF-24', 'AIRFIBER 1.4GBPS+ BACKHAUL 24GHZ (SHIPPED AS SINGLES)'),('178', '2', 'AF-5', 'AIRFIBER 1GBPS+ BACKHAUL 5.4-5.8GHZ'),('179', '2', 'AG-HP-2G16', '2.4GHZ AIRGRID AIRMAX 16DBI'),('180', '2', 'AG-HP-2G20', '5PK 2.4GHZ AIRGRID AIRMAX 20DBI'),('181', '2', 'AG-HP-5G23', '5PK 5GHZ AIRGRID AIRMAX 23DBI'),('182', '2', 'AG-HP-5G27', '5PK 5GHZ AIRGRID AIRMAX 27DBI'),('183', '2', 'AIRCAM', 'AIRCAM'),('184', '2', 'AIRCAM-3', 'AIRCAM 3-PACK'),('185', '2', 'AIRCAM-DOME', 'AIRCAM DOME'),('186', '2', 'AIRCAM-DOME-3', 'AIRCAM-DOME 3PK SOLUTION 3 PACK'),('187', '2', 'AIRCAM-MINI', 'AIRCAM-MINI VIDEO SOLUTION'),('188', '2', 'AIRGATEWAY', 'AIRGATEWAY INDOOR AP'),('189', '2', 'AIRGATEWAY-LR', 'AIRGATEWAY INDOOR AP LONG RANGE ANTENNA'),('190', '2', 'AIRROUTER', 'AIRROUTER INDOOR AP'),('191', '2', 'AIRROUTER-HP', 'AIRROUTER INDOOR AP HP EXT ANT'),('192', '2', 'AIRVISION-C', 'AIRVISION NVR CONTROLLER'),('193', '2', 'AM-2G15-120', '2.3-2.7GHZ AIRMAX BASE STATION 15DBI 120 DEG W/ ROCKET KIT'),('194', '2', 'AM-2G16-90', '2.3-2.7GHZ AIRMAX BASE STATION 16DBI 90DEG W/ ROCKET KIT'),('195', '2', 'AM-3G18-120', '3.3-3.8GHZ AIRMAX BASE STATION 18DBI 120 DEG W/ROCKET KIT'),('196', '2', 'AM-5AC21-60', '5G AIRMAX AC 60 DEGREES SECTOR ANTENNA 21DBI'),('197', '2', 'AM-5AC22-45', '5G AIRMAX AC 45 DEGREES SECTOR ANTENNA 22DBI'),('198', '2', 'AM-5G16-120', '4.9-5.9GHZ AIRMAX BASE STATION 16DBI 120 DEG W/ ROCKET KIT'),('199', '2', 'AM-5G17-90', '4.9-5.9GHZ AIRMAX BASE STATION 17DBI 90 DEG W/ROCKET KIT'),('200', '2', 'AM-5G19-120', '4.9-5.9GHZ AIRMAX BASE STATION 19DBI 120 DEG W/ ROCKET KIT'),('201', '2', 'AM-5G20-90', '4.9-5.9GHZ AIRMAX BASE STATION 20DBI 90 DEG W/ ROCKET KIT'),('202', '2', 'AM-9M13-120', '900MHZ AIRMAX BASE STATION 13DBI'),('203', '2', 'AM-M-V5G-TI', '5GHZ VARIABLE BEAM BASE STATION MID-GAIN 60-120DEG TI W/ ROCKET KIT'),('204', '2', 'AMO-2G10', '2GHZ AIRMAX DUAL OMNI 10DBI W/ ROCKET KIT'),('205', '2', 'AMO-2G13', '2GHZ AIRMAX DUAL OMNI 13DBI W/ ROCKET KIT'),('206', '2', 'AMO-3G12', '3GHZ AIRMAX DUAL OMNI 12DBI W/ ROCKET KIT'),('207', '2', 'AMO-5G10', '5GHZ AIRMAX DUAL OMNI 10DBI W/ ROCKET KIT'),('208', '2', 'AMO-5G13', '5GHZ AIRMAX DUAL OMNI 13DBI W/ ROCKET KIT'),('209', '2', 'AM-V2G-TI', '2GHZ VARIABLE BEAM BASE STATION 60-120DEG TITANIUM W/ROCKET KIT'),('210', '2', 'AM-V5G-TI', '5GHZ VARIABLE BEAM BASE STATION 60-120DEG TITANIUM W/ROCKET KIT'),('211', '2', 'AMY-9M16-2', '900MHZ AIRMAX YAGI ANTENNA 16DBI W/ ROCKET KIT 2-PACK'),('212', '2', 'BM2-TI', '2.4GHZ BULLET AIRMAX TITA
Błąd: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''2.4GHZ BULLET AIRMAX TITA' at line 1
Zapytanie: NIUM POE/ADAPTER INCL'),('213', '2', 'BULLET5', 'BULLET5 CPE'),('214', '2', 'BULLETM2-HP', '2.4GHZ BULLET AIRMAX HP'),('215', '2', 'BULLETM5-HP', '5GHZ BULLET AIRMAX HP'),('216', '2', 'BULLETM5-TI', '5GHZ BULLET AIRMAX TITANIUM POE/ADAPTER INCL'),('217', '2', 'ER-8', 'EDGEROUTER 8 5PORT ROUTER'),('218', '2', 'ERLITE-3', 'EDGEROUTER LITE 3PORT'),('219', '2', 'ERPOE-5', 'EDGEROUTER POE 5PORT ROUTER WITH POE'),('220', '2', 'ERPRO-8', 'EDGEROUTER PRO 8 8PORT ROUTER 2 SFP'),('221', '2', 'ES-24-250W', 'EDGE SWITCH 24 250W'),('222', '2', 'ES-24-500W', 'EDGE SWITCH 24PORT 500W'),('223', '2', 'ES-48-500W', 'EDGE SWITCH 48PORT 500W'),('224', '2', 'ES-48-750W', 'EDGE SWITCH 48PORT 750W'),('225', '2', 'ETH-SP', 'ETHERNET SURGE PROTECTOR'),('226', '2', 'INS-8023AF-I', 'INSTANT 8023AF ADAPTER INDOOR'),('227', '2', 'INS-8023AF-O', 'INSTANT 8023AF ADAPTER OUTDOOR'),('228', '2', 'LOCOM2', '2.4GHZ LOCO MIMO AIRMAX'),('229', '2', 'LOCOM5', '5GHZ LOCO MIMO AIRMAX'),('230', '2', 'LOCOM900', '900MHZ LOCO MIMO AIRMAX'),('231', '2', 'MFI-CS', 'MFI CURRENT SENSOR'),('232', '2', 'MFI-DS', 'MFI DOOR SENSOR'),('233', '2', 'MFI-LD', 'IN-WALL MANAGEABLE SWITCH/ DIMMER'),('234', '2', 'MFI-MPW', 'IN-WALL MANAGEABLE OUTLET'),('235', '2', 'MFI-MSC', 'MFI CEILING MOUNT MOTION SENSOR'),('236', '2', 'MFI-MSW', 'MFI WALL MOUNT MOTION SENSOR'),('237', '2', 'MFI-THS', 'MFI TEMPERATURE SENSOR'),('238', '2', 'MPORT', 'MFI MPORT'),('239', '2', 'MPORT-S', 'MFI MPORT SERIAL'),('240', '2', 'MPOWER', 'MFI 3PORT POWER EU & US WIFI'),('241', '2', 'MPOWER-MINI', 'MFI 1PORT POWER EU & US WIFI'),('242', '2', 'MPOWER-PRO', 'MFI 8PORT US 6PORT EU POWER WIFI/ETH'),('243', '2', 'NANOMOUNT', 'NANOMOUNT'),('244', '2', 'NBE-M5-19', '5GHZ NANOBEAM AIRMAX 19DB'),('245', '2', 'NBE-M5-400', '5PK 5GHZ NANOBEAM AIRMAX 400MM'),('246', '2', 'NBE-RAD-400', 'NANOBEAM RADOME 400MM'),('247', '2', 'NBE-WMK', 'NANOBEAM WALL MOUNT KIT'),('248', '2', 'NBM3', '3.5GHZ NANOBRIDGE AIRMAX 22DBI 2 PARTS NBM3+NB-OD3'),('249', '2', 'NBM365', '3.65GHZ NANOBRIDGE AIRMAX 22DBI 2 PARTS NBM365+NB-OD3'),('250', '2', 'NBM9', '900MHZ NANOBRIDGE AIRMAX 13DBI 2 PARTS NBM9+NB-OD9'),('251', '2', 'NSM2', '2.4GHZ NANO MIMO AIRMAX'),('252', '2', 'NSM3', '3.5GHZ NANO MIMO AIRMAX'),('253', '2', 'NSM365', '3.65GHZ NANOBRIDGE AIRMAX 22DBI 2 PARTS NBM365+NB-OD3'),('254', '2', 'NSM5', '5GHZ NANO MIMO AIRMAX'),('255', '2', 'PBM10', '10GHZ POWERBRIDGE MIMO AIRMAX 2 PARTS - PBM10 $275 + PBM10-DISH 75'),('256', '2', 'PBM3', '3.5GHZ POWERBRIDGE MIMO AIRMAX'),('257', '2', 'PBM365', '3.65GHZ POWERBRIDGE MIMO AIRMAX'),('258', '2', 'PBM5', '5GHZ POWERBRIDGE MIMO AIRMAX'),('259', '2', 'PICOM2-HP', '2.4GHZ PICO AIRMAX HP'),('260', '2', 'POE-24-12W', 'POE INJECTOR 24VDC 12W'),('261', '2', 'POE-24-24W', 'POE INJECTOR 24VDC 24W'),('262', '2', 'POE-48-24W', 'POE INJECTOR 48VDC 24W'),('263', '2', 'POE-48-24W-G', 'POE INJECTOR 48VDC 24W ROCKETTI UAP-PRO'),('264', '2', 'POE-50-60W', 'POE INJECTOR 50V 60W AIRFIBER POE'),('265', '2', 'PS2-17D', 'POWERSTATION2-17D CPE'),('266', '2', 'PS5-22V', 'POWERSTATION5-22V CPE'),('267', '2', 'RAD-2RD', 'RADOME 2 ROCKETDISH EAR99 RADOME FOR ROCKETDISH'),('268', '2', 'RAD-3RD', 'RADOME 3 ROCKETDISH EAR99 RADOME FOR ROCKETDISH'),('269', '2', 'RD-2G24', '2GHZ ROCKET DISH 24DBI W/ ROCKET KIT'),('270', '2', 'RD-3G26', '3GHZ ROCKET DISH 26DBI W/ ROCKET KIT'),('271', '2', 'RD-5G30', '5GHZ ROCKET DISH 30DBI W/ ROCKET KIT'),('272', '2', 'RD-5G34', '5GHZ ROCKET DISH 34DBI W/ROCKET KIT'),('273', '2', 'RM2-TI', '2.4GHZ ROCKET MIMO AIRMAX TITANIUM'),('274', '2', 'RM5-TI', '5GHZ ROCKET MIMO AIRMAX TITANIUM'),('275', '2', 'ROCKETM2', '2.4GHZ ROCKET MIMO AIRMAX'),('276', '2', 'ROCKETM3', '3.5GHZ ROCKET MIMO AIRMAX'),('277', '2', 'ROCKETM365', '3.65GHZ ROCKET MIMO AIRMAX'),('278', '2', 'ROCKETM5', '5GHZ ROCKET MIMO AIRMAX'),('279', '2', 'ROCKETM9', '900MHZ ROCKET MIMO AIRMAX'),('280', '2', 'SR2', 'SR2 MINI PCI PCBA'),('281', '2', 'SR5', 'SR5 MINI PCI PCBA'),('282', '2', 'SR71-15', '11A/N 5GHZ 27DBM 2X2 OUTDOOR'),('283', '2', 'SR71E', '11A/B/G/N 200MW 2X2 EXT. ANTENNA'),('284', '2', 'SRC', 'SRC CARDBUS'),('285', '2', 'TC-CARRIER', 'TOUGH CABLE LEVEL 2 1000 BOX'),('286', '2', 'TC-CON', 'TOUGH CABLE CONNEXTRS X 2400 100PCS/BOX'),('287', '2', 'TC-GND', 'TOUGH CABLE CONNECTOR GROUND X 1000'),('288', '2', 'TC-PRO', 'TOUGH CABLE LEVEL 1 1000 BOX'),('289', '2', 'TS-16-CARRIER', 'TOUGHSWITCH 16PORT POE PRO RACKMOUNT'),('290', '2', 'TS-5-POE', 'TOUGHSWITCH 5PORT POE'),('291', '2', 'TS-8-PRO', 'TOUGHSWITCH 8PORT POE PRO'),('292', '2', 'UAP', 'UNIFI AP'),('293', '2', 'UAP-3', 'UNIFI AP 3-PACK'),('294', '2', 'UAP-AC', 'UNIFI AP 802.11AC'),('295', '2', 'UAP-AC-3', 'UNIFI AP AC 3PK'),('296', '2', 'UAP-AC-OUTDOOR', 'UNIFI AP AC OUTDOOR'),('297', '2', 'UAP-LR', 'UNIFI AP LONG RANGE'),('298', '2', 'UAP-LR-3', 'UNIFI AP LONG RANGE 3-PACK'),('299', '2', 'UAP-OUTDOOR+', 'UNIFI AP OUTDOOR+ XRF'),('300', '2', 'UAP-OUTDOOR-5', 'UNIFI AP OUTDOOR 5GHZ'),('301', '2', 'UAP-PRO', 'UNIFI AP PRO GIGE 802.3AF DUAL RADIO'),('302', '2', 'UAP-PRO-3', 'UNIFI AP PRO GIGE 802.3AF DUAL RADIO 3PK'),('303', '2', 'UB-AM', '10PK UBIQUITI ANTENNA MOUNT'),('304', '2', 'USG', 'UNIFI SECURITY GATEWAY'),('305', '2', 'UVC', 'UNIFI VIDEO CAMERA IR'),('306', '2', 'UVC-3', 'UNIFI VIDEO CAMERA IR 3PK'),('307', '2', 'UVC-DOME', 'UNIFI VIDEO CAMERA DOME IR'),('308', '2', 'UVC-DOME-3', 'UNIFI VIDEO CAMERA DOME IR 3-PACK'),('309', '2', 'UVC-NVR', 'AIRVISION NVR CONTROLLER'),('310', '2', 'UVC-PRO', 'UNIFI VIDEO CAMERA PRO'),('311', '2', 'UVC-PRO-C', 'UNIFI CAMERA PRO CABLE ACCESSORY'),('312', '2', 'UVC-PRO-M', 'UNIFI CAMERA PRO MOUNT ACCESSORY'),('313', '2', 'UVP', 'UNIFI VOIP PHONE'),('314', '2', 'WS5', 'WS5 SUBSCRIBER'),('315', '2', 'WSM5', 'WISPSTATION M SERIES 5GHZ AIRMAX'),('316', '2', 'XR2', 'MINI PCI 600MW 2.4GHZ'),('317', '2', 'XR5', 'MINI PCI 600MW 5GHZ'),('318', '2', 'XR7', 'XR7 MINI PCI PCBA'),('319', '2', 'XR9', 'MINI PCI 600MW 900MHZ')
Błąd: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NIUM POE/ADAPTER INCL'),('213', '2', 'BULLET5', 'BULLET5 CPE'),('214', '2', 'BUL' at line 1
Zapytanie: INSERT INTO uiconfig (id,section,var,value,description,disabled,type) VALUES ('1', 'phpui', 'default_autosuggest_placement', 'bottom', '', '0', '0'),('2', 'phpui', 'autosuggest_max_length', '40', '', '0', '0'),('3', 'phpui', 'lang', '', '', '0', '0'),('4', 'phpui', 'allow_from', '', '', '0', '0'),('5', 'phpui', 'default_module', 'welcome', '', '0', '0'),('6', 'phpui', 'timeout', '600', '', '0', '0'),('7', 'phpui', 'settings_timeout', '28800', '', '0', '0'),('8', 'phpui', 'customerlist_pagelimit', '100', '', '0', '0'),('9', 'phpui', 'billinglist_pagelimit', '100', '', '0', '0'),('10', 'phpui', 'nodelist_pagelimit', '100', '', '0', '0'),('11', 'phpui', 'balancelist_pagelimit', '100', '', '0', '0'),('12', 'phpui', 'invoicelist_pagelimit', '100', '', '0', '0'),('13', 'phpui', 'debitnotelist_pagelimit', '100', '', '0', '0'),('14', 'phpui', 'ticketlist_pagelimit', '100', '', '0', '0'),('15', 'phpui', 'accountlist_pagelimit', '100', '', '0', '0'),('16', 'phpui', 'domainlist_pagelimit', '100', '', '0', '0'),('17', 'phpui', 'aliaslist_pagelimit', '100', '', '0', '0'),('18', 'phpui', 'configlist_pagelimit', '100', '', '0', '0'),('19', 'phpui', 'receiptlist_pagelimit', '100', '', '0', '0'),('20', 'phpui', 'taxratelist_pagelimit', '100', '', '0', '0'),('21', 'phpui', 'numberplanlist_pagelimit', '100', '', '0', '0'),('22', 'phpui', 'divisionlist_pagelimit', '100', '', '0', '0'),('23', 'phpui', 'documentlist_pagelimit', '100', '', '0', '0'),('24', 'phpui', 'voipaccountlist_pagelimit', '100', '', '0', '0'),('25', 'phpui', 'networkhosts_pagelimit', '256', '', '0', '0'),('26', 'phpui', 'messagelist_pagelimit', '100', '', '0', '0'),('27', 'phpui', 'recordlist_pagelimit', '100', '', '0', '0'),('28', 'phpui', 'cashreglog_pagelimit', '100', '', '0', '0'),('29', 'phpui', 'networklist_pagelimit', '100', '', '0', '0'),('30', 'phpui', 'reload_type', 'sql', '', '0', '0'),('31', 'phpui', 'reload_execcmd', '/bin/true', '', '0', '0'),('32', 'phpui', 'reload_sqlquery', '', '', '0', '0'),('33', 'phpui', 'lastonline_limit', '600', '', '0', '0'),('34', 'phpui', 'timetable_days_forward', '7', '', '0', '0'),('35', 'phpui', 'gd_translate_to', 'ISO-8859-2', '', '0', '0'),('36', 'phpui', 'check_for_updates_period', '86400', '', '0', '0'),('37', 'phpui', 'homedir_prefix', '/home/', '', '0', '0'),('38', 'phpui', 'default_taxrate', '23', '', '0', '0'),('39', 'phpui', 'default_zip', '', '', '0', '0'),('40', 'phpui', 'default_city', '', '', '0', '0'),('41', 'phpui', 'default_address', '', '', '0', '0'),('42', 'phpui', 'smarty_debug', 'false', '', '0', '0'),('43', 'phpui', 'force_ssl', 'false', '', '0', '0'),('44', 'phpui', 'allow_mac_sharing', 'false', '', '0', '0'),('45', 'phpui', 'big_networks', 'false', '', '0', '0'),('46', 'phpui', 'short_pagescroller', 'false', '', '0', '0'),('47', 'phpui', 'helpdesk_stats', 'true', '', '0', '0'),('48', 'phpui', 'helpdesk_customerinfo', 'true', '', '0', '0'),('49', 'phpui', 'helpdesk_customerinfo_mail_body', '--\nKlient: %custname ID: %cid\nAdres: %address\nE-mail: %email\nTelefon: %phone', '', '0', '0'),('50', 'phpui', 'helpdesk_customerinfo_sms_body', 'Klient: %custname ID: %cid Adres: %address Telefon: %phone', '', '0', '0'),('51', 'phpui', 'helpdesk_backend_mode', 'false', '', '0', '0'),('52', 'phpui', 'helpdesk_sender_name', '', '', '0', '0'),('53', 'phpui', 'helpdesk_reply_body', 'false', '', '0', '0'),('54', 'phpui', 'helpdesk_notification_mail_subject', '[RT#%tid] %subject', '', '0', '0'),('55', 'phpui', 'helpdesk_notification_mail_body', '%body\n\nURL: %url\n\n%customerinfo', '', '0', '0'),('56', 'phpui', 'helpdesk_notification_sms_body', '[RT#%tid] %subject: %body %customerinfo', '', '0', '0'),('57', 'phpui', 'use_invoices', 'false', '', '0', '0'),('58', 'phpui', 'ticket_template_file', 'rtticketprint.html', '', '0', '0'),('59', 'phpui', 'use_current_payday', 'false', '', '0', '0'),('60', 'phpui', 'default_monthly_payday', '', '', '0', '0'),('61', 'phpui', 'newticket_notify', 'false', '', '0', '0'),('62', 'phpui', 'to_words_short_version', 'false', '', '0', '0'),('63', 'phpui', 'ticketlist_status', '', '', '0', '0'),('64', 'phpui', 'ewx_support', 'false', '', '0', '0'),('65', 'phpui', 'invoice_check_payment', 'false', '', '0', '0'),('66', 'phpui', 'note_check_payment', 'false', '', '0', '0'),('67', 'phpui', 'radius', '1', '', '0', '0'),('68', 'phpui', 'public_ip', '1', '', '0', '0'),('69', 'phpui', 'default_assignment_period', '3', '', '0', '0'),('70', 'phpui', 'default_assignment_invoice', '0', '', '0', '0'),('71', 'phpui', 'default_editor', 'html', '', '0', '0'),('72', 'phpui', 'logging', 'false', '', '0', '0'),('73', 'phpui', 'hide_toolbar', 'false', '', '0', '0'),('74', 'phpui', 'add_customer_group_required', 'false', '', '0', '0'),('75', 'phpui', 'document_margins', '10,5,15,5', '', '0', '0'),('76', 'phpui', 'quicksearch_limit', '15', '', '0', '0'),('77', 'phpui', 'ping_type', '1', '', '0', '0'),('78', 'phpui', 'default_teryt_city', 'false', '', '0', '0'),('79', 'phpui', 'passwordhistory', '6', '', '0', '0'),('80', 'phpui', 'event_usergroup_selection_type', 'update', '', '0', '0'),('81', 'payments', 'date_format', '%Y/%m/%d', '', '0', '0'),('82', 'payments', 'default_unit_name', 'pcs.', '', '0', '0'),('83', 'voip', 'default_cost_limit', '200', '', '2', '0'),('84', 'invoices', 'template_file', 'invoice.html', '', '0', '0'),('85', 'invoices', 'content_type', 'text/html', '', '0', '0'),('86', 'invoices', 'cnote_template_file', 'invoice.html', '', '0', '0'),('87', 'invoices', 'print_balance_history', 'false', '', '0', '0'),('88', 'invoices', 'print_balance_history_limit', '10', '', '0', '0'),('89', 'invoices', 'default_printpage', 'original,copy', '', '0', '0'),('90', 'invoices', 'type', 'html', '', '0', '0'),('91', 'invoices', 'attachment_name', '', '', '0', '0'),('92', 'invoices', 'paytime', '14', '', '0', '0'),('93', 'invoices', 'paytype', '1', '', '0', '0'),('94', 'notes', 'template_file', 'note.html', '', '0', '0'),('95', 'notes', 'content_type', 'text/html', '', '0', '0'),('96', 'notes', 'type', 'html', '', '0', '0'),('97', 'notes', 'attachment_name', '', '', '0', '0'),('98', 'notes', 'paytime', '14', '', '0', '0'),('99', 'receipts', 'template_file', 'receipt.html', '', '0', '0'),('100', 'receipts', 'content_type', 'text/html', '', '0', '0'),('101', 'receipts', 'type', 'html', '', '0', '0'),('102', 'receipts', 'attachment_name', '', '', '0', '0'),('103', 'finances', 'suspension_percentage', '0', '', '0', '0'),('104', 'mail', 'debug_email', '', '', '0', '0'),('105', 'mail', 'smtp_host', '127.0.0.1', '', '0', '0'),('106', 'mail', 'smtp_port', '25', '', '0', '0'),('107', 'mail', 'backend', 'pear', '', '0', '0'),('108', 'mail', 'smtp_secure', 'tls', '', '0', '0'),('109', 'zones', 'hostmaster_mail', 'hostmaster.localhost', '', '0', '0'),('110', 'zones', 'master_dns', 'localhost', '', '0', '0'),('111', 'zones', 'slave_dns', 'localhost', '', '0', '0'),('112', 'zones', 'default_ttl', '3600', '', '0', '0'),('113', 'zones', 'ttl_refresh', '28800', '', '0', '0'),('114', 'zones', 'ttl_retry', '7200', '', '0', '0'),('115', 'zones', 'ttl_expire', '604800', '', '0', '0'),('116', 'zones', 'ttl_minimum', '86400', '', '0', '0'),('117', 'zones', 'default_webserver_ip', '127.0.0.1', '', '0', '0'),('118', 'zones', 'default_mailserver_ip', '127.0.0.1', '', '0', '0'),('119', 'zones', 'default_mx', 'localhost', '', '0', '0'),('120', 'userpanel', 'data_consent_text', '', '', '0', '0'),('121', 'userpanel', 'disable_transferform', '0', '', '0', '0'),('122', 'userpanel', 'disable_invoices', '0', '', '0', '0'),('123', 'userpanel', 'invoice_duplicate', '0', '', '0', '0'),('124', 'userpanel', 'show_tariffname', '1', '', '0', '0'),('125', 'userpanel', 'show_speeds', '1', '', '0', '0'),('126', 'userpanel', 'queues', '1', '', '0', '0'),('127', 'userpanel', 'tickets_from_selected_queues', '0', '', '0', '0'),('128', 'userpanel', 'allow_message_add_to_closed_tickets', '1', '', '0', '0'),('129', 'userpanel', 'limit_ticket_movements_to_selected_queues', '0', '', '0', '0'),('130', 'userpanel', 'default_userid', '0', '', '0', '0'),('131', 'userpanel', 'debug_email', '', '', '0', '0'),('132', 'userpanel', 'lms_url', '', '', '0', '0'),('133', 'userpanel', 'hide_nod
Błąd: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''hide_nod' at line 1
Zapytanie: esbox', '0', '', '0', '0'),('134', 'userpanel', 'hide_documentbox', '0', '', '0', '0'),('135', 'userpanel', 'logout_url', '', '', '0', '0'),('136', 'userpanel', 'owner_stats', '1', '', '0', '0'),('137', 'userpanel', 'default_categories', '1', '', '0', '0'),('138', 'userpanel', 'auth_type', '1', '', '0', '0'),('139', 'userpanel', 'show_confirmed_documents_only', 'false', '', '0', '0'),('140', 'userpanel', 'module_order', '', '', '0', '0'),('141', 'userpanel', 'visible_ticket_sources', '0;1;2;3;4;5;6;7', '', '0', '0'),('142', 'userpanel', 'change_notification_mail_sender', '', '', '0', '0'),('143', 'userpanel', 'change_notification_mail_recipient', '', '', '0', '0'),('144', 'userpanel', 'change_notification_mail_subject', '', '', '0', '0'),('145', 'userpanel', 'change_notification_mail_body', '', '', '0', '0'),('146', 'userpanel', 'change_confirmation_mail_subject', '', '', '0', '0'),('147', 'userpanel', 'change_confirmation_mail_body', '', '', '0', '0'),('148', 'userpanel', 'change_rejection_mail_subject', '', '', '0', '0'),('149', 'userpanel', 'change_rejection_mail_body', '', '', '0', '0'),('150', 'userpanel', 'google_recaptcha_sitekey', '', '', '0', '0'),('151', 'userpanel', 'google_recaptcha_secret', '', '', '0', '0'),('152', 'userpanel', 'allow_reopen_tickets_newer_than', '0', '', '0', '0'),('153', 'userpanel', 'pin_changes', 'true', '', '0', '0'),('154', 'userpanel', 'show_last_years', '5', '', '0', '0'),('155', 'userpanel', 'aggregate_documents', '0', '', '0', '0'),('156', 'userpanel', 'speed_unit_type', '1000', '', '0', '0'),('157', 'userpanel', 'speed_unit_aggregation_threshold', '5', '', '0', '0'),('158', 'userpanel', 'shortcut_icon', '', '', '0', '0'),('159', 'directories', 'userpanel_dir', 'userpanel', '', '0', '0')
Błąd: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'esbox', '0', '', '0', '0'),('134', 'userpanel', 'hide_documentbox', '0', '', '0'' at line 1
chilek commented 5 years ago

Wygląda jakby zapytania były ucięte w trakcie, albo komunikat mysql generuje z uciętym zapytaniem. Proponuję zweryfikować w pliku sql.

cyberavis commented 5 years ago

Plik wygląda w porządku. Wczytanie go z konsoli mysql działa. To jego przetwarzanie na etapie przywracania gdzieś zawodzi.

chilek commented 5 years ago

Spróbuj wiersz: https://github.com/lmsgit/lms/blob/master/modules/dbrecover.php#L46 zastąpić przez:

$line = fgets($file);
cyberavis commented 5 years ago

Strzał w 10 - o to chodziło. Czemu miało służyć 8192?

chilek commented 5 years ago

Czemu miało służyć 8192?

Jakaś pozostałość z czasów archaicznych. Pewnie chodziło o nie zajmowanie zbyt dużej ilości pamięci, ale jeśli limit rekordów w wierszu jest 500 to i tak super dużo nie zajmie jeden wiersz.