solved Aparna Module giving error using proxima

serveion
@serveion
8 years ago
223 posts
Hello

I update the jamroom system to the later version and a lot of modules everything is working fine until we find the module we create using Aparna is this case name promotion is getting an error i posted the error bellow.

if we go to the website the audio works but if we go to the proxima and request that audio it don't work.

(2016-12-19T18:46:45+00:00.0.56908900 : 0)-(mem: 5MB)-(pid: 6652)-(ip: 172.68.102.162)-(uri: GET /promotion/stream/promotion_audio/11)
Array
(
[error] => Query Error: Unknown column 'a._profile_id' in 'where clause'
[_post] => Array
(
[_uri] => /promotion/stream/promotion_audio/11
[module_url] => promotion
[module] => xxPromotion
[option] => stream
[_1] => promotion_audio
[_2] => 11
)

[query] => /* [visitor]:/promotion/stream/promotion_audio/11 */ SELECT a.`_item_id` AS _item_id FROM jr_xxpromotion_item_key a
WHERE (a.`key` = '_created' AND a.`_item_id` = '11')
AND a.`_profile_id` NOT IN(210)
LIMIT 1 
)

(2016-12-19T18:46:46+00:00.0.76263000 : 0)-(mem: 5MB)-(pid: 6659)-(ip: 172.68.102.162)-(uri: GET /promotion/stream/promotion_audio/11)
Array
(
[error] => Query Error: Unknown column 'a._profile_id' in 'where clause'
[_post] => Array
(
[_uri] => /promotion/stream/promotion_audio/11
[module_url] => promotion
[module] => xxPromotion
[option] => stream
[_1] => promotion_audio
[_2] => 11
)

[query] => /* [visitor]:/promotion/stream/promotion_audio/11 */ SELECT a.`_item_id` AS _item_id FROM jr_xxpromotion_item_key a
WHERE (a.`key` = '_created' AND a.`_item_id` = '11')
AND a.`_profile_id` NOT IN(210)
LIMIT 1 
)

(2016-12-19T18:46:48+00:00.0.84147800 : 0)-(mem: 5MB)-(pid: 6663)-(ip: 172.68.102.162)-(uri: GET /promotion/stream/promotion_audio/11)
Array
(
[error] => Query Error: Unknown column 'a._profile_id' in 'where clause'
[_post] => Array
(
[_uri] => /promotion/stream/promotion_audio/11
[module_url] => promotion
[module] => xxPromotion
[option] => stream
[_1] => promotion_audio
[_2] => 11
)



updated by @serveion: 03/21/17 07:13:44PM
brian
@brian
8 years ago
10,148 posts
Make sure you run an integrity check:

https://www.jamroom.net/the-jamroom-network/documentation/getting-started/4581/upgrading-jamroom-5-to-jamroom-6


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
michael
@michael
8 years ago
7,744 posts
Things to try in order:
* run the integrity check. (then see if it works, also reset the caches)
Could be that something needs fixing up.

* update one of the promotion_audio items
It seams like there is a missing _profile_id value from the datastore which I would have expected would be there when the item was created. Thinking maybe that updating, or creating a new one will add that item in.
serveion
@serveion
8 years ago
223 posts
hello

doing the integrity check worked, i just open the app and try the audio and it works perfect.

i forgot about doing integrity check after every update.

thank you so much.
paul
@paul
8 years ago
4,330 posts
Quote: i forgot about doing integrity check after every update.
Not every update needs it, but running the IC (and clearing caches) after an update will do no harm, so its a good routine to get in to.


--
Paul Asher - JR Developer and System Import Specialist

Tags