Topic on Project:Support desk

Hi,

I am deleted objectcache table by mistake. How i create it on the mysql terminal?

CREATE TABLE objectcache;

is it enough?

No, that is not enough.

Basically, the file maintenance/tables.sql contains the CREATE statement, which you have to run.

How exactly the table has to look may be different in other versions of MediaWiki and in other database management systems (e.g. in MSSQL or PostGres).

And note that /*_*/ has to be replaced by the table prefix, if set. And /*i*/ is what indeces are prepended with.

If i run maintenance script problem is solve?

I am created table on the terminal like that, it works but i don't know, maybe in the background there may be a problem.

"CREATE TABLE objectcache (keyname char(255) binary, value mediumblob, exptime datetime);"

No, running update.php will not help.

The query, which you have run, misses the PRIMARY KEY on the keyname column.

Also, you should still add an index:

 CREATE INDEX exptime ON objectcache (exptime);

CREATE INDEX exptime ON objectcache (exptime);

I I applied that command. Is that all? Do I need to do something else?

Thank you for your help. 

That's all you need