I get this error when installing.

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY rtid, rid' at line 1: SELECT rtid, rid FROM {user_relationship_type_roles} WHERE rtid IN () ORDER BY rtid, rid; Array ( ) in user_relationships_types_load() (line 79 of .\sites\all\modules\user_relationships\user_relationships_api\user_relationships_api.api.inc).

CommentFileSizeAuthor
#6 fix_load_sql_error.patch1.71 KBberdir
#2 fix_load_sql_error.patch1.29 KBberdir
UR-Blocks.png48.91 KBZytaro

Comments

Zytaro’s picture

Zytaro commented

This error is also caused by the module "UR-Node Access. " But not appears when installed, appears later in different parts of the site, for example trying to create content.

berdir’s picture

berdir
Primary language German
Location Switzerland
commented
Title: Error when installing UR-Blocks. » SQL Exception when trying to load relationship types but none exist
Priority: Major » Critical
Status: Active » Needs review
StatusFileSize
new fix_load_sql_error.patch1.29 KB

Confirmed. Has nothing to do with these modules (except that they use the API).

Try this patch.

Zytaro’s picture

Zytaro commented
Priority: Critical » Major
Status: Needs review » Fixed

Thank you very much for responding so quickly.
The patch works correctly.

Zytaro’s picture

Zytaro commented
Priority: Major » Critical
berdir’s picture

berdir
Primary language German
Location Switzerland
commented
Status: Fixed » Needs work

If you tested a patch, set the issue to RTBC, then I'll commit it and can set it to fixed.

Thanks for testing. I've seen another issue that needs to be fixed, however, will upload a new patch soon.

berdir’s picture

berdir
Primary language German
Location Switzerland
commented
Status: Needs work » Needs review
StatusFileSize
new fix_load_sql_error.patch1.71 KB

New, better patch.

BenK’s picture

BenK commented

@ Zytaro: Can you test Berdir's latest patch and report back so we can close out this issue?

--Ben

berdir’s picture

berdir
Primary language German
Location Switzerland
commented
Status: Needs review » Fixed

Commited, this was breaking my tests, took me like an hour to figure this out ;)

Zytaro’s picture

Zytaro commented

Sorry, these days I could not connect. Now I look.

Zytaro’s picture

Zytaro commented

@ Berdir Thanks , now works fine.

Status: Fixed » Closed (fixed)

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