user_relationship_types error. Help!
| Project: | User Relationships |
| Version: | 6.x-1.0-beta10 |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | alex.k |
| Status: | closed |
Jump to:
Hey!
First of all i want to say thanks for this wonderful module! I have used it before in other sites and it works wonderfully.
On a new site, i tried to install UR and i have been receiving the following error and i just cant fix it:
user warning: Table 'gen0912807443845.user_relationship_types' doesn't exist query: SELECT * FROM user_relationship_types in /home/content/d/j/s/djsecond/html/modules/user_relationships/user_relationships_api/user_relationships_api.api.inc on line 73.
user warning: Table 'gen0912807443845.user_relationship_types' doesn't exist query: SELECT * FROM user_relationship_types in /home/content/d/j/s/djsecond/html/modules/user_relationships/user_relationships_api/user_relationships_api.api.inc on line 73.
user warning: Table 'gen0912807443845.user_relationship_types' doesn't exist query: SELECT * FROM user_relationship_types in /home/content/d/j/s/djsecond/html/modules/user_relationships/user_relationships_api/user_relationships_api.api.inc on line 73.
user warning: Table 'gen0912807443845.user_relationship_types' doesn't exist query: SELECT * FROM user_relationship_types in /home/content/d/j/s/djsecond/html/modules/user_relationships/user_relationships_api/user_relationships_api.api.inc on line 73.
Screenshot of this error is attached.
Also, when i try to create a relationship type the following error appears:
user warning: Table 'gen0912807443845.user_relationship_types' doesn't exist query: SELECT name FROM user_relationship_types WHERE LOWER(name) = LOWER('amigo') AND rtid != 0 in /home/content/d/j/s/djsecond/html/modules/user_relationships/user_relationships_ui/user_relationships_ui.admin_actions.inc on line 19.
user warning: Table 'gen0912807443845.user_relationship_types' doesn't exist query: INSERT INTO user_relationship_types (name, plural_name, is_oneway, requires_approval, expires_val) VALUES ('amigo', 'amigos', 0, 1, 0) in /home/content/d/j/s/djsecond/html/includes/common.inc on line 3422.
user warning: Table 'gen0912807443845.user_relationship_types' doesn't exist query: SELECT * FROM user_relationship_types in /home/content/d/j/s/djsecond/html/modules/user_relationships/user_relationships_api/user_relationships_api.api.inc on line 76.
user warning: Table 'gen0912807443845.user_relationship_type_roles' doesn't exist query: SELECT rtid, rid FROM user_relationship_type_roles ORDER BY rtid, rid in /home/content/d/j/s/djsecond/html/modules/user_relationships/user_relationships_api/user_relationships_api.api.inc on line 81.
user warning: Table 'gen0912807443845.user_relationship_type_roles' doesn't exist query: DELETE FROM user_relationship_type_roles WHERE rtid = 0 in /home/content/d/j/s/djsecond/html/modules/user_relationships/user_relationships_ui/user_relationships_ui.admin_actions.inc on line 90.
user warning: Table 'gen0912807443845.user_relationship_type_roles' doesn't exist query: INSERT INTO user_relationship_type_roles (rtid, rid) VALUES (0, 2) in /home/content/d/j/s/djsecond/html/includes/common.inc on line 3422.
user warning: Table 'gen0912807443845.user_relationship_types' doesn't exist query: SELECT * FROM user_relationship_types in /home/content/d/j/s/djsecond/html/modules/user_relationships/user_relationships_api/user_relationships_api.api.inc on line 76.
user warning: Table 'gen0912807443845.user_relationship_type_roles' doesn't exist query: SELECT rtid, rid FROM user_relationship_type_roles ORDER BY rtid, rid in /home/content/d/j/s/djsecond/html/modules/user_relationships/user_relationships_api/user_relationships_api.api.inc on line 81.
user warning: Table 'gen0912807443845.user_relationship_types' doesn't exist query: SELECT * FROM user_relationship_types in /home/content/d/j/s/djsecond/html/modules/user_relationships/user_relationships_api/user_relationships_api.api.inc on line 76.
user warning: Table 'gen0912807443845.user_relationship_type_roles' doesn't exist query: SELECT rtid, rid FROM user_relationship_type_roles ORDER BY rtid, rid in /home/content/d/j/s/djsecond/html/modules/user_relationships/user_relationships_api/user_relationships_api.api.inc on line 81.
user warning: Table 'gen0912807443845.user_relationship_types' doesn't exist query: SELECT * FROM user_relationship_types in /home/content/d/j/s/djsecond/html/modules/user_relationships/user_relationships_api/user_relationships_api.api.inc on line 76.
user warning: Table 'gen0912807443845.user_relationship_type_roles' doesn't exist query: SELECT rtid, rid FROM user_relationship_type_roles ORDER BY rtid, rid in /home/content/d/j/s/djsecond/html/modules/user_relationships/user_relationships_api/user_relationships_api.api.inc on line 81.
user warning: Table 'gen0912807443845.user_relationship_types' doesn't exist query: SELECT * FROM user_relationship_types in /home/content/d/j/s/djsecond/html/modules/user_relationships/user_relationships_api/user_relationships_api.api.inc on line 76.
user warning: Table 'gen0912807443845.user_relationship_type_roles' doesn't exist query: SELECT rtid, rid FROM user_relationship_type_roles ORDER BY rtid, rid in /home/content/d/j/s/djsecond/html/modules/user_relationships/user_relationships_api/user_relationships_api.api.inc on line 81.
I have attached another screenshot with this problem.
The extensions i have activated are UR-API, UR-UI, UR-Mailer and UR-Views.
Would really appreciate any kind of help! Thanks in advance :)
| Attachment | Size |
|---|---|
| user-relationships-error.png | 35.46 KB |
| user-relationships-error2.png | 29.23 KB |
#1
It appears the table user_relationship_types was not created when installing UR. If you can, pls disable and uninstall UR, and install again noting any errors. If not then you could create the table manually:
CREATE TABLE IF NOT EXISTS `user_relationship_types` (
`rtid` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`plural_name` varchar(255) NOT NULL default '',
`is_oneway` tinyint(3) unsigned NOT NULL default '0',
`requires_approval` tinyint(3) unsigned NOT NULL default '0',
`expires_val` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`rtid`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
But I wonder if that's the only table that is missing - check the tables mentioned in module .install files and compare with your database.
#2
hey alex!
I checked the database and none of those tables exist :S. I'm not very good handling mysql, is there any way to run .install files and create the databases automatically?
Thanks in advance man! really appreciate it!
ps: sorry i didn't answer before! I was finishing my degree thesis :)
#3
No problem at all. You should be able to disable all UR-related modules, then uninstall them (the uninstall tab on modules page), and then install again. That should create all necessary tables. If you have errors during installation, please post them here.
#4
Thank you alex! It works 100000% good now :D :D :D
#5
Great, thanks for the follow-up
#6
Automatically closed -- issue fixed for 2 weeks with no activity.