[FIXED] Is it a bug in the file "[Joomla1.5]\installation\sql\sample_data.sql" ? - Joomla! Forum - community, help and support
my joomla :
version:1.5beta
os:win xp
db:mysql server
questions: think should be: sum(#_poll_data.hits) == count(#_poll_date) == #_polls.voters
sample_data.sql tell : sum(#_poll_data.hits) = 8 , 8 hits
count(#_poll_date) = 7 , 7 records
#_polls.voters = 8 , 8 voters.
-----------
open file "[joomla1.5]\installation\sql\sample_data.sql" , find lines tables "#_poll_data,#_poll_date,#_polls," , below follow:
insert `#__poll_data` values (1, 14, 'community sites', 2);
insert `#__poll_data` values (2, 14, 'public brand sites', 2);
insert `#__poll_data` values (3, 14, 'ecommerce', 0);
insert `#__poll_data` values (4, 14, 'blogs', 0);
insert `#__poll_data` values (5, 14, 'intranets', 0);
insert `#__poll_data` values (6, 14, 'photo , media sites', 0);
insert `#__poll_data` values (7, 14, 'all of above!', 4);
insert `#__poll_data` values (8, 14, '', 0);
insert `#__poll_data` values (9, 14, '', 0);
insert `#__poll_data` values (10, 14, '', 0);
insert `#__poll_data` values (11, 14, '', 0);
insert `#__poll_data` values (12, 14, '', 0);
insert `#__poll_date` values (1, '2006-10-09 13:01:58', 1, 14);
insert `#__poll_date` values (2, '2006-10-10 15:19:43', 7, 14);
insert `#__poll_date` values (3, '2006-10-11 11:08:16', 7, 14);
insert `#__poll_date` values (4, '2006-10-11 15:02:26', 2, 14);
insert `#__poll_date` values (5, '2006-10-11 15:43:03', 7, 14);
insert `#__poll_date` values (6, '2006-10-11 15:43:38', 7, 14);
insert `#__poll_date` values (7, '2006-10-12 00:51:13', 2, 14);
insert `#__polls` values (14, 'joomla! used for?', 8, 0, '0000-00-00 00:00:00', 1, 0, 86400);
version:1.5beta
os:win xp
db:mysql server
questions: think should be: sum(#_poll_data.hits) == count(#_poll_date) == #_polls.voters
sample_data.sql tell : sum(#_poll_data.hits) = 8 , 8 hits
count(#_poll_date) = 7 , 7 records
#_polls.voters = 8 , 8 voters.
-----------
open file "[joomla1.5]\installation\sql\sample_data.sql" , find lines tables "#_poll_data,#_poll_date,#_polls," , below follow:
insert `#__poll_data` values (1, 14, 'community sites', 2);
insert `#__poll_data` values (2, 14, 'public brand sites', 2);
insert `#__poll_data` values (3, 14, 'ecommerce', 0);
insert `#__poll_data` values (4, 14, 'blogs', 0);
insert `#__poll_data` values (5, 14, 'intranets', 0);
insert `#__poll_data` values (6, 14, 'photo , media sites', 0);
insert `#__poll_data` values (7, 14, 'all of above!', 4);
insert `#__poll_data` values (8, 14, '', 0);
insert `#__poll_data` values (9, 14, '', 0);
insert `#__poll_data` values (10, 14, '', 0);
insert `#__poll_data` values (11, 14, '', 0);
insert `#__poll_data` values (12, 14, '', 0);
insert `#__poll_date` values (1, '2006-10-09 13:01:58', 1, 14);
insert `#__poll_date` values (2, '2006-10-10 15:19:43', 7, 14);
insert `#__poll_date` values (3, '2006-10-11 11:08:16', 7, 14);
insert `#__poll_date` values (4, '2006-10-11 15:02:26', 2, 14);
insert `#__poll_date` values (5, '2006-10-11 15:43:03', 7, 14);
insert `#__poll_date` values (6, '2006-10-11 15:43:38', 7, 14);
insert `#__poll_date` values (7, '2006-10-12 00:51:13', 2, 14);
insert `#__polls` values (14, 'joomla! used for?', 8, 0, '0000-00-00 00:00:00', 1, 0, 86400);
fixed on svn.
Comments
Post a Comment