digital scrapbooking
computer scrapooking

Go Back   SBB Digital Scrapbooking Forums | Scrapbook-Bytes > Announcements > Comments, Suggestions, & Technical Assistance

 

Comments, Suggestions, & Technical Assistance Thread, Error in the store? in Announcements; Is it error ? I was browsing Tracy Ann's Kits today but sudden it came up this.. hihihi INVALID SQL: ...
Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 12-08-2006
Edhish's Avatar
Registered User
 
Join Date: Apr 2005
Location: Sweden
Posts: 2,574
Thanks: 0
Thanked 1 Time in 1 Post
Error in the store?

Is it error ? I was browsing Tracy Ann's Kits today but sudden it came up this.. hihihi

INVALID SQL: 1146 : Table 'scrapboo_sbbxcart4.xcart_categories' doesn't exist
SQL QUERY FAILURE: SELECT xcart_categories.categoryid,xcart_categories.paren tid,xcart_categories.categoryid_path,xcart_categor ies.category,xcart_categories.product_count,xcart_ categories.avail,xcart_categories.order_by,IF(xcar t_categories_lng.category != '', xcart_categories_lng.category, xcart_categories.category) as category,xcart_categories_subcount.subcategory_cou nt, xcart_categories_subcount.product_count,IF(xcart_i cons.image_path != '','Y','') as is_icon, xcart_icons.image_path FROM xcart_categories USE INDEX (am) LEFT JOIN xcart_categories_lng USE INDEX (PRIMARY) ON xcart_categories_lng.code='US' AND xcart_categories_lng.categoryid=xcart_categories.c ategoryid LEFT JOIN xcart_categories_subcount USE INDEX (PRIMARY) ON xcart_categories_subcount.categoryid = xcart_categories.categoryid AND xcart_categories_subcount.membership = xcart_categories.membership LEFT JOIN xcart_icons ON xcart_categories.categoryid = xcart_icons.categoryid WHERE xcart_categories.avail='Y' AND xcart_categories.membership IN('', '') GROUP BY xcart_categories.categoryid ORDER BY xcart_categories.order_by, xcart_categories.category
INVALID SQL: 1146 : Table 'scrapboo_sbbxcart4.xcart_categories' doesn't exist
SQL QUERY FAILURE: SELECT COUNT(xcart_products.productid), MIN(xcart_pricing.price) as price , xcart_products_lng.product as product_lng, xcart_products_lng.descr as descr_lng, xcart_products_lng.full_descr as fulldescr_lng, IF(xcart_variants.variantid IS NOT NULL,'Y','') as is_variant, IF(xcart_classes.classid IS NOT NULL,'Y','') as is_product_options, MIN(v_pricing.price) as v_price FROM xcart_products, xcart_pricing , xcart_featured_products, xcart_products_categories, xcart_categories LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'US' LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid LEFT JOIN xcart_pricing as v_pricing ON v_pricing.variantid = xcart_variants.variantid AND v_pricing.quantity = 1 AND v_pricing.membership IN ('','') WHERE xcart_products.productid=xcart_featured_products.p roductid AND xcart_featured_products.avail='Y' AND xcart_featured_products.categoryid='0' AND xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND xcart_pricing.variantid = 0 AND xcart_products_categories.productid=xcart_products .productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.membership IN ('','') AND xcart_categories.avail = 'Y' AND xcart_products.forsale='Y' GROUP


Oh I hope this will be over soon..
__________________


MY FAVE SCANDINAVIAN FORUM
Need QP's? Contact me here ---> My Portfolio
:wub
Reply With Quote TOP
  #2 (permalink)  
Old 12-08-2006
danib's Avatar
Design Team Member
 
Join Date: Jan 2004
Location: in the sticks
Posts: 6,259
Thanks: 0
Thanked 0 Times in 0 Posts
try again, and see if you get the error. I just poked around Tracy's shop and didn't get an error.
__________________
Dani B.

My Gallery!
My little Blog
Reply With Quote TOP
  #3 (permalink)  
Old 12-08-2006
Edhish's Avatar
Registered User
 
Join Date: Apr 2005
Location: Sweden
Posts: 2,574
Thanks: 0
Thanked 1 Time in 1 Post
oh ok.. can't wait to shop.. thanks dani
__________________


MY FAVE SCANDINAVIAN FORUM
Need QP's? Contact me here ---> My Portfolio
:wub
Reply With Quote TOP
  #4 (permalink)  
Old 12-08-2006
~Amy~'s Avatar
Administrator
 
Join Date: Jan 2003
Location: Newark Valley
Posts: 12,213
Thanks: 27
Thanked 123 Times in 70 Posts
that was just me working on some things It was probably only there for about 5 minutes; thanks for letting us know though!
__________________

~ SBB Owner/Founder ~
Visit my blog!
Reply With Quote TOP
  #5 (permalink)  
Old 12-08-2006
Edhish's Avatar
Registered User
 
Join Date: Apr 2005
Location: Sweden
Posts: 2,574
Thanks: 0
Thanked 1 Time in 1 Post
oh ok.. thanks ladies.. :hugs:
__________________


MY FAVE SCANDINAVIAN FORUM
Need QP's? Contact me here ---> My Portfolio
:wub
Reply With Quote TOP
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT -4. The time now is 06:58 AM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0 RC5
©2003-2008 Scrapbook-Bytes

Home  :  Terms of Use  :  Privacy Policy  :  Site Map  :  Contacts

NEW SERVER
Google



  Digital Scrapbooking Top50