Задать вопрос

Rasul_qa

Комментарии

  • Что за связь между таблицами?

    @Rasul_qa Автор вопроса
    Не знал, что в WHERE умеет выбирать данные из другой таблицы...
    А если нужно вывести имя товара, имя производителя и имя категории для товаров, на которые действует скидка (discount) 10%. Тогда запрос будет таким?

    SELECT Goods.name, Manufactures.name, Categories.name, Prices.price
 FROM Prices, Goods
  INNER JOIN Categories on Categories.id = Goods.category_id
  INNER JOIN Manufactures on Manufactures.id = Goods.manufacturer_id
 WHERE Prices.discount = 10 AND Goods.id = Prices.id;
    Написано

  • Как правильно установить и настроить falcon?

    @Rasul_qa Автор вопроса
    Так фалкон вроде установился... imagy.me/nisoxukdwr
    Но ошибки по прежнему есть...
    spoiler
    2018/05/16 11:55:29 [error] 27822#27822: *28 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught Error: Class 'Phalcon\Config' not found in /var/www/html/backend/config/config.php:5
    Stack trace:
    #0 /var/www/html/backend/index.php(27): include()
    #1 {main}
    thrown in /var/www/html/backend/config/config.php on line 5" while reading response header from upstream, client: ::1, server: 127.0.0.1, request: "GET /app.css?v=1526373912940 HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php7.2-fpm.sock:", host: "localhost", referrer: "localhost"
    2018/05/16 11:55:29 [error] 27822#27822: *27 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught Error: Class 'Phalcon\Config' not found in /var/www/html/backend/config/config.php:5
    Stack trace:
    #0 /var/www/html/backend/index.php(27): include()
    #1 {main}
    thrown in /var/www/html/backend/config/config.php on line 5" while reading response header from upstream, client: ::1, server: 127.0.0.1, request: "GET /app.js?v=1526373912940 HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php7.2-fpm.sock:", host: "localhost", referrer: "localhost"
    2018/05/16 12:39:45 [error] 27822#27822: *39 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught Error: Class 'Phalcon\Config' not found in /var/www/html/backend/config/config.php:5
    Stack trace:
    #0 /var/www/html/backend/index.php(27): include()
    #1 {main}
    thrown in /var/www/html/backend/config/config.php on line 5" while reading response header from upstream, client: ::1, server: 127.0.0.1, request: "GET /app.js?v=1526373912940 HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php7.2-fpm.sock:", host: "localhost", referrer: "localhost"
    2018/05/16 12:39:45 [error] 27822#27822: *39 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught Error: Class 'Phalcon\Config' not found in /var/www/html/backend/config/config.php:5
    Stack trace:
    #0 /var/www/html/backend/index.php(27): include()
    #1 {main}
    thrown in /var/www/html/backend/config/config.php on line 5" while reading response header from upstream, client: ::1, server: 127.0.0.1, request: "GET /app.css?v=1526373912940 HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php7.2-fpm.sock:", host: "localhost", referrer: "localhost"
    2018/05/16 12:53:26 [info] 25751#25751: Using 32768KiB of shared memory for nchan in /etc/nginx/nginx.conf:63
    2018/05/16 12:57:08 [info] 25976#25976: Using 32768KiB of shared memory for nchan in /etc/nginx/nginx.conf:63
    2018/05/16 12:57:19 [error] 25979#25979: *1 open() "/var/www/index.php/info" failed (2: No such file or directory), client: ::1, server: 127.0.0.1, request: "GET /info HTTP/1.1", host: "localhost"
    2018/05/16 12:58:36 [info] 26103#26103: Using 32768KiB of shared memory for nchan in /etc/nginx/nginx.conf:63
    2018/05/16 12:58:37 [error] 26106#26106: *1 open() "/var/www/html/index.php/info" failed (20: Not a directory), client: ::1, server: 127.0.0.1, request: "GET /info HTTP/1.1", host: "localhost"
    2018/05/16 12:58:38 [error] 26106#26106: *1 open() "/var/www/html/index.php/info" failed (20: Not a directory), client: ::1, server: 127.0.0.1, request: "GET /info HTTP/1.1", host: "localhost"
    2018/05/16 12:58:39 [error] 26106#26106: *1 open() "/var/www/html/index.php/info" failed (20: Not a directory), client: ::1, server: 127.0.0.1, request: "GET /info HTTP/1.1", host: "localhost"
    2018/05/16 12:58:39 [error] 26106#26106: *1 open() "/var/www/html/index.php/info" failed (20: Not a directory), client: ::1, server: 127.0.0.1, request: "GET /info HTTP/1.1", host: "localhost"
    2018/05/16 12:58:39 [error] 26106#26106: *1 open() "/var/www/html/index.php/info" failed (20: Not a directory), client: ::1, server: 127.0.0.1, request: "GET /info HTTP/1.1", host: "localhost"
    2018/05/16 12:58:40 [error] 26106#26106: *1 open() "/var/www/html/index.php/info" failed (20: Not a directory), client: ::1, server: 127.0.0.1, request: "GET /info HTTP/1.1", host: "localhost"
    2018/05/16 12:58:40 [error] 26106#26106: *1 open() "/var/www/html/index.php/info" failed (20: Not a directory), client: ::1, server: 127.0.0.1, request: "GET /info HTTP/1.1", host: "localhost"
    2018/05/16 12:59:44 [error] 26106#26106: *1 open() "/var/www/html/index.php/info" failed (20: Not a directory), client: ::1, server: 127.0.0.1, request: "GET /info HTTP/1.1", host: "localhost"
    2018/05/16 12:59:44 [error] 26106#26106: *1 open() "/var/www/html/index.php/info" failed (20: Not a directory), client: ::1, server: 127.0.0.1, request: "GET /info HTTP/1.1", host: "localhost"
    2018/05/16 12:59:45 [error] 26106#26106: *1 open() "/var/www/html/index.php/info" failed (20: Not a directory), client: ::1, server: 127.0.0.1, request: "GET /info HTTP/1.1", host: "localhost"
    2018/05/16 12:59:45 [error] 26106#26106: *1 open() "/var/www/html/index.php/info" failed (20: Not a directory), client: ::1, server: 127.0.0.1, request: "GET /info HTTP/1.1", host: "localhost"
    2018/05/16 12:59:57 [error] 26106#26106: *1 open() "/var/www/html/index.php/info" failed (20: Not a directory), client: ::1, server: 127.0.0.1, request: "GET /info HTTP/1.1", host: "localhost"
    2018/05/16 13:00:08 [error] 26106#26106: *1 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught Error: Class 'Phalcon\Config' not found in /var/www/html/backend/config/config.php:5
    Stack trace:
    #0 /var/www/html/backend/index.php(27): include()
    #1 {main}
    thrown in /var/www/html/backend/config/config.php on line 5" while reading response header from upstream, client: ::1, server: 127.0.0.1, request: "GET /app.js?v=1526373912940 HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php7.2-fpm.sock:", host: "localhost", referrer: "localhost"
    2018/05/16 13:00:08 [error] 26106#26106: *23 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught Error: Class 'Phalcon\Config' not found in /var/www/html/backend/config/config.php:5

    Написано