Forum Activity for @soaringeagle

soaringeagle
@soaringeagle
10/17/16 04:44:11PM
3,304 posts

cri mysql error in shops...only when logged out


Design and Skin Customization

woot
but will old jr 5 skins work on jr 6 will they need to be adapted

please tell me that a search, and shops updates are coming too soon
because im stuck on old sitebuilder thats not going to screw me or is the jr 6 sb going to function the way i hope
soaringeagle
@soaringeagle
10/17/16 01:04:17PM
3,304 posts

cri mysql error in shops...only when logged out


Design and Skin Customization

oh your right sorry ...when i say updated to newest that includes beta
version: 5.4.0b4
ok good to know
hope a fix is scheduled soonish?
soaringeagle
@soaringeagle
10/16/16 08:28:23PM
3,304 posts

cri mysql error in shops...only when logged out


Design and Skin Customization

{jrSeamless_list modules="jrFoxyCartBundle,jrStore" limit="8" order_by="product_qty random" }
soaringeagle
@soaringeagle
10/16/16 11:51:38AM
3,304 posts

cri mysql error in shops...only when logged out


Design and Skin Customization

and since im not getting debug to work what other keys can be used to randomize thatlist
soaringeagle
@soaringeagle
10/16/16 11:49:24AM
3,304 posts

cri mysql error in shops...only when logged out


Design and Skin Customization

i think i understand the issue maybe
order_by="product_qty random"

is product_qty not common to jrStore and jrFoxyCartBundle?
or is the randomizing of that causing issues
soaringeagle
@soaringeagle
10/16/16 11:31:35AM
3,304 posts

cri mysql error in shops...only when logged out


Design and Skin Customization

debug entry 	
Key 	Value
Message 	Query Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY RAND() LIMIT 1000000' at line 3
Date 	10/16/16 02:23:05PM
IP Address 	54.175.227.92
URL 	/shops
Memory 	21.5MB
Data 	
Array
(
    [error] => Query Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY RAND() LIMIT 1000000' at line 3
    [_post] => Array
        (
            [_uri] => /shops
            [module_url] => shops
            [module] => 
        )

    [query] => SELECT a.`_item_id` AS _item_id FROM jr_jrfoxycartbundle_item_key a
JOIN jr_jrfoxycartbundle_item_key pr ON (pr.`_item_id` = a.`_item_id` AND pr.`key` = '_profile_id' AND pr.`value` NOT IN(1081, 1414, 2312, 2336, 2419, 2699, 2803, 3091, 3959, 5172, 5225, 6523, 6743, 7802, 7845, 8238, 8343, 8664, 8820, 9233, 9667, 9751, 9865, 10202, 10860, 10922, 11183, 11529, 11848, 12128, 12488, 13167, 13483, 13589, 13779, 13858, 13861, 13879, 13885, 13930, 13942, 13973, 13979, 13980, 14027, 14094, 14114, 14146, 14152, 14161, 14202, 14240, 14251, 14275, 14372, 14377, 14392, 14524, 14579, 212, 354, 12446, 14384, 14414, 14609, 14618, 14621, 14630, 14635, 14640))
WHERE ORDER BY RAND() LIMIT 1000000 
)
soaringeagle
@soaringeagle
10/16/16 11:17:50AM
3,304 posts

cri mysql error in shops...only when logged out


Design and Skin Customization

latest core.. everything except sitebuilder and ningja is always updated immediately
and no it has nothing to do with debug i just couldnt get debug to work
though i didnt put it directly int the template
it only affects it when not logged in as admin
will look into log and reply
soaringeagle
@soaringeagle
10/15/16 07:36:06AM
3,304 posts

maybe a bug in itemlist maybe only in tabbed containers


Using Jamroom

hmm musta been server cache.. now i' getting them
ofcourse what you suggested was 1st thing i tried, that's when no ds elements at all showed up in the list
it was blank
i tried multiple hard refreshes, loging in and out.. etc
the list was just blank but not anymore...
weird but glad its not a bug just a temp issue
soaringeagle
@soaringeagle
10/14/16 07:40:55PM
3,304 posts

maybe a bug in itemlist maybe only in tabbed containers


Using Jamroom

managed to get the results i wanted using template code, but the disappearing options in the item list option are troublesome
  96