tajhay
Well-known member
majority of my site visitors are from aus/nz. loads up fine here.That site has quite a delay for every page I tried.
can you pm me your site so i can see what the difference may be.
majority of my site visitors are from aus/nz. loads up fine here.That site has quite a delay for every page I tried.
Using Cache and its dedicated server. No issues on the server itself...i comfortably run over 90+ addons with no issues.It's probably just the lag to the US then if it's in NZ. The news page took much longer than anything on the rest of the site though. Is it a shared host? Are you using a cache?
SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
node.title AS node_title, node.node_name,
GREATEST(COALESCE(thread_read.thread_read_date, 0), COALESCE(forum_read.forum_read_date, 0), 1381564836) AS thread_read_date,
IF(thread_watch.user_id IS NULL, 0,
IF(thread_watch.email_subscribe, 'watch_email', 'watch_no_email')) AS thread_is_watched,
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)
LEFT 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 = 1)
LEFT JOIN xf_forum_read AS forum_read ON
(forum_read.node_id = thread.node_id
AND forum_read.user_id = 1)
LEFT JOIN xf_thread_watch AS thread_watch
ON (thread_watch.thread_id = thread.thread_id
AND thread_watch.user_id = 1)
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 = 1)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 84
AND permission.content_type = 'node'
AND permission.content_id = thread.node_id)
WHERE (thread.discussion_state IN ('visible')) AND (thread.last_post_date > 1383552036) AND 1=1 AND thread.node_id IN ('10', '18', '17', '12')
ORDER BY thread.last_post_date DESC
LIMIT 7
Fixed path issues for sites using xenforo in a sub directory installation
Added multi-forum fix provided by XF member Silence
Fixed loading gif appearance
Added option to turn off infinite scroll
Added option to draw articles that have images only
Right now News portal is to be used as a news portal and so display multiple images attached to the same article isn't what I was aiming for. I'll send you some adjusted files tomorrow afternoon to give you what you're looking for.Well. But I uploaded three photos in the message, but in the news, only one image, and
As a wish - you can use phrases?
Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') DESC LIMIT 8' at line 9
Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 734
Zend_Db_Adapter_Abstract->fetchAll() in OXY/News/Model/Articles.php at line 26
OXY_News_Model_Articles->getNewsArticles() in OXY/News/ControllerPublic/News.php at line 21
OXY_News_ControllerPublic_News->actionIndex() in XenForo/FrontController.php at line 337
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') DESC LIMIT 10' at line 9 - library/Zend/Db/Statement/Mysqli.php:77
Generado por: Gimomo, Hoy a las 10:01
Seguimiento
#0 /home2/gimomo/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare(' ? ?SELE...')
#1 /home2/gimomo/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), ' ? ?SELE...')
#2 /home2/gimomo/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare(' ? ?SELE...')
#3 /home2/gimomo/public_html/library/Zend/Db/Adapter/Abstract.php(734): Zend_Db_Adapter_Abstract->query(' ? ?SELE...', Array)
#4 /home2/gimomo/public_html/library/OXY/News/Model/Articles.php(26): Zend_Db_Adapter_Abstract->fetchAll(' ? ?SELE...')
#5 /home2/gimomo/public_html/library/OXY/News/ControllerPublic/News.php(21): OXY_News_Model_Articles->getNewsArticles(Array)
#6 /home2/gimomo/public_html/library/XenForo/FrontController.php(337): OXY_News_ControllerPublic_News->actionIndex()
#7 /home2/gimomo/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#8 /home2/gimomo/public_html/index.php(13): XenForo_FrontController->run()
#9 {main}
Have you tried re-installing? I know sometimes I've got this error when installing other add-ons in the past.Getting this error: "Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 82 bytes) in /home/optiks/public_html/library/Zend/Db/Statement/Mysqli.php on line 304"
When trying to upgrade the addon to 1.12c
Ah shoot I didn't write in a fallback if no forums were found. Go to the options and be sure to select a forum! It'll go away. It's trying to retrieve from nothing and throwing an errorerror
Code:Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') DESC LIMIT 8' at line 9 Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115 Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381 Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478 Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 734 Zend_Db_Adapter_Abstract->fetchAll() in OXY/News/Model/Articles.php at line 26 OXY_News_Model_Articles->getNewsArticles() in OXY/News/ControllerPublic/News.php at line 21 OXY_News_ControllerPublic_News->actionIndex() in XenForo/FrontController.php at line 337 XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
Exactly what I said to the last person lolidem, error...
Code:Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') DESC LIMIT 10' at line 9 - library/Zend/Db/Statement/Mysqli.php:77 Generado por: Gimomo, Hoy a las 10:01 Seguimiento #0 /home2/gimomo/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare(' ? ?SELE...') #1 /home2/gimomo/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), ' ? ?SELE...') #2 /home2/gimomo/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare(' ? ?SELE...') #3 /home2/gimomo/public_html/library/Zend/Db/Adapter/Abstract.php(734): Zend_Db_Adapter_Abstract->query(' ? ?SELE...', Array) #4 /home2/gimomo/public_html/library/OXY/News/Model/Articles.php(26): Zend_Db_Adapter_Abstract->fetchAll(' ? ?SELE...') #5 /home2/gimomo/public_html/library/OXY/News/ControllerPublic/News.php(21): OXY_News_Model_Articles->getNewsArticles(Array) #6 /home2/gimomo/public_html/library/XenForo/FrontController.php(337): OXY_News_ControllerPublic_News->actionIndex() #7 /home2/gimomo/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch)) #8 /home2/gimomo/public_html/index.php(13): XenForo_FrontController->run() #9 {main}
Uncheck "Show Articles That Only contain Images"multiple forum works, but not every forum, eg.
1.- Forum is selected "Zona Playstation"
2.- the news is created
3.-but the news does not appear in the portal ...
Yes that's what I mean to use for right now since it's not working in style properties. I'll look into it again.what if I turn out, is to modify the data directly from the payroll, IT WORKS
1.- NOT WORKING
2 IT WORKS
Yes that's a future update to read embedded images and videos as well. There's no eta on that but I'd very much like this in the add-on and feel it's extremely needed.perfect ... thank you very much ...
there will be some way to put thumbnails external web link?
definitely...thanksYes that's a future update to read embedded images and videos as well. There's no eta on that but I'd very much like this in the add-on and feel it's extremely needed.
Yes, I first tried upgrading. This error occurred. I then uninstalled, and then reinstalled 1.12c. And am now unable to even reinstall that 1.12c add on.Have you tried re-installing? I know sometimes I've got this error when installing other add-ons in the past.
We use essential cookies to make this site work, and optional cookies to enhance your experience.