error after upgrade

[greeryan]

after i upgraded i get this message whenever I try to view an image. www.thecollegeartist.com

Critical error
There was an error while processing a database query




thanks
Ryan

[Joachim Müller]

Enable debug_mode - see http://coppermine-gallery.net/tutorial/debug_mode.php

[greeryan]

ok here is what I get

While executing query "SELECT c.msg_id, c.msg_author, c.msg_body, UNIX_TIMESTAMP(msg_date) AS msg_date, c.author_id, c.author_md5_id, c.msg_raw_ip, c.msg_hdr_ip, c.pid, u. AS avatar_url FROM cpg_comments AS c LEFT JOIN `whorules_joom2`.jos_users AS u ON c.author_id=u.id WHERE pid='3' ORDER BY c.msg_id ASC" on Resource id #26

mySQL 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 'AS avatar_url FROM cpg_comments AS c LEFT JOIN `whorules_joom2`.jos_users AS u O' at line 1


USER:
------------------
Array
(
    [ID] => e96827a5b8b8c1183f7382bece89715b
    [am] => 1
    [lang] => english
    [theme] => project_vii
    [liv] => Array
        (
           

• => 5
  
  
  
  

[Nibbler]

Are you using the modpack? If so post in the section dedicated to the modpack.

[Joachim Müller]

Moving this thread to modpack board.

[Stramm]

http://forum.coppermine-gallery.net/index.php?topic=29153.msg135084#msg135084

[kevio]

have you run update.sql?