phpBB Türkiye

Arkadaşlar Kendi Sitemde Üye Olurken Site Hata Veriyo phpbb 1.52 plus kullanıyorum Siteyi Ücretli Aldım Hatada Şu

Kod: Tümünü seç

Could not insert data into users table

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '1, '')' at line 1

UPDATE phpbb_ctrack SET value = '81.215.109.226' WHERE name = 'lastreg_ip'1, '')

Line : 730
File : usercp_register.php

name = 'lastreg_ip'1,

şu kısımda sintaks hatası var, sanırım ordaki 1 i silmen gerek, kontrol et

name = 'lastreg_ip', --> daha mantıklı

sql den şunu eklemen yeterli aslında;

INSERT INTO phpbb_ctrack (name, value) VALUES ('lastreg', '0');


ama gördüğüm kadarıyla ctrackin avalueleride yüklenmemiş, sen bunu olduğu gibi sql e gönder...

INSERT INTO phpbb_ctrack (name, value) VALUES ('lastreg', '0');
INSERT INTO phpbb_ctrack (name, value) VALUES ('version', '4.1.1');
INSERT INTO phpbb_ctrack (name, value) VALUES ('footer', '6');
INSERT INTO phpbb_ctrack (name, value) VALUES ('floodlog', '100');
INSERT INTO phpbb_ctrack (name, value) VALUES ('proxylog', '100');
INSERT INTO phpbb_ctrack (name, value) VALUES ('filter', '1');
INSERT INTO phpbb_ctrack (name, value) VALUES ('floodprot', '1');
INSERT INTO phpbb_ctrack (name, value) VALUES ('maxsearch', '4');
INSERT INTO phpbb_ctrack (name, value) VALUES ('searchtime', '16');
INSERT INTO phpbb_ctrack (name, value) VALUES ('regblock', '1');
INSERT INTO phpbb_ctrack (name, value) VALUES ('regtime', '1');
INSERT INTO phpbb_ctrack (name, value) VALUES ('autoban', '1');
INSERT INTO phpbb_ctrack (name, value) VALUES ('posttimespan', '200');
INSERT INTO phpbb_ctrack (name, value) VALUES ('postintime', '10');
INSERT INTO phpbb_ctrack (name, value) VALUES ('lastreg_ip', '000.000.000.000');
INSERT INTO phpbb_ctrack (name, value) VALUES ('mailfeature', '1');
INSERT INTO phpbb_ctrack (name, value) VALUES ('pwreset', '1');
INSERT INTO phpbb_ctrack (name, value) VALUES ('loginfeature', '1');
INSERT INTO phpbb_ct_filter (id, list) VALUES (1, 'WebStripper');
INSERT INTO phpbb_ct_filter (id, list) VALUES (2, 'NetMechanic');
INSERT INTO phpbb_ct_filter (id, list) VALUES (3, 'CherryPicker');
INSERT INTO phpbb_ct_filter (id, list) VALUES (4, 'EmailCollector');
INSERT INTO phpbb_ct_filter (id, list) VALUES (5, 'EmailSiphon');
INSERT INTO phpbb_ct_filter (id, list) VALUES (6, 'WebBandit');
INSERT INTO phpbb_ct_filter (id, list) VALUES (7, 'EmailWolf');
INSERT INTO phpbb_ct_filter (id, list) VALUES (8, 'ExtractorPro');
INSERT INTO phpbb_ct_filter (id, list) VALUES (9, 'SiteSnagger');
INSERT INTO phpbb_ct_filter (id, list) VALUES (10, 'CheeseBot');
INSERT INTO phpbb_ct_filter (id, list) VALUES (11, 'ia_archiver/1.6');
INSERT INTO phpbb_ct_filter (id, list) VALUES (12, 'Website Quester');
INSERT INTO phpbb_ct_filter (id, list) VALUES (13, 'WebZip');
INSERT INTO phpbb_ct_filter (id, list) VALUES (14, 'moget/2.1');
INSERT INTO phpbb_ct_filter (id, list) VALUES (15, 'WebSauger');
INSERT INTO phpbb_ct_filter (id, list) VALUES (16, 'WebCopier');
INSERT INTO phpbb_ct_filter (id, list) VALUES (17, 'WWW-Collector-E');
INSERT INTO phpbb_ct_filter (id, list) VALUES (18, 'InfoNaviRobot');
INSERT INTO phpbb_ct_filter (id, list) VALUES (19, 'Harvest/1.5');
INSERT INTO phpbb_ct_filter (id, list) VALUES (20, 'Bullseye/1.0');
INSERT INTO phpbb_ct_filter (id, list) VALUES (21, 'lwp-trivial/1.34');
INSERT INTO phpbb_ct_filter (id, list) VALUES (22, 'lwp-trivial');
INSERT INTO phpbb_ct_filter (id, list) VALUES (23, 'LinkWalker');
INSERT INTO phpbb_ct_filter (id, list) VALUES (24, 'LinkextractorPro');
INSERT INTO phpbb_ct_filter (id, list) VALUES (25, 'Offline Explorer');
INSERT INTO phpbb_ct_filter (id, list) VALUES (26, 'BlowFish/1.0');
INSERT INTO phpbb_ct_filter (id, list) VALUES (27, 'WebEnhancer');
INSERT INTO phpbb_ct_filter (id, list) VALUES (28, 'TightTwatBot');
INSERT INTO phpbb_ct_filter (id, list) VALUES (29, 'LinkScan/8.1a Unix');
INSERT INTO phpbb_ct_filter (id, list) VALUES (30, 'WebDownloader');
INSERT INTO phpbb_ct_filter (id, list) VALUES (31, 'lwp-trivial/1.33');
INSERT INTO phpbb_ct_filter (id, list) VALUES (32, 'lwp-trivial/1.38');
INSERT INTO phpbb_ct_filter (id, list) VALUES (33, 'BruteForce');
INSERT INTO phpbb_ct_filter (id, list) VALUES (34, 'lwp');

your MySQL server version for the right syntax to use near

Ben sql Nasıl Yapılcağını Bilmiyorum Yardımcı Olurmusunuz...

phpmyadmin den db adını seç en üstte sql var ona tıkla açılan yere sql kodlarını yapıştır ve git de yeter...

sql i yaptım olmadı şu çıktı