duanshan188866 2013-06-10 10:43
浏览 166
已采纳

PHP activerecord异常:找不到基表或视图

I am trying out php active record, it's a great ORM, however I am at a standstill.

I have looked around google, blogs, phpactiverecord documentation as well as statckoverflow for days but have not been able to come across a suitable solution to this problem.

I am able to carry out the basic CRUD (insert,fetch, modify and delete) operations however as soon as i validate an object property using a static $validates_uniqueness_of filter, i get

Fatal error: Uncaught exception 'ActiveRecord\DatabaseException'

With message

exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'test_ar.models' doesn't exist' in C:\wamp\www\test_AR\AR\lib\Connection.php on line 325

Here is the code i used in full.

<?php
$path_to_AR = "AR/"; 
include $path_to_AR . "activerecord.php"; 
ActiveRecord\Config::initialize(function($cfg) {
        $cfg->set_model_directory('model');
        $cfg->set_connections(
                        array(
                         'development' => 'mysql://root:asdf@localhost/test_ar',
                         'test' => 'mysql://username:password@localhost/test_database_name',
                         'production' => 'mysql://username:password@localhost/production_database_name'
                        )
                );
        });   

/*
class user extends ActiveRecord\Model 
{ 

  static $validates_presence_of = array(array('username', 'message' => 'Please supply a username')); //this works just fine
  static $validates_uniqueness_of = array(array('username'));//this line causes the PDO exception   

}
*/
$user = new user(); 

user::create((array('username'=>'mike','password'=>'test','created'=>time())));
$user::create(array('username'=>'mike')); //cannot even reach this line because of the exeption

References i have tried/looked at

https://github.com/kla/php-activerecord/issues/274 (though i don't really understand what's going on there)

http://www.phpactiverecord.org/projects/main/wiki/Validations#validates_uniqueness_of

http:// blog.felho.hu/what-is-new-in-php-53-part-2-late-static-binding.html

as well as many others.

Platform and php version

I am using php 5.3.4 and using nightly build (May 8 2013) I have almost failed to get my head around this. Please advise on how to correct this.

  • 写回答

2条回答 默认 最新

  • douciping4283 2013-06-10 19:36
    关注

    This has been solved by the question author:

    After discussing it with a few developers on github. It seems this is a bug.

    The work around was to create a custom validator in the model

    public function validate() {
            if ($this->is_new_record() && static::exists(array('conditions' => array('username' => $this->username)))) {
                $this->errors->add('username', 'This username is already taken');
            }
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题