vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   vb 4.2.5 Upgrade error (https://vborg.vbsupport.ru/showthread.php?t=326208)

chikuru 03-15-2018 06:46 AM

vb 4.2.5 Upgrade error
 
The upgrade hangs even if I refresh the page.

I already searched and tried the different solutions but nothing worked.

I cant also login to the forum and adminCP. After the interstitial page "Thank you for logging in....", it just return to the previous page and didnt log in..

Code:

Action Required
Unexpected Text:
<?xml version="1.0" encoding="windows-1252"?>
<br />
<b>Warning</b>:  mysqli_query(): (42000/1064): 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 ' )
                        )
                        WHERE ipid IS NULL' at line 6 in <b>/home/**********/public_html/forum/includes/class_core.php</b> on line <b>1386</b><br />
<?xml version="1.0" encoding="windows-1252"?>
<errors>
        <error><![CDATA[<p>Database Error</p>

Invalid SQL:

                        SELECT bt.userid, bt.dateline, blogtextid, ipaddress, firstblogtextid
                        FROM vb_blog_text bt
                        JOIN vb_blog bl USING (blogid)
                        LEFT JOIN vb_ipdata ip ON (
                                bt.ipaddress = ip.ipid AND bt.blogtextid  = ip.contentid
                                AND bt.userid = ip.userid AND ip.contenttypeid IN (, )
                        )
                        WHERE ipid IS NULL;

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 ' )
                        )
                        WHERE ipid IS NULL' at line 6]]></error>
        <error_html><![CDATA[<p>Database error in vBulletin 4.2.5</p>
<p>Invalid SQL:

                        SELECT bt.userid, bt.dateline, blogtextid, ipaddress, firstblogtextid
                        FROM vb_blog_text bt
                        JOIN vb_blog bl USING (blogid)
                        LEFT JOIN vb_ipdata ip ON (
                                bt.ipaddress = ip.ipid AND bt.blogtextid  = ip.contentid
                                AND bt.userid = ip.userid AND ip.contenttypeid IN (, )
                        )
                        WHERE ipid IS NULL;<p>
<p>
<strong>MySQL Error</strong>  : 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 ' )
                        )
                        WHERE ipid IS NULL' at line 6<br />
<strong>Error Number</strong>  : 1064<br />
<strong>Request Date</strong>  : Thursday, March 15th 2018 @ 06:48:31 AM<br />
<strong>Error Date</strong>    : Thursday, March 15th 2018 @ 06:48:31 AM<br />
<strong>Script</strong>        : http://www.**********.com/forum/install/upgrade.php<br />
<strong>Referrer</strong>      : http://www.**********.com/forum/install/upgrade.php<br />
<strong>Classname</strong>    : vB_Database_MySQLi<br />
<strong>MySQL Version</strong> : 5.6.38<br />
</p>]]></error_html>
</errors>


snakes1100 03-15-2018 08:01 AM

enable the blogs, then upgrade.

chikuru 03-15-2018 10:17 AM

Quote:

Originally Posted by snakes1100 (Post 2593537)
enable the blogs, then upgrade.

Blog is already enabled..

I also tried to reupload default vb 4.2.5 files and didnt work

Stratis 03-15-2018 02:03 PM

Try to make install with browser Firefox.

ForceHSS 03-16-2018 12:49 AM

Did you disable plugins via the config first before starting the update


All times are GMT. The time now is 10:12 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00966 seconds
  • Memory Usage 1,730KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete