Piwigo.org

Linty · **Linty** 2024-12-09 15:48:08

Est-ce que tu peux montrer dans ton gestionnaire de donnée le résultat de ces deux commandes :

Code:

desc piwigo_activity;

Code:

show create table piwigo_activity;

Voici les résultat de mon côté :

Code:

MariaDB [piwigo_db]> desc piwigo_activity;
+--------------+-----------------------+------+-----+---------------------+----------------+
| Field        | Type                  | Null | Key | Default             | Extra          |
+--------------+-----------------------+------+-----+---------------------+----------------+
| activity_id  | int(11) unsigned      | NO   | PRI | NULL                | auto_increment |
| object       | varchar(255)          | NO   |     | NULL                |                |
| object_id    | int(11) unsigned      | NO   |     | NULL                |                |
| action       | varchar(255)          | NO   |     | NULL                |                |
| performed_by | mediumint(8) unsigned | NO   |     | NULL                |                |
| session_idx  | varchar(255)          | NO   |     | NULL                |                |
| ip_address   | varchar(50)           | YES  |     | NULL                |                |
| occured_on   | timestamp             | YES  |     | current_timestamp() |                |
| details      | varchar(255)          | YES  |     | NULL                |                |
| user_agent   | varchar(255)          | YES  |     | NULL                |                |
+--------------+-----------------------+------+-----+---------------------+----------------+
10 rows in set (0.002 sec)

Code:

show create table piwigo_activity;
+-----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table           | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
+-----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| piwigo_activity | CREATE TABLE `piwigo_activity` (
  `activity_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `object` varchar(255) NOT NULL,
  `object_id` int(11) unsigned NOT NULL,
  `action` varchar(255) NOT NULL,
  `performed_by` mediumint(8) unsigned NOT NULL,
  `session_idx` varchar(255) NOT NULL,
  `ip_address` varchar(50) DEFAULT NULL,
  `occured_on` timestamp NULL DEFAULT current_timestamp(),
  `details` varchar(255) DEFAULT NULL,
  `user_agent` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`activity_id`)
) ENGINE=MyISAM AUTO_INCREMENT=14848 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci |
+-----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.000 sec)

Piwigo.org

Annonce

Écrire une réponse

Résumé de la discussion (messages les plus récents en premier)

Code:

Code:

Code:

Code:

Pied de page des forums