Please do NOT post requests for help here. Use the Help forum for that.

TOPIC: Unknown column—bug?

Unknown column—bug? 1 week 1 day ago #1

  • WGroleau
  • WGroleau's Avatar
  • Offline
  • Gold
  • Posts: 1523
Is this (image) a bug I should report? It doesn’t sound like a configuration issue.
Seems odd that latitude and longitude are not failing at the same time.
--
Wes Groleau
UniGen.us/
PHP 7.2.15; MySQL 5.6.40; Apache
Last Edit: 1 week 1 day ago by WGroleau.
The administrator has disabled public write access.

Unknown column—bug? 1 week 23 hours ago #2

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Posts: 11357
The google-maps module is part of webtrees 1.7.
It uses the sv_lati/sv_long columns to store the google-street-view location

webtrees 2.0 uses openstreetmap instead of google maps.
There is no streetview equivalent on OSM - or any other mapping provider.

So, the upgrade from 1.7 to 2.0 deletes these columns.

Are you using a database from 2.0 with 1.7?
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net
The administrator has disabled public write access.

Unknown column—bug? 1 week 14 hours ago #3

  • WGroleau
  • WGroleau's Avatar
  • Offline
  • Gold
  • Posts: 1523
Ffisharebest wrote:
webtrees 2.0 uses openstreetmap instead of google maps.
There is no streetview equivalent on OSM - or any other mapping provider.

So, the upgrade from 1.7 to 2.0 deletes these columns.

Are you using a database from 2.0 with 1.7?

The last couple of years, I have only done upgrades by the control panel link, which currently says I am at 1.7.14 with no upgrade available.
--
Wes Groleau
UniGen.us/
PHP 7.2.15; MySQL 5.6.40; Apache
The administrator has disabled public write access.

Unknown column—bug? 3 days 9 hours ago #4

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Posts: 11357
I have looked at the 1.7 and 2.0 code.

The columns were deleted in 2.0. I can't see how they could be deleted in just 1.7 code.

I can't see how these columns would be deleted if you have only ever used 1.7 code.

Can you show me the structure of the wt_placelocation table in your database?
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net
The administrator has disabled public write access.

Unknown column—bug? 3 days 8 hours ago #5

  • WGroleau
  • WGroleau's Avatar
  • Offline
  • Gold
  • Posts: 1523
fisharebest wrote:
I can't see how these columns would be deleted if you have only ever used 1.7 code.

Can you show me the structure of the wt_placelocation table in your database?

Is it possible to have unintentionally installed 2.0 ? But then I don’t know how I would have reversed it.
Or is it possible that long ago when I was updating via git or svn, that I got something I regret?

The first such error happened 2015-09-09 14:34:31. Seems they happen when no one is logged in and a spider is crawling.

I only have an iPad right now, so I can’t download SQL, but I got a PDF from phpmyadmin. And then could not post the PDF, so had to take a screenshot of that!
Attachments:
--
Wes Groleau
UniGen.us/
PHP 7.2.15; MySQL 5.6.40; Apache
The administrator has disabled public write access.

Unknown column—bug? 2 days 18 hours ago #6

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Posts: 11357
Here are the columns you are missing.

Add them via PhpMyAdmin?

`sv_long` float NOT NULL DEFAULT '0',
`sv_lati` float NOT NULL DEFAULT '0',
`sv_bearing` float NOT NULL DEFAULT '0',
`sv_elevation` float NOT NULL DEFAULT '0',
`sv_zoom` float NOT NULL DEFAULT '1',
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net
The administrator has disabled public write access.
Powered by Kunena Forum