Pixrael Posted April 3, 2018 Share Posted April 3, 2018 HELP! On my dedicated server CentOS 6.9 with plesk Onyx, I upgrade mysql from version 5.1 to 5.5 and then to version 5.7, as indicated, to not break the mysql tables. After taht the frontend continued to work, but the backend did not. The message came out: This request was aborted because it appears to be forged. Then I try all the steps from here: https://processwire.com/docs/tutorials/troubleshooting-guide/page2 Nothing! Later I use TRUNCATE in the tables caches and session_login_throttle as it says here: https://processwire.com/talk/topic/16592-this-request-was-aborted-because-it-appears-to-be-forged/ It was worse! because in the frontend now I have an "Internal Server Error" and in the backend the screen showed in the picture. Any idea??? Link to comment Share on other sites More sharing options...
Pixrael Posted April 3, 2018 Author Share Posted April 3, 2018 ---- I enable $config->debug and get this in the frontend: Notice: Undefined variable: sitesetup in /var/www/vhosts/sitename.com/httpdocs/site/templates/_init.php on line 51 Notice: Trying to get property 'template_product' of non-object in /var/www/vhosts/sitename.com/httpdocs/site/templates/_init.php on line 51 Notice: Undefined variable: sitesetup in /var/www/vhosts/sitename.com/httpdocs/site/templates/_init.php on line 54 Notice: Trying to get property 'template_article' of non-object in /var/www/vhosts/sitename.com/httpdocs/site/templates/_init.php on line 54 Notice: Undefined variable: sitesetup in /var/www/vhosts/sitename.com/httpdocs/site/templates/_main.php on line 13 Notice: Trying to get property 'meta_add' of non-object in /var/www/vhosts/sitename.com/httpdocs/site/templates/_main.php on line 13 Notice: Undefined variable: sitesetup in /var/www/vhosts/sitename.com/httpdocs/site/templates/includes/head-prefetch.php on line 2 Notice: Trying to get property 'prefetch_twitter' of non-object in /var/www/vhosts/sitename.com/httpdocs/site/templates/includes/head-prefetch.php on line 2 Notice: Undefined variable: sitesetup in /var/www/vhosts/sitename.com/httpdocs/site/templates/includes/head-prefetch.php on line 7 Notice: Trying to get property 'prefetch_facebook' of non-object in /var/www/vhosts/sitename.com/httpdocs/site/templates/includes/head-prefetch.php on line 7 Notice: Undefined variable: sitesetup in /var/www/vhosts/sitename.com/httpdocs/site/templates/includes/head-prefetch.php on line 14 Notice: Trying to get property 'prefetch_google' of non-object in /var/www/vhosts/sitename.com/httpdocs/site/templates/includes/head-prefetch.php on line 14 Notice: Undefined variable: sitesetup in /var/www/vhosts/sitename.com/httpdocs/site/templates/includes/head-prefetch.php on line 22 Notice: Trying to get property 'prefetch_amazon' of non-object in /var/www/vhosts/sitename.com/httpdocs/site/templates/includes/head-prefetch.php on line 22 Notice: Undefined variable: sitesetup in /var/www/vhosts/sitename.com/httpdocs/site/templates/includes/head-prefetch.php on line 29 Notice: Trying to get property 'prefetch_custom' of non-object in /var/www/vhosts/sitename.com/httpdocs/site/templates/includes/head-prefetch.php on line 29 Fatal error: Uncaught Error: Call to a member function render() on null in /var/www/vhosts/sitename.com/httpdocs/site/templates/includes/head-jsonld.php:25 Stack trace: #0 /var/www/vhosts/sitename.com/httpdocs/site/templates/_main.php(30): include() #1 /var/www/vhosts/sitename.com/httpdocs/wire/core/TemplateFile.php(297): require('/var/www/vhosts...') #2 /var/www/vhosts/sitename.com/httpdocs/wire/core/Wire.php(380): ProcessWire\TemplateFile->___render() #3 /var/www/vhosts/sitename.com/httpdocs/wire/core/WireHooks.php(714): ProcessWire\Wire->_callMethod('___render', Array) #4 /var/www/vhosts/sitename.com/httpdocs/wire/core/Wire.php(442): ProcessWire\WireHooks->runHooks(Object(ProcessWire\TemplateFile), 'render', Array) #5 /var/www/vhosts/sitename.com/httpdocs/wire/modules/PageRender.module(514): ProcessWire\Wire->__call('render', Array) #6 /var/www/vhosts/sitename.com/httpdocs/wire/core/Wire.php(383): ProcessWire\PageRender->___renderPage(Object(ProcessWire\HookEvent)) #7 /var/www/vhosts/sitename.com/httpdocs/wire/core/WireHooks.php(714): P in /var/www/vhosts/sitename.com/httpdocs/site/templates/includes/head-jsonld.php on line 25 Error: Uncaught Error: Call to a member function render() on null in /var/www/vhosts/sitename.com/httpdocs/site/templates/includes/head-jsonld.php:25 Stack trace: #0 /var/www/vhosts/sitename.com/httpdocs/site/templates/_main.php(30): include() #1 /var/www/vhosts/sitename.com/httpdocs/wire/core/TemplateFile.php(297): require('/var/www/vhosts...') #2 /var/www/vhosts/sitename.com/httpdocs/wire/core/Wire.php(380): ProcessWire\TemplateFile->___render() #3 /var/www/vhosts/sitename.com/httpdocs/wire/core/WireHooks.php(714): ProcessWire\Wire->_callMethod('___render', Array) #4 /var/www/vhosts/sitename.com/httpdocs/wire/core/Wire.php(442): ProcessWire\WireHooks->runHooks(Object(ProcessWire\TemplateFile), 'render', Array) #5 /var/www/vhosts/sitename.com/httpdocs/wire/modules/PageRender.module(514): ProcessWire\Wire->__call('render', Array) #6 /var/www/vhosts/sitename.com/httpdocs/wire/core/Wire.php(383): ProcessWire\PageRender->___renderPage(Object(ProcessWire\HookEvent)) #7 /var/www/vhosts/sitename.com/httpdocs/wire/core/WireHooks.php(714): P (line 25 of /var/www/vhosts/sitename.com/httpdocs/site/templates/includes/head-jsonld.php) This error message was shown because: site is in debug mode. ($config->debug = true; => /site/config.php). Error has been logged. ---- and in the backend this: Field: Fieldtype 'FieldtypeMapMarker' does not exist Field: Fieldtype 'FieldtypeFontIconPicker' does not exist Field: Fieldtype 'FieldtypeRepeaterMatrix' does not exist Field: Fieldtype 'FieldtypeTable' does not exist Field: Fieldtype 'FieldtypeTextareas' does not exist ProcessWire: ProcessLogin: This request was aborted because it appears to be forged. DEBUG MODE BACKTRACE ($config->debug == true): #0 /var/www/vhosts/sitename.com/httpdocs/wire/modules/Inputfield/InputfieldForm.module(145): ProcessWire\SessionCSRF->validate() #1 /var/www/vhosts/sitename.com/httpdocs/wire/core/Wire.php(383): ProcessWire\InputfieldForm->___processInput(Object(ProcessWire\WireInputData)) #2 /var/www/vhosts/sitename.com/httpdocs/wire/core/WireHooks.php(714): ProcessWire\Wire->_callMethod('___processInput', Array) #3 /var/www/vhosts/sitename.com/httpdocs/wire/core/Wire.php(442): ProcessWire\WireHooks->runHooks(Object(ProcessWire\InputfieldForm), 'processInput', Array) #4 /var/www/vhosts/sitename.com/httpdocs/wire/modules/Process/ProcessLogin/ProcessLogin.module(165): ProcessWire\Wire->__call('processInput', Array) #5 /var/www/vhosts/sitename.com/httpdocs/wire/core/Wire.php(380): ProcessWire\ProcessLogin->___execute() #6 /var/www/vhosts/sitename.com/httpdocs/wire/core/WireHooks.php(714): ProcessWire\Wire->_callMethod('___execute', Array) #7 /var/www/vhosts/sitename.com/httpdocs/wire/core/Wire.php(442): ProcessWire\WireHooks->runHooks(Object(ProcessWire\ProcessLogin), 'execute', Array) #8 /var/www/vhosts/sitename.com/httpdocs/wire/core/ProcessController.php(244): ProcessWire\Wire->__call('execute', Array) #9 /var/www/vhosts/sitename.com/httpdocs/wire/core/Wire.php(380): ProcessWire\ProcessController->___execute() #10 /var/www/vhosts/sitename.com/httpdocs/wire/core/WireHooks.php(714): ProcessWire\Wire->_callMethod('___execute', Array) #11 /var/www/vhosts/sitename.com/httpdocs/wire/core/Wire.php(442): ProcessWire\WireHooks->runHooks(Object(ProcessWire\ProcessController), 'execute', Array) #12 /var/www/vhosts/sitename.com/httpdocs/wire/core/admin.php(113): ProcessWire\Wire->__call('execute', Array) #13 /var/www/vhosts/sitename.com/httpdocs/wire/modules/AdminTheme/AdminThemeDefault/controller.php(13): require('/var/www/vhosts...') #14 /var/www/vhosts/sitename.com/httpdocs/site/templates/admin.php(15): require('/var/www/vhosts...') #15 /var/www/vhosts/sitename.com/httpdocs/wire/core/TemplateFile.php(287): require('/var/www/vhosts...') #16 /var/www/vhosts/sitename.com/httpdocs/wire/core/Wire.php(380): ProcessWire\TemplateFile->___render() #17 /var/www/vhosts/sitename.com/httpdocs/wire/core/WireHooks.php(714): ProcessWire\Wire->_callMethod('___render', Array) #18 /var/www/vhosts/sitename.com/httpdocs/wire/core/Wire.php(442): ProcessWire\WireHooks->runHooks(Object(ProcessWire\TemplateFile), 'render', Array) #19 /var/www/vhosts/sitename.com/httpdocs/wire/modules/PageRender.module(514): ProcessWire\Wire->__call('render', Array) #20 /var/www/vhosts/sitename.com/httpdocs/wire/core/Wire.php(383): ProcessWire\PageRender->___renderPage(Object(ProcessWire\HookEvent)) #21 /var/www/vhosts/sitename.com/httpdocs/wire/core/WireHooks.php(714): ProcessWire\Wire->_callMethod('___renderPage', Array) #22 /var/www/vhosts/sitename.com/httpdocs/wire/core/Wire.php(442): ProcessWire\WireHooks->runHooks(Object(ProcessWire\PageRender), 'renderPage', Array) #23 /var/www/vhosts/sitename.com/httpdocs/wire/core/WireHooks.php(808): ProcessWire\Wire->__call('renderPage', Array) #24 /var/www/vhosts/sitename.com/httpdocs/wire/core/Wire.php(442): ProcessWire\WireHooks->runHooks(Object(ProcessWire\Page), 'render', Array) #25 /var/www/vhosts/sitename.com/httpdocs/wire/modules/Process/ProcessPageView.module(205): ProcessWire\Wire->__call('render', Array) #26 /var/www/vhosts/sitename.com/httpdocs/wire/core/Wire.php(383): ProcessWire\ProcessPageView->___execute(true) #27 /var/www/vhosts/sitename.com/httpdocs/wire/core/WireHooks.php(714): ProcessWire\Wire->_callMethod('___execute', Array) #28 /var/www/vhosts/sitename.com/httpdocs/wire/core/Wire.php(442): ProcessWire\WireHooks->runHooks(Object(ProcessWire\ProcessPageView), 'execute', Array) #29 /var/www/vhosts/sitename.com/httpdocs/index.php(55): ProcessWire\Wire->__call('execute', Array) #30 {main} I was using ProCache too Link to comment Share on other sites More sharing options...
Sergio Posted April 3, 2018 Share Posted April 3, 2018 Dumb question, did you try to delete ALL folders (except files) inside /site/assets/ ? Link to comment Share on other sites More sharing options...
Pixrael Posted April 3, 2018 Author Share Posted April 3, 2018 nop.. it works? in the docs said that should be at least this folders: /site/assets/cache/ /site/assets/logs/ /site/assets/sessions/ ..and now in the root I have this files: active.php index.php installed.php should be delete too? .. i'll make a backup and delete this Link to comment Share on other sites More sharing options...
Sergio Posted April 3, 2018 Share Posted April 3, 2018 These folders are created automatically if they don't exist, I think. Keep the files. Try again and tell us what happened. Link to comment Share on other sites More sharing options...
Pixrael Posted April 3, 2018 Author Share Posted April 3, 2018 I get the same in the Backend.. and in the frontend this new message: Error: Uncaught Error: Call to a member function render() on null in /var/www/vhosts/sitename.com/httpdocs/site/templates/includes/head-jsonld.php:25 Stack trace: #0 /var/www/vhosts/sitename.com/httpdocs/site/templates/_main.php(30): include() #1 /var/www/vhosts/sitename.com/httpdocs/wire/core/TemplateFile.php(297): require('/var/www/vhosts...') #2 /var/www/vhosts/sitename.com/httpdocs/wire/core/Wire.php(380): ProcessWire\TemplateFile->___render() #3 /var/www/vhosts/sitename.com/httpdocs/wire/core/WireHooks.php(714): ProcessWire\Wire->_callMethod('___render', Array) #4 /var/www/vhosts/sitename.com/httpdocs/wire/core/Wire.php(442): ProcessWire\WireHooks->runHooks(Object(ProcessWire\TemplateFile), 'render', Array) #5 /var/www/vhosts/sitename.com/httpdocs/wire/modules/PageRender.module(514): ProcessWire\Wire->__call('render', Array) #6 /var/www/vhosts/sitename.com/httpdocs/wire/core/Wire.php(383): ProcessWire\PageRender->___renderPage(Object(ProcessWire\HookEvent)) #7 /var/www/vhosts/sitename.com/httpdocs/wire/core/WireHooks.php(714): P (line 25 of /var/www/vhosts/sitename.com/httpdocs/site/templates/includes/head-jsonld.php) This error message was shown because: Superuser has never logged in. Error has been logged. Link to comment Share on other sites More sharing options...
Pixrael Posted April 3, 2018 Author Share Posted April 3, 2018 put back to the 3 php files at the root and get again the "Internal Server Error" Link to comment Share on other sites More sharing options...
Sergio Posted April 3, 2018 Share Posted April 3, 2018 I'm assuming you have a backup of both files and database (when it ran on MySQL 5.1), right? Is it possible to try the procedure again on you local machine? Or if I can help you on that, send me the files and a dump and I'll try to run it here? Link to comment Share on other sites More sharing options...
Pixrael Posted April 3, 2018 Author Share Posted April 3, 2018 the problem seems to be this: Warning: call_user_func_array() expects parameter 1 to be a valid callback, class 'ProcessWire\Database' does not have a method 'exec' in /var/www/vhosts/sitename.com/httpdocs/wire/core/DatabaseMysqli.php on line 38 Link to comment Share on other sites More sharing options...
Sergio Posted April 3, 2018 Share Posted April 3, 2018 What version of PW are you running? Did you upgrade it too or only the database? Link to comment Share on other sites More sharing options...
Pixrael Posted April 3, 2018 Author Share Posted April 3, 2018 PW 3.0.79 ... I only upgrade mysql from 5.1 to 5.5 to 5.7 with SSH .. in each step I upgrade the databases too.. the previous Warning is very strange, after that no variable works.. seem that PW don't execute the queries to the database Link to comment Share on other sites More sharing options...
Sergio Posted April 3, 2018 Share Posted April 3, 2018 Check these posts and this issue: https://github.com/processwire/processwire-issues/issues/28#issuecomment-252870084 Link to comment Share on other sites More sharing options...
Pixrael Posted April 3, 2018 Author Share Posted April 3, 2018 I already read those topics ... Thanks very much Sergio Link to comment Share on other sites More sharing options...
Pixrael Posted April 4, 2018 Author Share Posted April 4, 2018 I reloaded a dump from the database that I saved the day before doing the upgrade to mysql and the frontend is now working, except FormBuilder forms .. but the backend keeps saying: This request was aborted because it appears to be forged. Link to comment Share on other sites More sharing options...
dragan Posted April 4, 2018 Share Posted April 4, 2018 17 hours ago, Pixrael said: ---- and in the backend this: Field: Fieldtype 'FieldtypeMapMarker' does not exist Field: Fieldtype 'FieldtypeFontIconPicker' does not exist Field: Fieldtype 'FieldtypeRepeaterMatrix' does not exist Field: Fieldtype 'FieldtypeTable' does not exist Field: Fieldtype 'FieldtypeTextareas' does not exist ProcessWire: ProcessLogin: This request was aborted because it appears to be forged. At least this part could maybe be solved with clearing the modules cache. Modules > Site @ the bottom "clear compiled files". Did you check if these fields / modules actually exist physically? Perhaps something went wrong with the FTP upload. An re: troubleshooting guide: Did you check file permissions and did you set all of these to false in your config.php? $config->protectCSRF = false; $config->sessionChallenge = false; $config->sessionFingerprint = false; 1 Link to comment Share on other sites More sharing options...
Pixrael Posted April 4, 2018 Author Share Posted April 4, 2018 File permissions.. Tested Config false options... Tested (doing that backend don't load) All files exist, this was a working website, only stop after upgrade mysql from 5.1 to 5.5 to 5.7 I want to clear the modules cache, but i can't use your option Modules > Site @ the bottom "clear compiled files" because I can't login to admin.. Can I delete the folder in assets? Link to comment Share on other sites More sharing options...
flydev Posted April 4, 2018 Share Posted April 4, 2018 16 hours ago, Pixrael said: Warning: call_user_func_array() expects parameter 1 to be a valid callback, class 'ProcessWire\Database' does not have a method 'exec' in /var/www/vhosts/sitename.com/httpdocs/wire/core/DatabaseMysqli.php on line 38 Just an idea, is mysqli extension enabled ? Also, on your newly upgraded server, you could run the ProcessWire installer to check if everything required is installed. If you are tired, you can run the first step of the standalone Duplicator installer. You can delete folders in sites/assets, just keep the file and session folders, and empty the session folder manually. 1 Link to comment Share on other sites More sharing options...
mr-fan Posted April 4, 2018 Share Posted April 4, 2018 next idea....i've run into the forged message while on this webspace i've had no more space with an automatic backup script that use all webspace...so i get a lot of errors...and could only login if i delete the cache....under assets. Stupid and easy solution was to clean the webspace...just i case. regards mr-fan 1 Link to comment Share on other sites More sharing options...
Pixrael Posted April 4, 2018 Author Share Posted April 4, 2018 (edited) yes mysqli is enabled delete folders under assets tested too let's me try Duplicator installer check's Duplicator Compatibility Check.. passed Edited April 4, 2018 by Pixrael Update Link to comment Share on other sites More sharing options...
Pixrael Posted April 4, 2018 Author Share Posted April 4, 2018 23 minutes ago, mr-fan said: next idea....i've run into the forged message while on this webspace i've had no more space with an automatic backup script that use all webspace...so i get a lot of errors...and could only login if i delete the cache....under assets. Stupid and easy solution was to clean the webspace...just i case. regards mr-fan this webspace is almost empty.. used only 514.7 MB from GBs available Link to comment Share on other sites More sharing options...
Pixrael Posted April 4, 2018 Author Share Posted April 4, 2018 When I put $config->protectCSRF = false; I get this when trying to login in the admin: This page isn’t working www.sitename.com redirected you too many times. Try clearing your cookies. ERR_TOO_MANY_REDIRECTS Link to comment Share on other sites More sharing options...
bernhard Posted April 5, 2018 Share Posted April 5, 2018 And did you clear your cookies? It's always a good idea to test pw in the browser's incognito mode when strange things occur. That has helped me several times already. 2 Link to comment Share on other sites More sharing options...
Pixrael Posted April 5, 2018 Author Share Posted April 5, 2018 I tried it, it does not work As I have seen in this forum the "This request was aborted because it appears to be forged" is very common and a serious black hole in PW It was very hard to convince the boss to use PW instead of the previous WP website! Maybe the PW's adventure ended for me Link to comment Share on other sites More sharing options...
bernhard Posted April 5, 2018 Share Posted April 5, 2018 1 hour ago, Pixrael said: As I have seen in this forum the "This request was aborted because it appears to be forged" is very common and a serious black hole in PW I disagree. I have had no problems at all for some years and on several websites. Also I followed the forum quite intensively and I've never come across any serious problems with that. But maybe I'm misunderstanding what you mean by "black hole". 1 hour ago, Pixrael said: It was very hard to convince the boss to use PW instead of the previous WP website! Maybe the PW's adventure ended for me If you are not able to solve this problem on your own, I'm sure there are many experienced developers you can pay for professional support. There is the jobs board in the forum and you could even ask ryan per email to assist. There is also the possibility to contact your hosting provider for backups. Then you can start from the last working version. Finally: It seems to me that the problem you are having is totally NOT related to processwire. The same could have happened with wordpress: When you break the setup of your server, the CMS has no chance to run properly. Another advice would be to start from your last working backup, protocol every step you take and share your information here. Sometimes when you write things down the solution pops up and asking that question isn't even necessary anymore. Good luck, bugfixing sucks - independent from any cms 1 Link to comment Share on other sites More sharing options...
Pixrael Posted April 5, 2018 Author Share Posted April 5, 2018 I meant that if you search in google you find 127 forum topics with the same problem in the processwire website, I read each of them, almost all with different situations/solutions (session.referer_check in php.ini, no space in server disk, file permissions, CSRF, database auto_increment, etc), with all in the forum trying to guess the solution, even some threads don't reach a final solution. It's good to know that you have not fallen into this situation. You're a lucky man Thanks for your advice Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now