404 Enhancement (ST404) [Deleted]

@au lait any thoughts?

Code: 
Server error log
XF\Db\Exception: MySQL query error [1406]: Data too long for column 'request_string' at row 1 src/XF/Db/AbstractStatement.php:212
Generated by: Unknown account 05.04.2018. at 12:55
Stack trace
INSERT  INTO `xf_xenmade_404` (`hits`, `request_string`, `redirect_string`, `referrer`, `http_code`, `active`, `dateline`) VALUES (?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1406, '22001')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1406, '22001')
#2 src/XF/Db/AbstractAdapter.php(79): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(160): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1389): XF\Db\AbstractAdapter->insert('xf_xenmade_404', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1121): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/addons/xenMade/ST404/Repository/ST404.php(28): XF\Mvc\Entity\Entity->save()
#7 src/addons/xenMade/ST404/Listener.php(18): xenMade\ST404\Repository\ST404->save404('/forum/%3Cifram...')
#8 [internal function]: xenMade\ST404\Listener::dispatcher_pre_render(Object(XF\Mvc\Dispatcher), Object(XF\Mvc\Reply\Error), 'html')
#9 src/XF/Extension.php(67): call_user_func_array(Array, Array)
#10 src/XF/App.php(2352): XF\Extension->fire('dispatcher_pre_...', Array, NULL)
#11 src/XF/Mvc/Dispatcher.php(278): XF\App->fire('dispatcher_pre_...', Array)
#12 src/XF/Mvc/Dispatcher.php(44): XF\Mvc\Dispatcher->render(Object(XF\Mvc\Reply\Error), 'html')
#13 src/XF/App.php(1891): XF\Mvc\Dispatcher->run()
#14 src/XF.php(328): XF\App->run()
#15 index.php(13): XF::runApp('XF\\Pub\\App')
#16 {main}
Request state
array(4) {
  ["url"] => string(778) "/forum/%3Ciframe%20width=%22425%22%20height=%22350%22%20frameborder=%220%22%20scrolling=%22no%22%20marginheight=%220%22%20marginwidth=%220%22%20src=%22http://maps.google.it/maps?f=q&amp%3Bsource=s_q&amp%3Bsource=embed&amp%3Bhl=it&amp%3Bhl=it&amp%3Bgeocode=&amp%3Bgeocode=&amp%3Bq=djelekovec&amp%3Bq=djelekovec&amp%3Bsll=41.442726%2C12.392578&amp%3Bsll=41.442726%2C12.392578&amp%3Bsspn=15.763969%2C38.803711&amp%3Bsspn=15.763969%2C38.803711&amp%3Bie=UTF8&amp%3Bie=UTF8&amp%3Bt=h&amp%3Bt=h&amp%3Bll=46.246351%2C16.908302&amp%3Bll=46.246351%2C16.908302&amp%3Bspn=0.04155%2C0.072956&amp%3Bspn=0.04155%2C0.072956&amp%3Bz=13&amp%3Bz=13%22%20style%3D%22color%3A&amp%3Boutput=embed%22%3E%3C%2Fiframe%3E%3Cbr%20%2F%3E%3Csmall%3E%3Ca%20href%3D%22http%3A%2F%2Fmaps.google.it%2Fmaps%3Ff%3Dq"
  ["referrer"] => bool(false)
  ["_GET"] => array(14) {
    ["/forum/<iframe_width"] => string(113) ""425" height="350" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="http:/maps.google.it/maps"
    ["f"] => string(1) "q"
    ["amp;source"] => string(5) "embed"
    ["amp;hl"] => string(2) "it"
    ["amp;geocode"] => string(0) ""
    ["amp;q"] => string(10) "djelekovec"
    ["amp;sll"] => string(19) "41.442726,12.392578"
    ["amp;sspn"] => string(19) "15.763969,38.803711"
    ["amp;ie"] => string(4) "UTF8"
    ["amp;t"] => string(1) "h"
    ["amp;ll"] => string(19) "46.246351,16.908302"
    ["amp;spn"] => string(16) "0.04155,0.072956"
    ["amp;z"] => string(17) "13" style="color:"
    ["amp;output"] => string(68) "embed"></iframe><br /><small><a href="http://maps.google.it/maps?f=q"
  }
  ["_POST"] => array(0) {
  }
}
 
Sunka said:
Data too long for column 'request_string'
Click to expand...
wow
What was in the URL was too long ;(

Code: 
/forum/%3Ciframe%20width=%22425%22%20height=%22350%22%20frameborder=%220%22%20scrolling=%22no%22%20marginheight=%220%22%20marginwidth=%220%22%20src=%22http://maps.google.it/maps?f=q&amp%3Bsource=s_q&amp%3Bsource=embed&amp%3Bhl=it&amp%3Bhl=it&amp%3Bgeocode=&amp%3Bgeocode=&amp%3Bq=djelekovec&amp%3Bq=djelekovec&amp%3Bsll=41.442726%2C12.392578&amp%3Bsll=41.442726%2C12.392578&amp%3Bsspn=15.763969%2C38.803711&amp%3Bsspn=15.763969%2C38.803711&amp%3Bie=UTF8&amp%3Bie=UTF8&amp%3Bt=h&amp%3Bt=h&amp%3Bll=46.246351%2C16.908302&amp%3Bll=46.246351%2C16.908302&amp%3Bspn=0.04155%2C0.072956&amp%3Bspn=0.04155%2C0.072956&amp%3Bz=13&amp%3Bz=13%22%20style%3D%22color%3A&amp%3Boutput=embed%22%3E%3C%2Fiframe%3E%3Cbr%20%2F%3E%3Csmall%3E%3Ca%20href%3D%22http%3A%2F%2Fmaps.google.it%2Fmaps%3Ff%3Dq

This is not quite "normal" but will be improved here;)
 
One thing that would be nice, is a delete with select all option, to help remove some of the noise in results, to find the important stuff.

Yes, this is what filter does, but there are URL's that may be one or two important ones, amongst 50 pages of noise... so to use filter, then select all, delete, to those, would be nice to remove the noise and get at the important stuff.

I am finding times where I got through 15 pages and find a URL type that matters... hence this would be nice to help when finding that needle in the haystack.
 
Yes. You can bulk select to edit, but not delete. Sifting through results is the tedious aspect. When you action something, it sends you to the 404 redirects page, so you start again with every action taken back at 404 errors page. And that is fine, which is where bulk delete comes into play. When you are deleting nonsense, you return to the errors and can start back where you were, not have to return to the page, then sift again.
 
Anthony Parsons said:
Yes. You can bulk select to edit, but not delete. Sifting through results is the tedious aspect. When you action something, it sends you to the 404 redirects page, so you start again with every action taken back at 404 errors page. And that is fine, which is where bulk delete comes into play. When you are deleting nonsense, you return to the errors and can start back where you were, not have to return to the page, then sift again.
Click to expand...
I will work out an improvement in the coming week
 
CNK said:
Hello, is it possible to exclude some address from logs?

Eg. I'm using AndyB's Quick search: https://xenforo.com/community/resources/quick-search.6149/

All works great, but this generates a lot of 404 errors with '/quicksearch' at the end of url:
View attachment 182436


here is example of quicksearch in forum: https://www.xf2addons.com/forums/main-forum.2/
Click to expand...

He and his add-ons :sick:(n):eek::oops:
That's obviously a bug in his add-on. You should report this to him and he should react to it.
 
  • Like
Reactions: CNK
au lait updated 404 Enhancement (ST404) with a new update entry:

1.5.0

[add] Improved URL recognition
[add] Redirect for Merge Threads - to the merged thread
[add] Delete XF-Redirect Thread u can insert Redirect URL
[add] Options: Errors per Page
[add] Mass Delete
[fixed] "Page" is no longer considered in the URL
[fixed] "404 Redirects List" Order dont work
[fixed] Missing Phrase
[fixed] Many optimizations and bugfixes
Click to expand...

Read the rest of this update entry...
 
Hi! Getting these errors but can't find why:
Code:
Code: 
/miembros/129418/" class="username" data-xf-init="member-tooltip" data-user-id="129418" data-username="@blood
Go to...
Code: 
https://www.movilesdualsim.com/miembros/129418/%22%20class=%22username%22%20data-xf-init=%22member-tooltip%22%20data-user-id=%22129418%22%20data-username=%22@blood
Member profiles are open to non-registered:
Code: 
https://www.movilesdualsim.com/miembros/blood.129418/

Any idea if this can be solved?
Thanks

imaxe006.webp
 
Breixo said:
Code:
Click to expand...
Code: 
/miembros/129418/" class="username" data-xf-init="member-tooltip" data-user-id="129418" data-username="@blood

Where does the code come from!
what has to be done to get it?

You mean that the URL is displayed wrong in the list?
 
ozzy47 said:
Would be best if you posted the full error including the stack trace and request state.
Click to expand...
au lait said:
Code: 
/miembros/129418/" class="username" data-xf-init="member-tooltip" data-user-id="129418" data-username="@blood

Where does the code come from!
what has to be done to get it?

You mean that the URL is displayed wrong in the list?
Click to expand...
Hi, thanks for your replies.
It's not in the "server error log".
The only info I get is from this addon. In fact, I can't reproduce it outside this addon... :(
 
You must log in or register to reply here.
Back
Top Bottom