Edit Schedules Error

[carlosuc99]

Hi,

When I edit a schedule I have this error:

There was an error editing the schedule: Unknown column 'week1' in 'field list'

Please, I need help. I installed the Mod RealScheduleLite.

[Parkho]

Did you enter "week1" into any fields? If yes, that might be the problem.

[carlosuc99]

Did you enter "week1" into any fields? If yes, that might be the problem.

No, I didn´t enter week1 into any fields.

[mark1million]

When you updated did you run the install/update.php

Also your templates will have changed to include weeks 1 2 3 and 4.

[carlosuc99]

When you updated did you run the install/update.php

Also your templates will have changed to include weeks 1 2 3 and 4.

Yes, I run the install/update.php?force and when finished the update it says:

phpVMS Updater

Starting the update...

Update completed!

If there were any errors, you may have to manually run the SQL update, or correct the errors, and click the following to re-run the update:

Click here to force the update to run again

Click here to goto your site, or your admin panel

But the problem don´t fix.

[mark1million]

Ok so in your database do you have the columns there for weeks?

Also in your admin schedules template do you have it there and finally in the operations data class file is it in the array there. (Just going from memory may be wrong filename)

[carlosuc99]

Ok so in your database do you have the columns there for weeks?

Also in your admin schedules template do you have it there and finally in the operations data class file is it in the array there. (Just going from memory may be wrong filename)

I haven´t got any column in my db for weeks

[mark1million]

This should be your table structure,

CREATE TABLE IF NOT EXISTS `phpvms_schedules` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `code` char(3) NOT NULL DEFAULT '',
 `flightnum` varchar(10) NOT NULL DEFAULT '0',
 `depicao` varchar(4) NOT NULL DEFAULT '',
 `arricao` varchar(4) NOT NULL DEFAULT '',
 `route` text NOT NULL,
 `route_details` text NOT NULL,
 `aircraft` text NOT NULL,
 `flightlevel` varchar(6) NOT NULL,
 `distance` float NOT NULL DEFAULT '0',
 `deptime` varchar(15) NOT NULL DEFAULT '',
 `arrtime` varchar(15) NOT NULL DEFAULT '',
 `flighttime` varchar(8) NOT NULL,
 `daysofweek` varchar(7) NOT NULL DEFAULT '0123456',
 `week1` varchar(7) NOT NULL DEFAULT '0123456',
 `week2` varchar(7) NOT NULL DEFAULT '0123456',
 `week3` varchar(7) NOT NULL DEFAULT '0123456',
 `week4` varchar(7) NOT NULL DEFAULT '0123456',
 `price` float NOT NULL,
 `payforflight` float NOT NULL DEFAULT '0',
 `flighttype` varchar(1) NOT NULL DEFAULT 'P',
 `timesflown` int(11) NOT NULL DEFAULT '0',
 `notes` text NOT NULL,
 `enabled` int(11) NOT NULL DEFAULT '1',
 `bidid` int(11) NOT NULL DEFAULT '0',
 PRIMARY KEY (`id`),
 KEY `depicao` (`depicao`),
 KEY `flightnum` (`flightnum`),
 KEY `depicao_arricao` (`depicao`,`arricao`),
 KEY `code` (`code`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2684 ;

Just watch that auto increment at the end there, that will be different for you.

[carlosuc99]

This should be your table structure,

CREATE TABLE IF NOT EXISTS `phpvms_schedules` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` char(3) NOT NULL DEFAULT '',
`flightnum` varchar(10) NOT NULL DEFAULT '0',
`depicao` varchar(4) NOT NULL DEFAULT '',
`arricao` varchar(4) NOT NULL DEFAULT '',
`route` text NOT NULL,
`route_details` text NOT NULL,
`aircraft` text NOT NULL,
`flightlevel` varchar(6) NOT NULL,
`distance` float NOT NULL DEFAULT '0',
`deptime` varchar(15) NOT NULL DEFAULT '',
`arrtime` varchar(15) NOT NULL DEFAULT '',
`flighttime` varchar(8) NOT NULL,
`daysofweek` varchar(7) NOT NULL DEFAULT '0123456',
`week1` varchar(7) NOT NULL DEFAULT '0123456',
`week2` varchar(7) NOT NULL DEFAULT '0123456',
`week3` varchar(7) NOT NULL DEFAULT '0123456',
`week4` varchar(7) NOT NULL DEFAULT '0123456',
`price` float NOT NULL,
`payforflight` float NOT NULL DEFAULT '0',
`flighttype` varchar(1) NOT NULL DEFAULT 'P',
`timesflown` int(11) NOT NULL DEFAULT '0',
`notes` text NOT NULL,
`enabled` int(11) NOT NULL DEFAULT '1',
`bidid` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `depicao` (`depicao`),
KEY `flightnum` (`flightnum`),
KEY `depicao_arricao` (`depicao`,`arricao`),
KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2684 ;

Just watch that auto increment at the end there, that will be different for you.

Ok, thanks it fix it