When I download the gallery module in my server, appear this error:

"user error: 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 ')) AND g2_AccessMap.g_permission & 1 = 1' at line query: SELECT DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid INNER JOIN users_roles ur ON ur.rid = r.rid WHERE ur.uid = 0 in /home/navalagr/public_html/includes/database.mysql.inc on line 66.

Fatal error: 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 ')) AND g2_AccessMap.g_permission & 1 = 1' at line query: INSERT INTO watchdog (uid, type, message, severity, link, location, hostname, timestamp) VALUES (0, 'php', '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 \')) AND g2_AccessMap.g_permission & 1 = 1\' at line query: SELECT DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid INNER JOIN users_roles ur ON ur.rid = r.rid WHERE ur.uid = 0 en la línea 66 del archivo /home/navalagr/public_html/includes/database.mysql.inc.', 2, '', '/admin/modules', '81.33.127.212', 1129577610) in /home/navalagr/public_html/includes/database.mysql.inc on line 66

Fatal error: 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 ')) AND g2_AccessMap.g_permission & 1 = 1' at line query: UPDATE sessions SET uid = 0, hostname = '81.33.127.212', session = 'messages|a:0:{}watchdog_overview_filter|s:3:\"all\";', timestamp = 1129577610 WHERE sid = 'ebc6cf7bd561d2e9bc8718393aaa9908' in /home/navalagr/public_html/includes/database.mysql.inc on line 66

Warning: Unknown(): A session is active. You cannot change the session module's ini settings at this time. in
Unknown on line 0"

I use gallery 2.0.1 and Drupal 4.6.3

somebody can help me?

Comments

kiz_0987’s picture

Not sure, but were you logged in to G2 when you installed the Drupal gallery.module? I can imagine (but can't say for sure) that this may cause issues. Log out of both G2 (non-embedded) and Drupal and try again (login as the Drupal admin to install the module). Make sure you configure the gallery module as per the INSTALL.txt instructions -- it will probably not work immediately.

tecnosalva’s picture

Status: Active » Fixed

thank you for your help, problem solved.

kiz_0987’s picture

capitanZ: Did my suggestion work, or did G2 just start working? If the former, I'll add it to the How-To troubleshooting section.

Anonymous’s picture

Status: Fixed » Closed (fixed)