Error in Project>Tasks

[piemme]

After copying the latest update, today, I get the following error, when I select
Projects > Tasks or Tasks inactive

/srv/www/htdocs/dotproject/includes/db_adodb.php(92): Invalid object passed to db_num_rows

Thank you

[Eterno]

Same problem...

http://www.dotproject.net/index.php?name=PNphpBB2&file=viewtopic&t=1031&start=15

[piemme]

Same problem...

http://www.dotproject.net/index.php?name=PNphpBB2&file=viewtopic&t=1031&start=15More details:
Server Suse Linux
Browser Mozilla 1.8, in W2K
DB Mysql

Before copying the complete Latest CVS Snapshot (sorry, I had not realized I had to follow this way), I had copied some updated files, insome directories, and run the upgrade mysql scripts. And dotproject failed to work any more.
After copying Latest... dotproject seems to work fine again, but that problem.
Thank you

[bebory]

db_adodb.php(92): Invalid object passed to db_num_rows

Fatal error: Call to a member function on a non-object in nightlycvs/dotproject/includes/db_adodb.php on line 93


I have applied the latest 3 nighty cvs to a copy of my db reinstalled help desk which is working but can't get the tasks to work. A clean install with absolutely a new db works, but need to get this to work with my db I have applied the nightly latest_sql but absolutely no luck

[cyberhorse]

I don't get this problem so I can't really investigate. Please enable debugging and try to see on which query this error appears.

[bebory]

I enabled debugging where do the errors go? The only thing on the screen is
nightlycvs/dotproject/includes/db_adodb.php(92): Invalid object passed to db_num_rows

Fatal error: Call to a member function on a non-object in nightlycvs/dotproject/includes/db_adodb.php on line 93

[piemme]

db_adodb.php(92): Invalid object passed to db_num_rows

Fatal error: Call to a member function on a non-object in nightlycvs/dotproject/includes/db_adodb.php on line 93


I have applied the latest 3 nighty cvs to a copy of my db reinstalled help desk which is working but can't get the tasks to work. A clean install with absolutely a new db works, but need to get this to work with my db I have applied the nightly latest_sql but absolutely no luck

Same for me:
1) debug was already enable, and I have only that message
2) tried to create a new empty db, and Task feature works fine.
But with this new db I am no more able to ADD USERs.
Other features seem to work fine.

[bebory]

Ok found my problem. Had 1.02 installed and was upgrading to latest cvs on that.

Finally it dawned on me that I might need 1.02-1 so, downloaded it and upgraded my 1.02 just by copying over the files then downloading the latest cvs and upgrading to that and tasks are NOW working.

B

[piemme]

Ok found my problem. Had 1.02 installed and was upgrading to latest cvs on that.

Finally it dawned on me that I might need 1.02-1 so, downloaded it and upgraded my 1.02 just by copying over the files then downloading the latest cvs and upgrading to that and tasks are NOW working.

B

Unfortunately this does not solve in my case. Could you help me more?

I also tried to restart from reinstalling 1.0.2.

For example: when choosing Task from the menu I get
my todo : all tasks : show inactive tasks : tasks per user
/srv/www/htdocs/dotproject/includes/db_adodb.php(92): Invalid object passed to db_num_rows
Fatal error: Call to a member function on a non-object in /srv/www/htdocs/dotproject/includes/db_adodb.php on line 93

MyToDo and TAsks form all users seems to work fine.
But same error for All tasks and MyPinedTasks

Starting from
1.0.2 + latest cvs + mysql latest_upgrade.sql
I downloaded and copied 1.0.2-1 , no changes to db, and then downloaded latest cvs and copied.
Tried to run, but same error. Also after trying again mysql latest_upgrade.sql
This last mysql command gives errors like
1091 can't drop project_actual_end_date
1050 table user_access_log already exists
1062 duplicate entry 10, ... 14 for key 11
1060 duplicate column name task_log_problem, task_log_reference, task_log_related_url
1050 table user_task_pin already exists

Thank you

[bebory]

I had some of the same errors that you are experiencing so what I did was open update_latest.sql and ran the items one by one manually in php admin. This dropped the project_actual_end_date
noticed that I had the user_access_log already so just checked to see if any changes, had to update the sysvals manually because I too had duplicates, you need to increase to the next number in sequence. For instance if you already have 10, then make the next entries 11, 12 etc. Pain in the butt - I know!

After running each item manually - about a 1/2 hour process things are working fine so far.

If anyone has a better idea, I'd sure like to hear it.

sysvals is another issue on the board that is a known issue. There has been discussion but I haven't followed it in the last couple of days;

Good luck :o

[caseydk]

If you run the release version off of the same database with the cvs version, the dropping of project_actual_end_date is one of the major things that will cause problems...

[piemme]

I had some of the same errors that you are experiencing so what I did was open update_latest.sql and ran the items one by one manually in php admin. This dropped the project_actual_end_date
noticed that I had the user_access_log already so just checked to see if any changes, had to update the sysvals manually because I too had duplicates, you need to increase to the next number in sequence. For instance if you already have 10, then make the next entries 11, 12 etc. Pain in the butt - I know!

After running each item manually - about a 1/2 hour process things are working fine so far.

If anyone has a better idea, I'd sure like to hear it.

sysvals is another issue on the board that is a known issue. There has been discussion but I haven't followed it in the last couple of days;

Good luck :o

Thank you.
Following your suggestion I have manually verified the tables, via mysql.
What I have found was that in sysvals there where a lot of duplicated keys: taskType, taskStatus, etc.
And I cleaned the table, keeping only the first 14 items, up to TaskLogReferenceImage.
The other tables referenced in update_latest.sql seem to be fine.

When running dotProject, still I have that error.
And if I check sysvals table, I see that again a lot of items have been replicated.
In conclusion: it seems to me that dp adds items to sysvals table.

Waiting for more help!
Thank you.

[cyberhorse]

It does. Well, it does only if you have sql errors, but then it runs the upgrade_latest.sql file automatically and inserts new copies of the sysvals ... this will be changes to sysvals using static IDs probably, so insertions will fail or whatever ... still trying to figure out the best way to deal with this.

[piemme]

It does. Well, it does only if you have sql errors, but then it runs the upgrade_latest.sql file automatically and inserts new copies of the sysvals ... this will be changes to sysvals using static IDs probably, so insertions will fail or whatever ... still trying to figure out the best way to deal with this.
Sorry, but I cannot understand what I should do.
Could you be more precise... for a novice as I am?
or...
Can I expect this will be solved in a future version, in a short time?
Thank you.

[cyberhorse]

the latter

[Rgerla]

I had a simulare error in the todo section ( at least the same error message) I solved it there by replace the following lines
Bugfix is todo.php:

at line 166 and 167 the lines

$start = intval( @$task["task_start_date"] ) ? new CDate( $task["task_start_date"] ) : null;
$end = intval( @$task["task_end_date"] ) ? new CDate( $task["task_end_date"] ) : null;

with these lines

$start = intval( @$task["task_start_date"] ) ? new CDate( $task["task_start_date"] ) : new CDate();
$end = intval( @$task["task_end_date"] ) ? new CDate( $task["task_end_date"] ) : new CDate();

thus create a new cdate variable instead of a Null variable. Maybe this will help you.

[Karen]

Mantis Bug Number 0000235