Serendipity Forums

Posted: **Tue May 05, 2009 9:00 am**

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

Posted: **Tue May 05, 2009 12:16 pm**

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

Posted: **Tue May 05, 2009 11:44 pm**

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!!

Serendipity Forums

freetag table is missing (entrytags)

freetag table is missing (entrytags)

Re: freetag table is missing (entrytags)

Re: freetag table is missing (entrytags)