Can someone please help with this
Database error in minglesingle.net
Query:
INSERT INTO `SDatingEvents` SET
`Title` = 'friday test 1',
`Description` = 'sssssssssssss',
`Status` = 'Active',
`StatusMessage` = 'ssssssssssss',
`Country` = 'US',
`City` = 'ssssssss',
`Place` = 'ssssssssssss',
`PhotoFilename` = '',
`EventStart` = FROM_UNIXTIME( 1213498500 ),
`EventEnd` = FROM_UNIXTIME( 1213584900 ),
`TicketSaleStart` = FROM_UNIXTIME( 1213325729 ),
`TicketSaleEnd` = FROM_UNIXTIME( 1213412131 ),
`ResponsibleName` = 'ssssssss',
`ResponsibleEmail` = 'ssssss',
`ResponsiblePhone` = 'sss',
`EventSexFilter` = 'female,male',
`EventAgeLowerFilter` = 21,
`EventAgeUpperFilter` = 75,
`EventMembershipFilter` = '\'all\'',
`TicketCountFemale` = 15,
`TicketCountMale` = 15,
`TicketPriceFemale` = 0.00,
`TicketPriceMale` = 0.00,
`ChoosePeriod` = 1,
`AllowViewParticipants` = 1
Mysql error:
Duplicate entry '' for key 2
Found error in file /home/admin/public_html/admin/sdating_admin.php
at line 195. Called db_res function
with erroneous argument #0
Debug backtrace:
Array
(
[1] => Array
(
[file] => /home/admin/public_html/admin/sdating_admin.php
[line] => 195
[function] => db_res
[args] => Array
(
[0] => INSERT INTO `SDatingEvents` SET
`Title` = 'friday test 1',
`Description` = 'sssssssssssss',
`Status` = 'Active',
`StatusMessage` = 'ssssssssssss',
`Country` = 'US',
`City` = 'ssssssss',
`Place` = 'ssssssssssss',
`PhotoFilename` = '',
`EventStart` = FROM_UNIXTIME( 1213498500 ),
`EventEnd` = FROM_UNIXTIME( 1213584900 ),
`TicketSaleStart` = FROM_UNIXTIME( 1213325729 ),
`TicketSaleEnd` = FROM_UNIXTIME( 1213412131 ),
`ResponsibleName` = 'ssssssss',
`ResponsibleEmail` = 'ssssss',
`ResponsiblePhone` = 'sss',
`EventSexFilter` = 'female,male',
`EventAgeLowerFilter` = 21,
`EventAgeUpperFilter` = 75,
`EventMembershipFilter` = '\'all\'',
`TicketCountFemale` = 15,
`TicketCountMale` = 15,
`TicketPriceFemale` = 0.00,
`TicketPriceMale` = 0.00,
`ChoosePeriod` = 1,
`AllowViewParticipants` = 1
)
)
[2] => Array
(
[file] => /home/admin/public_html/admin/sdating_admin.php
[line] => 1210
[function] => sdaddevent
[args] => Array
(
)
)
)
Called script: /admin/sdating_admin.php
Request parameters:
Array
(
[event_title] => friday test 1
[event_desc] => sssssssssssss
[event_status] => active
[event_statusmsg] => ssssssssssss
[event_country] => US
[event_city] => ssssssss
[event_place] => ssssssssssss
[event_photo_width] => 200
[event_photo_height] => 150
[event_start] => 2008-06-14 21:55:00
[event_end] => 2008-06-15 21:55:00
[event_sale_start] => 2008-06-12 21:55:29
[event_sale_end] => 2008-06-13 21:55:31
[event_resp_name] => ssssssss
[event_resp_email] => ssssss
[event_resp_phone] => sss
[event_sex_female] => on
[event_sex_male] => on
[event_age_start] => 21
[event_age_end] => 75
[event_membership] => Array
(
[0] => all
)
[event_count_female] => 15
[event_count_male] => 15
[event_price_free] => on
[event_choose_period] => 1
[event_allow_view] => on
[event_save] => Save
[action] => new
[ZP_CAL] => \'fdow\':null,\'history\':\"2008/06/13/21/55,2008/06/12/21/55,2008/06/15/21/55,2008/06/14/21/55,2008/06/04/02/00,2008/06/03/20/00\",\'sortOrder\':\"asc\",\'hsize\':9
)
--
