K2 database error on install

This forum is for general questions about extensions for Joomla! 3.x.

Moderators: pe7er, General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Post Reply
Trophonius
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Mon May 13, 2019 5:29 am

K2 database error on install

Post by Trophonius » Mon May 13, 2019 5:47 am

Dear people,

I am getting an error on trying to install K2 after resetting site to a backed up version.

Error received is: Table 'trophoni_topdata.#__k2_items' doesn't exist

I did find an answer to a similar problem which suggested running the following script to create the table in myphpadmin:

CREATE TABLE IF NOT EXISTS `#__k2_log` (
`status` int(11) NOT NULL,
`response` text NOT NULL,
`timestamp` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

I changed the table identifier to #_k2_items and successfully created it but the columns are not correct.

Can somebody help me with the table structure required please?

Or is there an easier fix available- not sure why when no K2 tables exist in database the installer doesn't just create them.

Cheers

User avatar
mjparadac
Joomla! Ace
Joomla! Ace
Posts: 1899
Joined: Mon Oct 29, 2012 3:58 pm

Re: K2 database error on install

Post by mjparadac » Wed Jul 17, 2019 4:16 pm

Hello Trophonius, welcome to the forum.

This thread could help you
viewtopic.php?t=924731

Regards,
Joomla Community Ambassador for A2 Hosting | A2 Hosting - Our speed, your success | https://www.a2hosting.com/joomla-hosting


Post Reply

Return to “Extensions for Joomla! 3.x”