Uzeo sam novi host i domen i naravno sve povezao kako treba,ali kada sam hteo da uvezem moj stari sajt pojavili se problemi.
Nikako ne mogu da ubacim SQL u novu bazu podataka.
Uvek izbacuje gresku.
Da li mogu nekako manuelno to da uradim?
Konkretno? Post must be at least 20 characters
Mislim da moras prvo kreirati praznu bazu ovako napamet. Sve ovisi kako si radio export.
Error
SQL query:
``
TRUNCATE TABLE `oc8m_address`
#1146 - Table 'hiqclqjj_new.oc8m_address' doesn't exist
obriši taj truncate query iz sql fajla
CREATE TABLE `oc8m_address` IF NOT EXISTS;
TRUNCATE TABLE `oc8m_address`;
dodaj ali pitanje je ostatka skripte odnosno kako će se skripta ponašati ako ne postoji.
Dodaj ovo pa da idemo na sljedeću grešku.
Edit: popravio.
Static analysis:
2 errors were found during analysis.
- Unexpected beginning of statement. (near “UNCATE” at position 0)
- Unrecognized statement type. (near “TABLE” at position 7)
SQL query:
UNCATE TABLE oc8m_address
IF EXISTS
#1064 - 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 'UNCATE TABLE
oc8m_addressIF EXISTS' at line 1
Stavi u sjedeći red i koristi backticks za naziv tabele >>>`<<<
CREATE TABLE `oc8m_address` IF NOT EXISTS;
TRUNCATE TABLE `oc8m_address`;
Nisam bas vest u ovom sportu.
Ovako sam napravio
TRUNCATE TABLE oc8m_address
IF NOT EXISTS ;
INSERT INTO oc8m_address
(address_id
, customer_id
, firstname
, lastname
, company
, address_1
, address_2
, city
, postcode
, country_id
, zone_id
, custom_field
) VALUES (‘1’, ‘1’, ‘Faiz’, ‘ali’, ‘Pakistan’, ‘A-14’, ‘Meezan bank near PSO pump malir Karachi Pakistan’, ‘Karachi’, ‘75080’, ‘162’, ‘2462’, ‘’);
TRUNCATE TABLE oc8m_address
IF NOT EXISTS;
INSERT INTO oc8m_api
(api_id
, username
, key
, status
, date_added
, date_modified
) VALUES (‘1’, ‘Default’, ‘72UvtGRDeUObh2plKrpGTSqXbhjzFzgUavhwhaAbbUuK415ak4abUZhyLFN871wtaJHVz0R5HHaIuUuBpKzWsxkmcnCIHHj8j6XaZMb2CYlInMevSHtdNEkj0KiE7SiIBWX2O2FwTvAwXGHfFom8bzlMPZwrM2uhvY8mYG8ovAWFbYEc1rHV1FwmW9VZm7Ttz5SNFzzuya40Ib8nUEIZGktWBAhxz9zD9JudxHUOVws7z1C8gz3YssJx1IZgE3Dm’, ‘1’, ‘2018-05-18 13:05:44’, ‘2018-05-18 13:05:44’);
TRUNCATE TABLE oc8m_address
;
CREATE TABLE >>>oc8m_address
<<< IF NOT EXISTS;
TRUNCATE TABLE oc8m_address
;
Ovako si treb’o
CREATE TABLE `oc8m_address` IF NOT EXISTS;
TRUNCATE TABLE `oc8m_address`;
INSERT INTO oc8m_address (address_id, customer_id, firstname, lastname, company, address_1, address_2, city, postcode, country_id, zone_id, custom_field) VALUES (‘1’, ‘1’, ‘Faiz’, ‘ali’, ‘Pakistan’, ‘A-14’, ‘Meezan bank near PSO pump malir Karachi Pakistan’, ‘Karachi’, ‘75080’, ‘162’, ‘2462’, ‘’);
INSERT INTO oc8m_api (api_id, username, key, status, date_added, date_modified) VALUES (‘1’, ‘Default’, ‘72UvtGRDeUObh2plKrpGTSqXbhjzFzgUavhwhaAbbUuK415ak4abUZhyLFN871wtaJHVz0R5HHaIuUuBpKzWsxkmcnCIHHj8j6XaZMb2CYlInMevSHtdNEkj0KiE7SiIBWX2O2FwTvAwXGHfFom8bzlMPZwrM2uhvY8mYG8ovAWFbYEc1rHV1FwmW9VZm7Ttz5SNFzzuya40Ib8nUEIZGktWBAhxz9zD9JudxHUOVws7z1C8gz3YssJx1IZgE3Dm’, ‘1’, ‘2018-05-18 13:05:44’, ‘2018-05-18 13:05:44’);
Mislim da treba mnogo toga da naucim
evo sad sam uradio kao ti i
Static analysis:
2 errors were found during analysis.
- Unexpected beginning of statement. (near “EATE” at position 0)
- Unrecognized statement type. (near “TABLE” at position 5)
SQL query:
EATE TABLE oc8m_address
IF NOT EXISTS
#1064 - 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 'EATE TABLE
oc8m_addressIF NOT EXISTS' at line 1
Pa ne čita ti dobro ili si loše prekopir’o.
EATE bi trebalo biti CREATE.
Prepiši, nemoj kopirati: nekad wysiwyg editori znaju malo pobrljaviti (iako sam se trudio koristiti code tags).
Završio prethodnu komandnu linuju tačka-zarezom?
Ili je ovo što sam ti napis’o ujedno i sve što se trenutno nalazi u skripti?
Stavio sam
ovako je napisano u tom sql koji treba da uvezem
to je original koji nije editovan
TRUNCATE TABLE oc8m_address
;
INSERT INTO oc8m_address
(address_id
, customer_id
, firstname
, lastname
, company
, address_1
, address_2
, city
, postcode
, country_id
, zone_id
, custom_field
) VALUES (‘1’, ‘1’, ‘Faiz’, ‘ali’, ‘Pakistan’, ‘A-14’, ‘Meezan bank near PSO pump malir Karachi Pakistan’, ‘Karachi’, ‘75080’, ‘162’, ‘2462’, ‘’);
TRUNCATE TABLE oc8m_api
;
INSERT INTO oc8m_api
(api_id
, username
, key
, status
, date_added
, date_modified
) VALUES (‘1’, ‘Default’, ‘72UvtGRDeUObh2plKrpGTSqXbhjzFzgUavhwhaAbbUuK415ak4abUZhyLFN871wtaJHVz0R5HHaIuUuBpKzWsxkmcnCIHHj8j6XaZMb2CYlInMevSHtdNEkj0KiE7SiIBWX2O2FwTvAwXGHfFom8bzlMPZwrM2uhvY8mYG8ovAWFbYEc1rHV1FwmW9VZm7Ttz5SNFzzuya40Ib8nUEIZGktWBAhxz9zD9JudxHUOVws7z1C8gz3YssJx1IZgE3Dm’, ‘1’, ‘2018-05-18 13:05:44’, ‘2018-05-18 13:05:44’);
TRUNCATE TABLE oc8m_api_ip
;
Hvala puno na vremenu i pomoci,ali ja nemam strpljenja vise.
Radije cu ponovo praviti sajt.
Nemozes insert u table ako table nije kreiran. A sto zapravo zelsi napraviti? Mozda ako vec razmisljas o kreiranju sitea iznova da probas dumpat cjelu bazu pa je importas cijelu jer onda vjerujemd a ce i creirat tablice a ne ovako da inserta u tablice koje ne postoje…
Sada si dod’o i oc8m_api_ip
tabelu dole. Ja ti mogu pomoći samo sa onim što izneseš ovde jer se nagadjanjima ne bavim.
Ako se predomisliš, vrati se na ovu temu.
Nisam dodao to je originalni sql koji nije editovan
Malo detaljnije,mozda i probam
Tebi je cilj da očistiš tabelu prije novog unosa. To radi TRUNCATE
naredba.
TRUNCATE
naredba cće ti vratiti grešku ako tabela koju planiraš da očistiš ne postoji u bazi.
Zbog toga komanda CREATE TABLE oc8m_address IF NOT EXISTS;
Ovde ćeš kreirati tabelu ukol’ko već ne postoji i naredna naredba neće imati problem jer će očistiti oc8m_address
tabelu koja sad u svakom slučaju postoji (nije problem ni ako je sama tabela pred izvodjenje TRUNCATE naredbe već prazna).
Nakon toga vršiš unos podataka u tabelu i to bi trebalo biti to. Ni manje ni više.
Vidim da si naknadno stavio čišćenje oc8m_api_ip
tabele (nije ga bilo u prvim postovima).
USE hiqclqjj_new;
CREATE TABLE `oc8m_address` IF NOT EXISTS;
TRUNCATE TABLE `oc8m_address`;
CREATE TABLE `oc8m_api_ip` IF NOT EXISTS;
TRUNCATE TABLE `oc8m_api_ip`;
CREATE TABLE `oc8m_api` IF NOT EXISTS;
TRUNCATE TABLE `oc8m_api`;
INSERT INTO oc8m_address (address_id, customer_id, firstname, lastname, company, address_1, address_2, city, postcode, country_id, zone_id, custom_field) VALUES (‘1’, ‘1’, ‘Faiz’, ‘ali’, ‘Pakistan’, ‘A-14’, ‘Meezan bank near PSO pump malir Karachi Pakistan’, ‘Karachi’, ‘75080’, ‘162’, ‘2462’, ‘’);
INSERT INTO oc8m_api (api_id, username, key, status, date_added, date_modified) VALUES (‘1’, ‘Default’, ‘72UvtGRDeUObh2plKrpGTSqXbhjzFzgUavhwhaAbbUuK415ak4abUZhyLFN871wtaJHVz0R5HHaIuUuBpKzWsxkmcnCIHHj8j6XaZMb2CYlInMevSHtdNEkj0KiE7SiIBWX2O2FwTvAwXGHfFom8bzlMPZwrM2uhvY8mYG8ovAWFbYEc1rHV1FwmW9VZm7Ttz5SNFzzuya40Ib8nUEIZGktWBAhxz9zD9JudxHUOVws7z1C8gz3YssJx1IZgE3Dm’, ‘1’, ‘2018-05-18 13:05:44’, ‘2018-05-18 13:05:44’);
Ovaj kod ti rješava sav problem (ako su polja address tabele i vrijednosti unosa korektno upisana):
setovana baza, napravljene i očišćene tabele koje trebaju biti očišćene te napravljen unos u address tabelu.
Ako ovo ne radi, nisam siguran da mogu pomoći s dostupnim podacima.
Edit: e sad je moguće da ne primjećuješ razliku izmedju api i api_ip tabela jer si ih izmiješ’o po postovima pa se postavlja pitanje da li su obe potrebne i [ako ne, ] koja od njih jeste.