Hi Bernard,
Can you please double check to see if the "Packages" table is fully populated?
At some reasons, the "Packages" table was not fully populated and the
"Group_Packages" tried to use the primary key of the "Packages" table whose
records do not exist, I believe.
If this is the case, I think you have to do "start_over" and you can start from
the new database installation. I hope that this may resolve your problem but I
am not completely sure until I reproduce this problem by myself. If you still
get the same problem after start_over, can you please post the full
oscarinstall.log?
Regards,
- DongInn
Bernard Li wrote:
> Got the following error message when trying to install crispy 5.1
> branch on Fedora 8 x86:
>
> Initializing package set <Default>
> DBD::mysql::db do failed: Cannot add or update a child row: a foreign
> key constraint fails (`oscar/Group_Packages`, CONSTRAINT
> `Group_Packages_ibfk_1` FOREIGN KEY (`package`) REFERENCES `Packages`
> (`package`) ON DELETE CASCADE) at /opt/oscar/lib/OSCAR/oda.pm line
> 733.
> DB_DEBUG>./wizard_prep:
> ====> in Database::do_update SQL : INSERT INTO Group_Packages
> (group_name, package, selected) VALUES ('Default', 'apitest', '1')
> Error message: Failed to update Group_Packages table in database
> <oscar>: Cannot add or update a child row: a foreign key constraint
> fails (`oscar/Group_Packages`, CONSTRAINT `Group_Packages_ibfk_1`
> FOREIGN KEY (`package`) REFERENCES `Packages` (`package`) ON DELETE
> CASCADE) at /opt/oscar/lib/OSCAR/oda.pm line 739.
> ./wizard_prep: SQL command that failed was: <INSERT INTO
> Group_Packages (group_name, package, selected) VALUES ('Default',
> 'apitest', '1')> at /opt/oscar/lib/OSCAR/oda.pm line 739.
> DB_DEBUG>./wizard_prep:
> ====>Failed to insert values via << INSERT INTO Group_Packages
> (group_name, package, selected) VALUES ('Default', 'apitest', '1') >>
> at /opt/oscar/lib/OSCAR/Database.pm line 1681.
> Oscar Wizard preparation script failed to complete at
> ./install_cluster line 279.
>
> Any ideas?
>
> Cheers,
>
> Bernard
>
> -------------------------------------------------------------------------
> SF.Net email is sponsored by: The Future of Linux Business White Paper
> from Novell. From the desktop to the data center, Linux is going
> mainstream. Let it simplify your IT future.
> http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
> _______________________________________________
> Oscar-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/oscar-devel
-------------------------------------------------------------------------
SF.Net email is sponsored by: The Future of Linux Business White Paper
from Novell. From the desktop to the data center, Linux is going
mainstream. Let it simplify your IT future.
http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
_______________________________________________
Oscar-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/oscar-devel
