ARRAY?
Using Jamroom
Have you run the integrity check after upgrading?
https://www.jamroom.net/the-jamroom-network/forum/announcements/46096/jamroom-6-upgrade-guide
Forum Activity for @ultrajam
Using Jamroom
Have you run the integrity check after upgrading?
https://www.jamroom.net/the-jamroom-network/forum/announcements/46096/jamroom-6-upgrade-guide
Follow me ssl browser issues
Jamroom Developers
Have you switched your site to use ssl and then emptied the caches? When I click a link to your profile page from the home page I see errors like
Quote: Blocked loading mixed active content "http://centricbeats.com/data/cache/jrFollowMe/S0b0193d5cfcf8820ebdb8f7d459a72f8.css"
Follow me ssl browser issues
Jamroom Developers
It's not really possible to read that as you have compressed and encoded the html?
Do you have a link?
Follow me ssl browser issues
Jamroom Developers
Look at the source of your page and find where you have a link to a script which starts with http://
That will need to be changed to https:// if you want to use ssl
Managing power users
Using Jamroom
The $owner array will contain user data like this:
Quote: _created => "1456233333"
_profile_id => "1076"
_updated => "1475156456"
_user_id => 77
user_active => "1"
user_email => "stevex@blah.com"
user_group => "user"
user_image_extension => "jpg"
user_image_height => "768"
user_image_name => "user_image.jpg"
user_image_size => "33658"
user_image_time => "1464777777"
user_image_type => "image/jpeg"
user_image_width => "1164"
user_jrGoogleAnalytics_cid => "6786786768-262c-4d5a-926b-sdfgsdfg"
user_jrTips_enabled => "on"
user_language => "en-US"
user_last_login => "1475147751"
user_name => "SteveX"
user_validate => "4e94d345345e232343242435"
user_validated => "1"
_profile_id => "1076"
_updated => "1475156456"
_user_id => 77
user_active => "1"
user_email => "stevex@blah.com"
user_group => "user"
user_image_extension => "jpg"
user_image_height => "768"
user_image_name => "user_image.jpg"
user_image_size => "33658"
user_image_time => "1464777777"
user_image_type => "image/jpeg"
user_image_width => "1164"
user_jrGoogleAnalytics_cid => "6786786768-262c-4d5a-926b-sdfgsdfg"
user_jrTips_enabled => "on"
user_language => "en-US"
user_last_login => "1475147751"
user_name => "SteveX"
user_validate => "4e94d345345e232343242435"
user_validated => "1"
Managing power users
Using Jamroom
jrProfile_get_owner_info will return an array of the profile owners.
You can use it in a template like this:
{$_owners = jrProfile_get_owner_info($_profile_id)}
{foreach $_owners as $owner}
{$owner.user_name}<br>
{/foreach}Beta 8 errors with custom module
Jamroom Developers
Doh! Of course!
That brings my items back
Thanks Brian!
Beta 8 errors with custom module
Jamroom Developers
On my work test site, after upgrading to Beta 8 from 5.3.6 my microsites disappear on the profile's microsites index, and also when visiting a microsite page. (ujMicroSite is a sectional module similar to jrDocs).
Any clues as to why these errors are occurring would be much appreciated.
When viewing the profile list of microsites:
Quote: Data
Array
(
[error] => Query Error: Unknown column 'a._profile_id' in 'where clause'
[_post] => Array
(
[_uri] => /steve/microsite
[module_url] => steve
[module] =>
[option] => microsite
[_profile_id] => 1
)
[query] => /* [Steve] :/steve/microsite */ SELECT COUNT(a.`_item_id`) AS tc FROM jr_ujmicrosite_item_key a
JOIN jr_ujmicrosite_item_key b ON (b.`_item_id` = a.`_item_id` AND b.`key` = 'micro_section_type' AND b.`value` = 'header')
WHERE ((a.`key` = 'micro_category') OR (a.`key` = '_created' AND a.`_item_id` NOT IN(SELECT `_item_id` FROM jr_ujmicrosite_item_key WHERE `key` = 'micro_category')))
AND a.`_profile_id` IN(1)
GROUP BY a.`value`
)
Array
(
[error] => Query Error: Unknown column 'a._profile_id' in 'where clause'
[_post] => Array
(
[_uri] => /steve/microsite
[module_url] => steve
[module] =>
[option] => microsite
[_profile_id] => 1
)
[query] => /* [Steve] :/steve/microsite */ SELECT COUNT(a.`_item_id`) AS tc FROM jr_ujmicrosite_item_key a
JOIN jr_ujmicrosite_item_key b ON (b.`_item_id` = a.`_item_id` AND b.`key` = 'micro_section_type' AND b.`value` = 'header')
WHERE ((a.`key` = 'micro_category') OR (a.`key` = '_created' AND a.`_item_id` NOT IN(SELECT `_item_id` FROM jr_ujmicrosite_item_key WHERE `key` = 'micro_category')))
AND a.`_profile_id` IN(1)
GROUP BY a.`value`
)
When viewing a page:
Quote:
Array
(
[error] => Query Error: Unknown column 'a._profile_id' in 'where clause'
[_post] => Array
(
[_uri] => /steve/microsite/workbook-features/2/question-types
[module_url] => steve
[module] => ujMicroSite
[option] => workbook-features
[_1] => workbook-features
[_2] => 2
[_3] => question-types
[_profile_id] => 1
)
[query] => /* [Steve] :/steve/microsite/workbook-features/2/question-types */ SELECT a.`_item_id` AS _item_id FROM jr_ujmicrosite_item_key a
JOIN jr_ujmicrosite_item_key b ON (b.`_item_id` = a.`_item_id` AND b.`key` = 'micro_group_id' AND b.`value` = '2')
WHERE ((a.`key` = 'micro_section_order') OR (a.`key` = '_created' AND a.`_item_id` NOT IN(SELECT `_item_id` FROM jr_ujmicrosite_item_key WHERE `key` = 'micro_section_order')))
AND a.`_profile_id` IN(1)
ORDER BY FIELD(a.`key`, '_created', 'micro_section_order') ASC, (a.`value` + 0) ASC LIMIT 500
)
Array
(
[error] => Query Error: Unknown column 'a._profile_id' in 'where clause'
[_post] => Array
(
[_uri] => /steve/microsite/workbook-features/2/question-types
[module_url] => steve
[module] => ujMicroSite
[option] => workbook-features
[_1] => workbook-features
[_2] => 2
[_3] => question-types
[_profile_id] => 1
)
[query] => /* [Steve] :/steve/microsite/workbook-features/2/question-types */ SELECT a.`_item_id` AS _item_id FROM jr_ujmicrosite_item_key a
JOIN jr_ujmicrosite_item_key b ON (b.`_item_id` = a.`_item_id` AND b.`key` = 'micro_group_id' AND b.`value` = '2')
WHERE ((a.`key` = 'micro_section_order') OR (a.`key` = '_created' AND a.`_item_id` NOT IN(SELECT `_item_id` FROM jr_ujmicrosite_item_key WHERE `key` = 'micro_section_order')))
AND a.`_profile_id` IN(1)
ORDER BY FIELD(a.`key`, '_created', 'micro_section_order') ASC, (a.`value` + 0) ASC LIMIT 500
)
updated by @ultrajam: 02/24/17 11:56:19AM
Truncated description causes missing div tag
Jamroom Developers
discuss_description is probably an editor field which would save html to the database.
You can get rid of the html using the jrCore_strip_html smarty modifier before you truncate:
{$item.discuss_description|jrCore_strip_html|truncate:120}Just Purchased Google Maps Module
GoogleMaps
When you create the key, set the Key Restriction to: HTTP referrers (web sites)
Then add your domain to Accept requests from...
*.yoursite.com/*
