Jump to content

Recommended Posts

Posted

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

Posted

yes but... i still have no flights scheduled. i don't understand PHP, somebody can help me? I'm trying to add my VA flights, but can not. this error is appearing. I can not fix it.

Dibujo_zpsd7175f71.png

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