Ticket #801 (closed defect: fixed)

Opened 2 years ago

Last modified 2 years ago

Bug: mysql issue with seagull application, pull the ';''s from the schema files

Reported by: anonymous Assigned to: somebody
Priority: high Milestone: 0.6.0
Component: SGL - Install Severity: major
Keywords: semicolon Cc: agp@andrew.palmer.name


Hi, below is a bug for mysql issue with seagull application. Pull the ';s from the schema files. From seagull-0.6.0RC1.tar.gz.

Thanks, -Andrew Palmer, agp@andrew.palmer.name

~ Begin forwarded message:

From: "Apollo Hosting" <gateway-reply@helpdesk.apollohosting.com> Date: March 22, 2006 12:40:12 PM CST To: agpalmer@cs.wisc.edu Subject: Apollo Hosting [820330--e878b09]


Dear agpalmer@cs.wisc.edu,

This is a message to advise you that we have recently worked on your ticket.

Ticket ID : 820330

Your question was the following: mysql issue with seagull application

Our Technicians response to your ticket is as follows


This is a bug in seagull. I corrected the bug. You may want to notify them of the error along with your server setup.

In lib/SGL/Sql.php line 111:

if (($confdb?type? == 'oci8_SGL') ($confdb?type? == 'odbc')){

$sql = preg_replace("/;\s*$/", , $sql);


Changed to

// if (($confdb?type? == 'oci8_SGL') ($confdb?type? == 'odbc')){

$sql = preg_replace("/;\s*$/", , $sql);

// }

To always pull the ';s from teh schema files before running the query.

Please re-run the installation.

Let me know if you need anything else.


Tier 2 Technical Support Apollo Hosting Inc. http://www.apollohosting.com

If you choose to reply by email, please be sure not to add any unwanted text above the line indicated and leave the email subject unedited.

Apollo Hosting Help Desk Services


ticket-801.patch.diff (0.9 kB) - added by mattdeir on 04/15/06 11:06:01.
please test and give feedback. tested on 3.23.59-nightly-20050301-log

Change History

04/15/06 11:06:01 changed by mattdeir

  • attachment ticket-801.patch.diff added.

please test and give feedback. tested on 3.23.59-nightly-20050301-log

04/15/06 15:23:57 changed by demian

  • status changed from new to closed.
  • resolution set to fixed.

(In [1867]) made sql parsing mysql 3.23 compatible, fixes #801