Forums

Likely side effects of a hack to StartingPointPackage.php

Permalink
What are the likely side effects of commenting out this line?

I have been having issues with installing on a windows XP based development system. Same issue with any 5.7.x version.

In all cases commenting out line Line 211 of StartingPointPackage enabled the install to complete and the site appears to function correctly.
$db->Execute(
            'alter table QueueMessages add FOREIGN KEY (`queue_id`) REFERENCES `Queues` (`queue_id`) ON DELETE CASCADE ON UPDATE CASCADE'


Its not a production system, just a dev system. I expect the above could have side effects, but what are they likely to be?

The only references I can find in the core are:
config\db.xml(5031): <table name="QueueMessages">

src\Foundation\Queue\DatabaseQueueAdapter.php(101): 
$count = $this->db->GetOne('select count(*) from QueueMessages where queue_id = ?', array(

src\Foundation\Queue\DatabaseQueueAdapter.php(132): 
$this->db->insert('QueueMessages', $msg);

src\Foundation\Queue\DatabaseQueueAdapter.php(165): 
$statement = $this->db->prepare('select * from QueueMessages where queue_id = ? and handle is null or timeout + ' . (int) $timeout . ' < ' . (int) $microtime . ' limit ' . $maxMessages . ' for update');

src\Foundation\Queue\DatabaseQueueAdapter.php(174): 
$count = $this->db->executeUpdate('update QueueMessages set handle = ?, timeout = ? where message_id = ? and (handle is null or timeout + ' . (int)$timeout . ' < ' . (int) $microtime . ')',

src\Foundation\Queue\DatabaseQueueAdapter.php(202): 
if ($this->db->delete('QueueMessages', array('handle' => $message->handle))) {

src\Package\StartingPointPackage.php(212): 
'alter table QueueMessages add FOREIGN KEY (`queue_id`) REFERENCES `Queues` (`queue_id`) ON DELETE CASCADE ON UPDATE CASCADE'
JohntheFish