|
|
|
|
|
|
[ Vadim Kotelnikov ]
Created:
1/18/11
Closing date:
2/3/11
|
      |
|
Type of improvement:
Error correction
Area of improvement:
Contests
|
|
Location:
Title |
I get this code
REPLACE contestHADSubjects
SELECT
22,
35,
'How To Reduce Lying in this World: 7 NEVERs',
'
marry\r\n !
Never ask your employees why they are late!\r\n
Never ask project managers to write project reports!\r\n
Never ask investment seekers to prepare a revenue forecast!\r\n
Never ask others how you look!\r\n ',
'Media File',
'',
'',
'2011-01-17 08:43:05',
'2011-01-17',
'2011-02-16',
t1.modified,
'',
1,
150,
'yes',
'9.50000',
'9.50000',
'9.50000',
13,
0,
0,
325,
15,
'',
'',
''
FROM contestHAD AS t1
WHERE t1.id_thread = 22
ORDER BY t1.modified DESC, t1.id DESC
LIMIT 1
289 Execution error => 1136: Column count doesn't match value count at row 1 |
|
Correct the error. |
|
|
|
|
|
