I tried to update to Similar by Terms 1.15 and get this error, that "table cache_similarterms doesn't exist"
I saw that there was the same problem fixed for version 6 and there it was mentioned that version 5 should work also.
Uninstalling wasn't possible, because the module is not listed in the uninstall list after removing the mark from the checkbox.

Comments

rmiddle’s picture

rmiddle commented

That means the table wasn't created right. You database is mysql or PG?

1) Disable the module.
2) Make sure similarterms.install exists and has the same date as the .module file.
2) Make sure there in nothing in uninstall to uninstall.
3) Go in to the database manager you prefer and look for similarterms_xxxxxx or cache_similarterms if they exist remove them.
4) install module.

These steps should recreate the database.

Thanks
Robert

merilainen’s picture

merilainen commented

No luck. I'm using MySQL.

I have no tables to remove. When I install similarterms, it says everything is ok, but I cannot see any new tables in phpMyAdmin. If I try to create the tables from phpMyAdmin, I get this error for the first table (cache_similarterms):

 MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{cache_similarterms} (
        cid varchar(255) NOT NULL default '',
        d' at line 1

and this error for the second table (similarterms_override):

 MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{similarterms_override} (
        nid INT(10) UNSIGNED NOT NULL DEFAULT '0',
' at line 1
rmiddle’s picture

rmiddle commented

I have no idea why your system isn't creating those table automatically like they should. Note if you are tiring to apply the updates manually you must remove the { xxxx } around the table names those are there so drupal can add in any table prefix you might have defined.

Thanks
Robert

merilainen’s picture

merilainen commented

Oh yeah, I forgot that syntax. Now I managed to create the tables and it works.

I was using rather old 1.5 version of similarterms before updating to 1.15.

rmiddle’s picture

rmiddle commented
Status: Active » Fixed

I had a glitch in 1.12 in which if you upgraded to that version it wouldn't create the tables. But all my test suggests that 1.5 to 1.15 should have created those tables. Well you are upgraded that is what is important.

Thanks
Robert

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.