Jaxel
Well-known member
yesFixed a huge security exploit! THIS IS IMPORTANT!
was this the one I pm'ed you about? if so I'll install this again
-
This forum has been archived. New threads and replies may not be made. All add-ons/resources that are active should be migrated to the Resource Manager. See this thread for more information.
[8wayRun.Com] XenPorta (Portal)
- Thread starter Jaxel
- Start date
- Status
x4rl
Well-known member
Awesome great work Jaxel many thanks
yavuz
Well-known member
Jaxel I'm getting following error when I select forums to show with recent threads:
Rich (BB code):
Server Error
Mysqli statement execute error : Data too long for column 'setting_value' at row 1
- Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
- Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
- Zend_Db_Adapter_Abstract->query() in EWRporta/Model/Settings.php at line 68
- EWRporta_Model_Settings->updateSettings() in EWRporta/ControllerPublic/Portal.php at line 80
- EWRporta_ControllerPublic_Portal->actionEdit() in XenForo/FrontController.php at line 310
- XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
- XenForo_FrontController->run() in /home/user/public_html/index.php at line 17
Jaxel
Well-known member
Damn man... how many forums do you have? Go into your database, EWRporta_settings and change the size of setting_value from varchar(255) to varchar(1024)
yavuz
Well-known member
Oh too much
Thanks Jaxel.One more thing, after updating the portal www. prefix from the domain disappeard :S There is still www. in my admincp.
Jaxel
Well-known member
The portal now canonicalizes the link... so if you are using the index router, it will update the URL. If you want the WWW to show up, you need to make sure the WWW is included in your basic board information in your admin CP.Oh too much
One more thing, after updating the portal www. prefix from the domain disappeard :S There is still www. in my admincp.
yavuz
Well-known member
It's included Jaxel:
But it's not affecting the url I guess. Why I'm asking? I have 20.000 URL's indexed and worrying if this will affect these url's.
yavuz
Well-known member
I was viewing a cached version, back to normal. Sorry for the hassle.
iTuN3r
Well-known member
Anything about this i am having this strange issue in FF i checked from laptop too it's same issue.
Jaxel
Well-known member
Works fine for me... you must select the forums itself, you can't select the parents.
Renada
Active member
Yep, I have this issue too.
Also after upgrading the Recent Threads module appears to have reverted to only pulling threads from one forum. All forums (minus the categories) are selected but it pulls from the first forum in the list only.
Regards,
Renada
unkn0wn
Member
I've downloaded the add-on from first post, why my promoted thread (I have one), facebook, twitter won't show up on the portal?
Here is the screenshot:
View attachment 12668
Can anyone help me?
Thank you
Hi Jaxel, can you help me why my promoted thread won't show up on the portal?
Thank you..
Jaxel
Well-known member
Try the attached file... if it still doesnt work, put your forum in debug mode and give me the query for the recentthreads module that is being run on your forum. Otherwise I can't fix it, because this works perfectly fine on my forum.
Jaxel
Well-known member
Are you using geekshed? I've said many times that the chatUsers module ONLY works with geekshed.
ddmmh
Well-known member
Yes I know you have and yes I am using geekshed. Doesnt work on local or on my website this version or last.
ddmmh
Well-known member
This may help also, only error in error log... same time as I was trying to see if the chatusers module worked again.. probably related??
Code:
rror Info
ErrorException: Undefined index: nick - library/EWRhabla/Model/Chat.php:22
Generated By: Seb, Today at 6:33 PM
Stack Trace
#0 /home/ddmmh/public_html/community/library/EWRhabla/Model/Chat.php(22): XenForo_Application::handlePhpError(8, 'Undefined index...', '/home/ddmmh/pub...', 22, Array)
#1 /home/ddmmh/public_html/community/library/EWRporta/Block/ChatUsers.php(17): EWRhabla_Model_Chat->fetchUsers('#mmazone')
#2 /home/ddmmh/public_html/community/library/EWRporta/ViewPublic/Portal.php(96): EWRporta_Block_ChatUsers->getModule(false, 1)
#3 /home/ddmmh/public_html/community/library/EWRporta/ViewPublic/Portal.php(46): EWRporta_ViewPublic_Portal->getModuleParams(Array, 1)
#4 /home/ddmmh/public_html/community/library/XenForo/ViewRenderer/Abstract.php(222): EWRporta_ViewPublic_Portal->renderHtml()
#5 /home/ddmmh/public_html/community/library/XenForo/ViewRenderer/HtmlPublic.php(67): XenForo_ViewRenderer_Abstract->renderViewObject('EWRporta_ViewPu...', 'Html', Array, 'EWRporta_Portal')
#6 /home/ddmmh/public_html/community/library/XenForo/FrontController.php(533): XenForo_ViewRenderer_HtmlPublic->renderView('EWRporta_ViewPu...', Array, 'EWRporta_Portal', NULL)
#7 /home/ddmmh/public_html/community/library/XenForo/FrontController.php(156): XenForo_FrontController->renderView(Object(XenForo_ControllerResponse_View), Object(XenForo_ViewRenderer_HtmlPublic), Array)
#8 /home/ddmmh/public_html/community/index.php(17): XenForo_FrontController->run()
#9 {main}
Request State
array(3) {
["url"] => string(32) "http://mmazone.com.au/community/"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}
estranged
Well-known member
Attached file didn't work either.
Code:
SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
node.title AS node_title,
GREATEST(COALESCE(thread_read.thread_read_date, 0), COALESCE(forum_read.forum_read_date, 0), 1297760623) AS thread_read_date,
IF(thread_watch.user_id IS NULL, 0, 1) AS thread_is_watched,
IF(thread_user_post.user_id IS NULL, 0, thread_user_post.post_count) AS user_post_count,
permission.cache_value AS node_permission_cache
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
INNER JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_thread_read AS thread_read ON
(thread_read.thread_id = thread.thread_id
AND thread_read.user_id = 4)
LEFT JOIN xf_forum_read AS forum_read ON
(forum_read.node_id = thread.node_id
AND forum_read.user_id = 4)
LEFT JOIN xf_thread_watch AS thread_watch
ON (thread_watch.thread_id = thread.thread_id
AND thread_watch.user_id = 4)
LEFT JOIN xf_thread_user_post AS thread_user_post
ON (thread_user_post.thread_id = thread.thread_id
AND thread_user_post.user_id = 4)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 88
AND permission.content_type = 'node'
AND permission.content_id = thread.node_id)
WHERE ((thread.discussion_state IN ('visible'))) AND (thread.node_id IN ('11,12,13,14,20,36,32,33,34,25,26,27,24,5,6,7,16,17,29,30')) AND thread.node_id IN ('11', '12', '13', '14', '20', '36', '32', '33', '34', '25', '26', '27', '24', '5', '6', '7', '16', '17', '29', '30')
ORDER BY thread.last_post_date DESC
LIMIT 5- Status
