I don't have a lot of experience so I could be completely wrong, but I got this error:

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 DISTINCT rid FROM user_roles WHERE uid IN () in /home/vol5/byethost7.com/b7_2038049/htdocs/sites/all/modules/statistics_advanced/statistics_advanced.module on line 75

Line 75 reads:
$query = db_query("SELECT DISTINCT uid FROM {users_roles} WHERE rid IN (". db_placeholders($user_roles, 'int') .")", $user_roles);
Things worked perfectly after I changed it to:
$query = db_query("SELECT DISTINCT uid FROM {$user_roles} WHERE rid IN (". db_placeholders($user_roles, 'int') .")", $user_roles);
Note that the same error also exists on line 81 (accesslog » $accesslog)

Comments

int13h’s picture

int13h commented

That was very stupid. I now understand that the problem wasn't with the $. I still have the problem but changed it back now. I'll leave it to people who know what they're doing.

dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented

Can you give the 6.x-1.x version a try and let me know if you still have this problem?

int13h’s picture

int13h commented

Thanks, that worked perfectly, I first got an enormous amount of error messages, but after that things went fine. I'm experiencing no problems at all now.

dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented
Status: Active » Fixed

Marking as fixed!

Status: Fixed » Closed (fixed)

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