freetag table is missing (entrytags)

[g00se]

Hi,

today I upgraded to s9y 1.4.1 and installed the current available freetag plugin.

/ Table 'serendipity.serendipity_entrytags' doesn't exist

but it does complain that one table is missing (edit entry section, trying to add tags).
In my database theirs is no such table and I haven't found the table definition so far....

Can somebody post me the SQL?

greetz

[garvinhicking]

Hi!

Usually the plugin should install that. Does your MYSQL user maybe not have CREATE TABLE privileges anymore?

The SQL is:

Code: Select all

create table serendipity_entrytags (
  entryid int(10) not null,
  tag varchar(50) not null,
  primary key (entryid, tag)
);

CREATE INDEX tagsentryindex ON serendipity_entrytags (entryid);

CREATE INDEX tagsTagIndex ON serendipity_entrytags (tag);

create table serendipity_tagkeywords (
  keywords text,
  tag varchar(50) not null,
  primary key (tag)
);

Regards,
Garvin

[g00se]

Thanks for the code. Everythings works fine by now.

The serendipity users is granted all on the database :/, so I don't know what went wrong. Sorry.

It would be nice if the db code gets included into the readme of the plugin. It might help the next one...

Thanks for the fast reply!!