install file broken for Tables with prefix
jmountz - July 6, 2007 - 03:34
| Project: | Path Access |
| Version: | 5.x-1.1 |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Description
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!
#1
Documentation corrected.
Since Drupal 5 there is no longer any manual SQL scripts to run, thanks to the automated .install files.
#2
#3
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!
#4
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.
:)
#5
Patch created, ready for testing.
#6
The dev release was already fixed in CVS months ago. Release 1.2 just created which includes the correct .install file.
#7
Automatically closed -- issue fixed for two weeks with no activity.