I dont speak english, sorry about it... i have this problem whit my data base myslq in phpvms_schedules table:
There was an error adding the schedule, already exists DB error: 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 ''1)' at line 25
here the code:
--
-- Estructura de tabla para la tabla `phpvms_schedules`
--
CREATE TABLE IF NOT EXISTS `phpvms_schedules` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` char(3) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`flightnum` varchar(10) COLLATE latin1_general_ci NOT NULL DEFAULT '0',
`depicao` varchar(4) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`arricao` varchar(4) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`route` text COLLATE latin1_general_ci NOT NULL,
`route_details` text COLLATE latin1_general_ci NOT NULL,
`aircraft` text COLLATE latin1_general_ci NOT NULL,
`flightlevel` varchar(6) COLLATE latin1_general_ci NOT NULL,
`distance` float NOT NULL DEFAULT '0',
`deptime` varchar(15) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`arrtime` varchar(15) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`flighttime` float NOT NULL DEFAULT '0',
`daysofweek` varchar(7) COLLATE latin1_general_ci NOT NULL DEFAULT '0123456',
`price` float NOT NULL,
`flighttype` varchar(3) COLLATE latin1_general_ci NOT NULL DEFAULT 'a',
`timesflown` int(11) NOT NULL DEFAULT '0',
`notes` text COLLATE latin1_general_ci 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=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=5 ;
Thanks for all. im new in this world of PHP and etc...