By grahamu on

Hi all

Ive done a search on this but found no answers. My problem is this....

I am setting up a new drupal site (I've got a couple of sites up and running ok previously).

I've been installing a bunch of modules and have come to install the feedback module, it shows up in the module list fine, I enable it and can see the feedback link in the menu. However when I click the link I get the error:

user warning: Table 'newsite.feedback_pages' doesn't exist query: SELECT * from feedback_pages WHERE name = 'default' in /mysite/html/includes/database.mysql.inc on line 120.

All the other modules have installed fine and are working.

I have tried removing the feedback module and re-downloading and re-installing but this makes no difference.

I noticed there is a feedback.install file as part of the module that looks like it is responsible for creating the tables, however it seems that the file doesnt get run.

I noticed in the INSTALL.txt for the module that it says to copy the feedback.module file to the /modules folder (which I do), but doesnt mention the feedback.install file. This leaves me how it gets run, is it that I should leave the whole feedback module folder in the /modules folder even after copying the feedback.module form into /modules? I've left the folder there anyway as trying to solve this problem but is that something you should do in general?

Is there a way to get the feedback.install file to run manually? or some sql I can put in manually? I tried copying the sql out of the file but found that it contains (what I presume are) references to variables.

Any help would be greatly appreciated

Graham

⋅ Categories: Drupal 4.7.x

Comments

bl4h’s picture

bl4h commented

Dont know why it failed. Maybe bad syntax. What version of mysql do you run?

Anyway, try manually running the query thats in feedback.install.

i see:

CREATE TABLE IF NOT EXISTS {feedback_pages} (
name VARCHAR(32) NOT NULL PRIMARY KEY,
data LONGTEXT
);

The rest of the functions in that file look like they are for upgrading from a previous version

grahamu’s picture

grahamu commented

Thanks for your reply.

I have already tried running that sql from the file but I believe that the {feedback.pages} bit is a variable of some kind and so I get some kind of sql error back when I tried (not at the right computer now so kind quote the exact message).

My version of mysql is a bit outdated, version 3.something (again not at the right machine sorry). However I have had the feedback module running on other sites on the same machine so I dont think the mysql version is the problem. If someone could translate what they variable (if it is one) resolves to, then I could substitute in the correct table name......

Actually thinking about it, it will be the table name I got in the original sql error in my first post, so I'll try that for now.

However, I would stil like to understand what caused the feedback.install script not to run so if anyboy has any suggestions, they would be appreciated.

Thanks

Graham