Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Guest

[Contribution] STS v4

Recommended Posts

This question is regarding the CONTENT templates.

 

These are working fine for categories. I have a nice set of templates per category, and when the user approaches the catalog from a category standpoint, the category template is displayed.

 

I'm not having any success building a CONTENT template for MANUFACTURER. When the user picks a manufacturer to browse, product information is displayed in the ugly default format and without any of the defined variables I want.

 

How do I set up CONTENT template per MANUFACTURER? Perhaps it is the naming convention I have wrong??

 

If it's not possible to do this, could somebody please tell me that rather than just ignoring?

 

Thanks,

 

Anne

Anne, there are no content templates available for the manufacturer pages. You can create a template for any of the manufacturer pages themselves (a sample was provided in the contribution) but not for the PHP content (the stuff in the middle).

 

Also, one more thing...

What version of osCommerce are you using? I know there was some typo errors regarding the manufacturer pages in earlier versions of osC. The latest Online Merchant RC1 has those typos corrected. I can't remember the specific locations of the typos but I do believe they would affect your template structure for manufacturers. Just a thought. :thumbsup:

 

Take a look at this post and let me know if this answers your question:

http://forums.oscommerce.com/index.php?s=&...t&p=1105479

 

Hope this helped,

Edited by bkellum

Bill Kellum

 

Sounds Good Productions

STS Tutorials & more: STSv4.6, STS Add-ons (STS Power Pack), STS V4 Forum STS Forum FREE TEMPLATE

Share this post


Link to post
Share on other sites
Guest
Anne, there are no content templates available for the manufacturer pages. You can create a template for any of the manufacturer pages themselves (a sample was provided in the contribution) but not for the PHP content (the stuff in the middle).

 

Also, one more thing...

What version of osCommerce are you using? I know there was some typo errors regarding the manufacturer pages in earlier versions of osC. The latest Online Merchant RC1 has those typos corrected. I can't remember the specific locations of the typos but I do believe they would affect your template structure for manufacturers. Just a thought. :thumbsup:

 

Take a look at this post and let me know if this answers your question:

http://forums.oscommerce.com/index.php?s=&...t&p=1105479

 

Hope this helped,

 

Hi Bill,

 

I'm using the August 2006 update. Have not upgraded to Online Merchant. STS version is 4.4.

 

Let me ask you this: I've become quite a dab hand at modifying the STS version of sts_inc/product_info.php to show what I want it to show. This basically involved modifying the basic query and setting up a couple of new template variables based on the results. In my particular case (working on a bookseller site), that involved going into the manufacturer's table and also adding a couple of new fields (products_isbn and products_binding) to the products table, fetching query results for those, and setting up variables for them as well. So I now have three very useful new variables for my content template: $productbinding$, $productisbn$, and $manufacturer$. (Manufacturer in this case equates to Publisher.)

 

If I wanted to set up a modification that would permit a content template for the manufacturer's page, which files would need to be addressed?

 

What I have here is the almost-completed nucleus of a toolkit for developers of book or library sites--even publishers. In addition to the stuff mentioned here, there are template pages for "recommended reading," author bios, and a number of others. Getting a customized manufacturer's product info page would really tie the whole together and might make it worth sharing with the community at large. Of course my work so far has built on a number of other peoples' contributions both in the contribs section and from posts here in the forums. In the course of my work for this client, I've been to about a million publisher sites and have gained impressions of the good, the bad, and the ugly--all of which I'm trying to apply to this installation.

 

If you wouldn't mind setting my feet along the right path, I think I'm equal to the task. In return, I would gladly share what I've done. I suspect there are booksellers out there who would benefit.

 

Thanks,

Anne

Share this post


Link to post
Share on other sites
Hi Bill,

 

I'm using the August 2006 update. Have not upgraded to Online Merchant. STS version is 4.4.

 

Let me ask you this: I've become quite a dab hand at modifying the STS version of sts_inc/product_info.php to show what I want it to show. This basically involved modifying the basic query and setting up a couple of new template variables based on the results. In my particular case (working on a bookseller site), that involved going into the manufacturer's table and also adding a couple of new fields (products_isbn and products_binding) to the products table, fetching query results for those, and setting up variables for them as well. So I now have three very useful new variables for my content template: $productbinding$, $productisbn$, and $manufacturer$. (Manufacturer in this case equates to Publisher.)

 

If I wanted to set up a modification that would permit a content template for the manufacturer's page, which files would need to be addressed?

 

What I have here is the almost-completed nucleus of a toolkit for developers of book or library sites--even publishers. In addition to the stuff mentioned here, there are template pages for "recommended reading," author bios, and a number of others. Getting a customized manufacturer's product info page would really tie the whole together and might make it worth sharing with the community at large. Of course my work so far has built on a number of other peoples' contributions both in the contribs section and from posts here in the forums. In the course of my work for this client, I've been to about a million publisher sites and have gained impressions of the good, the bad, and the ugly--all of which I'm trying to apply to this installation.

 

If you wouldn't mind setting my feet along the right path, I think I'm equal to the task. In return, I would gladly share what I've done. I suspect there are booksellers out there who would benefit.

 

Thanks,

Anne

Anne,

Sounds like you have done a lot of great work.

First things first...

Since you are using STSv4.4, you will need to make sure you have updated that version with the following bug fixes or your manufacturer templates WILL NOT work:

 

Bug fix 1 of 2 can be found at: http://forums.oscommerce.com/index.php?s=&...t&p=1023674

 

At the very end of application_top.php, it should look like this:

 

 

// START STS 4.1
 require (DIR_WS_CLASSES.'sts.php');
 $sts= new sts();
 $sts->start_capture();
 // END STS 4.1
// initialize the message stack for output messages
 require(DIR_WS_CLASSES . 'message_stack.php');
 $messageStack = new messageStack;

// set which precautions should be checked
 define('WARN_INSTALL_EXISTENCE', 'true');
 define('WARN_CONFIG_WRITEABLE', 'true');
 define('WARN_SESSION_DIRECTORY_NOT_WRITEABLE', 'true');
 define('WARN_SESSION_AUTO_START', 'true');
 define('WARN_DOWNLOAD_DIRECTORY_NOT_READABLE', 'true');
?>

 

Bug fix 2 of 2 can be found at: http://forums.oscommerce.com/index.php?s=&...t&p=1037770

 

Templates are not being recognized by STS.

 

Open the includes/modules/sts/sts_default.php file.

Find:

 

if (strstr($scriptbasename, "popup") || strstr($scriptbasename, "info_shopping_cart")) {
return ''; // We don't use template for these scripts

$check_file = STS_TEMPLATE_DIR .$scriptbasename . ".html";

if (file_exists($check_file)) return $check_file;

 }

 

Replace with (you will remove the bracket):

 

if (strstr($scriptbasename, "popup") || strstr($scriptbasename, "info_shopping_cart"))
  return ''; // We don't use template for these scripts

$check_file = STS_TEMPLATE_DIR .$scriptbasename . ".html";

if (file_exists($check_file)) return $check_file;

 

If you leave the brackets "as is", then you will experience templates not being recognized by STS.

 

--------------------------------------------------------------------

OK...now regarding what STS looks at regarding the $content variable. The $content is taken from the php script you are running. For example, the $content for index.php is the piece of code you find in index.php, between the call of column_left and the call of column_right. If you want to modify it, you have to modify the script itself.

 

Hopefully that will get you on your way,

Edited by bkellum

Bill Kellum

 

Sounds Good Productions

STS Tutorials & more: STSv4.6, STS Add-ons (STS Power Pack), STS V4 Forum STS Forum FREE TEMPLATE

Share this post


Link to post
Share on other sites
Guest
Anne,

 

Hopefully that will get you on your way,

 

Bill, thanks! Those will be very helpful, and hopefully I'll be able to go in there and set up what I need. I'll pay special attention to the bug fixes.

 

I've actually been working on this to the extent that I need to take a break and go do something else--walk the dog, watch TV, read a book. If I'm successful, I'll spend some time with my notes, I'll contact the other people who have contributed, and I'll set up a little bookseller's package for the community.

 

Much appreciated. I'll either be back in the morning crowing or crying. ;)

 

Anne

Share this post


Link to post
Share on other sites

Hi Bill, first of all Thank you very much for the work you have put into STS! I asked a question the other day about showing the cart only if the cart has products in it on certain pages such as the home page. While using STS the following code does not work.

 

if ($cart->count_contents() > 0) {
require(DIR_WS_BOXES . 'shopping_cart.php');
}

 

You said that I should just remove the cart from the actual page (in this case the homepage). I do understand that I could do that, but there are going to be circumstances where the user is on the homepage and wishes to see their cart/increase the chance that they will checkout.

 

Can you think of any possible way to find out if cart_contents = 0 or greater than 0 so I enable this in STS?

 

 

Thank you :)

Share this post


Link to post
Share on other sites
Hi Bill, first of all Thank you very much for the work you have put into STS! I asked a question the other day about showing the cart only if the cart has products in it on certain pages such as the home page. While using STS the following code does not work.

 

if ($cart->count_contents() > 0) {
require(DIR_WS_BOXES . 'shopping_cart.php');
}

 

You said that I should just remove the cart from the actual page (in this case the homepage). I do understand that I could do that, but there are going to be circumstances where the user is on the homepage and wishes to see their cart/increase the chance that they will checkout.

 

Can you think of any possible way to find out if cart_contents = 0 or greater than 0 so I enable this in STS?

 

 

Thank you :)

Ryan,

Play around with the following code and let me know what you come up with:

 

 

Add this to your includes/modules/sts_inc/sts_user_code.php file, before the ?> at the end:

 

 

 

$sts->start_capture();
$productno = $cart->count_contents();
$totalprice = $currencies->format($cart->show_total());

if ($productno > 1) {
  echo ENTRY_HCART_CONTAINS;
  echo " ";
  echo $productno;
  echo " ";
  echo ENTRY_HCART_ITEMS;
  echo " "; echo " ";
  echo ENTRY_HCART_PRICE;
  echo " ";
  echo $totalprice;
} elseif ($productno == 0) {
  echo ENTRY_HCART_EMPTY;
} else {
  echo ENTRY_HCART_CONTAINS;
  echo " ";
  echo $productno;
  echo " ";
  echo ENTRY_HCART_ITEM;
  echo " "; echo " ";
  echo ENTRY_HCART_PRICE;
  echo " ";
  echo $totalprice;
}
$sts->stop_capture ('headcart');

Add this to your includes/languages/english.php file, before the ?> at the end: (plus any other language you have for you shop)

 

define('ENTRY_HCART_EMPTY', 'Your cart is empty.');
define('ENTRY_HCART_CONTAINS', 'Your cart contains:');
define('ENTRY_HCART_ITEM',  'item.');
define('ENTRY_HCART_ITEMS',  'items.');
define('ENTRY_HCART_PRICE', 'Total price:');

 

The above code checks for cart contents as well as create the STS code needed for you to simple place the STS tag $headcart anywhere you want, such as your home page. This code is derived from the "Place Shopping Cart In Your Header" contribution. It may be just what you are looking for or may need just a little tweaking to be exact. :thumbsup:


Bill Kellum

 

Sounds Good Productions

STS Tutorials & more: STSv4.6, STS Add-ons (STS Power Pack), STS V4 Forum STS Forum FREE TEMPLATE

Share this post


Link to post
Share on other sites

Thank you very much for your help! I managed to modify it slightly to get it to wwork how I wanted it. Anybody else who is trying to get this to work can use this.

 

$sts->start_capture();
$productno = $cart->count_contents();

if ($productno >= 1) {
  echo '$cartbox';
}
$sts->stop_capture ('headcart');

 

Then simply use $headcart in document.

 

Thanks again!

Share this post


Link to post
Share on other sites

Firstly I just have to say thank you for this contribution, I wish I had used it earlier as I would have saved myself alot of time.

I have been modifying an existing template that I found & like but I could not get it to work for me as I wanted it to. Now with STS I finally can ;)

All has gone very well, but now that I am close to the end I finally have one major difficulty. I cant get my header text to display after I have almost finished my modifications.

 

 

As an example the code for the infobox.php template is:

<!--  Box Header Start  -->
<table width="100%" border="0" cellspacing="0" cellpadding="0" style="border-collapse: collapse" bordercolor="#111111">
 <tr class="infoBoxHeading">
 <td width="30"><img src=images/corner_left.gif width=30 height=29 border=0></td>
 <td background="images/infobox_03.gif" width="100%" height="29" valign="center">$headertext</td>
 <td width="30"><img src=images/corner_right.gif width=30 height=29 border=0></td>  
 </tr>
</table>
<!--  Box Header EOF  -->

<!--  Box Body Start  -->
<table width="100%" border="1" cellspacing="0" cellpadding="0" bgcolor="#999999" style="border-collapse: collapse" bordercolor="#999999">
 <tr>
<td bgcolor="#FFFFFF">$content</td>
 </tr>
</table>
<!--  Box Body EOF  -->

 

I have also uploaded a demo version for anybody that can help me to take a look at and let me know where I am going wrong (http://www.labrats.co.za/catalog)

 

Thanks in advance

 

P.S. The main header is currently hard coded to link to the actuall live site, so please becarefull when using this.

Share this post


Link to post
Share on other sites
Renato,

I suggest that you use the Featured Products contribution to replace your New Products for month box. This will give you complete control over those products.

 

Check it out here:

 

http://www.oscommerce.com/community/contributions,651

 

Have fun,

 

Hi Bill,

 

Thanks for the answer and about the suggestion. I'll install this contribution.

 

In my last question I asked how could I know how can I do to setup each content, if this pags using the same tag ($content). Could you explain to me how, please?

 

What's the difference betwenn index.php.html and sts_template.html?

 

Thanks a lot

 

Renato

Share this post


Link to post
Share on other sites
Hi Bill,

 

Thanks for the answer and about the suggestion. I'll install this contribution.

 

In my last question I asked how could I know how can I do to setup each content, if this pags using the same tag ($content). Could you explain to me how, please?

 

What's the difference betwenn index.php.html and sts_template.html?

 

Thanks a lot

 

Renato

Renato, the $content tag is dynamic in that it depends upon what PHP script (page in your store) is being called. For example: If you create a category template (index.php_21.html), the $content tag will only look at the PHP code in the index.php page between the call of column_left and the call of column_right.

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

content tag pulls in all of the code up to

<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>

So, if you do not like what osCommerce is doing inbetween those two lines, then you will have to manually edit the code or look for a contribution that has already made those changes.

 

Regarding your other question...

The sts_template.html is the "out of the box" DEFAULT TEMPLATE. Basically, if you do not create any other templates, then this is the template that will be used for the layout of all of the pages in your store. You should design this page with that in mind. If you want to start creating templates for specific pages, then you will need to use the naming syntax mentioned in the STS User Manual. For example: index.php_0.html can be your home page template, index.php.html can be your default category template, index.php_21.html can be a specific template for category 21 and so on.

 

:thumbsup: Look at the flow charts in the STS User Manual to get a better idea how STS looks for what template to use when a page is requested in the browser.


Bill Kellum

 

Sounds Good Productions

STS Tutorials & more: STSv4.6, STS Add-ons (STS Power Pack), STS V4 Forum STS Forum FREE TEMPLATE

Share this post


Link to post
Share on other sites
Guest

Ryan,

Play around with the following code and let me know what you come up with:

Add this to your includes/modules/sts_inc/sts_user_code.php file, before the ?> at the end:

 

 

I have a question along these lines as well:

 

Is it possible to use either the OSC "tips and tricks" or the user contribution to add code to the header so that the cart contents are displayed at the top of the page rather than in an infobox? It's a clean way to do it and takes up a lot less "screen real estate" than the use of a box. I'd actually be happy only to show the total number of items in the cart, total cost, and a link to checkout.

 

Thanks--still working on my manufacturer's template.

 

Anne

Share this post


Link to post
Share on other sites
Guest
I have a question along these lines as well:

 

Is it possible to use either the OSC "tips and tricks" or the user contribution to add code to the header so that the cart contents are displayed at the top of the page rather than in an infobox? It's a clean way to do it and takes up a lot less "screen real estate" than the use of a box. I'd actually be happy only to show the total number of items in the cart, total cost, and a link to checkout.

 

OK, so I'm answering this myself. It's easy to set up a variable in sts_user_code.php to display an abbreviated version of the user's shopping cart wherever on your page you may want one. You can base it on the "OSC Tip and Trick" found here:

 

http://oscommerce.info/kb/osCommerce/Gener...s_and_Tricks/56

 

with one HUGE exception. There's an error in that code. This line:

 

if ($cart->count_contents() > 0) {
   echo '<br>Total: ' . $osC_Currencies->format($cart->show_total());

 

needs to read:

if ($cart->count_contents() > 0) {
   echo '<br>Total: ' . $currencies->format($cart->show_total());

 

Once that's taken care of, error messages disappear, and you can set up a few lines in includes/modules/sts_inc/sts_user_code.php as follows:

//shopping cart wherever you want one
$sts->start_capture();
?> 
<table border="0" width="100%" cellspacing="0" cellpadding="0">
 <tr>
   <td class="shoppingCartContents">
<?php
 echo $cart->count_contents() . ' Items';

 if ($cart->count_contents() > 0) {
   echo '<br>Total: ' . $currencies->format($cart->show_total());
 }
?>
   </td>
 </tr>
</table>
<?php

$sts->stop_capture('cart');
//shopping cart ends

 

Set up a new class in your stylesheet called shoppingCartContents, and you can use $cart# wherever you want it. It should be possible to spruce it up quite a bit with a little shopping cart icon, a link to checkout, or whatever. All this does is give you one line with the number of items and a second with the total.

 

So I'm a happy person. :rolleyes:

 

Regards,

Anne

Share this post


Link to post
Share on other sites

Hi,

 

Just installed STS on my OSC RC1 store, and haven;t turned anything on yet. I am getting the title "New products for July" twice on my site. Any ideas why? I am using the most current version of STS for RC1 stores.

 

Thanks.

 

Colin.

 

You can see what I mean here: My Website

Share this post


Link to post
Share on other sites
OK, so I'm answering this myself. It's easy to set up a variable in sts_user_code.php to display an abbreviated version of the user's shopping cart wherever on your page you may want one. You can base it on the "OSC Tip and Trick" found here:

 

http://oscommerce.info/kb/osCommerce/Gener...s_and_Tricks/56

 

with one HUGE exception. There's an error in that code. This line:

 

if ($cart->count_contents() > 0) {
echo '<br>Total: ' . $osC_Currencies->format($cart->show_total());

 

needs to read:

if ($cart->count_contents() > 0) {
echo '<br>Total: ' . $currencies->format($cart->show_total());

 

Once that's taken care of, error messages disappear, and you can set up a few lines in includes/modules/sts_inc/sts_user_code.php as follows:

//shopping cart wherever you want one
$sts->start_capture();
?> 
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td class="shoppingCartContents">
<?php
echo $cart->count_contents() . ' Items';

if ($cart->count_contents() > 0) {
echo '<br>Total: ' . $currencies->format($cart->show_total());
}
?>
</td>
</tr>
</table>
<?php

$sts->stop_capture('cart');
//shopping cart ends

 

Set up a new class in your stylesheet called shoppingCartContents, and you can use $cart# wherever you want it. It should be possible to spruce it up quite a bit with a little shopping cart icon, a link to checkout, or whatever. All this does is give you one line with the number of items and a second with the total.

 

So I'm a happy person. :rolleyes:

 

Regards,

Anne

 

Anne,

 

Did you not see my post regarding this same issue just one page back in this thread?

http://forums.oscommerce.com/index.php?s=&...t&p=1105585


Bill Kellum

 

Sounds Good Productions

STS Tutorials & more: STSv4.6, STS Add-ons (STS Power Pack), STS V4 Forum STS Forum FREE TEMPLATE

Share this post


Link to post
Share on other sites
Hi,

 

Just installed STS on my OSC RC1 store, and haven;t turned anything on yet. I am getting the title "New products for July" twice on my site. Any ideas why? I am using the most current version of STS for RC1 stores.

 

Thanks.

 

Colin.

 

You can see what I mean here: My Website

 

Never mind...fixed it. classes/boxes.php was wrong.

Share this post


Link to post
Share on other sites
Hi,

 

Just installed STS on my OSC RC1 store, and haven;t turned anything on yet. I am getting the title "New products for July" twice on my site. Any ideas why? I am using the most current version of STS for RC1 stores.

 

Thanks.

 

Colin.

 

You can see what I mean here: My Website

Colin,

I went to your site and could tell right away that it was not a default version of Online Merchant RC1. You have made some modifications that may be causing the double header for your New Products Box.

 

You may have not installed STS correctly as well. Check the includes/classes/boxes.php file to be sure you made the correct modifications.

Edited by bkellum

Bill Kellum

 

Sounds Good Productions

STS Tutorials & more: STSv4.6, STS Add-ons (STS Power Pack), STS V4 Forum STS Forum FREE TEMPLATE

Share this post


Link to post
Share on other sites
Guest

Hello all,

I’m hoping someone can help with my problem. I am new to Oscommerce but have successfully, I think, installed Online Merchant v2.2 RC1 and managed to get the ‘default’ shop up and running (on localhost). I then applied contribution ‘UK Based Oscommerce 2.2’ which again appeared successful. Subsequently I applied the ‘STS v4.5.3’ contribution but now, when trying to open the Admin panel, I get the following error;

 

1146 - Table 'shopdb01.administrators' doesn't exist

select id from administrators limit 1

 

I have searched for this error on the forum but other than confirming the administrators table is missing there are no other clues.

 

I did find a post which referred to the administrator table but had no indication as to why it was 'additional'.

 

 

(I'm using the new osC v2.2 RC1 with the updated STS 4.5.3, and I've imported the database from my previous installation, adding the additional administrators table)

 

Is there a way of finding out if my install has failed and if, perhaps, there are more tables which I have missed – currently my ‘shopdb01’ has 46 tables.

 

Regards

Alan

Share this post


Link to post
Share on other sites

Hi Bill.

 

I have a question regarding the pop-up function for STS, I created my own template using your example as a guide, but whenever I click on an image the pop-up does not resize to the size of the picture. Any idea of where I went wrong, here is the code for my pop up image page.

 

<?php define ('STS_END_CHAR', '}'); ?>
<html $htmlparams}>
<head>
<!--$headcontent-->
<link rel="stylesheet" type="text/css" href="stylesheet.css">
<script language="javascript"><!--


function resize() {
 var i=0;
 var MarginW = 60;
 var MarginH = 140;

 if (document.layers) i=40;
 if (document.prodimage.width>document.bannerimage.width) {Width=document.prodimage.width +MarginW}
else Width = document.bannerimage.width+MarginW;
 Height = document.prodimage.height+document.bannerimage.height+MarginH;
 window.resizeTo(Width,Height);
 self.focus();
}
//--></script>
<?php // BOF: More Pics 6 ?>
<meta http-equiv="Page-Enter" content="blendTrans(Duration=0.5)">
<meta http-equiv="Page-Exit" content="blendTrans(Duration=0.5)">
<?php // EOF: More Pics 6 ?>
</head>
<body onLoad="resize();">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
 <tr>
<td width="28"><img border="0" src="styles/apollo/images/ttl.jpg" width="28" height="52"></td>
<td width="100%" background="styles/apollo/images/tt.jpg"> </td>
<td width="28"><img border="0" src="styles/apollo/images/ttr.jpg" width="28" height="52"></td>
 </tr>
 <tr>
<td width="28" background="styles/apollo/images/tl.jpg"> </td>
<td align="center" width="100%">$popupimage}</td>
<td width="28" background="styles/apollo/images/tr.jpg"> </td>
 </tr>
 <tr>
<td width="28"><img border="0" src="styles/apollo/images/tbl.jpg" width="28" height="55"></td>
<td width="100%" align="center" style="font-family: Arial; font-size: 8pt" background="styles/apollo/images/tb.jpg">$productname}$productmodel}</td>
<td width="28"><img border="0" src="styles/apollo/images/tbr.jpg" width="28" height="55"></td>
 </tr>
</table>

</body>

</html>


Powered By osC 2.2RC2a STS 4.5.8 - HTC 2.6.3 - FP 1.5.9 - BCH 1.0.0

Share this post


Link to post
Share on other sites
Hello all,

I’m hoping someone can help with my problem. I am new to Oscommerce but have successfully, I think, installed Online Merchant v2.2 RC1 and managed to get the ‘default’ shop up and running (on localhost). I then applied contribution ‘UK Based Oscommerce 2.2’ which again appeared successful. Subsequently I applied the ‘STS v4.5.3’ contribution but now, when trying to open the Admin panel, I get the following error;

 

1146 - Table 'shopdb01.administrators' doesn't exist

select id from administrators limit 1

 

I have searched for this error on the forum but other than confirming the administrators table is missing there are no other clues.

 

I did find a post which referred to the administrator table but had no indication as to why it was 'additional'.

 

 

 

 

Is there a way of finding out if my install has failed and if, perhaps, there are more tables which I have missed – currently my ‘shopdb01’ has 46 tables.

 

Regards

Alan

Alan,

This is not a STS issue but rather an osCommerce installation issue. I don't want to confuse the newbies trying to get STS running by trying to troubleshoot your problem within this thread.

 

Take a look at this link and ask your question there:

http://forums.oscommerce.com/index.php?sho...p;#entry1099572

 

:thumbsup: I will give you a hint though...Online Merchant RC1 has the osC 3.0 Admin Tool included which was not included with the UK version that you installed afterwards. This is most likely your issue. Please post any replies using the link above. Thanks and good luck.


Bill Kellum

 

Sounds Good Productions

STS Tutorials & more: STSv4.6, STS Add-ons (STS Power Pack), STS V4 Forum STS Forum FREE TEMPLATE

Share this post


Link to post
Share on other sites
Guest
Anne,

 

Did you not see my post regarding this same issue just one page back in this thread?

http://forums.oscommerce.com/index.php?s=&...t&p=1105585

 

Goodness. I didn't, and I wish I had, as it would have saved me quite a bit of work and head-scratching. I signed up for updates to the forum, and I always try to hunt before I ask, but the topic updates arrive in clumps all at the same time, and by the time they do, I've forged ahead. I've been fooling around with it on and off for months, but it wasn't until today that I saw the typo in the currency class.

 

Just my little contribution to lowering the signal-to-noise ratio. :) Oh, well. It was a good exercise for me to work on. Right? Right!

 

Thanks,

Anne

Share this post


Link to post
Share on other sites

Hi,

 

I have installed STS and successfully implemented a template system for my store- it works great, thanks!! :D

 

However, I do not know how to create a product template. I have read the user docs. and I can't get it to work. I have installed the neccessary module in the admin area. Anyone able to give me a step by step guide on what to do?

 

Cheers!

 

Andy.

Share this post


Link to post
Share on other sites

STS Is GREAT! One problem though....when I click on a category, and then on the product there are no images. I can see the image placeholders loading, but I only get the alt text for the images, and no buttons, except on the checkout page and beyond.

 

Example here: My Website

 

Thanks a ton,

Edited by colinz

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×