shahiem / todolist-plugin Goto Github PK

I use SQLite on one of my October installs and I realize that this plugin uses direct SQL query here which throws an error like this...

SQLite doesn't come with the information_schema table, hence this error. Perhaps the logic could be improved? I've been exploring the code a bit trying to understand it and I haven't been quite able to figure out the logic in that section. Could you take a look to see if this issue can be fixed, preferably using Laravel's Eloquent approach instead of the direct DB query, so that it's more database-neutral. Thanks for the plugin by the way!

This is a good plugin which needs some updates. Will it be updated to OctoberRC? It doesn't seem to work at the moment

Update: Thanks for update to RC

When added ToDo error: missing field progress_val in table database:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'progress_val' in 'field list' (
  SQL: insert 
  into
    `shahiemseymor_todo` (
      `title`, `description`, `progress_val`, `priority`, `deadline`, `project_id`, `user_id`, `updated_at`, `created_at`
    ) 
  values
    (Title, Description, 26, high, 2014-07-15 12:23:00, 1, 1, 2014-07-14 08:26:02, 2014-07-14 08:26:02)
  )

When installing the plugin creates field progress:

        Schema::create('shahiemseymor_todo', function($table)
        {
            $table->engine = 'InnoDB';
            $table->increments('id');
            $table->string('title');
            $table->string('priority');
            $table->text('description');
            $table->timestamp('deadline');
            $table->integer('progress');
            $table->integer('project_id');
            $table->integer('user_id');
            $table->timestamps();
        });

Further work is being done with the field progress_val.

A report widget, so you can add a task to a project via your dashboard. You can also see your tasks on a specific day

Support of multiple languages

Defeault: English

Other languages:

Dutch

Got : "Syntax error or access violation: 1067 Invalid default value for 'deadline' (SQL: create table shahiemseymor_todo (id int unsigned not null auto_increment primary key, title varchar(255) not null, priority varchar(255) not null, description text not null, deadline timestamp default 0 not null, progress_val int not null, project_id int not null, user_id int not null, created_at timestamp null, updated_at timestamp null) default character set utf8 collate utf8_unicode_ci engine = InnoDB)" on installation

When removing the plug-in, you receive the error:

SQLSTATE[42S02]: Base table 
or view not found: 1051 Unknown table  'cnm_canonium_db.shahiemseymor_todo' (
  SQL: drop table `shahiemseymor_todo`
)

In the table of the database remains:

In create_projects_table.php:

    public function down()
    {
        Schema::drop('shahiemseymor_todo');
        Schema::drop('shahiemseymor_todo_projects_assigned');
    }

Necessary:

    public function down()
    {
        Schema::drop('shahiemseymor_todo_projects');
        Schema::drop('shahiemseymor_todo_projects_assigned');
    }

Clear install.
Tried to add a project and got:

Apparently, there is a dependence on plugin RainLab.User?
Maybe should write about this in the documentation?

Without field "Assign to":

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'assign' in 'field list'  (
  SQL:insert 
into
  `shahiemseymor_todo_projects`  (
    `title`, `description`, `assign`, `user_id`,`updated_at`, `created_at`
  ) 
values
  (One, Two, , 1, 2014-07-13 21:36:41, 2014-07-13 21:36:41)
)

Backend no longer works as of System Build 349.