Hi :-)
I can't reproduce the problem.
I suggest deleting the directory via FTP. and removing the line from the plugin table.
Offline
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
Hi
install PhpMyAdmin ?
Offline
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
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
Offline
Shall I delete the "piwigo_metaog" table as well as the piwigo_plugins table?
Offline
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
Hi :-)
Only mata_og table !
Offline
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 >
Offline
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