Error after upgrade from 2.1.5 to 2.1.6 - How can I solve this?

Prosper

I upgraded from vanilla 2.1.5 to 2.1.6.
Update seems to be okay and /utility/update and /utility/structure where successful and showed no errors.
However, when I click on the name of any forum member I get this error below. Profile page shows the error. Edit profile page shows same error.
Please how can I solve this?

Fatal Error in Gdn_Database.Query();

PDO Statement failed to prepare

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 '?' at line 5
The error occurred on or near: /home4/casiegbu/public_html/library/database/class.database.php

288:       if (!is_null($InputParameters) && count($InputParameters) > 0) {
289:          $PDOStatement = $this->Connection()->prepare($Sql);
290: 
291:          if (!is_object($PDOStatement)) {
292:             trigger_error(ErrorMessage('PDO Statement failed to prepare', $this->ClassName, 'Query', $this->GetPDOErrorMessage($this->Connection()->errorInfo())), E_USER_ERROR);
293:          } else if ($PDOStatement->execute($InputParameters) === FALSE) {
294:             trigger_error(ErrorMessage($this->GetPDOErrorMessage($PDOStatement->errorInfo()), $this->ClassName, 'Query', $Sql), E_USER_ERROR);
295:          }
296:       } else {

peregrine

@Prosper said:
R_J the link is this
http://naijanetwork.com/profile/3/John
There is no possible alteration I made to the theme other than updating from Vanilla 2.1.5 to Vanilla 2.1.6

as usual when debugging and troubleshooting, reduce the problem and make it as simple as possible.

that is,

change to the default theme and see if you have the problem.

disable all plugins and see if you have the problem.

troubleshooting problems has not changed.

the issue you see now, is possibly a result of this security change in 2.1.6 upgrade, if it worked in 2.1.5

$this->_Connection->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);

but the question still remains. do you see the problem with default theme and plugins disabled.

Prosper

I just found out that the problem occur only on the desktop theme and not on the mobile theme. Notification link says "Whoops There was an error". Please I need assistance.

R_J

Have you altered that theme? Can you post the link that you click?

Prosper

@R_J the link is this
http://naijanetwork.com/profile/3/John
There is no possible alteration I made to the theme other than updating from Vanilla 2.1.5 to Vanilla 2.1.6

peregrine

@Prosper said:
R_J the link is this
http://naijanetwork.com/profile/3/John
There is no possible alteration I made to the theme other than updating from Vanilla 2.1.5 to Vanilla 2.1.6

as usual when debugging and troubleshooting, reduce the problem and make it as simple as possible.

that is,

change to the default theme and see if you have the problem.

disable all plugins and see if you have the problem.

troubleshooting problems has not changed.

the issue you see now, is possibly a result of this security change in 2.1.6 upgrade, if it worked in 2.1.5

$this->_Connection->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);

but the question still remains. do you see the problem with default theme and plugins disabled.

Prosper

@Peregrine and @R_J - Thank you guys for your inputs.
"Following" plugin by @Tim Gunter caused the problem. I have disabled the plugin and issue is solved.

peregrine

@Prosper‌

check this before using plugins.

http://vanillaforums.org/discussion/26703/plugins-themes-that-work-and-dont-work-in-vanilla-2-1

and add your information the the discussion.

http://vanillaforums.org/discussion/26703/plugins-themes-that-work-and-dont-work-in-vanilla-2-1

Prosper

@peregrine - Thanks