[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);

fixed on svn.





Comments

Popular posts from this blog

VIDIOC_S_FMT error 16, Device or resource busy - Raspberry Pi Forums

using a laptop skeleton to build a pi laptop - Raspberry Pi Forums

Forum for Joomla? - Joomla! Forum - community, help and support