By scooby82 on

Ok so I can not get this thing to work. In the settings part of it when I click to regenerate the database i get 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 'OR REPLACE VIEW site_user_list_view AS SELECT u.uid as uid, u.name as uname, u.m' at line 1 query: CREATE OR REPLACE VIEW site_user_list_view AS SELECT u.uid as uid, u.name as uname, u.mail as email, t_3.value as profile_full_name, t_2.value as profile_age FROM users as u LEFT OUTER JOIN profile_values as t_3 on (u.uid = t_3.uid and t_3.fid = 3) LEFT OUTER JOIN profile_values as t_2 on (u.uid = t_2.uid and t_2.fid = 2) WHERE u.status = 1 in /home/scooby82/public_html/spaceout/includes/database.mysql.inc on line 121.

and when i click on the actual user list link in the menu i get this error:

user warning: Table 'scooby82_drupal.site_user_list_view' doesn't exist query: SELECT cd.uid as uid_key, cd.uname, cd.email FROM site_user_list_view as cd WHERE cd.uid not in (0) ORDER BY cd.uname ASC in /home/scooby82/public_html/spaceout/includes/database.mysql.inc on line 121.

knowing my luck it's prolly because i have the wrong version or something, but i hope not. if i do have the wrong version and this will not work, does anyone know of a good module to allow users to browse/search profiles. i have the latest version of drupal and am very new to this system so all help is greatly appreciated. thank you

Comments

cvining’s picture

cvining commented

I've just seen the same thing & filed a bug report. After that, I noticed there is a comment in both the *.install and *.module files with an alterntive form of the SQL query. I followed the comment suggestion, line 69 in *.module, and the analogous line in *.install: use the DROP/CREATE rather than CREATE OR REPLACE sql. Hey presto: seems to work for me!

Ah, the virtues of commenting your code.

- Cronin

harro’s picture

harro commented

Hi there - could you post the SQL code that you now actually use? I checked the .module and .install file and can find one instance of db_query("CREATE OR REPLACE VIEW {$name} AS " . $internal_sql); , but no comments near there to describe what to change it to...

Greatly appreciate the feedback!

Harro