lemon2015

lemon2015

Good Good Study,Day Day Up!

  • 财富值60
  • 威望值0
  • 总积分70

个人信息

  • 2017-01-24 已签到
    连续签到1天,获得了5个金钱
  • 2017-01-09 已签到
    连续签到1天,获得了5个金钱
  • 2016-10-13 已签到
    连续签到1天,获得了5个金钱
  • 回复了 的评论

    安装之后通过域名不能直接访问,需要加上/frontend/web/ 才可以。不知道怎么做才能打开域名就能访问。初学者还不会。

    配置虚拟域名,apache的话在/etc/apache2/sites-enables/下面,Nginx也有响应目录,配完之后配置/etc/hosts文件。不会的话网上搜下都有。

  • 前台config下的main.php缺少view目录配置。

    'view' => [
        'theme' => [
            'basePath' => '@app/themes/basic',
            'baseUrl' => '@web/themes/basic',
            'pathMap' => [
                '@app/views' => '@app/themes/basic',
            ],
        ],
    ],
    
  • 2016-03-29 已签到
    连续签到1天,获得了5个金钱
  • 回复了 的评论

    您好,请问我在后台标签列表页面,搜索营业点的时候,ajax总报500错误是怎么回事儿?别的页面没事...这个/store/name-filter路由指向的是哪?

    GET http://backend.lemon.local/store/name-filter?q=9999
    500 Internal Server Error55ms
    jquery.min.js (第 4 行)
    "NetworkError: 500 Internal Server Error - http://backend.lemon.local/store/name-filter?q=9999"
    name-fi...?q=9999

    知道了,sql语句生成的时候成form了,应该是from

  • 回复了 的评论

    您好,请问我在后台标签列表页面,搜索营业点的时候,ajax总报500错误是怎么回事儿?别的页面没事...这个/store/name-filter路由指向的是哪?

    GET http://backend.lemon.local/store/name-filter?q=9999
    500 Internal Server Error55ms
    jquery.min.js (第 4 行)
    "NetworkError: 500 Internal Server Error - http://backend.lemon.local/store/name-filter?q=9999"
    name-fi...?q=9999

    查询语句语法错误,我的mysql数据库版本是Server version: 5.6.28-0ubuntu0.15.04.1 (Ubuntu)

  • 回复了 的评论

    您好,请问我在后台标签列表页面,搜索营业点的时候,ajax总报500错误是怎么回事儿?别的页面没事...这个/store/name-filter路由指向的是哪?

    GET http://backend.lemon.local/store/name-filter?q=9999
    500 Internal Server Error55ms
    jquery.min.js (第 4 行)
    "NetworkError: 500 Internal Server Error - http://backend.lemon.local/store/name-filter?q=9999"
    name-fi...?q=9999

    响应的是:
    {"name":"Database Exception","message":"SQLSTATE[42000]: Syntax error or access violation: 1064 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 'FORM t_store AS t0 LEFT JOIN t_school AS t1 ON t0.school_id = t1.id WHERE
    t0' at line 1\nThe SQL being executed was: SELECT t0.id,CONCAT(t1.name,'-',t0.name) AS text FORM t_store AS t0 LEFT JOIN t_school AS t1 ON t0.school_id = t1.id WHERE t0.name LIKE '%999%' ORDER BY t0.school_id
    ASC LIMIT 25","code":42000,"type":"yii\db\Exception","file":"/var/www/Yii/vendor/yiisoft/yii2/db/Schema
    .php","line":628,"stack-trace":["#0 /var/www/Yii/vendor/yiisoft/yii2/db/Command.php(852): yii\db\Schema-
    >convertException(Object(PDOException), 'SELECT t0.id,CO...')","#1 /var/www/Yii/vendor/yiisoft/yii2/db
    /Command.php(359): yii\db\Command->queryInternal('fetchAll', NULL)","#2 /var/www/Yii/backend/controllers
    /StoreController.php(208): yii\db\Command->queryAll()","#3 [internal function]: backend\controllers
    \StoreController->actionNameFilter('999', NULL)","#4 /var/www/Yii/vendor/yiisoft/yii2/base/InlineAction
    .php(55): call_user_func_array(Array, Array)","#5 /var/www/Yii/vendor/yiisoft/yii2/base/Controller.php
    (151): yii\base\InlineAction->runWithParams(Array)","#6 /var/www/Yii/vendor/yiisoft/yii2/base/Module
    .php(455): yii\base\Controller->runAction('name-filter', Array)","#7 /var/www/Yii/vendor/yiisoft/yii2
    /web/Application.php(84): yii\base\Module->runAction('store/name-filt...', Array)","#8 /var/www/Yii
    /vendor/yiisoft/yii2/base/Application.php(375): yii\web\Application->handleRequest(Object(yii\web
    \Request))","#9 /var/www/Yii/backend/web/index.php(18): yii\base\Application->run()","#10 {main}"
    ],"error-info":["42000",1064,"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 'FORM t_store AS t0 LEFT JOIN t_school AS t1 ON t0.school_id = t1.id WHERE t0' at line 1"],"previous":{"name":"Exception","message":"SQLSTATE
    [42000]: Syntax error or access violation: 1064 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 'FORM t_store AS t0
    LEFT JOIN t_school AS t1 ON t0.school_id = t1.id WHERE t0' at line 1","code":"42000","type":"PDOException"
    ,"file":"/var/www/Yii/vendor/yiisoft/yii2/db/Command.php","line":837,"stack-trace":["#0 /var/www/Yii
    /vendor/yiisoft/yii2/db/Command.php(837): PDOStatement->execute()","#1 /var/www/Yii/vendor/yiisoft/yii2
    /db/Command.php(359): yii\db\Command->queryInternal('fetchAll', NULL)","#2 /var/www/Yii/backend/controllers
    /StoreController.php(208): yii\db\Command->queryAll()","#3 [internal function]: backend\controllers
    \StoreController->actionNameFilter('999', NULL)","#4 /var/www/Yii/vendor/yiisoft/yii2/base/InlineAction
    .php(55): call_user_func_array(Array, Array)","#5 /var/www/Yii/vendor/yiisoft/yii2/base/Controller.php
    (151): yii\base\InlineAction->runWithParams(Array)","#6 /var/www/Yii/vendor/yiisoft/yii2/base/Module
    .php(455): yii\base\Controller->runAction('name-filter', Array)","#7 /var/www/Yii/vendor/yiisoft/yii2
    /web/Application.php(84): yii\base\Module->runAction('store/name-filt...', Array)","#8 /var/www/Yii
    /vendor/yiisoft/yii2/base/Application.php(375): yii\web\Application->handleRequest(Object(yii\web
    \Request))","#9 /var/www/Yii/backend/web/index.php(18): yii\base\Application->run()","#10 {main}"
    ]}}

  • 您好,请问我在后台标签列表页面,搜索营业点的时候,ajax总报500错误是怎么回事儿?别的页面没事...这个/store/name-filter路由指向的是哪?

    GET http://backend.lemon.local/store/name-filter?q=9999
    500 Internal Server Error55ms
    jquery.min.js (第 4 行)
    "NetworkError: 500 Internal Server Error - http://backend.lemon.local/store/name-filter?q=9999"
    name-fi...?q=9999

职场新人 等级规则
70/100
资料完整度
90/100
用户活跃度
0/100

Ta的关注

0

Ta的粉丝

1

Ta的访客

4