Try to install this module on the site.
Everything seems ok: new schema in DB, new module in modules list.
But I don't see additional ni_cron features on the import tasks list form, no "Forced import in cron" and "Delete old nodes".

This module was installed like others: I copied files to /sites/all/modules/ and checked it in Modules list.
Any ideas, what's wrong?

Thanks.

CommentFileSizeAuthor
#11 ni_cron_quickpatch.patch831 byteslupus78

Comments

dealancer’s picture

You did everything right. Have you tried to clear cache? Have you tried to install 1.4 release of this module (http://drupal.org/node/642788/release)? Was it working well?

dealancer’s picture

What release of "Node Import" module are you using?

orkaan’s picture

Have the same with ni_cron 1.5 and node_import 1.x-dev on Drupal 6.17.

(There are ni_cron's lines in dblog, but nothing happens.)

an_louc’s picture

to dealancer

I've installed ni_cron 6.x-1.5
Also I've tried 1.4, 1.3, 1.2 and 1.0 - no difference, all of them do not work properly.
I use node_import 6.x-1.x-dev.

Thnx for help!

orkaan’s picture

Priority: Normal » Critical

The module doesn't work at all. So setting a priority.

dealancer, we need help and get it worked. ;) Thank you.

dealancer’s picture

Sorry for delay. 86 people are using module and most of them are using latest version. But there can be a problem with prefixes for db tables.

Do you use prefixes for Drupal tables?

orkaan’s picture

Yes, I use prefixes (PostgreSQL).

an_louc’s picture

I don't use prefixes :)

dealancer’s picture

an_louc, do you use PostgreSQL or MySQL?

an_louc’s picture

dealancer, I use MySQL.

lupus78’s picture

StatusFileSize
new831 bytes

Hi,

Are you using node_import-6.x-dev? I've tried it, and that seam to cause the problem.
In node import, they changed the name of the form for the import task list, and that's why you don't see the cron settings.
I advice you to use node_import 1.0 rc4.

We will release a patch for this, but have to check it more deeply, if anything else has changed in node_import.

I've attached a quick patch, if you wanna play with node import dev version. Not recommended!

petu’s picture

Thank you for the patch!

I use node_import-6.x-dev. After patching the option "Forced import in cron" appeared but the state of this option can't be saved by pressing Save-button.

an_louc’s picture

lupus78,

thank you for the patch, I will try it though it's not recommended :)
I can't use other versions of node_import except 6.x-dev (first tried not -dev version, didn't fit) because only this one meets my needs.

orkaan’s picture

Confirm, petu. Options do not save.

an_louc’s picture

Yes, there is no records in ni_cron table.

lupus78’s picture

ok, i'm a bit busy, but i will try to fix it soon.

szy’s picture

Status: Fixed » Active

Thank you for your module. Will you repair 'Forced import in cron'
option, please? :]

Szy.

dealancer’s picture

Status: Active » Fixed

This bug was fixed in new dev release (http://drupal.org/node/857604).

The were several problems and reason of that was because of changes in code in dev release of Node Import module.

orkaan’s picture

Seems there was job done, but...

warning: pg_query(): Query failed: ERROR: syntax error at or near "SET" LINE 1: INSERT INTO dp_ni_cron SET taskid=18, cronruntype=2, deleteo... ^ in /var/www/dp/includes/database.pgsql.inc on line 139.
user warning: query: INSERT INTO dp_ni_cron SET taskid=18, cronruntype=2, deleteold=0 ON duplicate KEY UPDATE cronruntype=2, deleteold=0 in /home/pask/web/drupal/all/modules/ni_cron/ni_cron.module on line 284.

I use PostgreSQL 8.4.4.

Changed the code to be all DB convenient:

// UPDATE a task...
db_query("UPDATE {ni_cron} SET cronruntype=%d, deleteold=%d", $cronruntype, $deleteold);
// ...or INSERT if don't exists
if (db_affected_rows() == 0) db_query("INSERT INTO {ni_cron} (taskid, cronruntype, deleteold) VALUES (%d, %d, %d)", $child, $cronruntype, $deleteold);

It works for me now. Will be seeking for import results. ;-)

szy’s picture

Status: Active » Fixed

I can't make it working. This is what I do:

1. quite normal import job, all is imported correctly, file.csv gets
uploaded on the server,

2. set 'only new data' in 'Forced import in cron' option.

3. cron job to import file.csv from Yahoo Pipes every hour, imported
on the server correctly, also chmodded 777.

All what happens is log activity:

"ni_cron 21 lp. 2010 - 10:00 Taskid: 14, Appended data run type, prepared for new import
ni_cron 21 lp. 2010 - 10:00 NI CRON START"

Nothing gets imported... :/

Szy.

dealancer’s picture

Strange, it was working on my machine.

szy, do you use MySQL or PostreSQL?

Do you use dev version of node_import and dev version of ni_cron published on 19 July?

an_louc’s picture

dealancer, thnx a lot for new release, it's working!

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

dealancer’s picture

Status: Closed (fixed) » Active
dealancer’s picture

Status: Active » Fixed

Fixed in the last nightly dev release (2010-Sep-29).

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.