#16 2025-12-12 06:14:16

ddtddt
Piwigo Team
Quetigny - France
2007-07-27
7334

Re: og:image properties?

Hi :-)

I can't reproduce the problem.

I suggest deleting the directory via FTP. and removing the line from the plugin table.


You love Piwigo so don't hesitate to participate, learn more on the "Contribute to Piwigo" page. If you don't have much time for contribution, you can also help the project with a donation.

Offline

 

#17 2025-12-12 10:06:32

BobbyV
Member
Wales
2007-04-22
73

Re: og:image properties?

Many thanks for trying.
At the moment I'm stuck because my FTP clients can't connect to the Piwigo machine and I don't know why (see earlier posts).
I can log on to the Piwigo machine and get a command line but I don't know how to delete an entry from the DB.

My Piwigo machine is just a headless LAMP server, so there is very little I can do with it with my lack of knowledge. Unless you say it's a bad idea, I think I'm going to try and install a desktop on the Piwigo machine, at least then I will have a GUI in which to try and get some SQL tools.

I'm so sorry this is proving to be so hard, Bob.

Offline

 

#18 2025-12-12 11:04:46

ddtddt
Piwigo Team
Quetigny - France
2007-07-27
7334

Re: og:image properties?

Hi

install PhpMyAdmin ?


You love Piwigo so don't hesitate to participate, learn more on the "Contribute to Piwigo" page. If you don't have much time for contribution, you can also help the project with a donation.

Offline

 

#19 2025-12-12 21:15:07

BobbyV
Member
Wales
2007-04-22
73

Re: og:image properties?

Interesting discovery:
I go to "Add a new plugin"
Find "Metadata Open Graph" and click "Add"
It shows up in Piwigo on the "List" tab under "Deactivated"
BUT
It does not show up in the plugins table.
"SELECT * FROM `piwigo_plugins`" does not increment with this plugin

The same is true with the "Meta" plugin, but all other plugins do add rows to the piwigo_plugins table.

I am wondering where the information on the "List/Deactivated" page is coming from because it's not from the plugins table. Maybe this is the reason for the error when trying to activate these two plugins. It can't change the status because there is no row in the table.

Even after removing the meta_og plugin, there is a table called piwigo_metaog with these two records:
     id,type,1,idobj,page,metaogtitle,metaogdescription,metaogimage
     2,1,0,tags,Metadata Open Graph title 2,Metadata Open Graph description 2,3921
     1,1,0,recent_pics,Metadata Open Graph title 1,Metadata Open Graph description 1,3914
Should I delete them, or even delete the whole piwigo_metog table?

What do you think?

Last edited by BobbyV (2025-12-13 11:56:21)

Offline

 

#20 2025-12-13 12:29:18

ddtddt
Piwigo Team
Quetigny - France
2007-07-27
7334

Re: og:image properties?

Hi :-)

I can't reproduce the problem.

If you do not yet have any data, you can delete the plugin tables.

the plugin appears in the table > piwigo_plugins on first activate


You love Piwigo so don't hesitate to participate, learn more on the "Contribute to Piwigo" page. If you don't have much time for contribution, you can also help the project with a donation.

Offline

 

#21 2025-12-13 13:14:44

BobbyV
Member
Wales
2007-04-22
73

Re: og:image properties?

Shall I delete the "piwigo_metaog" table as well as the piwigo_plugins table?

Offline

 

#22 2025-12-13 13:45:31

BobbyV
Member
Wales
2007-04-22
73

Re: og:image properties?

Table deleted, I had to create it again using the schema in piwigo_structure-mysql.sql to void fatal sql errors.
It looks like this and is empty
    #    Name    Type    Collation    Attributes    Null    Default    Comments    Extra    Action
    1    id    varchar(64)    utf8mb4_0900_ai_ci        No    None            Change Change    Drop Drop   
    2    name    varchar(64)    utf8mb4_0900_ai_ci        No    None            Change Change    Drop Drop   
    3    version    varchar(16)    utf8mb4_0900_ai_ci        No    None            Change Change    Drop Drop   
    4    state    varchar(16)    utf8mb4_0900_ai_ci        No    None            Change Change    Drop Drop   

I then added the "meta open graph" plugin which now shows up in the "List/Deactivated" tab
but the piwigo_plugins table is still empty and the error still happens when I try to activate it.

If you give me the correct values for id, name, version and state, shall I create a row manually and test?

Last edited by BobbyV (2025-12-13 14:19:55)

Offline

 

#23 2025-12-13 15:45:16

ddtddt
Piwigo Team
Quetigny - France
2007-07-27
7334

Re: og:image properties?

Hi :-)

Only mata_og table !


You love Piwigo so don't hesitate to participate, learn more on the "Contribute to Piwigo" page. If you don't have much time for contribution, you can also help the project with a donation.

Offline

 

#24 2025-12-13 15:52:14

ddtddt
Piwigo Team
Quetigny - France
2007-07-27
7334

Re: og:image properties?

BobbyV wrote:

If you give me the correct values for id, name, version and state, shall I create a row manually and test?

id -> meta_og    
state > inactive    
version >


You love Piwigo so don't hesitate to participate, learn more on the "Contribute to Piwigo" page. If you don't have much time for contribution, you can also help the project with a donation.

Offline

 

#25 2025-12-13 16:59:38

BobbyV
Member
Wales
2007-04-22
73

Re: og:image properties?

It worked,
as soon as I manually created the record, I was able to activate it.

Now I just have to learn how it works ;-)
Thanks for your patience, it's been a long haul.
Bob.

Offline

 

Board footer

Powered by FluxBB