Bienvenue, Invité
Nom d'utilisateur : Mot de passe :


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

SUJET : Unknown column—bug?

Unknown column—bug? il y a 1 semaine 1 jour #1

  • WGroleau
  • Portrait de WGroleau
  • Hors Ligne
  • Gold
  • Messages : 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
Dernière édition: il y a 1 semaine 1 jour par WGroleau.
L'administrateur a désactivé l'accès en écriture pour le public.

Unknown column—bug? il y a 1 semaine 23 heures #2

  • fisharebest
  • Portrait de fisharebest
  • Hors Ligne
  • Administrator
  • Messages : 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 - Cette adresse e-mail est protégée contre les robots spammeurs. Vous devez activer le JavaScript pour la visualiser. - fisharebest.webtrees.net
L'administrateur a désactivé l'accès en écriture pour le public.

Unknown column—bug? il y a 1 semaine 14 heures #3

  • WGroleau
  • Portrait de WGroleau
  • Hors Ligne
  • Gold
  • Messages : 1523
Ffisharebest écrit:
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
L'administrateur a désactivé l'accès en écriture pour le public.

Unknown column—bug? il y a 3 jours 9 heures #4

  • fisharebest
  • Portrait de fisharebest
  • Hors Ligne
  • Administrator
  • Messages : 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 - Cette adresse e-mail est protégée contre les robots spammeurs. Vous devez activer le JavaScript pour la visualiser. - fisharebest.webtrees.net
L'administrateur a désactivé l'accès en écriture pour le public.

Unknown column—bug? il y a 3 jours 8 heures #5

  • WGroleau
  • Portrait de WGroleau
  • Hors Ligne
  • Gold
  • Messages : 1523
fisharebest écrit:
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!
Pièces jointes :
--
Wes Groleau
UniGen.us/
PHP 7.2.15; MySQL 5.6.40; Apache
L'administrateur a désactivé l'accès en écriture pour le public.

Unknown column—bug? il y a 2 jours 18 heures #6

  • fisharebest
  • Portrait de fisharebest
  • Hors Ligne
  • Administrator
  • Messages : 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 - Cette adresse e-mail est protégée contre les robots spammeurs. Vous devez activer le JavaScript pour la visualiser. - fisharebest.webtrees.net
L'administrateur a désactivé l'accès en écriture pour le public.
Propulsé par Kunena