.

for Drupal 5.1 and Category 5.x-1.1

while all sub-modules and database tables have been enabled/installed properly a message to the effect that the "category" table is not available appears (and the table is indeed unavailable in the drupal database)

two new clean installs have been attempted - with only issue being the non-installation of the single "category" table.

error message is as follows:

user warning: Table 'drupal.category' doesn't exist query: SELECT c.*, n.title, n.status, nt.type, cd.allowed_parent FROM category_cont c INNER JOIN category t ON c.cid = t.cid INNER JOIN node n ON c.cid = n.nid LEFT JOIN category_cont_node_types nt ON c.cid = nt.cid LEFT JOIN category_cont_distant cd ON c.cid = cd.cid ORDER BY t.weight, n.title in C:\home\user\public_html\drupal\includes\database.mysql.inc on line 172.

"views" "cck" and many other modules have been also "clean" pre-installed - no issues.

is the "category" table an actual, required table - and if so why is it not installed?
what to do in this case? have searched in the forums, and nobody has faced this issue before!!

many thanks in advance for any ideas.

.

.

Comments

abramo’s picture

abramo commented
Title: Database Table "category" not insatalled » Database Table "category" not installed
abramo’s picture

abramo commented

.

creating manually the missing mysql table "category" according to the table details found in file "category.install" (modules/category/category.install) resolves the issue of the module functioning.

still, the issue remains of: why the table is not created during install, in the first place.
in spite of repeated clean installs, the table "category" could not be created automatically - it needed to be created manually.

oldblue’s picture

oldblue commented

When you installed MySQL you probably kept Strict Mode enabled. It has a habit of screwing things up. Go through your config and disable strict mode and it should clear things up.

abramo’s picture

abramo commented

.

many thanks, much appreciated.

- I confirm that mysql configuration was set to "strict", apparently being the cause of the problem.
have now disabled "strict" - shall monitor future behaviour re: table auto-creation, and report back.

hope this helps others too.

best,
abramo

abramo’s picture

abramo commented
Status: Active » Fixed
abramo’s picture

abramo commented
Status: Fixed » Closed (fixed)
ofktoubro’s picture

ofktoubro commented
Status: Closed (fixed) » Closed (won't fix)

I have the same problem - then I found this fabulous thread... reinstalled and unchecked mysql strict mode.
But it still doesn't work! I get the same error:

user warning: Table 'database.category' doesn't exist query: SELECT c.*, n.title, n.status, nt.type, cd.allowed_parent FROM category_cont c INNER JOIN category t ON c.cid = t.cid INNER JOIN node n ON c.cid = n.nid LEFT JOIN category_cont_node_types nt ON c.cid = nt.cid LEFT JOIN category_cont_distant cd ON c.cid = cd.cid ORDER BY t.weight, n.title in C:\www\includes\database.mysqli.inc on line 151.

Thanks for any help on this annoyance...

ofktoubro’s picture

ofktoubro commented
Status: Closed (won't fix) » Closed (fixed)

Ok I found the problem:
I did this other change...
>>description longtext NOT NULL default '',<< changed to >>description longtext NOT NULL,<<
(like in http://drupal.org/node/117034)
...before disabling strict mode and redoing the install file for a fresh install I made the line like the others next to it:
>>description longtext NOT NULL default '0',<< and the 0 is not supposed to be there!!!

When I dropped the 0 and did a fresh install - everything worked!