Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Need help trying to install OSC center shop 3.0


Porsche032

Recommended Posts

Hey guys Im new at this and Im trying to install center shop 3.0. I replaced the header and footer like it said. Then it told me to import the SQL file. I went to phpmyadmin and clicked on the SQL button and clicked on import. It gave me this

INSERT INTO configuration_group

VALUES ( 16, 'Center Shop', 'Center Shop Module Integration', 16, 1 )

 

MySQL said: Documentation

.#1146 - Table 'carcustomz.configuration_group' doesn't exist

 

can someone help me and tell me what to do. Thanks alot.

Link to comment
Share on other sites

It sounds like your database is not set up correctly - but if that were true then it's likely your whole site would be down.

 

Check in phpMyAdmin to make sure that the configuration_group table does exist.

 

Vger

Link to comment
Share on other sites

Uninstall Center Shop, and install Fixed Width Site With CSS - link below my name. No changes to database, one div class in the header, close div in the footer, and a change/addition to the stylesheet - all done.

 

Vger

Link to comment
Share on other sites

Hi Vger

I have been reading all I can in "help" with the Center Shop, and I think I have conflicts with Center Shop and your contribution.

1) How do you uninstall Center Shop?

2) OR, preferably, If I don't have to uninstall, could you please check my code for header.php and footer.php to see where the conflicts are with the

<div> and </div> to see if they are compatible? I would like my site centered depending on resolution.

 

header.php

<?php
/*
 $Id: header.php,v 1.42 2003/06/10 18:20:38 hpdl Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

// check if the 'install' directory exists, and warn of its existence
 if (WARN_INSTALL_EXISTENCE == 'true') {
   if (file_exists(dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']) . '/install')) {
     $messageStack->add('header', WARNING_INSTALL_DIRECTORY_EXISTS, 'warning');
   }
 }

// check if the configure.php file is writeable
 if (WARN_CONFIG_WRITEABLE == 'true') {
   if ( (file_exists(dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']) . '/includes/configure.php')) && (is_writeable(dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']) . '/includes/configure.php')) ) {
     $messageStack->add('header', WARNING_CONFIG_FILE_WRITEABLE, 'warning');
   }
 }

// check if the session folder is writeable
 if (WARN_SESSION_DIRECTORY_NOT_WRITEABLE == 'true') {
   if (STORE_SESSIONS == '') {
     if (!is_dir(tep_session_save_path())) {
       $messageStack->add('header', WARNING_SESSION_DIRECTORY_NON_EXISTENT, 'warning');
     } elseif (!is_writeable(tep_session_save_path())) {
       $messageStack->add('header', WARNING_SESSION_DIRECTORY_NOT_WRITEABLE, 'warning');
     }
   }
 }

// check session.auto_start is disabled
 if ( (function_exists('ini_get')) && (WARN_SESSION_AUTO_START == 'true') ) {
   if (ini_get('session.auto_start') == '1') {
     $messageStack->add('header', WARNING_SESSION_AUTO_START, 'warning');
   }
 }

 if ( (WARN_DOWNLOAD_DIRECTORY_NOT_READABLE == 'true') && (DOWNLOAD_ENABLED == 'true') ) {
   if (!is_dir(DIR_FS_DOWNLOAD)) {
     $messageStack->add('header', WARNING_DOWNLOAD_DIRECTORY_NON_EXISTENT, 'warning');
   }
 }

 if ($messageStack->size('header') > 0) {
   echo $messageStack->output('header');
 }   

///////////////////    
///////////////////        
// [0001] BOF: WebMakers.com Added: Center Shop
// This goes before any other table of the shop
//
// Is center Shop ON/OFF ?
///////////////////

   if ( CENTER_SHOP_ON == 'on' ) {

///////////////////   
// [0001] Background Color ON/OFF and CellPadding for around the shop?
///////////////////

     if ( CENTER_SHOP_BACKGROUND_ON == 'on' ) {
?>
<div class="fixcenter">
   <table width="100%" cellpadding="<?php echo CENTER_SHOP_PADDING; ?>" cellspacing="0" border="0" bgcolor="<?php echo CENTER_SHOP_BACKGROUND_COLOR_OUT; ?>">
     <tr><td>
<?php
     }
  
   
///////////////////    
// [0001] Shop Width Size and Shop Background Color
///////////////////
?>
   <table width="<?php echo CENTER_SHOP_WIDTH; ?>" align="center" BGCOLOR="<?php echo CENTER_SHOP_BACKGROUND_COLOR; ?>" BORDER="<?php echo CENTER_SHOP_BORDER; ?>" bordercolor="<?php echo CENTER_SHOP_BORDERCOLOR; ?>" CELLSPACING="<?php echo CENTER_SHOP_CELLSPACING; ?>" CELLPADDING="<?php echo CENTER_SHOP_CELLPADDING; ?>" >
     <tr><td BGColor="#D1E7FC">
<?php
 
///////////////////
// [0001] The rest of this <td> statement is located at the end of footer.php
///////////////////
}
?>
<div style="text-align: center; background: #D1E7FC; margin: 0;">
<div style="text-align: left; margin: 8px auto; width: 760px;">
<table border="0" width="100%" cellspacing="0" cellpadding="0">

 <tr class="header">
 

   <td valign="middle"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image(DIR_WS_IMAGES . 'bluehawthorne.gif', 'bluehawthorne') . '</a>'; ?></td>

   <td align="right" valign="bottom"><?php echo '<a href="' . tep_href_link(FILENAME_ACCOUNT, '', 'SSL') . '">' . tep_image(DIR_WS_IMAGES . 'header_account.gif', HEADER_TITLE_MY_ACCOUNT) . '</a>  <a href="' . tep_href_link(FILENAME_SHOPPING_CART) . '">' . tep_image(DIR_WS_IMAGES . 'header_cart.gif', HEADER_TITLE_CART_CONTENTS) . '</a>  <a href="' . tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL') . '">' . tep_image(DIR_WS_IMAGES . 'header_checkout.gif', HEADER_TITLE_CHECKOUT) . '</a>'; ?>  </td>
 </tr>
</table>
<table border="0" width="100%" cellspacing="0" cellpadding="1">
 <tr class="headerNavigation">
   <td class="headerNavigation">  <?php echo $breadcrumb->trail(' » '); ?></td>
   <td align="right" class="headerNavigation"><?php if (tep_session_is_registered('customer_id')) { ?><a href="<?php echo tep_href_link(FILENAME_LOGOFF, '', 'SSL'); ?>" class="headerNavigation"><?php echo HEADER_TITLE_LOGOFF; ?></a>  |  <?php } ?><a href="<?php echo tep_href_link(FILENAME_ACCOUNT, '', 'SSL'); ?>" class="headerNavigation"><?php echo HEADER_TITLE_MY_ACCOUNT; ?></a>  |  <a href="<?php echo tep_href_link(FILENAME_SHOPPING_CART); ?>" class="headerNavigation"><?php echo HEADER_TITLE_CART_CONTENTS; ?></a>  |  <a href="<?php echo tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL'); ?>" class="headerNavigation"><?php echo HEADER_TITLE_CHECKOUT; ?></a>   </td>
 </tr>
</table>
<?php
 if (isset($HTTP_GET_VARS['error_message']) && tep_not_null($HTTP_GET_VARS['error_message'])) {
?>
<table border="0" width="100%" cellspacing="0" cellpadding="2">
 <tr class="headerError">
   <td class="headerError"><?php echo htmlspecialchars(urldecode($HTTP_GET_VARS['error_message'])); ?></td>
 </tr>
</table>
<?php
 }

 if (isset($HTTP_GET_VARS['info_message']) && tep_not_null($HTTP_GET_VARS['info_message'])) {
?>
<table border="0" width="100%" cellspacing="0" cellpadding="2">
 <tr class="headerInfo">
   <td class="headerInfo"><?php echo htmlspecialchars($HTTP_GET_VARS['info_message']); ?></td>
 </tr>
</table>
<?php
 }
?>

 

footer.php

<?php
/*
 $Id: footer.php,v 1.26 2003/02/10 22:30:54 hpdl Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

 require(DIR_WS_INCLUDES . 'counter.php');
?>
<table border="0" width="100%" cellspacing="0" cellpadding="1">
 <tr class="footer">
   <td class="footer">  <?php echo strftime(DATE_FORMAT_LONG); ?>  </td>
   <td align="right" class="footer">  <?php echo $counter_now . ' ' . FOOTER_TEXT_REQUESTS_SINCE . ' ' . $counter_startdate_formatted; ?>  </td>
 </tr>
</table>
<br>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
 <tr>
   <td align="center" class="smallText">
<?php
/*
 The following copyright announcement can only be
 appropriately modified or removed if the layout of
 the site theme has been modified to distinguish
 itself from the default osCommerce-copyrighted
 theme.

 For more information please read the following
 Frequently Asked Questions entry on the osCommerce
 support site:

 http://www.oscommerce.com/community.php/faq,26/q,50

 Please leave this comment intact together with the
 following copyright announcement.
*/

 echo FOOTER_TEXT_BODY
?>
   </td>
 </tr>
</table>
<?php
 if ($banner = tep_banner_exists('dynamic', '468x50')) {
?>
<br>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
 <tr>
   <td align="center"><?php echo tep_display_banner('static', $banner); ?></td>
 </tr>
</table>
</div>
</div>
</div>
<?php
 }
?>

<?php
///////////////////
// [0001] WebMakers.com Added: Center Shop
// This goes at the very end of the footer after all the tables
///////////////////

 if ( CENTER_SHOP_ON == 'on' ) {
  
///////////////////
// [0001] close table used to center
///////////////////
?>
     </td></tr>
   </table>
<?php
   if ( CENTER_SHOP_BACKGROUND_ON == 'on' ) {
    
///////////////////
// [0001] Add color to bottom of screen for large displays - needed especially on notebooks that run at 1600x1200
// close table used for outer bgcolor around the shop
///////////////////
?>

<!-- deleting the Spacer in the footer without the default background-color -->
    <!--  </td></tr>
     <tr><td height="150"> </td></tr>
   </table> -->

<?php
   }
 }
///////////////////
// [0001] EOF: WebMakers.com Added: Center Shop
///////////////////
///////////////////
?>

Any help would be appreciated.

 

My site is:

BlueHawthorne Antiques and Collectables: http://www.bluehawthorne.com/catalog/index.php

Link to comment
Share on other sites

Center Shop and Fixed Width Site With CSS are not compatible and work in different ways. If you wish to uninstall Center Shop then you simply have to follow the Install instructions in reverse.

 

My contribution will not give you a centred shop based on screen resolution - osCommerce already does that by expanding to fit the width of the screen whatever the resolution is. My contribution is intended to give you a centered shop of a fixed width, where you can set the border colour and style and apply a different colour or image outside of the webpage border.

 

From a web design point of view it is better to have a site with a fixed width, because you can design knowing that it will look the same no matter what the screen resolution is.

 

Vger

Link to comment
Share on other sites

  • 2 weeks later...

hey guys im getting this on whatever i try to import an sql

Error

 

SQL query:

 

# NEW RECORDS FOR: WYSIWYG HTML AREA 1.7 and ULTRA IMAGES for MS2

# HTML_WYSIWYG_SQL.sql

# Created by: MaxiDVD www.maxidvd.com.au

INSERT INTO configuration_group( configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible )

VALUES (

'112', 'WYSIWYG Editor 1.7', 'HTMLArea 1.7 Options', '15', '1'

)

 

MySQL said: Documentation

#1146 - Table 'carcustomz.configuration_group' doesn't exist

 

 

I dont know what im doing wrong. Maybe im importing it wrong. Im using PHPMYADMIN I just click on the import button and select teh text file but i keep getting this error. I dont know what to do, can someone help? Thanks

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...