Update to 6.1.3 - Table 'kunenatoubdd83_phocadownload_logging' doesn't exist

[Scott]

Hello,
I've updated my website PhocaDownload 6.1.1 to PhocaDownload 6.1.3.
I'm on Joomla 6.1.2.
In the menu Joomla administration database, I've got this message :
Table 'kunenatoubdd.ktouchbdd83_phocadownload_logging' doesn't exist

What can I do ?

Excuse me for my bad english.

[Benno]

Hi,
First, create a backup of your database. Then, using a tool such as phpMyAdmin, verify that the table #__phocadownload_logging really does not exist. If this table is missing, you can create it manually using this query, replace #_ with your database prefix first:

Code: Select all

CREATE TABLE IF NOT EXISTS `#__phocadownload_logging` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `fileid` int(11) NOT NULL default '0',
  `catid` int(11) NOT NULL default '0',
  `userid` int(11) NOT NULL default '0',
  `ip` varchar(50) NOT NULL default '',
  `page` text,
  `date` datetime NOT NULL,
  `type` tinyint(1) NOT NULL DEFAULT '0',
  `params` text,
  PRIMARY KEY  (`id`)
) DEFAULT CHARSET=utf8 ;

Next, you'll need to run the following query, replace #_ with your database prefix first:

Code: Select all

ALTER TABLE `#__phocadownload_logging` CHANGE `page` `page` TEXT;

Kind regards,
Benno

[Scott]

Hello Benno,
It's perfect. PhocaDownload 6.1.3 is now on my website.
Thank you very much for your help.

[Benno]

You're welcome!

Kind regards,
Benno