#290 [Clyde] Galaxia - update process

[Marc Archuleta]

When updating the name of a process, the update works,
but the resulting page is as follows:

Notice: Undefined variable: pId in
c:\Inetpub\wwwroot\clyde\galaxia\src\ProcessManager\ProcessManager.php
on line 540

Click here to log a bug, if this appears to be an error
with the application.

Go here to begin the installation process, if you
haven't done so already.

[ - Clyde v3-BETA - ] [ Thu Mar 24 15:06:53 2005 ]
#### USER AGENT: Mozilla/5.0 (Windows; U; Windows NT
5.1; en-US; rv:1.7.5) Gecko/20041107 Firefox/1.0
#### ACCT: ID: 2 - Login: admin - e-mail:
archuleta37@gmail.com
#### URL:
http://localhost/clyde/galaxia/admin/g_admin_processes.php/
#### REFERRER:
http://localhost/clyde/galaxia/admin/g_admin_processes.php?find=&where=&offset=0&sort_mode=last_modified_desc&fTicket=21598bf180f70428009c&pid=1
#### HOST: localhost
#### IP: 127.0.0.1
#### SQL: select * from `galaxia_activities` where
`p_id`=
#### ADODB: Errno: 1064 Message: 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 '' at line 1

}}}}}}}}} -> tiki_error_string(Array[7])
}}}}}}}}} LINE: 33,
c:\Inetpub\wwwroot\clyde\kernel\tiki_error_inc.php
}}}}}}}} -> tiki_error_handler(mysql, EXECUTE,
1064, You have an error in your SQL syntax; check the
manual that corr..., select * from `galaxia_activities`
where `p_id`=, false, Object:ADODB_mysql)
}}}}}}}} LINE: 859,
c:\Inetpub\wwwroot\clyde\util\adodb\adodb.inc.php
}}}}}}} -> ADODB_mysql::_Execute(select * from
`galaxia_activities` where `p_id`=, false)
}}}}}}} LINE: 833,
c:\Inetpub\wwwroot\clyde\util\adodb\adodb.inc.php
}}}}}} ->
ADODB_mysql::ADODB_mysql::Execute(select * from
`galaxia_activities` where `p_id`=, null)
}}}}}} LINE: 351,
c:\Inetpub\wwwroot\clyde\kernel\TikiDB.php
}}}}} ->
ADODB_mysql::ADODB_mysql::TikiDB::query(select * from
`galaxia_activities` where `p_id`=, null, -1, -1, -1)
}}}}} LINE: 181,
c:\Inetpub\wwwroot\clyde\kernel\TikiBase.php
}}}} ->
ADODB_mysql::ADODB_mysql::TikiDB::ActivityManager::query(select
* from `galaxia_activities` where `p_id`=)
}}}} LINE: 159,
c:\Inetpub\wwwroot\clyde\galaxia\src\ProcessManager\ActivityManager.php
}}} ->
ADODB_mysql::ADODB_mysql::TikiDB::ActivityManager::ActivityManager::get_process_activities(null)
}}} LINE: 722,
c:\Inetpub\wwwroot\clyde\galaxia\src\ProcessManager\ActivityManager.php
}} ->
ADODB_mysql::ADODB_mysql::TikiDB::ActivityManager::ActivityManager::ActivityManager::compile_process_activities(null)
}} LINE: 540,
c:\Inetpub\wwwroot\clyde\galaxia\src\ProcessManager\ProcessManager.php
} ->
ADODB_mysql::ADODB_mysql::TikiDB::ActivityManager::ActivityManager::ActivityManager::ProcessManager::replace_process(1,
Array[4])
} LINE: 108,
c:\Inetpub\wwwroot\clyde\galaxia\admin\g_admin_processes.php

[Christian Fowler]

Logged In: YES
user_id=947814

I made a blind fix to this by using $p_id instead of $pId:

$am->compile_process_activities($p_id);

please test and let me know if that works

[Marc Archuleta]

Logged In: YES
user_id=1232036

the $p_id worked, but leads to the next issue where there is
an undefined activityId that should not be necessary:

Notice: Undefined index: activityId in
c:\Inetpub\wwwroot\clyde\galaxia\src\ProcessManager\ActivityManager.php
on line 724

Click here to log a bug, if this appears to be an error with
the application.

Go here to begin the installation process, if you haven't
done so already.

[ - Clyde v3-BETA - ] [ Sun Apr 03 16:32:12 2005 ]
#### USER AGENT: Mozilla/5.0 (Windows; U; Windows NT 5.1;
en-US; rv:1.7.6) Gecko/20050317 Firefox/1.0.2
#### ACCT: ID: 2 - Login: admin - e-mail:
archuleta37@gmail.com
#### URL:
http://localhost/clyde/galaxia/admin/g_admin_processes.php/
#### REFERRER:
http://localhost/clyde/galaxia/admin/g_admin_processes.php?find=&where=&offset=0&sort_mode=last_modified_desc&fTicket=8412f42034af852f237e&pid=1
#### HOST: localhost
#### IP: 127.0.0.1
#### SQL: select * from `galaxia_activities` where
`p_id`=1 and `activity_id`=
#### ADODB: Errno: 1064 Message: 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 '' at
line 1

}}}}}}}}}} -> tiki_error_string(Array[7])
}}}}}}}}}} LINE: 33,
c:\Inetpub\wwwroot\clyde\kernel\tiki_error_inc.php
}}}}}}}}} -> tiki_error_handler(mysql, EXECUTE, 1064,
You have an error in your SQL syntax; check the manual that
corr..., select * from `galaxia_activities` where `p_id`=1
and `activity_..., false, Object:ADODB_mysql)
}}}}}}}}} LINE: 859,
c:\Inetpub\wwwroot\clyde\util\adodb\adodb.inc.php
}}}}}}}} -> ADODB_mysql::_Execute(select * from
`galaxia_activities` where `p_id`=1 and `activity_..., false)
}}}}}}}} LINE: 833,
c:\Inetpub\wwwroot\clyde\util\adodb\adodb.inc.php
}}}}}}} -> ADODB_mysql::ADODB_mysql::Execute(select *
from `galaxia_activities` where `p_id`=1 and `activity_...,
null)
}}}}}}} LINE: 348,
c:\Inetpub\wwwroot\clyde\kernel\TikiDB.php
}}}}}} ->
ADODB_mysql::ADODB_mysql::TikiDB::query(select * from
`galaxia_activities` where `p_id`=1 and `activity_..., null,
-1, -1, -1)
}}}}}} LINE: 181,
c:\Inetpub\wwwroot\clyde\kernel\TikiBase.php
}}}}} ->
ADODB_mysql::ADODB_mysql::TikiDB::ActivityManager::query(select
* from `galaxia_activities` where `p_id`=1 and `activity_...)
}}}}} LINE: 418,
c:\Inetpub\wwwroot\clyde\galaxia\src\ProcessManager\ActivityManager.php
}}}} ->
ADODB_mysql::ADODB_mysql::TikiDB::ActivityManager::ActivityManager::get_activity(1,
null)
}}}} LINE: 635,
c:\Inetpub\wwwroot\clyde\galaxia\src\ProcessManager\ActivityManager.php
}}} ->
ADODB_mysql::ADODB_mysql::TikiDB::ActivityManager::ActivityManager::ActivityManager::compile_activity(1,
null)
}}} LINE: 724,
c:\Inetpub\wwwroot\clyde\galaxia\src\ProcessManager\ActivityManager.php
}} ->
ADODB_mysql::ADODB_mysql::TikiDB::ActivityManager::ActivityManager::ActivityManager::ActivityManager::compile_process_activities(1)
}} LINE: 540,
c:\Inetpub\wwwroot\clyde\galaxia\src\ProcessManager\ProcessManager.php
} ->
ADODB_mysql::ADODB_mysql::TikiDB::ActivityManager::ActivityManager::ActivityManager::ActivityManager::ProcessManager::replace_process(1,
Array[4])
} LINE: 108,
c:\Inetpub\wwwroot\clyde\galaxia\admin\g_admin_processes.php