I'm not sure what I'm doing wrong.
The module seems to be installed and I can see the Page Title input boxes. I successfully created the page_title table manually using the table definition.

The problem is that the page titles aren't being inserted into the table and saved. Other modules are able to use the database without any problems.

Is there something I should check to troubleshoot this?

Comments

johnalbin’s picture

johnalbin
they/他
Primary language English
Location Taipei, Taiwan
commented
Status: Active » Postponed (maintainer needs more info)

I wish I could be more helpful, but you are definitely doing something wrong.

When you first enabled the module, the automatic install didn’t work for you? It should have automatically created the table or displayed an error message. Did you see an error message?

I verified that the CREATE TABLE sql query in the README.txt file is correct. So try it again.

RoughOcean’s picture

RoughOcean commented

I have tried the installation a bunch of times.

I put the module in /sites/default/modules/page_title.

I do see the page_title module when I go to administer > modules, then I enable it.
I do NOT see any message confirming success or proclaiming failure of the database table creation.

My Drupal tables have a drupal_ prefix. Should this module pick up that prefix? I have looked for the page_title table both with and without the prefix.

I am stumped because before trying to install this module, I successfully installed Meta Tags which did create a table picking up my prefix. And it was able to write records to its table.

Is there another place I can look for any error message? I don't see anything in administer -> logs.

I can create the table manually using the sql query. When I do that, I do not use my drupal_ table prefix.
When I create the table with the sql query, it does not get written to when I add page titles.

johnalbin’s picture

johnalbin
they/他
Primary language English
Location Taipei, Taiwan
commented
Status: Postponed (maintainer needs more info) » Active

I don’t know why the auto table creation didn’t work on the first installation. It’s odd. Unfortunately, once a module is registered it never tries to re-install its tables even if you disable and re-enable the module. (This is a limitation of Drupal which was fixed in 5.0.)

But if you can create manual MySQL tables, use this query:

CREATE TABLE IF NOT EXISTS drupal_page_title (
  nid INT NOT NULL,
  page_title VARCHAR( 128 ) NOT NULL,
  PRIMARY KEY ( `nid` )
) /*!40100 DEFAULT CHARACTER SET utf8 */;

That should work with the table prefix “drupal_” that you are using.

RoughOcean’s picture

RoughOcean commented

I created the table with that query and the module works!
I'm not sure what I missed the other times. Thanks for helping me work through this.

johnalbin’s picture

johnalbin
they/他
Primary language English
Location Taipei, Taiwan
commented
Status: Active » Fixed

Yeah!

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)