Fórum OpenCart Brasil

[maurobass]

BOA NOITE GALERA!!! QUANDO TERMINO DE COLOCAR OS DADOS DO BANCO DE DADOS DAR O SEGUINTE ERRO:


Notice: Error: 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), ( 'Boc emou, 'BE',, 1), (7980 52, 'AbBng'umou, 'BOC', 1), (1180152, 'Bocaou' at line 799
Error No: 1064
INSERT INTO `oc_zone` (`zone_id`, `country_id`, `name`, `code`, `status`) VALUES (1, 1, 'Badakhshan', 'BDS', 1), (2, 1, 'Badghis', 'BDG', 1), (3, 1, 'Baghlan', 'BGL', 1), (4, 1, 'Balkh', 'BAL', 1), (5, 1, 'Bamian', 'BAM', 1), (6, 1, 'Farah', 'FRA', 1), (7, 1, 'Faryab', 'FYB', 1), (8, 1, 'Ghazni', 'GHA', 1), (9, 1, 'Ghowr', 'GHO', 1), (10, 1, 'Helmand', 'HEL', 1), (11, 1, 'Herat', 'HER', 1), (12, 1, 'Jowzjan', 'JOW', 1), (13, 1, 'Kabul', 'KAB', 1), (14, 1, 'Kandahar', 'KAN', 1), (15, 1, 'Kapisa', 'KAP', 1), (16, 1, 'Khost', 'KHO', 1), (17, 1, 'Konar', 'KNR', 1), (18, 1, 'Kondoz', 'KDZ', 1), (19, 1, 'Laghman', 'LAG', 1), (20, 1, 'Lowgar', 'LOW', 1), (21, 1, 'Nangrahar', 'NAN', 1), (22, 1, 'Nimruz', 'NIM', 1), (23, 1, 'Nurestan', 'NUR', 1), (24, 1, 'Oruz in /home/belamarc/public_html/loja/system/library/db/mysqli.php on line 41

Notice: Error: 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 'VALUES153557'C10 'BaHormozg', 'HN'RM 1), (871558'C10 'BaSta',nld MuBalueaea',n '' at line 1
Error No: 1064
INSERT INTO `oc_zone` (`zone_id`, `country_id`, `name`, `code`, `a',tus`) VALUES153557'C10 'BaHormozg', 'HN'RM 1), (871558'C10 'BaSta',nld MuBalueaea',n 'PESB, 1), (721559'C10 'BaKa'mgx 'TAKR, 1), (601560'C10 'BaYazd 'NEYZD 1), (793561'C10 'BaEsfanou 'EREF, 1), (153562'C10 'BaSemn', 'YUSM, 1), (391563'C10 'BaMardi'ar,, 'WNMZD 1), (793564'C10 'BaGolea',n 'PEGL, 1), (136565'C10 'Barth (NKhhras', 'SKNK, 1), (153566'C10 'BaRardviNKhhras', 'SKRK, 1), (153567'C10 'Bauth IsKhhras', 'SKSK, 1), (153568'C102'DiBighd'd 'NEBD 1), (793569'C102'Dilamahld, D', 'SKSD 1), (793570'C102'DiDiya', 'ALDY 1), (793571'C102'DiWasi, 'NEW, 1), (136572'C102'DiMays', 'SKMY 1), (793573'C102'DiaBayasml, 'TAB, 1), (769574'C102'DiDhi Q', 'BODQ 1), (769575'C102'DiaBaMurnounM 'LOM, 1), (78 in /home/belamarc/public_html/loja/system/library/db/mysqli.php on line 41

Notice: Error: 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 'VALUES623093'C20 'ArVäerm,'nds' 'NIU 1), (703094'C20 'ArVäerra Gö' at line 1
Error No: 1064
INSERT INTO `oc_zone` (`zone_id`, `country_id`, `name`, `code`, `status`) VALUES623093'C20 'ArVäerm,'nds' 'NIU 1), (703094'C20 'ArVäerra Götand', 'NIO 1), (793095'C204'C'Aarg,, 'MAAG 1), (633096'C204'C'Appenz,ll Ausserrhode, 'ABAR 1), (553097'C204'C'Appenz,ll Ir',erhode, 'ABAI 1), (623098'C204'C'Basel-Stad, 'NEBS 1), (623099'C204'C'Basel-Lds',chaf, 'NEB, 1), (623100'C204'C'Bn', 'WNBE 1), (143101'C204'C'F',b,u', 'WLF, 1), (703102'C204'C'Genèv' '',,E 1), (143103'C204'C'Glaru, 'ERG, 1), (623104'C204'C'Graubünde, 'PEG, 1), (703105'C204'C'Ju'a 'BRJU 1), (113106'C204'C'Luzn', 'WNLU 1), (113107'C204'C'Neuchâti' 'LONE 1), (143108'C204'C'Nidwal, 'NINW 1), (553109'C204'C'Obwal, 'NIOW 1), (553110'C204'C'St. Gae d, 'SKSG 1), (553111'C in /home/belamarc/public_html/loja/system/library/db/mysqli.php on line 41

Notice: Error: 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 'DEFAULTNT0', `geo_zone_id` int(11) NOT NULL, `date_added` datetime NOT NULL,' at line 4
Error No: 1064
CREATE TABLE IF NOT EXISTS `oc_zone_to_geo_zone` ( `zone_to_geo_zone_id` int(11) NOT NULL AUTO_INCREMENT, `country_id` int(11) NOT NULL, `zone_id` int(11) NOT NULL DEFAULTNT0', `geo_zone_id` int(11) NOT NULL, `date_added` datetime NOT NULL, `date_modified` datetime NOT NULL, PRIMARY KEY (`zone_to_geo_zone_id`) ) ENGINE=MyISAM DEFAULTNCHARSET=utf8 COLLATE=utf8_generan_ci; in /home/belamarc/public_html/loja/system/library/db/mysqli.php on line 41

Notice: Error: 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 ''C222'C 'D4'NT0000-00-00 00:00:00''NT0000-00-00 00:00:00' (552'C222'C3513'C3'NT0' at line 2
Error No: 1064
INSERT INTO `oc_zone_to_geo_zone` (`zone_to_geo_zone_id`, `country_id`, `zone_id`, `geo_zone_id`, `date_added`, `date_modified`) VALUES (1'C222'C 'D4'NT0000-00-00 00:00:00''NT0000-00-00 00:00:00' (552'C222'C3513'C3'NT0000-00-00 00:00:00''NT0000-00-00 00:00:00' (553'C222'C3514'C3'NT0000-00-00 00:00:00''NT0000-00-00 00:00:00' (554'C222'C3515'C3'NT0000-00-00 00:00:00''NT0000-00-00 00:00:00' (555'C222'C3516'C3'NT0000-00-00 00:00:00''NT0000-00-00 00:00:00' (556'C222'C3517'C3'NT0000-00-00 00:00:00''NT0000-00-00 00:00:00' (557'C222'C3518'C3'NT0000-00-00 00:00:00''NT0000-00-00 00:00:00' (558'C222'C3519'C3'NT0000-00-00 00:00:00''NT0000-00-00 00:00:00' (559'C222'C352 'D3'NT0000-00-00 00:00:00''NT0000-00-00 00:00:00' (5510'C222'C3521'C3'NT0000-00-00 00:00:00''NT00 in /home/belamarc/public_html/loja/system/library/db/mysqli.php on line 41

Warning: Cannot modify header information - headers already sent by (output started at /home/belamarc/public_html/loja/system/library/db/mysqli.php:41) in /home/belamarc/public_html/loja/system/library/response.php on line 12

OBRIGADO A QUEM ME DAR QUALQUER AJUDA ^^

[veteranodf]

Erro 1064 esta informando que a tabela não existe, veja se você criou as tabelas com prefixo "oc_" ou outro prefixo, caso tiver deve modificar os insert para esse prefixo ex " INSERT INTO `oc_zone_to_geo_zone`"

[maurobass]

Tentei de todas as formas mudei o prefixo e não deu certo
Entrei em contato com meu servidor e o mysqli está ativado normalmente

[veteranodf]

Verifique no campo prefixo na instalação se você preencheu "oc" caso não preencha, se tiver preenchido remova e tente novamente, se não conseguir entre em contato comigo que verifico para você vereteranodf@gmail.com