By boo_lolly on

it seems after i added the 'taxonomy_access.module' i've been getting random errors show up...

user warning: Table 'drupal.term_access' doesn't exist query: SELECT t.tid, d.vid, BIT_OR(t.grant_list) AS grant_list FROM term_access t INNER JOIN term_data d ON t.tid=d.tid WHERE t.rid in ('1') AND grant_list = 1 group by t.tid, d.vid in C:\apache2triad\htdocs\drupal\includes\database.mysql.inc on line 120.

this is so annoying and i can't seem to figure out how to diagnose the problem! i've searched a few previously posted forum topics regarding this issue and i've followed directions... but it's still a problem for me! as you can tell i am very frustrated but still determined to make this work. does anyone have any advice? any help at all would be more than i have right now. thank you for your time.

⋅ Categories: Drupal 4.7.x

Comments

vm’s picture

vm commented

diagnose the problem by looking at your db and seeing if the cloum is really there.

did you recently update the module and not run update.php ?

boo_lolly’s picture

boo_lolly commented

yes, i did run update.php, and surprizingly it ended up creating more problems for me. instead of just a couple of lines of errors, now it's like 30 lines of errors. =(

sillygwailo’s picture

sillygwailo
Location Toronto, ON
commented

It looks like the Term Access module does not come with the automatic creation of MySQL tables. If you see the file term_access.mysql, you will need to load the contents into the database. To do this at the command line, run the following command, replacing 'databaseusername', 'databasepassword', and 'databasename' as appropriate (you should also be able to import the file into phpMyAdmin if you have access to that.

mysql -udatabaseusername -pdatabasepassword databasename < term_access.mysql

If you don't have the term_access file, you can use the code in the file in the modules repository.

(Username formerly my full name, Richard Eriksson.)

boo_lolly’s picture

boo_lolly commented

i really appreciate your help richard. it was somewhat difficult to understand how to execute your post, but after reading it a couple of times i understood. i will try this and hope it works. i'll get back to you in the near future. thank you BOTH for all of your help and fast response

vm’s picture

vm commented

its can be done in phpmyadmin also (if unix commands arent your thing) by browsing to the mysql file and running it.

boo_lolly’s picture

boo_lolly commented

i sincerely apologize, but i am very very new to this sort of thing and it's difficult for me to understand your advice or instructions. assume i don't know anything... let me tell you what i have tried...

i logged into msql database in command prompt. i have found that there are a couple of different ways to do this, and each way takes you to a different part of the database. am i right?

using the command line 'mysqladmin -u root -p' logs you in.

but then again, so does 'mysql -udatabasename -p drupal'

i was wondering if it was possible to manually create tables in the mysql database using command prompt. i hope so, this would probably be the easiest way to do it in the meantime.

what do you mean by it can be done in phpmyadmin? where is that? and once i find it, how do i browse the mysql file and run it? what program do i use? how do i run it?

vm’s picture

vm commented

phpmyadmin can be installed on the host (check to see if your host has this, it if often the case).

Using phpmyadmin.

LOGIN with db username and db password
click on the SQL tab

paste the contents of the .mysql file and click go. The contents of the .mysql file is pasted below for your convienence.

CREATE TABLE IF NOT EXISTS `term_access` (
  `tid` int(10) unsigned NOT NULL default '0',
  `rid` int(10) unsigned NOT NULL default '0',
  KEY `tid` (`tid`),
  KEY `rid` (`rid`)
);

# Table for storage default roles assigned to new terms
CREATE TABLE IF NOT EXISTS `vocabulary_access` (
  `vid` int(10) unsigned NOT NULL default '0',
  `rid` int(10) unsigned NOT NULL default '0',
  KEY `vid` (`vid`),
  KEY `rid` (`rid`)
);

from the command line you would use the command given by Richard.

boo_lolly’s picture

boo_lolly commented

what program do i use to execute these kinds of processes? i'm not using a server connected to the internet. i'm simply using the server operating system that my home pc has when i downloaded and installed apache2triad.

when i tried to write the code in command prompt that richard posted, it didn't do anything, and the output was nothing but '->'. that's it...

mysql -udatabaseusername -pdatabasepassword databasename < term_access.mysql
-> (i can type any command here. no matter what i type, it just returns the same output...)
-> (try to retype another command)...
-> (still... nothing...)
-> (i can't even quit or exit this application. i am forced to close the command prompt window and start again.....)

what do i do? why do i have these issues? is it this difficult for everybody?!?

vm’s picture

vm commented

phpmyadmin can also be installed on a local machine.

I can't comment on the unix commands, I don't typically use them. I use phpmyadmin for all interaction with my databases. However, I do also have shell access to my host, and can use putty.exe to communicate with my server using unix commands. I've only found a need for this method when installing a drupal patch.

http://www.phpmyadmin.net/home_page/index.php is a link to the phpmyadmin project

phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges,export data into various formats

this document explains a little about CLI's (Command Line Interfaces) http://en.wikipedia.org/wiki/Command_line_interface

boo_lolly’s picture

boo_lolly commented

thank you so much for all your help, my friend. i sincerely appreciate it. i think i'm just going to uninstall apache and drupal, and wait until i have another pc to run as my own personal server. it seems like dualing my home pc as a server with apache is causing more harm than good and makes things much more complicated than necessary. even tho i have purchased the drupal book by david mercer and followed it closely, i'm still having problems. from the issues and jargon i have encountered thus far i've realized that i have a lot more to learn than i had originally preceived.

i have a lot to learn about mysql databases, and the way it reacts to servers and vice versa. i've also recently purchased a book on implementing php and mysql to help me in this respect. i'm going to do a lot of book reading and a lot of research online until i feel comfortable with being able to handle most, if not all, problems i encounter in the meantime until i am in the position to build, host, and operate a website powered by drupal. this course of action suites my current situation best; however, i want you to know that i am not letting this knock me down forever. i WILL learn everything there is to know about all of this, and i WILL create amazing websites in the future, and i WILL give back to the drupal community by offering my own help and services, and hopefully oneday write my own modules, effectively.

again, thank you both very much for all your help and dedication to my cause. even tho i am tapping out for the count, i promise it will not have been in vain.

-boo