Jump to content

DB error, phpvms_schedules


bsl0001

Recommended Posts

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...

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...