User map [Deleted]

Take one of your users and change their location in the Map Location and save. Does it change on the map? Trying to see if it's the saving or encoding on youside which is not working.
said user - what are the privacy settings for the map on that? They should be set to any or Location. Anything else will not invoke the location check.
 
I have gotten 4 of these errors in my server log below ever since I installed the new v4.0
Code: 
Error Info

Mysqli statement execute error : Incorrect integer value: '' for column 'randomise_on_map' at row 1 - library/Zend/Db/Statement/Mysqli.php:214

Stack Trace

#0 /home/me/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)

#1 /home/me/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)

#2 /home/me/public_html/library/Crispin/UserMap/Model/UserMaps.php(49): Zend_Db_Adapter_Abstract->query('insert into cri...')

#3 /home/me/public_html/library/Crispin/UserMap/DataWriter/User.php(55): Crispin_UserMap_Model_UserMaps->savePrivacy(Array)

#4 /home/me/public_html/library/PemBer/DataWriter/User.php(175): Crispin_UserMap_DataWriter_User->_postSave()

#5 /home/me/public_html/library/XenForo/DataWriter.php(1423): PemBer_DataWriter_User->_postSave()

#6 /home/me/public_html/library/XenForo/ControllerPublic/Register.php(416): XenForo_DataWriter->save()

#7 /home/me/public_html/library/PemBer/ControllerPublic/Register.php(157): XenForo_ControllerPublic_Register->actionRegister()

#8 /home/me/public_html/library/Andy/RegisterEmail/ControllerPublic/Register.php(7): PemBer_ControllerPublic_Register->actionRegister()

#9 /home/me/public_html/library/XenForo/FrontController.php(351): Andy_RegisterEmail_ControllerPublic_Register->actionRegister()

#10 /home/me/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))

#11 /home/me/public_html/index.php(13): XenForo_FrontController->run()

#12 {main}
.
 
Last edited:
I've had to turn the mod off because no one can register because of the error

I also cannot uninstall it either, it gives me an error :(

How do I uninstall it? Please send me the patch so I can uninstall this for now. It’s says field cannot be found when trying to uninstall.
 
Last edited:
Oh dear. Sorry about that :(

I'll send a patch file to get it working again.

As for the uninstall - I'm redoing all of that in 4.1. I know it's a bit lumpy.


Update coming soon.
 
Even when I disable the add-on it it throws the other Map Location box on the registration page. I had that box normally turned off and this is what happens with the add-on disabled.

Untitled.webp
.
 
The error might have something to do with my Don't Randomize setting....

Mysqli statement execute error : Incorrect integer value: '' for column 'randomise_on_map' at row 1 - library/Zend/Db/Statement/Mysqli.php:214

Untitled.webp

P.S. I've seen some add-ons in the past that after install the default checked settings don't always take in the database and you sometimes have to check or uncheck the boxes or settings and then save and then set them where you want them then save again. Might be what's going on here.

It's strange though how the Map location thing pops up on the registration page only after I disable the add-on.
.
.
 
Last edited:
RSI said:
The error might have had something to do with my Don't Randomize setting....

Mysqli statement execute error : Incorrect integer value: '' for column 'randomise_on_map' at row 1 - library/Zend/Db/Statement/Mysqli.php:214

View attachment 151584
.
Click to expand...

I can confirm I'm also getting the exact same issue on registrations.

@CrispinP


Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Incorrect integer value: '' for column 'randomise_on_map' at row 1 - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Unknown Account, Today at 10:17 AM
Stack Trace
#0 /var/www/forum.com/htdocs/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /var/www/forum.com/htdocs/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /var/www/forum.com/htdocs/library/Crispin/UserMap/Model/UserMaps.php(49): Zend_Db_Adapter_Abstract->query('insert into cri...')
#3 /var/www/forum.com/htdocs/library/Crispin/UserMap/DataWriter/User.php(55): Crispin_UserMap_Model_UserMaps->savePrivacy(Array)
#4 /var/www/forum.com/htdocs/library/XFA/ExtendedCover/Extends/XenForo/DataWriter/User.php(35): Crispin_UserMap_DataWriter_User->_postSave()
#5 /var/www/forum.com/htdocs/library/DigitalPointBetterAnalytics/DataWriter/User.php(12): XFA_ExtendedCover_Extends_XenForo_DataWriter_User->_postSave()
#6 /var/www/forum.com/htdocs/library/XenForo/DataWriter.php(1423): DigitalPointBetterAnalytics_DataWriter_User->_postSave()
#7 /var/www/forum.com/htdocs/library/XenForo/ControllerPublic/Register.php(416): XenForo_DataWriter->save()
#8 /var/www/forum.com/htdocs/library/XenForo/FrontController.php(351): XenForo_ControllerPublic_Register->actionRegister()
#9 /var/www/forum.com/htdocs/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /var/www/forum.com/htdocs/index.php(13): XenForo_FrontController->run()
#11 {main}
 
CrispinP said:
I'll add that. It happened to me but not to most others. Still, it's worth the mention.


That could be added too.


Urm, nope, should happen as soon as you change ACP. Change it to something like 3 days. See what happens.
Click to expand...

One more suggestion. In addition to exposing the active for X days on the front end as a filter I would also like to see an option to not show banned users on the map as they appear to be showing up (unless I'm missing an option somewhere).
 
ichpen said:
I can confirm I'm also getting the exact same issue on registrations.

@CrispinP


Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Incorrect integer value: '' for column 'randomise_on_map' at row 1 - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Unknown Account, Today at 10:17 AM
Stack Trace
#0 /var/www/forum.com/htdocs/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /var/www/forum.com/htdocs/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /var/www/forum.com/htdocs/library/Crispin/UserMap/Model/UserMaps.php(49): Zend_Db_Adapter_Abstract->query('insert into cri...')
#3 /var/www/forum.com/htdocs/library/Crispin/UserMap/DataWriter/User.php(55): Crispin_UserMap_Model_UserMaps->savePrivacy(Array)
#4 /var/www/forum.com/htdocs/library/XFA/ExtendedCover/Extends/XenForo/DataWriter/User.php(35): Crispin_UserMap_DataWriter_User->_postSave()
#5 /var/www/forum.com/htdocs/library/DigitalPointBetterAnalytics/DataWriter/User.php(12): XFA_ExtendedCover_Extends_XenForo_DataWriter_User->_postSave()
#6 /var/www/forum.com/htdocs/library/XenForo/DataWriter.php(1423): DigitalPointBetterAnalytics_DataWriter_User->_postSave()
#7 /var/www/forum.com/htdocs/library/XenForo/ControllerPublic/Register.php(416): XenForo_DataWriter->save()
#8 /var/www/forum.com/htdocs/library/XenForo/FrontController.php(351): XenForo_ControllerPublic_Register->actionRegister()
#9 /var/www/forum.com/htdocs/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /var/www/forum.com/htdocs/index.php(13): XenForo_FrontController->run()
#11 {main}
Click to expand...


Frustrating. I cannot recreate it. I sent RSI a patched file to test. Will send you the same one if you can test please.


Thanks
C
 
I'm using that new file now too, but I also re-upgraded the add-on again with all the ACP checkboxes unchecked and that seems to have done it. I went back and rechecked the boxes to change the settings back after and then saved it. Now when I register the error is gone.

It might be due to a semi-corrupted upgrade install when going from v3.6 to v4.o

I still need the Map Location box to disappear on the registration page when the add-on is disabled along with being able to uninstall the add-on. I need to be able to uninstall it.
.
 
RSI said:
Now when I register the error is gone.
Click to expand...
Good to hear. Still confused by it though....

RSI said:
I still need the Map Location box to disappear on the registration page when the add-on is disabled along with being able to uninstall the add-on. I need to be able to uninstall it.
Click to expand...
I'm redoing the install / uninstall bits so will get that sorted out next. As for the box appearing when it's disabled - most odd. will try recreate it.

C
 
Got an error log page full of these errors today, not sure why.

I'm still on 3.6

Code: 
ArgumentCountError: Too few arguments to function Crispin_UserMap_Model_UserMaps::getSettings(), 1 passed in /home/evolve/public_html/library/Crispin/UserMap/Listener.php on line 36 and exactly 2 expected - library/Crispin/UserMap/Model/UserMaps.php:194
Generated By: Kist2001, Today at 1:30 AM
Stack Trace
#0 /home/evolve/public_html/library/Crispin/UserMap/Listener.php(36): Crispin_UserMap_Model_UserMaps->getSettings(889)
#1 /home/evolve/public_html/library/XenForo/CodeEvent.php(58): Crispin_UserMap_Listener::template_hook_members_view('member_view_tab...', '', Array, Object(XenForo_Template_Public))
#2 /home/evolve/public_html/library/XenForo/Template/Abstract.php(285): XenForo_CodeEvent::fire('template_hook', Array, 'member_view_tab...')
#3 /home/evolve/public_html/library/XenForo/Template/Abstract.php(265) : eval()'d code(2221): XenForo_Template_Abstract->callTemplateHook('member_view_tab...', '', Array)
#4 /home/evolve/public_html/library/XenForo/Template/Abstract.php(265): eval()
#5 /home/evolve/public_html/library/XenForo/Template/Abstract.php(191): XenForo_Template_Abstract->_renderInternal('$__output = '';...', Array)
#6 /home/evolve/public_html/library/XenForo/Template/Public.php(110): XenForo_Template_Abstract->render()
#7 /home/evolve/public_html/library/XenForo/ViewRenderer/HtmlPublic.php(124): XenForo_Template_Public->render()
#8 /home/evolve/public_html/library/XenForo/FrontController.php(639): XenForo_ViewRenderer_HtmlPublic->renderContainer(Object(XenForo_Template_Public), Array)
#9 /home/evolve/public_html/library/XenForo/FrontController.php(158): XenForo_FrontController->renderView(Object(XenForo_ControllerResponse_View), Object(XenForo_ViewRenderer_HtmlPublic), Array)
#10 /home/evolve/public_html/index.php(13): XenForo_FrontController->run()
#11 {main}
Request State
array(3) {
  ["url"] => string(44) "https://site.com/members/lethal.696/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}
 
I can't view any user profiles because of the above error.

I'm hesitant to install the latest 4.0 version distributed by message due to issues other had above and no patch posted publicly to us yet.
 
Last edited:
Thanks for the patch mate - seems to have sorted it, working great!

Loving the way you can drag and resize the catchment area now. I've been able to target users in select areas of the world, generate the usernames from the conversation, convert them to a list prepended with @, and then tag them in upcoming event threads near where they live to invite them.
 
I think the 'Start user conversation' permission doesn't work correctly.

I've got it set to 'No, not allowed' and I can still see the link and start conversations.
 
You must log in or register to reply here.

Similar threads

Fredxd
Members map [Deleted]
Replies
1
Views
16
Fredxd
Fredxd
fahad ashraf
[XB] Join User Group [Deleted]
2 3
Replies
43
Views
3K
Paul B
P
Back
Top Bottom