| Question: |
Hello, I have a problem with the site shows error 500 with htaccess, this file is important for the operation of the site, even when fully salmeterol htaccess and followed the link on the main, I usodno shows error 500, help solve the problem |
| Answer: |
Hello the address which you see the error? |
| Question: |
http://ecroit.testv1.testforhost.com/bootstrap.phpР° if in. htaccess to DirectoryIndex raskomentiruyte bootstrap.php then the error is at http://ecroit.testv1.testforhost.com/ |
| Answer: |
your script with an error
[23-Jan-2016 18:19:25 Europe/Moscow] PHP Parse error: syntax error, unexpected `[` in /home/ecroit/public_html/bootstrap.php on line 28
[23-Jan-2016 18:19:28 Europe/Moscow] PHP Parse error: syntax error, unexpected `[` in /home/ecroit/public_html/bootstrap.php on line 28
[23-Jan-2016 17:25:17 Europe/Moscow] PHP Fatal error: connection failed: SQLSTATE[28000] [1045] Access denied for user `root`@`localhost` (using password: NO) in /home/ecroit/public_html/kernel/database.php on line 6
[23-Jan-2016 17:25:34 Europe/Moscow] PHP Fatal error: connection failed: SQLSTATE[28000] [1045] Access denied for user `root`@`localhost` (using password: NO) in /home/ecroit/public_html/kernel/database.php on line 6
[23-Jan-2016 17:29:58 Europe/Moscow] PHP Fatal error: connection failed: SQLSTATE[28000] [1045] Access denied for user `root`@`localhost` (using password: NO) in /home/ecroit/public_html/kernel/database.php on line 6
[23-Jan-2016 17:30:00 Europe/Moscow] PHP Fatal error: connection failed: SQLSTATE[28000] [1045] Access denied for user `root`@`localhost` (using password: NO) in /home/ecroit/public_html/kernel/database.php on line 6
[23-Jan-2016 17:31:18 Europe/Moscow] PHP Fatal error: connection failed: SQLSTATE[28000] [1045] Access denied for user `root`@`localhost` (using password: NO) in /home/ecroit/public_html/kernel/database.php on line 6
[23-Jan-2016 17:32:56 Europe/Moscow] PHP Fatal error: connection failed: SQLSTATE[28000] [1045] Access denied for user `root`@`localhost` (using password: NO) in /home/ecroit/public_html/kernel/database.php on line 6
[23-Jan-2016 17:36:12 Europe/Moscow] PHP Fatal error: connection failed: SQLSTATE[28000] [1045] Access denied for user `root`@`localhost` (using password: NO) in /home/ecroit/public_html/kernel/database.php on line 6
[23-Jan-2016 17:36:16 Europe/Moscow] PHP Fatal error: connection failed: SQLSTATE[28000] [1045] Access denied for user `root`@`localhost` (using password: NO) in /home/ecroit/public_html/kernel/database.php on line 6
|
| Answer: |
you have, there can be no root please check the settings of your script |
| Question: |
thank you, now will hold settings |
| Answer: |
<?php^M
^M
try {^M
$sql = new PDO(`mysql:host=localhost;dbname=shop;charset=utf8`, `root`\");^ ??? why root? please put the correct value
} catch (PDOException $e) {^M
trigger_error(`connection Error:` . $e- > getMessage(), E_USER_ERROR);^M
}^M
?>
|
| Question: |
to even when on a local server did scoring change |
| Answer: |
ok
|
| Question: |
all errors fixed, but another question, how to change the coding in the tables that bi information display bilo normalnim |
| Answer: |
To do this, after the creation of the database in the panel you need to go into phpMyAdmin and set the desired encoding for your table. |
| Question: |
checked on the website and our database danng I demonstrate that such information R•RRR–R No. on the website it uglyadet fine, but when I added a table with the list of categories in the database danh category citabel, and on the website �������, help to fix |
| Answer: |
to clarify where you see the problem |
| Question: |
on the website menu razdel place normalnih letters with diamonds voplotitelem signs |
| Answer: |
give a link please |
| Question: |
here`s an example http://ecro.it/shop/cat/id/1 or http://ecro.it/ |
| Answer: |
where are the data which are displayed in wrong encoding? |
| Question: |
table cat |
| Question: |
and dannie with Russian characters are entered to tablets, pma citabel they are not, an example can be seen in the users table in the columns name, surname |
| Answer: |
what is encoding of data in the database and on the website? |
| Question: |
all tablets utf8_general_ci |
| Answer: |
please indicate how you have filled the table |
| Question: |
INSERT INTO `cat` (`id`, `cat_id`, `title`, `server_name`, `add`) VALUES(1, 0, `Scripts`, `/skripty`, 0),(2, 1, `PHP-Scripts`, `/skripty/php skripty`, 1),(3, 1, `JS-Scripts`, `/skripty/js-skripty`, 1),(4, 1, `ASP-Scripts`, `/skripty/asp-skripty`, 1),(5, 1, `Other`, `/skripty/drugie`, 1),(6, 1, `CMS`, `/skripty/dlya-cms`, 1),(7, 0, `Graphics, design`, `/grafika-dizayn`, 0),(8, 7, `the Design of sites`, `/grafika-dizayn/dizayn-saytov`, 1),(9, 7, `Raster graphics`, `/grafika-dizayn/rastrovaya-grafika`, 1),(10, 7, `Fractal graphics`, `/grafika-dizayn/fraktal-naya-grafika`, 1),(11, 7, `2D-graphics`, `/grafika-dizayn/2d-grafika`, 1),(12, 7, `3D-graphics`, `/grafika-dizayn/3d-grafika`, 1),(13, 7, `Vector graphics`, `/grafika-dizayn/vektornaya-grafika`, 1),(14, 7, `Animation`, `/grafika-dizayn/animaciya`, 1),(15, 7, `Multimedia`, `/grafika-dizayn/multimedia`, 1),(16, 7, `Graphics applications`, `/grafika-dizayn/grafika-prilozheniy`, 1),(17, 7, `WEB-Graphics`, `/grafika-dizayn/web-grafika`, 1),(18, 7, `Other graphics`, `/grafika-dizayn/drugaya-grafika`, 1),(19, 0, `Programming`, `/programmirovanie`, 0),(20, 19, `System administrator`, `/programmirovanie/sistemnyy-administrator`, 1),(21, 19, `Database`, `/programmirovanie/bazy-dannyh`, 1),(22, 19, `Mobile apps`, `/programmirovanie/mobil-nye-prilozheniya`, 1),(23, 19, `Applied programming`, `/programmirovanie/prikladnoe-programmirovanie`, 1),(24, 19, `System programming`, `/programmirovanie/sistemnoe-programmirovanie`, 1),(25, 19, `Other`, `/programmirovanie/drugoe`, 1),(26, 0, `SEO Optimization`, `/seo-optimizaciya`, 1),(27, 0, `Training and consulting`, `/obuchenie-i-konsul-tacii`, 1),(28, 0, `Advertising`, `/reklama`, 0),(29, 28, `Media advertising`, `/reklama/mediynaya-reklama`, 1),(30, 28, `Banners`, `/reklama/bannery`, 1),(31, 28, `Frame`, `/reklama/freym`, 1),(32, 28, `POP-UP banners`, `/reklama/pop-up-bannery`, 1),(33, 28, `Direct-is`, `/reklama/direkt-reklama`, 1),(34, 28, `Other`, `/reklama/drugoe`, 1),(35, 0, `Accounts`, `/akkaunty`, 0),(36, 35, `Online games`, `/akkaunty/onlayn-game`, 1),(37, 35, `the Social network`, `/akkaunty/social-nye-seti`, 1),(38, 35, `Forums`, `/akkaunty/forumy`, 1),(39, 35, `Mobile apps`, `/akkaunty/mobil-nye-prilozheniya`, 1),(40, 35, `Portals`, `/akkaunty/portaly`, 1),(41, 35, `ICQ number`, `/akkaunty/icq-number`, 1),(42, 35, `Other accounts`, `/akkaunty/drugie-akkaunty`, 1),(43, 0, `Sites`, `/sayty`, 0),(44, 43, `WAP-Sites`, `/sayty/wap-sayty`, 1),(45, 43, `WEB-Sites`, `/sayty/web-sayty`, 1),(46, 43, `Projects`, `/sayty/proekty`, 1),(47, 43, `Developments`, `/sayty/narabotki`, 1),(48, 43, `Designers`, `/sayty/konstruktory`, 1),(49, 43, `Sold`, `/sayty/prodavaemye`, 1),(50, 43, `Landings`, `/sayty/landings`, 1),(51, 0, `Domains`, `/domeny`, 0),(52, 51, `Commercial`, `/domeny/kommercheskie`, 1),(53, 51, `Educational`, `/domeny/obrazovatel-nye`, 1),(54, 51, `Business`, `/domeny/biznes`, 1),(55, 51, `Information`, `/domeny/informacionnye`, 1),(56, 51, `Geographical`, `/domeny/geograficheskie`, 1),(57, 51, `Social`, `/domeny/social-nye`, 1),(58, 51, `Mobile`, `/domeny/mobil-nye`, 1),(59, 51, `Other`, `/domeny/drugie`, 1); |
| Answer: |
In this case, the instruction id is not required. After inserting MySQL will assign it the desired ID. Have you updated or edited? Judging by the query you are inserting data. |
| Question: |
I presented dannie threw just dump http://ecro.it/tables.sql |
| Question: |
by the way when you change the encoding in the browser to windows-1251 it dannie Vvedenie with tablets start to appear normally, and the other text is garbled |
| Answer: |
so you have data in the table in 1251 is not utf8/ update as you did the dump? |
| Question: |
odrl in a text editor, copied and vpanel query in pma |
| Answer: |
import the file, pre-clearing the database |
| Question: |
added an entry via the website in a table cat, she`s so uglyadet id: 60cat_id: 0title: S RSS` (adds ieroglif database danh, but the site is displayed normally)server_name: /testadd: 0 |
| Answer: |
all right CP1251 → UTF-8 |
| Question: |
so all tablets and so in utf8_general_ci |
| Answer: |
that on the website. phpmyadmin, the interface in a different encoding. |
|
