EDIT: Fault. Raises all kind of images.
Announcement
Collapse
No announcement yet.
Log errors
Collapse
X
-
Okay...
Here is what I have done to try and replicate this warning. First off, I am using vBulletin 5.4.5 Alpha 4 (not available for customer download yet). Going by the warning message, this is occuring in the /album functionality of the site. My environment is Ubuntu 18.04 under WSL using Apache 2.4.29, PHP 7.2.10, and MySQL 5.7.23
Here are the steps I took:- Stopped the Apache2 Service.
- Deleted the error.log for for my vBulletin5 virtual host.
- Restarted the Apache2 service.
- Went to my vBulletin5 install using Google Chrome 69.
- Logged in as the Administrator.
- Clicked on my username and selected My Profile.
- On the profile page, I clicked the Media tab.
- Clicked add Photos.
- The system prompted me to create a new Album. I named it Cats.
- I uploaded a variety of big cat images that I have collected over the years.
- Save the album.
- Clicked on the first Album Image.
- Went through each image in the album.
- Closed the lightbox.
- Opened the error.log file in my text editor. It was still empty.
Leave a comment:
-
Will look deeper. Will have to add albums to my test site.
- Likes 1
Leave a comment:
-
Result: First time my site broke. So I overwrite '/core/includes', '/core/vb' and '/core/vb5' (where files from) with a copy I do before. After that, my site was no longer broken. But when I run "Suspect File Versions" again, they were only three files (last three in list) displayed, not eight like before. So I delete those three files. My site seems to work fine so far. Now I wait for errors (notices, warnings) in log.
I'll get back.
EDIT: Not solved:
2018/10/14 07:22:47 [error] 27379#27379: *2918 FastCGI sent in stderr: "PHP message: PHP Notice: Undefined index: ishomeroute in /var/www/xxxxxxx.xx/core/vb5/route.php on line 130
PHP message: PHP Notice: Undefined index: ishomeroute in /var/www/xxxxxxx.xx/core/vb5/route.php on line 132" while reading response header from upstream, client: 0.0.0.0, server: xxxxxxx.xx, request: "GET /album/198-xxxxxxxxxxxxxxxxxxxxxxxxxx HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.2-fpm.sock:", host: "xxxxxxx.xx"Last edited by BulliM; Sat 13 Oct '18, 9:36pm.
Leave a comment:
-
I found some files, not recognized as part of vBulletin:
adminfunctions_bookmarksite.php
class_humanverify_recaptcha.php
array.php
input.php
verticalresponse.php
query.php
search.php
subscribedchannels.php
I'll delete/replace these files now. We'll see what happens.Last edited by BulliM; Sat 13 Oct '18, 8:28pm.
Leave a comment:
-
Sorry. Routenew is the correct table. The query looks correct.
Running the upgrade a second time won't actually do anything if the first run didn't produce any errors. The system will just skip to the "Final" upgrade where it reimports default XML files for pages, modules, languages, styles, and then rebuilds all this information in the database.
If you go to the AdminCP and select Maintenance -> Diagnostics -> Suspect File versions are any files listed? Can you delete all files listed as not part of vBulletin and replace all files that do not have the expected contents?
Leave a comment:
-
I now search for "ishomeroute" in /install/upgrade/includes/ and found some results in class_upgrade_544_a4.php. But they affect table routenew and not node.
So...
Code:[URL="https://srvadmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/select.html"]SELECT[/URL] * FROM `routenew` WHERE ishomeroute=1
Last edited by BulliM; Fri 12 Oct '18, 6:43pm.
Leave a comment:
-
-
Originally posted by BulliM View PostI did upgrade again. But that doesn't solve it.
select * from node where ishomeroute=1
It should return exactly one row.
Leave a comment:
-
A missing database field means there was a problem with the upgrade step. That step should be run again.
php upgrade.php --version=544a4
-
I have a client who reported to me SQL errors related to ishomeroute after upgrading to 5.4.4.
Code:MySQL Error : Unknown column 'ishomeroute' in 'where clause' Error Number : 1054 Request Date : Wednesday, October 10th 2018 @ 09:49:17 AM Error Date : Wednesday, October 10th 2018 @ 09:49:17 AM Script : https://xxxxxxx/contact-us Referrer : https://xxxxxx/contact-us IP Address : xxxxxxxxx Username : Guest Classname : vB_Database_MySQLi MySQL Version : Stack Trace: #0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1188 #1 vB_Database->halt() called in [path]/vb/database/mysqli.php on line 201 #2 vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 557 #3 vB_Database->query_read() called in [path]/vb/db/result.php on line 126 #4 vB_dB_Result->rewind() called in [path]/vb/db/result.php on line 63 #5 vB_dB_Result->__construct() called in [path]/vb/db/query/stored.php on line 104 #6 vB_dB_Query_Stored->execSQL() called in [path]/vb/db/assertor.php on line 301 #7 vB_dB_Assertor->assertQuery() called in [path]/vb/api/route.php on line 162 #8 vB_Api_Route->getRoute() called in on line #9 call_user_func_array() called in [path]/vb/api/wrapper.php on line 199 #10 vB_Api_Wrapper->__call() called in on line #11 vB_Api_Wrapper->getRoute() called in on line #12 call_user_func_array() called in /home/xxxxxx/public_html/includes/api/interface/collapsed.php on line 101 #13 Api_Interface_Collapsed->callApi() called in /home/xxxxxx/public_html/includes/vb5/frontend/routing.php on line 120 #14 vB5_Frontend_Routing->setRoutes() called in /home/xxxxxxx/public_html/includes/vb5/frontend/application.php on line 21 #15 vB5_Frontend_Application::init() called in /home/discover/public_html/index.php on line 48
Leave a comment:
-
I did upgrade again. But that doesn't solve it.
PHP message: PHP Notice: Undefined index: ishomeroute in /var/www/xxxxxxx.xx/core/vb5/route.php on line 132" while reading response header from upstream, client: 0.0.0.0, server: xxxxxxx.xx, request: "GET /album/6708-xxxxxxxxxxxxxxx-500-fdk HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.2-fpm.sock:", host: "xxxxxxx.xx"Last edited by BulliM; Thu 11 Oct '18, 7:21pm.
Leave a comment:
-
Neither of these are Errors. They are Warnings.
The first one means you need to run the 5.4.4 Upgrade scripts on your site.
The second one should be fixed in an upcoming version.
- Likes 1
Leave a comment:
Related Topics
Collapse
-
by holymannnHi,
I got tons of PHP Notice in error log after upgrade from 5.6.3 to 5.6.4 PL1. Anyone has similar problem?
[18-Apr-2021 05:00:39 UTC] PHP Notice: Undefined index: host...-
Channel: vBulletin 5 Installs & Upgrades
Sat 17 Apr '21, 9:42pm -
-
by dbrookeMy Specs:
CPANEL, VB5 Connect (5.2.3)
Hello, my version of VB5 is pretty slow on things like making a new post and logging in (which I think translates into database interaction?)......-
Channel: Support Issues & Questions
Thu 29 Sep '16, 5:10am -
-
by ep0chMy site runs in alpine docker containers.
It was running with PHP 7.1.5 and 10.1.22-MariaDB
I have since upgraded my containers to PHP 7.19 and 10.1.26-MariaDB
However vbulletin...-
Channel: vBulletin 5 Connect Feedback
Tue 19 Sep '17, 4:11am -
-
by mittac[20-Oct-2017 00:42:08 Europe/Minsk] PHP Warning: Illegal string offset 'starter' in public_html/includes/vb5/template.php(318) : eval()'d code on line 167
[20-Oct-2017 00:42:08 Europe/Minsk] PHP...-
Channel: Support Issues & Questions
Fri 20 Oct '17, 12:49am -
-
The original version of my forums was 5.5.0. I successfully upgraded it to the latest edition with the patch. But now I have three errors:
1. After posting anything in the form or in the...-
Channel: vB Cloud Support & Troubleshooting.
Mon 30 Sep '19, 11:03pm -
Leave a comment: