Download & Extend

Client node sql error

Project:Hosting
Version:6.x-0.4-alpha3
Component:Code
Category:bug report
Priority:critical
Assigned:Unassigned
Status:closed (fixed)

Issue Summary

Aegir 0.4-alpha6

Followed install per http://git.aegirproject.org/?p=provision.git;a=blob_plain;f=INSTALL.txt;...

Platforms and sites imported from Aegir 0.4-alpha3

From a site node clicking on the client name produces:

* warning: array_fill() [function.array-fill]: Number of elements must be positive in /var/aegir/hostmaster-0.4-alpha6/includes/database.inc on line 253.
* warning: implode() [function.implode]: Bad arguments. in /var/aegir/hostmaster-0.4-alpha6/includes/database.inc on line 253.
* warning: array_keys() [function.array-keys]: The first argument should be an array in /var/aegir/hostmaster-0.4-alpha6/modules/user/user.module on line 502.
* user warning: 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 ')' at line 1 query: SELECT p.perm FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in /var/aegir/hostmaster-0.4-alpha6/modules/user/user.module on line 502.

Comments

#1

Status:active» postponed (maintainer needs more info)

I can't reproduce this.

Could it simply be because the clients aren't imported when sites are? Do we even store that info about a client in the site's drushrc.php or is it only $client_email?

Can you confirm it doesn't occur for the 'main' original client, perhaps just clients of sites you've imported from an older install?

#2

I can confirm it doesn't occur for the 'main' original client.

The clients have been imported. At admin/content/node/overview, Show only items where type is Client, They are all listed.

#3

The clients exist in hosting_clients, hosting_site & node tables.

The same error is produced at node/443/edit?destination=admin%2Fcontent%2Fnode%2Foverview

#4

Priority:normal» critical
Status:postponed (maintainer needs more info)» needs work

I reproduced this.

http://skitch.com/vertice/de223/t-example.com-t

#5

Ok. found the cause of this.

It's occurring with imported clients, because the UID of the client node created is anonymous.

this actually seems to be a fairly endemic problem we have. All the package nodes are also UID 0 for instance.

I think this can be resolved by changing the bootstrap level of hosting-task, so that it actually logs in.

#6

Status:needs work» fixed

i fixed it last night.

#7

Status:fixed» closed (fixed)

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

nobody click here