Airline Mogul Forum

Airline Mogul => Bugs => Topic started by: Hal on October 18, 2009, 11:06:31 am

Title: Mass removing from market bug
Post by: Hal on October 18, 2009, 11:06:31 am

I wanted to remove all planes from market and change the price. But i got this 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 ') AS `engines`, `aircraft_name`, `status` FROM `zworld799_aircraft` AS `a` ' at line 2
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/airlinemogul.com/httpdocs/airlinemogul/aircraft_market.php on line 511

ID 15523, W799.

Title: Re: Mass removing from market bug
Post by: StephenM on October 18, 2009, 12:45:20 pm

Should be fixed now. Please let me know either way.

Title: Re: Mass removing from market bug
Post by: Hal on October 18, 2009, 01:06:18 pm

Its now ok. Thanks

Title: Re: [Fixed] Mass removing from market bug
Post by: Hal on October 21, 2009, 06:20:35 am

I got today same error.

Title: Re: [Fixed] Mass removing from market bug
Post by: StephenM on October 21, 2009, 07:10:06 am

Quote from: Hal on October 21, 2009, 06:20:35 am

I got today same error.

I don't know how that got around our version control software, but the changes disappeared. I'll be able to look in about 10 hours, have to go to a Conference today.

Title: Re: Mass removing from market bug
Post by: Air Elbonia on October 21, 2009, 11:57:26 am

Sorry about that. Fixed again.

been doing some housecleaning to try to clean up some old stuff in a few files and hopefully a few small performance tweaks (nothing amazing, but with luck every little bit helps), unfortunately I reverted that page in the process. :-[ sorry about that.

Title: Re: Mass removing from market bug
Post by: Hal on October 21, 2009, 03:26:41 pm

Sorry but it is not fixed.

Title: Re: Mass removing from market bug
Post by: StephenM on October 21, 2009, 05:01:41 pm

Quote from: Hal on October 21, 2009, 03:26:41 pm

Sorry but it is not fixed.

I will look at it when I get home.

Title: Re: Mass removing from market bug
Post by: StephenM on October 21, 2009, 10:10:48 pm

Hows that?

Title: Re: Mass removing from market bug
Post by: Hal on October 22, 2009, 07:06:12 am

Not working got this error.
Column 'type_id' in field list is ambiguous
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/airlinemogul.com/httpdocs/airlinemogul/aircraft_market.php on line 511

Title: Re: Mass removing from market bug
Post by: Air Elbonia on October 22, 2009, 11:47:00 pm

that specific issue should be fixed... -crosses fingers-