Bonk : Column 'UserId' cannot be null, version 1.1

Srggamer

Getting bonk error when Installing plugin. Any fixes?

422

try explaining more

Konquet

try explaining more and look this :

http://vanillawiki.homebrewforums.net/index.php/Bonk_Errors

:=)

Srggamer

Column 'UserId' cannot be null
insert GDN_PeregrineBadges (UserId, AnniversaryBadge) values (:UserId, :AnniversaryBadge)
The error occurred on or near: /home/rpaso604/public_html/dragonx.net/community/library/database/class.database.php

276: 

277:          if (!is_object($PDOStatement)) {

278:             trigger_error(ErrorMessage('PDO Statement failed to prepare', $this->ClassName, 'Query', $this->GetPDOErrorMessage($this->Connection()->errorInfo())), E_USER_ERROR);

279:          } else if ($PDOStatement->execute($InputParameters) === FALSE) {

280:             trigger_error(ErrorMessage($this->GetPDOErrorMessage($PDOStatement->errorInfo()), $this->ClassName, 'Query', $Sql), E_USER_ERROR);

281:          }

282:       } else {

283:          $PDOStatement = $this->Connection()->query($Sql);

284:       }

Backtrace:

/home/rpaso604/public_html/dragonx.net/community/library/database/class.database.phpPHP::Gdn_ErrorHandler();

[/home/rpaso604/public_html/dragonx.net/community/library/database/class.database.php:280] PHP::trigger_error();

[/home/rpaso604/public_html/dragonx.net/community/library/database/class.sqldriver.php:1650] Gdn_Database->Query();

[/home/rpaso604/public_html/dragonx.net/community/library/database/class.sqldriver.php:1121] Gdn_SQLDriver->Query();

[/home/rpaso604/public_html/dragonx.net/community/plugins/PeregrineBadges/class.peregrinebadgesmodel.php:58] Gdn_SQLDriver->Insert();

[/home/rpaso604/public_html/dragonx.net/community/plugins/PeregrineBadges/default.php:87] PeregrineBadgesModel->InsertAnniversaryBadge();

[/home/rpaso604/public_html/dragonx.net/community/plugins/PeregrineBadges/default.php:48] PeregrineBadgesPlugin->BadgePointUpDate();

[/home/rpaso604/public_html/dragonx.net/community/library/core/class.pluginmanager.php:648] PeregrineBadgesPlugin->ProfileController_BeforeRenderAsset_Handler();

[/home/rpaso604/public_html/dragonx.net/community/library/core/class.pluginmanager.php:590] Gdn_PluginManager->CallEventHandler();

[/home/rpaso604/public_html/dragonx.net/community/library/core/class.pluggable.php:127] Gdn_PluginManager->CallEventHandlers();

[/home/rpaso604/public_html/dragonx.net/community/library/vendors/SmartyPlugins/function.asset.php:37] Gdn_Pluggable->FireEvent();

[/home/rpaso604/public_html/dragonx.net/community/cache/Smarty/compile/%%1F^1F8^1F82467F%%default.master.tpl.php:50] PHP::smarty_function_asset();

[/home/rpaso604/public_html/dragonx.net/community/library/vendors/Smarty-2.6.25/libs/Smarty.class.php:1276] PHP::include();

[/home/rpaso604/public_html/dragonx.net/community/library/vendors/Smarty-2.6.25/libs/Smarty.class.php:1126] Smarty->fetch();

[/home/rpaso604/public_html/dragonx.net/community/library/core/class.smarty.php:81] Smarty->display();

[/home/rpaso604/public_html/dragonx.net/community/library/core/class.controller.php:1566] Gdn_Smarty->Render();

[/home/rpaso604/public_html/dragonx.net/community/library/core/class.controller.php:1141] Gdn_Controller->RenderMaster();

[/home/rpaso604/public_html/dragonx.net/community/library/core/class.pluggable.php:193] Gdn_Controller->xRender();

[/home/rpaso604/public_html/dragonx.net/community/applications/dashboard/controllers/class.profilecontroller.php:420] Gdn_Pluggable->__call();

[/home/rpaso604/public_html/dragonx.net/community/applications/dashboard/controllers/class.profilecontroller.php:420] ProfileController->Render();

[/home/rpaso604/public_html/dragonx.net/community/applications/dashboard/controllers/class.profilecontroller.php:324] ProfileController->Notifications();

[/home/rpaso604/public_html/dragonx.net/community/applications/dashboard/controllers/class.profilecontroller.php:324] ProfileController->Index();

[/home/rpaso604/public_html/dragonx.net/community/library/core/class.dispatcher.php:322] PHP::call_user_func_array();

[/home/rpaso604/public_html/dragonx.net/community/index.php:53] Gdn_Dispatcher->Dispatch();

Variables in local scope:

[Sql] 'insert GDN_PeregrineBadges 
(UserId, AnniversaryBadge) 
values (:UserId, :AnniversaryBadge)'

[InputParameters] array (
  ':UserId' => NULL,
  ':AnniversaryBadge' => 43,
)

[Options] array (
  'ReturnType' => 'ID',
)

[ReturnType] 'ID'

[PDOStatement] array (
  'queryString' => 'insert GDN_PeregrineBadges 
(UserId, AnniversaryBadge) 
values (:UserId, :AnniversaryBadge)',
)

This?

Konquet

da fuq edit the post and use :

< pre >yourcode < /pre >

remember deleted the space.

Srggamer

@Konquet said:
da fuq edit the post and use :

< pre >yourcode < /pre >

remember deleted the space.

Better? The Tag want closed.

peregrine

which version of plugin are you using?

Srggamer

I am Using the 1.1, Everything works, exsept when I click profile (Alex me) or others I get this BONK

422

line 25 looks sus

peregrine

@Srggamer

thanks for the feedback.

go back to 1.0 if you have problems.

I am rewriting some performance improvements and if it doesn't work for you, use version 1.0 or wait till the next enhancement.

Konquet

yep line 25 dont have " [ " that is the problem?

peregrine

line 25? which file? and are you logged in or not logged in when you get error.

In any event go back to version 1.0, if no further explanations instead of cryptic responses.

Konquet

@peregrine said:
line 25? which file?

/home/rpaso604/public_html/dragonx.net/community/library/database/class.database.phpPHP::Gdn_ErrorHandler();
 
[/home/rpaso604/public_html/dragonx.net/community/library/database/class.database.php:280] PHP::trigger_error();

Is wrong?

peregrine

Actually, "[" has nothing to do with it.

The userid is not set properly, perhaps the session is not logged in.

I'm rewriting anyway - thanks for the help.

In any event go back to version 1.0

Konquet

Ok :=)

phreak

@peregrine: Confirming the bonk also so i switched back to 1.0. ... But another thing i do not want to open a new thread for...

New users have no indication of 0 near the points in the profile, when they haven't collected any.

Total Points:

Maybe you can preserve a 0 here so it states:
Total Points: 0

peregrine

@phreak said:
peregrine: Confirming the bonk also so i switched back to 1.0. ... But another thing i do not want to open a new thread for...

New users have no indication of 0 near the points in the profile, when they haven't collected any.

Total Points:

Maybe you can preserve a 0 here so it states:
Total Points: 0

done. version 1.2 is available for testing. Read the readme in the plugin.

Srggamer

@peregrine said:

Great! Could you do a list of what you get for doing achievements then I may Photoshop my own images?

Srggamer

Fatal error: Call to undefined method PeregrineBadgesModel::GetTotalPoints() in /home/rpaso604/public_html/dragonx.net/community/plugins/PeregrineBadges/class.peregrinebadgesmodule.php on line 24

How can I fix this?

Srggamer

Also Adding this removed my header.

peregrine

@Srggamer said:

Fatal error: Call to undefined method PeregrineBadgesModel::GetTotalPoints() in /home/rpaso604/public_html/dragonx.net/community/plugins/PeregrineBadges/class.peregrinebadgesmodule.php on line 24

How can I fix this?

in version 1.2? Are you certain you updated? P

Please update to version 1.2

no need to report more errors in version 1.1 please.