Master Badge [Paid] [Deleted]

[Milano]

its still not working.. i dont understand that anymore..

Any error logs? I'm installing PHP 7 on my PC and gonna run a test though.

 

[NicoKuroKusagi]

where can i find the error logs?

 

[Milano]

In your admin CP, Tools -> Server Error Log

 

[NicoKuroKusagi]

There are 2 Errors Spamming:

array(3) {
["url"] => string(59) "http://linkremoved.de/board/admin.php?trophies/add"
["_GET"] => array(1) {
["trophies/add"] => string(0) ""
}
["_POST"] => array(0) {
}
}

and

array(3) {
["url"] => string(62) "http://linkremoved.de/board/admin.php?trophies/0/save"
["_GET"] => array(1) {
["trophies/0/save"] => string(0) ""
}
["_POST"] => array(13) {
["title"] => string(21) "Test"
["trophy_points"] => string(2) "10"
["description"] => string(34) "Test"
["trophy_key"] => string(0) ""
["badge_id"] => string(1) "0"
["trophy_order"] => string(2) "10"
["upload_trophy_icon"] => string(1) "1"
["callback_class"] => string(0) ""
["callback_method"] => string(0) ""
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(29) "/board/admin.php?trophies/add"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}

 

[Milano]

There are 2 Errors Spamming:



and

What is the message title? This looks like request details.

 

[NicoKuroKusagi]

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'trophy_key' in 'field list' - library\Zend\Db\Statement\Mysqli.php:77 you mean this ?

 

[Milano]

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'trophy_key' in 'field list' - library\Zend\Db\Statement\Mysqli.php:77 you mean this ?

Yeah, something link that. Is this one of latest 2 error messages?

 

[NicoKuroKusagi]

yes this is the latest. you can add me on skype if you have and i can show you all you need. will pm you with my name.

 

[Milano]

yes this is the latest. you can add me on skype if you have and i can show you all you need. will pm you with my name.

So you haven't run those queries from previous reply yet?

 

[NicoKuroKusagi]

i did.. nothing changed..

 

[NicoKuroKusagi]

I can create badges now but if i want to create a trophy this is still happening:

Mysqli prepare error: Unknown column 'trophy_key' in 'field list'

1. Zend_Db_Statement_Mysqli->_prepare() in C:\inetpub\wwwroot\board\library\Zend\Db\Statement.php at line 115
2. Zend_Db_Statement->__construct() in C:\inetpub\wwwroot\board\library\Zend\Db\Adapter\Mysqli.php at line 381
3. Zend_Db_Adapter_Mysqli->prepare() in C:\inetpub\wwwroot\board\library\Zend\Db\Adapter\Abstract.php at line 478
4. Zend_Db_Adapter_Abstract->query() in C:\inetpub\wwwroot\board\library\Zend\Db\Adapter\Abstract.php at line 574
5. Zend_Db_Adapter_Abstract->insert() in C:\inetpub\wwwroot\board\library\XenForo\DataWriter.php at line 1638
6. XenForo_DataWriter->_insert() in C:\inetpub\wwwroot\board\library\XenForo\DataWriter.php at line 1627
7. XenForo_DataWriter->_save() in C:\inetpub\wwwroot\board\library\XenForo\DataWriter.php at line 1419
8. XenForo_DataWriter->save() in C:\inetpub\wwwroot\board\library\XenForo\ControllerAdmin\Trophy.php at line 105
9. XenForo_ControllerAdmin_Trophy->actionSave() inC:\inetpub\wwwroot\board\library\MasterBadge\ControllerAdmin\Trophy.php at line 75
10. MasterBadge_ControllerAdmin_Trophy->actionSave() in C:\inetpub\wwwroot\board\library\XenForo\FrontController.php at line 351
11. XenForo_FrontController->dispatch() in C:\inetpub\wwwroot\board\library\XenForo\FrontController.php at line 134
12. XenForo_FrontController->run() in C:\inetpub\wwwroot\board\admin.php at line 13

 

[Milano]

i did.. nothing changed..

From the error log message, it showed that you haven't run it yet. Could you list all the columns of your xf_trophy table?

 

[NicoKuroKusagi]

is that what you need?

trophy_id trophy_points user_criteria badge_id trophy_order icon_date callback_class callback_method
1 1 [BLOB - 90 B] 0 0 0
2 5 [BLOB - 91 B] 0 0 0
3 10 [BLOB - 92 B] 0 0 0
4 20 [BLOB - 93 B] 0 0 0
5 2 [BLOB - 82 B] 0 0 0
6 10 [BLOB - 83 B] 0 0 0
7 15 [BLOB - 84 B] 0 0 0
8 20 [BLOB - 84 B] 0 0 0
9 30 [BLOB - 84 B] 0 0 0

Im really sorry but my english is bad..

 

[Milano]

Please run this SQL query, seems like the installation routine was not successfully completed.

ALTER TABLE `xf_trophy` ADD `trophy_key` VARBINARY(35) NOT NULL DEFAULT '' ;

Are you missing this one?

 

[NicoKuroKusagi]

i needed to do it like 10 times to get it work.. seems to be working now. thanks for the help!

 

[NicoKuroKusagi]

The Trophy System is now working perfectly but you are not able to register anymore.. the error is Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'awarded_trophy' in 'field list' - library\Zend\Db\Statement\Mysqli.php:77 do you know a fix ?

 

[Milano]

Pls run this SQL query

ALTER TABLE `xf_user` ADD `awarded_trophy` MEDIUMBLOB NULL;

 

[MasonK]

There's still no fix for the tooltip and I was wondering how I could move the trophies below the user information in the postbit, example: below locations, message count, etc.

 

[Milano]

There's still no fix for the tooltip and I was wondering how I could move the trophies below the user information in the postbit, example: below locations, message count, etc.

I don't have any problems with the tooltip, check you browser console for any errors. You can move the trophies below the user postbit by edit this add-on message_user_info template modification.

 

[MasonK]

Do any of these look relevant?