host of new errors after upgrade june 2014

[playthatbeat]

just FYI, a shitload of fucking errors now appearing after upgrade to 4.2.2.pl1

[playthatbeat]

While editing a post:

Warning: Only variables should be passed by reference in ..../editpost.php on line 327



Database error in vBulletin 4.2.2:

Invalid SQL:

					REPLACE INTO subscribethread (userid, threadid, emailupdate, folderid, canview)
					VALUES (21, 2820, , 0, 1);

MySQL Error   : 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 ' 0, 1)' at line 2
Error Number  : 1064
Request Date  : Friday, July 4th 2014 @ 12:18:47 PM
Error Date    : Friday, July 4th 2014 @ 12:18:48 PM
Script        : http://www.mrspring.info/vbulletin/editpost.php?do=updatepost&p=10120
Referrer      : http://www.mrspring.info/vbulletin/editpost.php?p=10120&do=editpost
IP Address    : 89.207.58.11
Username      : playthatbeat
Classname     : vB_Database
MySQL Version : 5.5.37-cll

solution:

If you need to disable error displays you can do the following ;

 Add the following line to your config.php under the 

[playthatbeat]

does not work (above)

Database error in vBulletin 4.2.2:

Invalid SQL:

					REPLACE INTO subscribethread (userid, threadid, emailupdate, folderid, canview)
					VALUES (21, 2818, , 0, 1);

MySQL Error   : 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 ' 0, 1)' at line 2
Error Number  : 1064
Request Date  : Friday, July 4th 2014 @ 04:38:53 PM
Error Date    : Friday, July 4th 2014 @ 04:38:53 PM
Script        : http://www.mrspring.info/vbulletin/editpost.php?do=updatepost&p=10121
Referrer      : http://www.mrspring.info/vbulletin/editpost.php?p=10121&do=editpost
IP Address    : 93.107.103.162
Username      : playthatbeat
Classname     : vB_Database
MySQL Version : 5.5.37-cll

[playthatbeat]

complaint in this thread: http://www.vbulletin.com/forum/forum...line-389/page3

[-=GoD=-]

ticket opened with vBulletin support:

Jul 17th '14 07:00am                                                                                       After upgrading to 4.2.2pl1 from 4.2.1, i started seeing some errors. one was suppressed after seeing this thread:

[URL="https://www.vbulletin.com/link.php?u=http%3A%2F%2Fwww.vbulletin.com%2Fforum%2Fforum%2Fvbulletin-4%2Fvbulletin-4-installations-and-upgrades%2F4000136-warning-only-vaiables-should-be-passed-by-reference-in-newreply-php-on-line-389"]http://www.vbulletin.com/forum/forum/vbulletin-4/vbulletin-4-installations-and-upgrades/4000136-warning-only-vaiables-should-be-passed-by-reference-in-newreply-php-on-line-389[/URL]

This thread also contains details of the new 'fatal' SQL error triggered by editing posts i can now not avoid.

no changes server-side, no edits aside from the error suppression edit called for in the above thread.

plugins & products have been disabled, making no difference.

https://www.vbulletin.com/issue.php?...hcode=9fda7814

login to get to this:

Customer Number: 8292110632654
Customer Password: 4c679958825

also, to help vbull support,

admin a/c created today, user: vbadmin

ftp to .info created, user: vbadmin

cpanel login shared also for access to phpMyAdmin etc.

meh, etc.

[-=GoD=-]

just checking:

Database error in vBulletin 4.2.2:

Invalid SQL:

                    REPLACE INTO subscribethread (userid, threadid, emailupdate, folderid, canview)
                    VALUES (1, 2818, , 0, 1);

MySQL Error   : 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 ' 0, 1)' at line 2
Error Number  : 1064
Request Date  : Thursday, July 17th 2014 @ 01:05:42 PM
Error Date    : Thursday, July 17th 2014 @ 01:05:42 PM
Script        : http://www.mrspring.info/vbulletin/editpost.php?do=updatepost&p=10142
Referrer      : http://www.mrspring.info/vbulletin/editpost.php?p=10142&do=editpost
IP Address    : 93.107.103.162
Username      : -=GoD=-
Classname     : vB_Database
MySQL Version : 5.5.37-cll

[-=GoD=-]

registration (new members) is suspended for now.

[-=GoD=-]

emailed reply:

Hello,

Thank you for posting a support contact request with the
vBulletin issue system. To view your query (and post
followups), please visit this address:
https://www.vbulletin.com/issue.php?...hcode=9fda7814

If you would like to post a followup (or reply) to your
query via email, please email contact@vbulletin.com being
sure to include this text in the subject:
[SID-1279222-9fda7814]

You will receive an email notification when a member of the support
team replies to your issue.

Please note, we are experiencing an extremely high volume of support requests at this time. All issues will be answered in the order they are received in and we will contact you as soon as possible. Thank you for understanding.

Thanks,

vBulletin

__________________________________________________
vBulletin® is a registered trademark of vBulletin Solutions, Inc. in the U.S., with registration pending. This e-mail message is confidential and for use by the addressee only. You are not allowed to share the contents of this message with anyone, nor are you allowed to post the URL of this ticket. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. vBulletin Solutions, Inc. does not accept responsibility for changes made to this message after it was sent.

[playthatbeat]

vBulleting support (Zach) has fixed this problem, we think by over-writing the editpost.php with a fresh copy.. simples!

goddamn, it's the little things!

registration re-enabled.

tyfffyfyyfytft vyu