Upgrade from 1.6.3 - 1.7.4 - duplicate entry problem

Ask community to help.

Moderators: Amaradana, TurboPT, TL Developers

Post Reply
gt1
TestLink user
Posts: 3
Joined: Tue Jan 06, 2009 5:34 pm

Upgrade from 1.6.3 - 1.7.4 - duplicate entry problem

Post by gt1 »

I've searched and am not finding the answer that the mods refer to on this forum.
I've got the step 1 complete, new db created and am on the upgrade part.
It fails with 1062; everyone knows it. A dupe exists and import fails. I've added 3 lines to the custom_config.inc.php - What am I missing? A few keywords to search on would be appreciated as I'm not seeing the real problem. I've searched the forums for several hours.
Do I have to just delete the dupes manually from the database?

## This should be the fix, but doesn't work.

* config.inc.php
* cfg\const.inc.php
*-----------------------------------------------------------------------------
*/
?>

$g_check_names_for_duplicates=TRUE;
$g_action_on_duplicate_name='allow_repeat';
$g_prefix_name_for_copy= strftime("%Y%m%d-%H:%M:%S", time());

##This is the failure

there are 500 in tpalnelems
PHP Warning: error_log(/tmp/testlink_errors.log) [function.error-log]: failed to open stream: No such file or directory in C:\Inetpub\ipdtestlink\htdocs\testlink17\third_party\adodb\adodb-errorhandler.inc.php on line 70 PHP Fatal error: mysql error: [1062: Duplicate entry '70940-42932' for key 2] in EXECUTE("INSERT INTO testplan_tcversions (testplan_id,tcversion_id) VALUES(70940,42932)") in C:\Inetpub\ipdtestlink\htdocs\testlink17\third_party\adodb\adodb-errorhandler.inc.php on line 77
gt1
TestLink user
Posts: 3
Joined: Tue Jan 06, 2009 5:34 pm

May be of importance - initially system was at 1.04

Post by gt1 »

Then upgraded to 1.6.3. build1
And now trying to get to 1.7.4
gt1
TestLink user
Posts: 3
Joined: Tue Jan 06, 2009 5:34 pm

Any ideas ?

Post by gt1 »

It seams this is an error that has not been resolved. The is a bug listing in mantis but no resolution and no resolution on this forum. One of the testlink people make reference to it being resolved but I think he's talking about the related ../logs folder missing.

Anyone? Please??
mysql 5.01, IIS, PHP5, 1.6.4 to 1.7.3, Windows 2003


using query SELECT * FROM tp_tmp_table ORDER BY projid LIMIT 1500,500

there are 500 in tpalnelems
PHP Warning: error_log(/tmp/testlink_errors.log) [function.error-log]: failed to open stream: No such file or directory in C:\Inetpub\ipdtestlink\htdocs\testlink\third_party\adodb\adodb-errorhandler.inc.php on line 70 PHP Fatal error: mysql error: [1062: Duplicate entry '70940-43329' for key 'tp_tcversion'] in EXECUTE("INSERT INTO testplan_tcversions (testplan_id,tcversion_id) VALUES(70940,43329)") in C:\Inetpub\ipdtestlink\htdocs\testlink\third_party\adodb\adodb-errorhandler.inc.php on line 77
Post Reply