Forum Support

Shape 5
April 20, 2021, 07:21:15 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: Shape 5 Forum
 
   Home   Help Search Login Register  
Pages: [1]
  Print  
Author Topic: Where are the instructions to installing this template?  (Read 506 times)
7se7en7
Jr. Member
**
Offline Offline

Posts: 6



« on: 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


« Last Edit: October 31, 2010, 01:17:16 AM by 7se7en7 » Logged
7se7en7
Jr. Member
**
Offline Offline

Posts: 6



« Reply #1 on: 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.
Logged
jleckenby
Jr. Member
**
Offline Offline

Posts: 284



WWW
« Reply #2 on: 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
Logged

James
------------
Shape 5 Team

Need some custom coding done on your site? Use our Shape 5 Hire a Coder program for free.  http://www.shape5.com/hire_a_coder/listauctions
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF | SMF © 2013, Simple Machines
Joomla Bridge by JoomlaHacks.com
Valid XHTML 1.0! Valid CSS!
Looking for the largest variety in template designs? Look no more. Never buy 1 theme again. Signups start at just $89 for access to all of our themes.
Send Us An Email
Please send us your questions and we will email you back as soon as we can. Product support questions should be posted in our support forums under the Help menu. Our staff will assist you from there.