blog documentation FAQ followers forum marketplace services youtube

store items that don't exist in datastore showing up in store

The Jamroom Network » Forum » Ning To Jamroom » Page » store items that don't exist in datastore showing up in store
soaringeagle
@soaringeagle
10 years ago
3,304 posts
http://www.greentechnologyforums.com/shops
i have a few garbled up displays
these might be the songs for sale that werent showing up bvefore?
but they arent displaying right
i am planning to go live tonight or tomorow if ican get the store cleaned up in time

i think these must be the songs for sale that wernt evven showing up before?


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
updated by @soaringeagle: 02/15/15 08:35:12AM
paul
@paul
10 years ago
4,335 posts
Well, the error messages say it all really - you need to get a valid _item_id into to delete button smarty call.


--
Paul Asher - JR Developer and System Import Specialist
soaringeagle
@soaringeagle
10 years ago
3,304 posts
ugh
deleted all test shops
now left alotta orphaned items that dont exist


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
soaringeagle
@soaringeagle
10 years ago
3,304 posts
paul:
Well, the error messages say it all really - you need to get a valid _item_id into to delete button smarty call.

the problem is the shops were deleted the data ittems dont exist inb the datastore but somehow the lisat still thinks they exist


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
soaringeagle
@soaringeagle
10 years ago
3,304 posts
even went into the database there were 2 jrstore_item records deleted those but still see these

and checked foxycart and store items and item keys
theres like 20000 or more bundle item keys no idea what thats all abouit but wasnt goingto touch that


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
paul
@paul
10 years ago
4,335 posts
Are you sure its not caching somewhere causing them to remain?


--
Paul Asher - JR Developer and System Import Specialist
soaringeagle
@soaringeagle
10 years ago
3,304 posts
cleared template cache browser cache checked datastores checked database
where else should i look


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
soaringeagle
@soaringeagle
10 years ago
3,304 posts
wait
maybe
in database jrcore_cache i do see 2 jrstore

uis it safe (i assime) to drop all tables in the cache clearing it out


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
soaringeagle
@soaringeagle
10 years ago
3,304 posts
i deleted all 10 jrStore iitems from database cache and still they re,main


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
soaringeagle
@soaringeagle
10 years ago
3,304 posts
nothing in database cache for foxycart anything
im stumped i have no idea where these are coming from or how to remove them


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
soaringeagle
@soaringeagle
10 years ago
3,304 posts
any jr team is it safe to empty the jrcore_cache database
is there anything eklse u can think of that will make this go away


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
soaringeagle
@soaringeagle
10 years ago
3,304 posts
if theres something in cache i sure as hell cant find it looked in aevery cache folder on the server in the database
i have no profiles in the shops quota
nothing in darastores
ill go through the database cache again but i think i cleared out anything that could cause it

oh wait

mysql temp
one and only place i hadnt looked


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
soaringeagle
@soaringeagle
10 years ago
3,304 posts
ok debug shows this

{$_items} 	Array (1)
0 => Array (4)
  seamless_list_rank => 1
  seamless_module_name => "jrStore"
  seamless_module_prefix => "product"
  seamless_module_title => "products"
and further down

{$item} 	Array (4)
seamless_list_rank => 1
seamless_module_name => "jrStore"
seamless_module_prefix => "product"
seamless_module_title => "products"

furthermore the jrstore_item_count says 0


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
michael
@michael
10 years ago
7,778 posts
Any datastore is made up of 2 tables in the database.

For store it will be something like:
jr_jrstore_item
jr_jrstore_item_key

The jr_jrstore_item will just be 1 column with numbers like:
1
2
3
4
5

and the jr_jrstore_item_key will be all the data related to each of those items. The _item_id column corresponds the item_id.

So if you delete both those tables then run the integrity check the tables will be re-created and empty.
soaringeagle
@soaringeagle
10 years ago
3,304 posts
ok the 1 table was empty the other has waytyyyy more stuff then i exxpected

thnx your a lifesaver this 1 had mestumped


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
soaringeagle
@soaringeagle
10 years ago
3,304 posts
you know i think you guys are masterminds but it takes all 4 of you to make 1 complete genius
cause every time it seems like each of u provides a peice of the puzzle but takes all 4 to put it all together
thsat did the trick
and my panic attacks over


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
gary.moncrieff
gary.moncrieff
@garymoncrieff
10 years ago
865 posts
Each member of the team concentrate on different areas of the product.
soaringeagle
@soaringeagle
10 years ago
3,304 posts
oh yes i know they do but they also think differently respond diferently make diferent mistakes
but together they are superhuman coding machines


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities

Tags