forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 modpack by Stramm => Topic started by: greeryan on August 30, 2006, 08:50:19 pm

Title: error after upgrade
Post by: greeryan on August 30, 2006, 08:50:19 pm
after i upgraded i get this message whenever I try to view an image. www.thecollegeartist.com (http://www.thecollegeartist.com)

Critical error
There was an error while processing a database query

 ???


thanks
Ryan

Title: Re: error after upgrade
Post by: Joachim Müller on August 30, 2006, 09:11:48 pm
Enable debug_mode - see http://coppermine-gallery.net/tutorial/debug_mode.php
Title: Re: error after upgrade
Post by: greeryan on August 31, 2006, 12:32:43 am
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
        (
           



Title: Re: error after upgrade
Post by: Nibbler on August 31, 2006, 01:26:03 am
Are you using the modpack? If so post in the section dedicated to the modpack.
Title: Re: error after upgrade
Post by: Joachim Müller on August 31, 2006, 05:40:43 am
Moving this thread to modpack board.
Title: Re: error after upgrade
Post by: Stramm on September 01, 2006, 07:34:13 am
http://forum.coppermine-gallery.net/index.php?topic=29153.msg135084#msg135084
Title: Re: error after upgrade
Post by: kevio on May 04, 2008, 07:40:12 pm
have you run update.sql?