bsl0001 Posted July 29, 2014 Report Share Posted July 29, 2014 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... Quote Link to comment Share on other sites More sharing options...
flyalaska Posted July 29, 2014 Report Share Posted July 29, 2014 The _schedules tables already exist. Quote Link to comment Share on other sites More sharing options...
bsl0001 Posted July 29, 2014 Author Report Share Posted July 29, 2014 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. Quote Link to comment Share on other sites More sharing options...
flyalaska Posted July 30, 2014 Report Share Posted July 30, 2014 Is this a new install? Quote Link to comment Share on other sites More sharing options...
bsl0001 Posted July 30, 2014 Author Report Share Posted July 30, 2014 nop, I already changed some things on my site. I dont know where I have to search to find the fault to fix it Quote Link to comment Share on other sites More sharing options...
bsl0001 Posted July 31, 2014 Author Report Share Posted July 31, 2014 Somebody can help me?.. i dont know what i have to do.. Quote Link to comment Share on other sites More sharing options...
bsl0001 Posted July 31, 2014 Author Report Share Posted July 31, 2014 Well.. if anybody can help me... im going to Re-install all.... thanks for all! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.