: Where are the instructions to installing this template? : 7se7en7 October 31, 2010, 01:06:29 AM I am NOT using the SiteShaper to install J! & CB.
Are there instructions to install / apply this template? I used the auto 'zip' install but still not all the components on in the correct position, etc.. Also, when I try importing the SQL sump for this template I get the below error: Error SQL query: -- -- Dumping data for table `jos_banner` -- INSERT INTO `jos_banner` ( `bid` , `cid` , `type` , `name` , `alias` , `imptotal` , `impmade` , `clicks` , `imageurl` , `clickurl` , `date` , `showBanner` , `checked_out` , `checked_out_time` , `editor` , `custombannercode` , `catid` , `description` , `sticky` , `ordering` , `publish_up` , `publish_down` , `tags` , `params` ) VALUES ( 1, 1, '', 'OSM 1', 'osm-1', 0, 53462, 354, 's5banner.jpg', 'http://www.opensourcematters.org', '2008-07-14 19:40:18', 1, 0, '0000-00-00 00:00:00', '', '', 0, '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '' ) , ( 2, 1, 'banner', 'OSM 2', 'osm-2', 0, 52082, 339, 'osmbanner2.png', 'http://www.opensourcematters.org', '2004-07-07 15:31:29', 0, 0, '0000-00-00 00:00:00', '', '', 0, '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '' ) ; MySQL said: #1062 - Duplicate entry '1' for key 1 : Re: Where are the instructions to installing this template? : 7se7en7 October 31, 2010, 01:19:19 AM I dumped all the tables in the DB; and used the SQL provided to re-create the tables 'successfully' but now I am missing tables for other 3rd party modules that were previously installed.
*** Is there a way to run the SQL dump provided & over write data with out losing / dropping all the tables? I am not sure what tables need to be over written and which ones should remain untouched. : Re: Where are the instructions to installing this template? : jleckenby November 01, 2010, 04:45:10 AM Just to check, you are trying to install the demo data on a site with existing components and data correct?
I can't say Im entirely sure it would work, and my advice would be to carry out a full using SiteShaper, and then install what you need and copy the data over. For example, install CB and all plugins until the config matches that of your current site, then dump the CB data in the database and import the old and copy over any media like avatars etc. However, if you really want to have a go you could use the 'ON DUPLICATE KEY UPDATE' command for SQL, which you can find more on at: http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html |