User map [Deleted]

[CrispinP]

what did you put for
'<yourDBName>'

You should have:

SELECT
    COLUMN_NAME
FROM
    information_schema.COLUMNS WHERE TABLE_SCHEMA = 'myforumdb' AND TABLE_NAME = 'xf_user_profile'

where myforumdb is, well, your forum db.

 

[furyflyer]

giantsca_xenforo

 

[furyflyer]

This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.

 

[CrispinP]

That's a link to your c-panel. I can't see it


Do a screen print and send it to me via PC.

 

[furyflyer]

Mysqli statement execute error : Duplicate column name 'cum_map_location_last_update'

1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
3. Zend_Db_Adapter_Abstract->query() in Crispin/UserMap/Install/Base.php at line 25
4. Crispin_UserMap_Install_Base::install()
5. call_user_func() in XenForo/Model/AddOn.php at line 215
6. XenForo_Model_AddOn->installAddOnXml() in XenForo/Model/AddOn.php at line 169
7. XenForo_Model_AddOn->installAddOnXmlFromFile() in XenForo/ControllerAdmin/AddOn.php at line 188
8. XenForo_ControllerAdmin_AddOn->actionInstall() in XenForo/FrontController.php at line 351
9. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
10. XenForo_FrontController->run() in /home/giantscalenews/public_html/admin.php at line 13

 

[furyflyer]

still can't install or uninstall.

 

[CrispinP]

You still not sent a screen print of the SQL execution.
You've not answered question question

what did you put for
'<yourDBName>'

Happy to help but can't help get back to a stable place without some feedback.

Try running this now:
alter table xf_user_profile drop column cum_map_location_last_update;

Run it twice. The first time it should just run and return quietly, the second time it should fail.

If this happens then you should be back to square one and can reinstall it.

 

[Freelancer]

Server Error

Server Error Log
Error Info
XenForo_Exception: Response from API call was HTTP:0. - library/Crispin/UserMap/Model/UserMaps.php:379
Generated By: xxxxxxxxxxxxx, 51 minutes ago
Stack Trace
#0 /var/www/clients/client180/web812/web/library/Crispin/UserMap/DataWriter/User.php(25): Crispin_UserMap_Model_UserMaps->getGeoLocationFromLocation(209, '3515 VELASCO CO...')
#1 /var/www/clients/client180/web812/web/library/ModEss/DataWriter/User.php(15): Crispin_UserMap_DataWriter_User->_postSave()
#2 /var/www/clients/client180/web812/web/library/Siropu/Chat/DataWriter/Extend/User.php(36): ModEss_DataWriter_User->_postSave()
#3 /var/www/clients/client180/web812/web/library/XenPushover/DataWriter/User.php(19): Siropu_Chat_DataWriter_Extend_User->_postSave()
#4 /var/www/clients/client180/web812/web/library/XFA/ExtendedCover/Extends/XenForo/DataWriter/User.php(35): XenPushover_DataWriter_User->_postSave()
#5 /var/www/clients/client180/web812/web/library/Nobita/ProfileCover/XenForo/DataWriter/User.php(36): XFA_ExtendedCover_Extends_XenForo_DataWriter_User->_postSave()
#6 /var/www/clients/client180/web812/web/library/XenForo/DataWriter.php(1423): Nobita_ProfileCover_XenForo_DataWriter_User->_postSave()
#7 /var/www/clients/client180/web812/web/library/XenForo/Model/User.php(72): XenForo_DataWriter->save()
#8 /var/www/clients/client180/web812/web/library/XenForo/Model/User.php(2032): XenForo_Model_User->update(209, 'following', '244,157,140,331...')
#9 /var/www/clients/client180/web812/web/library/XenForo/Model/User.php(1810): XenForo_Model_User->updateFollowingDenormalizedValue(209)
#10 /var/www/clients/client180/web812/web/library/XenGallery/Model/User.php(54): XenForo_Model_User->follow(Array, true, Object(XenForo_Visitor))
#11 /var/www/clients/client180/web812/web/library/XenForo/ControllerPublic/Member.php(505): XenGallery_Model_User->follow(Array)
#12 /var/www/clients/client180/web812/web/library/XenForo/FrontController.php(351): XenForo_ControllerPublic_Member->actionFollow()
#13 /var/www/clients/client180/web812/web/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#14 /var/www/clients/client180/web812/web/index.php(13): XenForo_FrontController->run()
#15 {main}
Request State
array(3) {
  ["url"] => string(149) "https://www.xxxxxxxxxxxxxx.com/members/xxxxxxxxxxxxxxxxxxxxxx.152/follow?_xfToken=209%2C1472591553%2C112264d7a83d7b96d6e326cd586d189c7ce2500d"
  ["_GET"] => array(1) {
    ["_xfToken"] => string(55) "209,1472591553,112264d7a83d7b96d6e326cd586d189c7ce2500d"
  }
  ["_POST"] => array(5) {
    ["_xfConfirm"] => string(1) "1"
    ["_xfRequestUri"] => string(1) "/"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["_xfResponseType"] => string(4) "json"
  }
}

 

[CrispinP]

XenForo_Exception: Response from API call was HTTP:0. - library/Crispin/UserMap/Model/UserMaps.php:379

That seemed to happen when the client (you) stopped trusting the server (google). I had this with another user. Turns out their local certs were not updated so they did not trust the google SSL certificate.

As a test, look in ACP, tick the "Ignore SSL certificates" and see what happens.

 

[Freelancer]

As a test, look in ACP, tick the "Ignore SSL certificates" and see what happens.

I did. Nothing happened. Map is displayed ok.

 

[CrispinP]

all users or just the one? if one, send me the full string from his address. Must be something malforming it.
or
try https://maps.googleapis.com/maps/api/geocode/json?sensor=true&address=<changeme>

 

[Freelancer]

Not sure what you are referring to?

 

[CrispinP]

Sorry - not enough / too much coffee.

Does it happen for all users or just one/a-few?

The URL above, take it, append the value from that particular user's Map Location field and paste it into browser. Does the browser / google understand it?

 

[Freelancer]

Till now it was only one user it seems. Error didnt occur again.

Where/How do I get the value of the field? And how does it have to be written?

 

[CrispinP]

It's a communication error or SSL error between you and google. If it's not happening again then that's fine.

 

[Freelancer]

Okay. Maybe just a glitch or timeout.

 

[CrispinP]

To the new user who bought the add-on: please pc me, your PayPal email bounced.

 

[Dirk22]

Hi @CrispinP

To the new user who bought the add-on: please pc me, your PayPal email bounced.

I have sent you an email with an alternative email address you can contact me. Sorry for problems with bounced email.

 

[Dirk22]

Hi CrispinP,

thank you for the User Map.

I have installed the User Map, very nice
(first I entered two map locations for test and set viewing rights only to me)

The red marked links not working correctly.


Main Menu:

Map
domain/index.php?usermap/
Map/Map overview
domain/index.php?usermap/
Map/Your position
domain/index.php?usermap?viewuser=1/


All other links (Member Navigation Tab, User Account Menu, Forum Navigation Tab, Member Profile) targets to self location:
domain/index.php?usermap?viewuser=1/

Message User Block:
there is no link with my custom template, with xenforo default template link exist:
domain/usermap?viewuser=1
This link is ok, it targets to User of message block
Maybe a problem with my custom template.


This would work: domain/index.php?usermap&viewuser=1/
Or this without "index.php?": domain/usermap?viewuser=1 (maybe a wrong config in ACP forum setup?!)

Any idea?

 

[CrispinP]

Map/Your position
domain/index.php?usermap?viewuser=1/

That certainly won't work.

It should be:

See there^^


It looks like you might have url_rewrite turned off. Do URLs to your threads look like this

https://www.landcruiserclub.net/community/threads/dragons-breath.146369/#post-1421514

or do they say /index.php?somethingorother?