K\u0101p\u0113c rodas k\u013c\u016bda?<\/h2>\n
\u012as\u0101k sakot, \u0161\u012b k\u013c\u016bda rodas t\u0101p\u0113c, ka WordPress nevar izveidot savienojumu ar datub\u0101zi. Ir da\u017e\u0101di iemesli, k\u0101p\u0113c tas neizdodas. Varb\u016bt j\u016bsu datub\u0101zes pieteik\u0161an\u0101s v\u0101rds un parole ir nepareizi vai ir main\u012bti. Varb\u016bt j\u016bsu datub\u0101zes serveris nerea\u0123\u0113. Varb\u016bt datub\u0101zes faili ir boj\u0101ti. P\u0113c m\u016bsu pieredzes, liel\u0101ko da\u013cu k\u013c\u016bdu izraisa k\u0101da veida servera k\u013c\u016bdas, lai gan past\u0101v ar\u012b citi faktori. Apskat\u012bsim, k\u0101 nov\u0113rst \u0161o probl\u0113mu.<\/p>\n
Vai t\u0101 pati k\u013c\u016bda rodas ar\u012b \/wp-admin\/?<\/h2>\n
Vispirms j\u0101p\u0101rliecin\u0101s, ka gan lietot\u0101ja saskarn\u0113, gan server\u012b (wp-admin) rodas viena un t\u0101 pati k\u013c\u016bda. Ja ab\u0101s lap\u0101s k\u013c\u016bdas zi\u0146ojums ir vien\u0101ds \u2014 \u201cError establishing a database connection\u201d, \u2014 varat p\u0101riet pie n\u0101kam\u0101s darb\u012bbas. Ja wp-admin lap\u0101 tiek par\u0101d\u012bta cita k\u013c\u016bda, piem\u0113ram, \u201cOne or more database tables are unavailable. The database may need to be repaired\u201d, \u2013 tad ir j\u0101labo datub\u0101ze.<\/p>\n
To var izdar\u012bt, pievienojot \u0161\u0101du rindi\u0146u savam wp-config.php failam. Pievienojiet to pirms rindas \u2018That\u2019s all, stop editing! Happy blogging<\/em>\u2019 wp-config.php fail\u0101:<\/p>\n Kad tas b\u016bs izdar\u012bts, \u0161aj\u0101 lap\u0101 var\u0113siet redz\u0113t iestat\u012bjumus:<\/p>\n \n Atcerieties, ka lietot\u0101jam nav j\u0101piesak\u0101s, lai piek\u013c\u016btu \u0161ai funkcijai, ja vien \u0161\u012b defin\u012bcija ir pieejama. Tas ir t\u0101p\u0113c, ka t\u0101s galvenais m\u0113r\u0137is ir labot boj\u0101tu datu sist\u0113mu. Lietot\u0101ji bie\u017ei vien nevar pieteikties, ja datub\u0101ze ir boj\u0101ta. T\u0101p\u0113c, kad esat pabeidzis datub\u0101zes labo\u0161anu un optimiz\u0113\u0161anu, noteikti no\u0146emiet \u0161o rindi\u0146u no wp-config.php. Ja tas neatrisina probl\u0113mu vai ja nevarat veikt \u0161o darb\u012bbu, lasiet t\u0101l\u0101k \u2014 jums var\u0113tu der\u0113t cita metode.<\/p>\n WP-Config.php, iesp\u0113jams, ir vissvar\u012bg\u0101kais fails vis\u0101 WordPress instal\u0113\u0161anas proces\u0101. \u0160eit varat iestat\u012bt WordPress iestat\u012bjumus un izveidot savienojumu ar datub\u0101zi. Ja esat main\u012bjis root paroli vai datub\u0101zes paroli, jums b\u016bs j\u0101maina ar\u012b \u0161is fails. Vienm\u0113r vispirms p\u0101rbaudiet failu wp-config.php, lai redz\u0113tu, vai nav veiktas k\u0101das izmai\u0146as.<\/p>\n Atcerieties, ka DB_Host v\u0113rt\u012bba ne vienm\u0113r b\u016bs localhost. T\u0101 at\u0161\u0137irsies atkar\u012bb\u0101 no hostinga pakalpojuma sniedz\u0113ja. Popul\u0101riem hostinga pakalpojumu sniedz\u0113jiem, piem\u0113ram, HostGator, BlueHost, Site5, t\u0101 ir localhost.<\/p>\n Lai noskaidrotu prec\u012bzu DB_Host v\u0113rt\u012bbu, ielogojieties sav\u0101 hostinga kont\u0101 (piem\u0113ram, cPanel vai Plesk), atveriet sada\u013cu \u201cMySQL Databases\u201d un p\u0101rbaudiet, k\u0101ds ir nor\u0101d\u012btais hosta nosaukums. Ja inform\u0101cija nav skaidri redzama, dro\u0161i sazinieties ar hostinga atbalsta dienestu.<\/p>\n Da\u017ei cilv\u0113ki apgalvo, ka vi\u0146iem izdev\u0101s nov\u0113rst probl\u0113mu, mainot localhost uz IP. \u0160\u0101da situ\u0101cija bie\u017ei rodas, palai\u017eot WordPress lok\u0101laj\u0101 server\u012b. Piem\u0113ram, MAMP vid\u0113 DB_Host v\u0113rt\u012bbas mai\u0146a uz IP var pal\u012bdz\u0113t.<\/p>\n IP at\u0161\u0137irsies atkar\u012bb\u0101 no t\u012bmek\u013ca hostinga.<\/p>\n Ja \u0161aj\u0101 fail\u0101 nav k\u013c\u016bdu (p\u0101rbaudiet, vai nav drukas k\u013c\u016bdu), visticam\u0101k, kaut kas nav k\u0101rt\u012bb\u0101 ar serveri.<\/p>\n Bie\u017ei vien \u0161\u012b datub\u0101zes savienojuma k\u013c\u016bda tiek paman\u012bta, kad vietnei ir palielin\u0101ta datpl\u016bsma. J\u016bsu hostinga serveris vienk\u0101r\u0161i nevar tikt gal\u0101 ar piepl\u016bdumu (\u012bpa\u0161i, ja izmantojat koplietotu hostingu). J\u016bsu vietne iev\u0113rojami pal\u0113nin\u0101sies un da\u017eiem lietot\u0101jiem tiks par\u0101d\u012bta k\u013c\u016bda. T\u0101p\u0113c lab\u0101kais, ko varat dar\u012bt, ir sazin\u0101ties ar savu hostinga pakalpojumu sniedz\u0113ju pa t\u0101lruni vai tie\u0161saistes t\u0113rz\u0113\u0161an\u0101 un pajaut\u0101t, vai j\u016bsu MySQL serveris darbojas.<\/p>\n Tiem no jums, kas v\u0113las pa\u0161i p\u0101rbaud\u012bt MySQL serveri, varat r\u012bkoties \u0161\u0101di. P\u0101rbaudiet, vai t\u0101da pati probl\u0113ma rodas cit\u0101s vietn\u0113s taj\u0101 pa\u0161\u0101 server\u012b. Ja tur par\u0101d\u0101s t\u0101da pati k\u013c\u016bda, probl\u0113ma noteikti ir MySQL server\u012b. Ja jums nav citas vietnes taj\u0101 pa\u0161\u0101 hostinga kont\u0101, vienk\u0101r\u0161i piesakieties cPanel un m\u0113\u0123iniet piek\u013c\u016bt phpMyAdmin un izveidot savienojumu ar datub\u0101zi. Ja nevarat izveidot savienojumu, p\u0101rliecinieties, vai j\u016bsu datub\u0101zes lietot\u0101jam ir atbilsto\u0161as \u200b\u200bat\u013caujas. Izveidojiet jaunu failu ar nosaukumu testconnection.php<\/strong> un iel\u012bm\u0113jiet taj\u0101 \u0161\u0101du kodu:<\/p>\n P\u0101rliecinieties, ka esat nomain\u012bjis lietot\u0101jv\u0101rdu un paroli. Ja varat izveidot savienojumu, tad j\u016bsu lietot\u0101jam ir atbilsto\u0161as \u200b\u200bat\u013caujas, un probl\u0113ma ir kaut kur citur. Atgriezieties wp-config fail\u0101 un p\u0101rbaudiet, vai viss ir pareizi (v\u0113lreiz p\u0101rbaudiet, vai nav drukas k\u013c\u016bdu).<\/p>\n Ja nevarat izveidot savienojumu ar datub\u0101zi, izmantojot phpMyAdmin, varat b\u016bt p\u0101rliecin\u0101ts, ka probl\u0113ma ir server\u012b. Tas nenoz\u012bm\u0113, ka j\u016bsu MySQL serveris nedarbojas. Iesp\u0113jams, ka j\u016bsu lietot\u0101jam nav atbilsto\u0161as \u200b\u200bpiek\u013cuves.<\/p>\n M\u016bsu gad\u012bjum\u0101 MySQL serveris darboj\u0101s. Visas m\u016bsu vietnes server\u012b darboj\u0101s pareizi, iz\u0146emot vienu. M\u0113\u0123inot pieteikties phpMyAdmin, par\u0101d\u012bj\u0101s \u0161\u0101da k\u013c\u016bda:<\/p>\n #1045 \u2013 Access denied for user \u2018foo\u2019@\u2019%\u2019 (using password: YES)<\/strong><\/p>\n M\u0113s piezvan\u012bj\u0101m HostGator, un vi\u0146u atbalsta dienests \u0101tri atrada probl\u0113mu. Kaut k\u0101d\u0101 veid\u0101 m\u016bsu lietot\u0101ja piek\u013cuve tika atiestat\u012bta. M\u0113s nezin\u0101m, k\u0101 tas notika, bet tas ac\u012bmredzami bija iemesls. Vi\u0146i atjaunoja piek\u013cuvi, un m\u0113s var\u0113j\u0101m atjaunot vietnes darb\u012bbu.<\/p>\n T\u0101tad, ja, piesl\u0113dzoties phpMyAdmin vai izmantojot testconnection.php rezult\u0101tus, rodas piek\u013cuves k\u013c\u016bda, nekav\u0113joties sazinieties ar savu hostinga uz\u0146\u0113mumu \u2014 vi\u0146iem vajadz\u0113tu b\u016bt iesp\u0113jai to nov\u0113rst.<\/p>\n Svar\u012bga atruna: \u0161ie risin\u0101jumi var jums neder\u0113t. Izmantojiet tos uz savu atbild\u012bbu un veiciet nepiecie\u0161am\u0101s dubl\u0113jumkopijas gad\u012bjumam, ja kaut kas noiet greizi.<\/p>\n Viens lietot\u0101js zi\u0146oja, ka vi\u0146a klientam rad\u0101s k\u013c\u016bda, kas saist\u012bta ar datub\u0101zi. Pat p\u0113c datub\u0101zes atjauno\u0161anas k\u013c\u016bda nepazuda. Vi\u0146\u0161 izm\u0113\u0123in\u0101ja daudzas lietas, bet galu gal\u0101 probl\u0113ma tika atrasta vietnes URL. Tas tika main\u012bts, k\u0101 rezult\u0101t\u0101 rad\u0101s \u0161\u012b k\u013c\u016bda. Vi\u0146\u0161 palaidis SQL vaic\u0101jumu phpMyAdmin:<\/p>\n P\u0101rliecinieties, ka YOUR_SITE_URL ir main\u012bts uz der\u012bgu URL, piem\u0113ram: https:\/\/coma.lv. wp_ opcijas b\u016bs atkar\u012bgas no t\u0101, vai esat main\u012bjis noklus\u0113juma WordPress datub\u0101zes prefiksu.<\/p>\n Vi\u0146a un vair\u0101ku citu gad\u012bjum\u0101 \u0161\u012b metode nov\u0113rsa k\u013c\u016bdu.<\/p>\n Cits lietot\u0101js teica, ka vi\u0146am izdev\u0101s izveidot savienojumu ar datub\u0101zi, izmantojot testconnection.php, t\u0101p\u0113c vi\u0146\u0161 nomain\u012bja wp-config.php lietot\u0101ju uz root lietot\u0101ju. WordPress s\u0101ka darboties lieliski. P\u0113c tam vi\u0146\u0161 atgrieza iestat\u012bjumus datub\u0101zes lietot\u0101jam. Vi\u0146\u0161 nevar\u0113ja saprast, k\u0101da ir probl\u0113ma, bet vi\u0146\u0161 dom\u0101, ka t\u0101 bija drukas k\u013c\u016bda.<\/p>\n Cita lietot\u0101ja zi\u0146oja, ka vi\u0146a no wp_options tabulas ir no\u0146\u0113musi active_plugins saturu un redi\u0123\u0113jusi nesen redi\u0123\u0113to saturu. \u0160\u0137iet, ka tas atrisin\u0101ja probl\u0113mu.<\/p>\n Daudzi avoti apgalvo, ka lietot\u0101jiem izdev\u0101s nov\u0113rst \u0161o k\u013c\u016bdu, vienk\u0101r\u0161i lejupiel\u0101d\u0113jot jaunu WordPress versiju.<\/p>\n \u0160\u012b ir \u013coti kaitino\u0161a k\u013c\u016bda. Ko j\u016bs m\u0113\u0123in\u0101j\u0101t, kas jums pal\u012bdz\u0113ja? M\u0113s labpr\u0101t papla\u0161in\u0101tu \u0161o rakstu, lai citiem b\u016btu viegl\u0101k atrast risin\u0101jumu.<\/p>\n M\u016bsu specializ\u0101cija ir WordPress viet\u0146u izstr\u0101de un atbalsts. Sazinieties ar mums, lai sa\u0146emtu bezmaksas konsult\u0101ciju. \u2014 vadim@coma.lv<\/a>, +371 29394520<\/a><\/em><\/p>\n Ja esat pavad\u012bjis diezgan ilgu laiku internet\u0101, iesp\u0113jams, esat sask\u0101ries ar \u0161o k\u013c\u016bdu vismaz p\u0101ris reizes. Datu b\u0101zes savienojuma k\u013c\u016bda ir viena no t\u0101m l\u0101stiem, kas var rasties da\u017e\u0101du iemeslu d\u0113\u013c. WordPress ies\u0101c\u0113jam t\u0101 ir \u012bsta probl\u0113ma, it \u012bpa\u0161i, ja k\u013c\u016bda par\u0101d\u0101s pati no sevis. L\u012bdz\u012bga k\u013c\u016bda par\u0101d\u012bj\u0101s ar\u012b m\u016bsu vietn\u0113. Mums vajadz\u0113ja nedaudz vair\u0101k […]<\/p>\n","protected":false},"author":12,"featured_media":38386,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1226,1317],"tags":[],"class_list":["post-35731","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-wordpress","category-iesacejiem"],"_links":{"self":[{"href":"https:\/\/coma.lv\/lv\/wp-json\/wp\/v2\/posts\/35731","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/coma.lv\/lv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/coma.lv\/lv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/coma.lv\/lv\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/coma.lv\/lv\/wp-json\/wp\/v2\/comments?post=35731"}],"version-history":[{"count":5,"href":"https:\/\/coma.lv\/lv\/wp-json\/wp\/v2\/posts\/35731\/revisions"}],"predecessor-version":[{"id":37081,"href":"https:\/\/coma.lv\/lv\/wp-json\/wp\/v2\/posts\/35731\/revisions\/37081"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/coma.lv\/lv\/wp-json\/wp\/v2\/media\/38386"}],"wp:attachment":[{"href":"https:\/\/coma.lv\/lv\/wp-json\/wp\/v2\/media?parent=35731"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/coma.lv\/lv\/wp-json\/wp\/v2\/categories?post=35731"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/coma.lv\/lv\/wp-json\/wp\/v2\/tags?post=35731"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}define('WP_ALLOW_REPAIR', true); <\/pre>\n![\"wprepairdb\"](\"https:\/\/coma.lv\/wp-content\/uploads\/2016\/08\/wprepairdb.jpg\" "\\"\\"")
<\/p>\nWP-Config faila p\u0101rbaude<\/h2>\n
\r\ndefine('DB_NAME', 'database-name');\r\ndefine('DB_USER', 'database-username');\r\ndefine('DB_PASSWORD', 'database-password');\r\ndefine('DB_HOST', 'localhost');\r\n<\/pre>\ndefine('DB_HOST', '127.0.0.1:8889');<\/pre>\nP\u0101rbaudiet savu hostingu (MySQL Server)<\/h2>\n
$link = mysql_connect('localhost', 'root', 'password');\r\nif (!$link) {\r\ndie('Could not connect: ' . mysql_error());\r\n}\r\necho 'Connected successfully';\r\nmysql_close($link);<\/pre>\nAlternat\u012bvi risin\u0101jumi<\/h2>\n
UPDATE wp_options SET option_value='YOUR_SITE_URL' WHERE option_name='siteurl'<\/pre>\n
\n
\n","protected":false},"excerpt":{"rendered":"