Jump to content

Claudia M

Member
  • Content Count

    444
  • Joined

  • Last visited

  • Days Won

    11

Everything posted by Claudia M

  1. That must have done it Brian. I'm no longer getting the orange error in admin/database. Thank you so much!
  2. Brian I cannot get this to work at all. Can I delete, drop, the custom_oid and query it back in correctly from the start? If so how would I word the query?
  3. " I believe you can just click the edit icon for custom_oid and change the BTREE to UNIQUE. " It will only let me change BTREE to HASH under advanced options/ Index type. When I try to change the INDEX choice to Unique is when I get the error. For the life of me I cannot find a custom_oid_2
  4. When I try to change the index to Unique I get this error, I don't have a column custom_oid_2 Error SQL query: ALTER TABLE `CubeCart_order_summary` ADD UNIQUE(`custom_oid`) MySQL said: #1062 - Duplicate entry '' for key 'custom_oid_2'
  5. I do have the 'live_from' column. I have tried to getthe "dimension_unit' column to say Yes 'cm' but it won't take I guess. I put the following in admin/Query MySQL Database ALTER TABLE `CubeCart_inventory` CHANGE `dimension_unit` `dimension_unit` VARCHAR(2) NULL DEFAULT 'cm'; #EOQ. This was straight from the 6.2.3 db file. I got the above to work. I'll see if I get more errors Now I keep getting this error: [20-Mar-2019 09:50:24 America/Louisville] PHP Warning: http_build_query() [<a href='http://docs.php.net/manual/en/function.http-build-query.php'>function.http-build-query.php</a>]: Parameter 1 expected to be Array or Object. Incorrect value given in /home/claudias/public_html/classes/db/database.class.php on line 522 ADMIN ERROR LOG: File: [database.class.php] Line: [556] "ALTER TABLE `CubeCart_inventory` CHANGE `dimension_unit` `dimension_unit` VARCHAR(2) NULL DEFAULT 'cm' " - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''cm'' at line 1 Also, what about that orange banner error. I seems I got that awhile back in another version. Thanks for all your help.
  6. Upon inspection it does seems that my database did upgrade. This is what I added back. Is it correct? And why am I still getting this orange error?
  7. I deleted the product_width, product_height, product_depth and dimension_unit fields from my database a few versions ago because I don't use them. When I upgraded to the next version it automatically readded them, so I deleted them again. I know, I know I should have left them alone and will once this is figured out. Anyway, upgraded to 6.2.4 and these fields were not automatically added and I don't have the tax_percent field either. I went ahead and added the product_width, product_height, product_depth and dimension_unit fields I also get the orange error in admin/database. CubeCart_order_summary.custom_oid has a key type KEY but expecting UNIQUE KEY. I have fields in the inventory table that I have added and what have been added via plugins. I don't think my database was updated when I upgraded to 6.2.4. In the 6.2.4 detup/db/upgrade file it says to CHANGE `dimension_unit` `dimension_unit` VARCHAR(2) NULL DEFAULT 'cm';. I don't know how to do that. I'd like to be sure my database is upgraded to the the current version 6.2.4. Anyway for me to check? When I upgraded I did get the red banner telling me to upgrade my database, which I did. Thanks for any and all help.
  8. Hey Brian, If I use the code you gave me it works like I want. Thanks so much!! {if $product.available and $product.ctrl_stock}
  9. Hey Brian, That worked if the item is unavailable (ie: listed on eBay etc.) But how do I NOT show the price ( or $0.00) if the item has sold? See the screenshot and my code earlier in this post.
  10. I dont know if one has to do with the other but here goes. I do not use the height, width, depth, dimensional unit fields provided by CubeCart. I have previously deleted all fields (and related fields) from the product_inventory database. I don't like having columns I don't use. Anyway, after updating to 6.2.4 I keep getting the following error in my error log. What should I do? Thanks in advance for any and all help. [10-Mar-2019 17:34:28 America/Louisville] PHP Warning: http_build_query() [<a href='http://docs.php.net/manual/en/function.http-build-query.php'>function.http-build-query.php</a>]: Parameter 1 expected to be Array or Object. Incorrect value given in /home/claudias/public_html/classes/db/database.class.php on line 522 [10-Mar-2019 18:03:25 America/Louisville] PHP Warning: http_build_query() [<a href='http://docs.php.net/manual/en/function.http-build-query.php'>function.http-build-query.php</a>]: Parameter 1 expected to be Array or Object. Incorrect value given in /home/claudias/public_html/classes/db/database.class.php on line 522 [10-Mar-2019 19:17:11 America/Louisville] PHP Warning: http_build_query() [<a href='http://docs.php.net/manual/en/function.http-build-query.php'>function.http-build-query.php</a>]: Parameter 1 expected to be Array or Object. Incorrect value given in /home/claudias/public_html/classes/db/database.class.php on line 522 [10-Mar-2019 19:19:35 America/Louisville] PHP Warning: http_build_query() [<a href='http://docs.php.net/manual/en/function.http-build-query.php'>function.http-build-query.php</a>]: Parameter 1 expected to be Array or Object. Incorrect value given in /home/claudias/public_html/classes/db/database.class.php on line 522 [10-Mar-2019 20:05:19 America/Louisville] PHP Warning: http_build_query() [<a href='http://docs.php.net/manual/en/function.http-build-query.php'>function.http-build-query.php</a>]: Parameter 1 expected to be Array or Object. Incorrect value given in /home/claudias/public_html/classes/db/database.class.php on line 522 [10-Mar-2019 20:33:38 America/Louisville] PHP Warning: http_build_query() [<a href='http://docs.php.net/manual/en/function.http-build-query.php'>function.http-build-query.php</a>]: Parameter 1 expected to be Array or Object. Incorrect value given in /home/claudias/public_html/classes/db/database.class.php on line 522 [10-Mar-2019 20:49:35 America/Louisville] PHP Warning: http_build_query() [<a href='http://docs.php.net/manual/en/function.http-build-query.php'>function.http-build-query.php</a>]: Parameter 1 expected to be Array or Object. Incorrect value given in /home/claudias/public_html/classes/db/database.class.php on line 522 [10-Mar-2019 20:55:30 America/Louisville] PHP Warning: http_build_query() [<a href='http://docs.php.net/manual/en/function.http-build-query.php'>function.http-build-query.php</a>]: Parameter 1 expected to be Array or Object. Incorrect value given in /home/claudias/public_html/classes/db/database.class.php on line 522
  11. How do you implement this? Are you suppose to be able to rearrange the admin menu? Thanks for any and all help https://github.com/cubecart/v6/issues/2181 Nevermind ... I found it!
  12. Thank you so much Brian. This was one of those annoying gnats in your ear things LOL
  13. I only use the grid view. Here is my custom code. Where do I make changes? Thanks Brian <div id="ccScroll"> <ul class="small-block-grid-2 medium-block-grid-3 large-block-grid-3 product_list" data-equalizer> {foreach from=$PRODUCTS item=product} <li> <form action="{$VAL_SELF}" method="post" class="panel add_to_basket"> <div class="product_grid_view"> <div data-equalizer-watch> <div class="text-center"> <a href="{$product.url}" title="{$product.name}"><img class="th" src="{$product.thumbnail}" alt="{$product.name}"></a> </div> <div class="pad-topbottom"><a href="{$product.url}" class="txt black nodecor" title="{$product.name}">{$product.name|truncate:65: "&hellip;"}</a></div> </div> <div class="med deep-red thinpad-bottom show-for-medium-up">Product Code:&nbsp;{$product.product_code}</div> {if $product.ctrl_sale}<span class="old_price">{$product.price}</span> <span class="sale_price">{$product.sale_price}</span> {else} <div class="pad-bottom txtmed bold"> {$product.price} {/if} <a class="right txt black" href="{$product.url}" title="{$product.name}" style="font-weight:normal">More Info</a></div> {if $product.available <= 0} <div class="row collapse marg-top"> <div class="small-12 columns"> <div class="buy_unavailable">See listing for details</div> </div> </div> {* ctrl_stock True when a product is considered 'in stock' for purposes of allowing a purchase, either by actually being in stock or via certain settings *} {elseif $product.ctrl_stock && !$CATALOGUE_MODE} <div class="row collapse marg-top"> <div class="small-12 columns "> <button type="submit" value="{$LANG.catalogue.add_to_basket}" class="button br4 expand">{$LANG.catalogue.add_to_basket}</button> <input type="hidden" name="add" value="{$product.product_id}"> </div> </div> {elseif !$CATALOGUE_MODE} <div class="row collapse marg-top"> <div class="small-12 columns"> <div class="buy_outofstock">SOLD</div> </div> </div> {/if} </div> </form> </li>
  14. On the skin category page I would like to remove the $0.00 price (price info completely) when the item is sold or unavailable (for sale elsewhere ex. eBay) but keep information lined up as is. Thanks for any and all help in this.
  15. I have the sales mode disabled. When I list an item on eBay or Etsy I put my price in in the sale price box of that product so I know what to charge for it if it doesn't sell on eBay or Etsy. Should I not do that?
  16. I got this several times in my system error log in admin. What does it mean and how do I fix it? Thanks in advance for any comments and help. File: [catalogue.class.php] Line: [1930] " " - Query was empty Today, 09:39 File: [catalogue.class.php] Line: [1932] "SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND " - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 And this was in the error log I created: [15-Feb-2019 09:39:38 America/Louisville] PHP Warning: Invalid argument supplied for foreach() in /home/claudias/public_html/classes/catalogue.class.php on line 258
  17. Sorry Brian I really don't know what you are talking about. This is what happens. First go to view basket no radio button is checked (dark full circle) though a shipping price shows. If I select a different method the dark circle shows and the rate automatically changes. But there is no dark circle in the newly selected method. Is this what you are talking about? If so I'd like the dark circle to always show the selected method if possible. Hope you understand what I'm saying. Thanks
  18. My update basket button is not working when a customer changes their shipping method. I use AIOS and usually the customer will have three options to choose from. If they select a different method than what is automatically applied (radio button) nothing happens. It seems to me the cart totals should be updated automatically. What's the purpose if they can't see their updated basket totals. Even when the Update Basket button is clicked nothing happens - no update to the shipping price. The only time it updates is when they select the continue to secure checkout button. The next page shows the selected shipping price. This happens if a customer is or is not logged in. Here is the code from my skin/checkout/template: <div class="clearfix"> <div class="show-for-medium-up"><a href="{$STORE_URL}/index.php?_a=basket&empty-basket=true" class="button alert left"><svg class="icon"><use xlink:href="#icon-trash-o"></use></svg> {$LANG.basket.basket_empty}</a></div> <div class="show-for-medium-up"><button type="submit" name="update" class="button secondary left" value="{$LANG.basket.basket_update}"><svg class="icon"><use xlink:href="#icon-refresh"></use></svg> {$LANG.basket.basket_update}</button></div> <div class="show-for-small-only"><button type="submit" name="update" class="button secondary left" value="{$LANG.basket.basket_update}"><svg class="icon"><use xlink:href="#icon-refresh"></use></svg> {$LANG.common.update}</button></div> I'm getting this error in my log: [28-Jan-2019 11:55:13 America/Louisville] PHP Warning: Shipping not setup or allow no shipping not enabled in /home/claudias/public_html/classes/cubecart.class.php on line 1707 ... And here is the code for that line area: } else { trigger_error('Shipping not setup or allow no shipping not enabled', E_USER_WARNING); unset($GLOBALS['cart']->basket['shipping'], $GLOBALS['cart']->basket['min_shipping_set']); // past 5.0.9 } Thanks in advance for any and all help
  19. I just updated to the current version of PayPal Pro 1.2.1 and I get the following warning: [27-Jan-2019 13:56:44 America/Louisville] PHP Warning: unlink(/home/claudias/public_html/includes/extra/PayPal_acceptance.js) [<a href='http://docs.php.net/manual/en/function.unlink.php'>function.unlink.php</a>]: No such file or directory in /home/claudias/public_html/modules/plugins/PayPal_Pro/admin/index.inc.php on line 56 I know it recommends using Smart Buttons but when I go to https://developer.paypal.com/developer/applications to get my client ID I have no idea how to set it up so I left it at redirect. If anyone wants to explain how to get a client ID I'm sure others would appreciate it too. Anyway, is this warning anything to worry about? Thanks in advance for any and all help Claudia
×
×
  • Create New...