The README.txt mentions a SQL script that needs to be run to complete installation. I am fairly new at this and have two problems; 1 - I do not see a SQL script, 2 - I do not know how to go about running the script within Drupal. As things stand right now, the module is not working as is. Any clarification or assistant with this will be greatly appreciated!

CommentFileSizeAuthor
#5 path_access_install0.patch485 bytessuit4

Comments

budda’s picture

budda
Primary language English
Location Cheshire
commented
Status: Active » Fixed

Documentation corrected.
Since Drupal 5 there is no longer any manual SQL scripts to run, thanks to the automated .install files.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)
lebisol’s picture

lebisol commented
Status: Closed (fixed) » Active

Hello Budda,
Sorry to reopen this but I ran accross strange issue on edit of user roles. Install went fine but it seems as if sql did not fire quite right and tables were not created.
Here is the error:
=============
user warning: Table 'db.PREFpath_access' doesn't exist query: SELECT * FROM PREFpath_access pa INNER JOIN PREFrole r ON pa.rid = r.rid WHERE pa.rid = 1 in /path_here/includes/database.mysql.inc on line 172.
user warning: Table 'db.PREFpath_access' doesn't exist query: INSERT INTO PREFpath_access (pid, rid, pages, visibility) VALUES (8, 1, '', '') in /path_here/includes/database.mysql.inc on line 172.
=============
Is there a way to manually excute sql after the fact?
Many thanks!

suydam’s picture

suydam commented

If you're using a table prefix, the .install file is screwd up.
It says: CREATE TABLE `path_access`
It should say: CREATE TABLE {path_access}

Uninstall the module.
Remove the entry from the system table.
Install the module.
Rejoice.
:)

suit4’s picture

suit4 commented
Title: SQL Script » install file broken for Tables with prefix
Component: Miscellaneous » Code
Status: Active » Needs review
StatusFileSize
new path_access_install0.patch485 bytes

Patch created, ready for testing.

budda’s picture

budda
Primary language English
Location Cheshire
commented
Status: Needs review » Fixed

The dev release was already fixed in CVS months ago. Release 1.2 just created which includes the correct .install file.

Anonymous’s picture

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

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