vb.org Archive

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

lacidious 04-01-2017 03:35 AM

Same issue here. I am running barkinghard.com/forums/version.php Current PHP version: 5.6.29

Had hostgator upgrade it specifically for this upgrade.

Still get: Parse error: syntax error, unexpected '=', expecting ')' in /home3/tbpp/public_html/forums/includes/functions_misc.php on line 759

Mark.B 04-01-2017 06:46 AM

Quote:

Originally Posted by lacidious (Post 2584558)
Same issue here. I am running barkinghard.com/forums/version.php Current PHP version: 5.6.29

Had hostgator upgrade it specifically for this upgrade.

Still get: Parse error: syntax error, unexpected '=', expecting ')' in /home3/tbpp/public_html/forums/includes/functions_misc.php on line 759

Again, this means the php version isn't what you think it is.

Can you still log into the admincp? What php version is reported there? As that is the only information that really matters.

lacidious 04-01-2017 02:09 PM

Server Type Linux Users to Moderate 15 [View]
Web Server Apache (cgi-fcgi) Threads to Moderate 0 [View]
PHP 5.6.29 Posts to Moderate 0 [View]
PHP Max Post Size 64.00 MB Attachments to Moderate 0 [View]
PHP Maximum Upload Size 64.00 MB Events to Moderate 0 [View]
PHP Memory Limit 256.00 MB Number of Queued E-Mails 0
MySQL Version 5.5.51-38.2
MySQL Packet Size 16.00 MB


Thanks for your help!

--------------- Added [DATE]1491065136[/DATE] at [TIME]1491065136[/TIME] ---------------

Ugh I was hoping I could turn my forum back on and it would work, but apparently this error took the entire forum down. Please advise, biggest month of the year for my forum.

Paul M 04-01-2017 05:03 PM

The only advice we can give is speak to your host.

That error is specific to older versions of PHP, and will not occur on 5.6.

loua_oz 05-11-2017 06:40 AM

Just logged in to here after failed upgrade and saw this post.

In March, tried to upgrade 4.2.3 P2 to 4.2.4 and did not work.
Today, tried to upgrade 4.2.3 P2 to 4.2.5 and same.

Hosting shows PHP 5.6.30.

VB Admin shows PHP 5.4.45.

For MySQL both (hosting and VB Admin panel) show 5.6.33

Paul M 05-11-2017 09:51 AM

Quote:

Originally Posted by loua_oz (Post 2586377)
VB Admin shows PHP 5.4.45.

For MySQL both (hosting and VB Admin panel) show 5.6.33

Then your forum is running on php 5.4.
Its as simple as that, so contact your host.

loua_oz 05-11-2017 10:23 AM

Quote:

Originally Posted by Paul M (Post 2586383)
Then your forum is running on php 5.4.
Its as simple as that, so contact your host.

What should I tell them? Someone from VB told me that you, the hosting site, are lying about versions of PHP?

--------------- Added [DATE]1494506710[/DATE] at [TIME]1494506710[/TIME] ---------------

How could I dispute what my hosting site says:

PHP Version 5.6.30

--------------- Added [DATE]1494550190[/DATE] at [TIME]1494550190[/TIME] ---------------

Has anyone actually upgraded to 4.2.4 or 4.2.5?What was their provider and VB Panel showing as versions of PHP?

XXP 12-18-2017 07:28 PM

Please help.
On update to 4.2.5 from 4.2.2, getting SQL error.
As suggested in this thread: checked that Blogs are enabled (yes), and returned to the vB control panel to check status:
It now reports that we are at vb 4.2.5 (partially as the upgrade halts halfway), and it confirms PHP 7.1.12

Thanks very much.

Here's the error message:
Quote:

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/xxxxxadm/public_html/bb/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 cr_blog_text bt
JOIN cr_blog bl USING (blogid)
LEFT JOIN cr_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 cr_blog_text bt
JOIN cr_blog bl USING (blogid)
LEFT JOIN cr_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> : Monday, December 18th 2017 @ 03:21:34 PM<br />
<strong>Error Date</strong> : Monday, December 18th 2017 @ 03:21:35 PM<br />
<strong>Script</strong> : http://www.xxxxx.com/bb/install/upgrade.php<br />
<strong>Referrer</strong> : http://www.xxxxx.com/bb/install/upgrade.php<br />
<strong>Classname</strong> : vB_Database_MySQLi<br />
<strong>MySQL Version</strong> : 5.5.58-cll<br />
</p>]]></error_html>
</errors>

Mark.B 12-18-2017 09:36 PM

That's not even close to being the 'same error' - it is always best to start a new thread rather than piggybacking someone else's.

Anyway, in this case, you need to ensure the blog product is enabled in the admincp, then run the upgrade again.

Stingray27 12-20-2017 02:55 PM

Quote:

Originally Posted by XXP (Post 2591687)
As suggested in this thread: checked that Blogs are enabled (yes)

The error says otherwise, it only occurs if you try to upgrade with the blogs disabled.


All times are GMT. The time now is 01:59 PM.

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.01142 seconds
  • Memory Usage 1,749KB
  • 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
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete