Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


bsmither last won the day on July 31

bsmither had the most liked content!

Profile Information

  • Gender
  • Location
    Pacific Coast

Recent Profile Visitors

92,038 profile views

bsmither's Achievements


Enthusiast (6/14)

  • Very Popular Rare
  • Conversation Starter Rare
  • Dedicated Rare
  • First Post Rare
  • Collaborator Rare

Recent Badges



  1. So, regardless of which you use for: {$product.whatever} in, for example: <td><span class="editable number" name="product[{$product.product_id}][begin]">{$product.begin}</span></td> the Smarty diagnostic window says it is a zero-length-string, but what gets displayed is null. That's crazy.
  2. That's strange. As you said, begin => "".
  3. So: Was: <td><span class="editable number" name="product[{$product.product_id}][redo_start]">{$product.redo_start}</span></td> Now: <td><span class="editable number" name="product[{$product.product_id}][begin]">{$product.begin}</span></td> And the database column name has been changed from 'redo_start' to 'begin'. Or do you assign the query result 'redo_start' to the product array element 'begin' that is given to Smarty?
  4. For the template you posted part of above, add at the end of that file this: {debug} This will have the browser popup a window showing the values of $product and the array that $product came from ($PRODUCTS?). What is the <div> statement doing? What is $PRODUCT.redo_start? I think the <div> block is where you are adding/editing data for a specific product. So, we won't worry about that.
  5. CubeCart's admin does not use the cache, so changes made that get databased show in admin immediately.
  6. In phpMyAdmin, when at the "Browse" tab looking at the CubeCart_inventory table, for those rows that do not have an actual date in 'redo_start', does the cell show NULL or is it blank?
  7. Try this: {foreach from=$SUBCATS item=subcat} <div class="subcategory product-list"> <a class="image" href="{$subcat.url}" title="{$subcat.cat_name}"><img src="{$subcat.cat_image}" alt="{$subcat.cat_name}" /></a> <p><a href="{$subcat.url}" title="{$subcat.cat_name}">{$subcat.cat_name}</a></p> </div> {/foreach} This evens out the sub-cat listing, except for a category name that takes two lines.
  8. In the Default column, choosing 'As Defined:' is a good choice. The text entry field that then appears would be left blank. All nulls should be converted to a blank string.
  9. All four of those images appear to be identical. In the Default column, is there a choice for a string? An empty string?
  10. Which approach are you wanting to do? Change how nulls get displayed, or change the value that the database table is allowed to hold? Using phpMyAdmin, have it show the list of columns for the Cubecart_inventory table. For each column you need to change, uncheck the "Allow null" option, and for the default value, choose a string with nothing entered in the text entry field. The database engine might then automatically change the nulls to a zero-length-string. Or it might not. Or phpMyAdmin may report that altering the columns can't happen as long as there are rows with values that would become disallowed. I'm not sure. Once the changes to the database is finished, clear the cache, and then those data items ('Start', 'End') will show a zero-length-string.
  11. The application is showing null because it was programmed that way. The application code could be rewritten to not show 'null' even if the value of that column in the database table is, in fact, null. Likewise, one can alter the database table schema so that a column must not hold a null, and must therefore default to a zero-length-string. (Using phpMyAdmin will make this alteration a very easy thing to do.) Please note there are some conceptual differences between null and a zero-length-string. Perhaps these differences make no difference to your needs.
  12. CubeCart is very good at figuring out where it is. But this is based on what the web server tells PHP in the $_SERVER array (you can see this array in admin, PHP Info, near the bottom). Clear the cache first (as CubeCart wants to use the FQDN URL in the HTML snippet having the list of categories and was cached). So, just tell the web server (vhost file) what new domain name it is to answer to, keeping the 'rootdoc' directory the same.
  13. You could copy/paste the file /cache/abcde.html.skin.menu.lang.cache, but it won't last long, and you will be taken by surprise when it happens. I see code in the admin Product Import feature that looks at a heading named 'cat_id' which will accept either a comma-separated list of ID numbers, or a comma-separated list of category names. I think each item in the name list can be expressed as a slash-separated hierarchy of category names. The first item in the list will be the item's primary category. But the most easiest is to have phpMyAdmin export the CubeCart_category database table to a SQL type of file, then import that SQL file via phpMyAdmin to the other database.
  14. I would ask that you read these threads. Please follow up with questions if you need more guidance. https://forums.cubecart.com/topic/51635-product-options/ https://forums.cubecart.com/topic/47004-product-options-and-stock-levels-how/ https://forums.cubecart.com/topic/50884-options-matrix-how-does-this-work/
  15. I have experimented with PHP 8, and, yes, there are a couple of things that need changing in the core code. However, one real biggie is that Smarty (the template engine) does not yet work all that reliably under PHP 8 - especially the way CubeCart codes the Smarty templates.
  • Create New...