forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 ecards & email => Topic started by: rickdrew on January 22, 2007, 09:27:22 pm

Title: ecard database error
Post by: rickdrew on January 22, 2007, 09:27:22 pm

When I click on the ecard link when viewing the image, I receive a generic

Critical error

There was an error while processing a database query

Any suggestions on where to get started?  I checked the log, but no error was generated.

Could this be caused by bridging with another application?

Thanks

Rick Drew

Title: Re: ecard database error
Post by: Nibbler on January 22, 2007, 09:31:26 pm

Enable debug mode in config and post the mysql error message you receive (not the entire debug output) when you replicate the error.

Title: Re: ecard database error
Post by: rickdrew on January 22, 2007, 09:35:06 pm

Here 'tis.....

Man, you guys are fast!


While executing query "SELECT *, login AS user_name,
                                                                                email AS user_email,
                                                                                added AS user_regdate,
                                                                                 AS user_location,
                                                                                 AS user_website

                                                                                FROM  `bright48_membership`.amember_members WHERE member_id = '5'" on Resource id #16

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 user_location,
                                                             ' at line 4

Title: Re: ecard database error
Post by: Nibbler on January 22, 2007, 09:40:17 pm

Looks like missing information in whatever bridge file you are using - some variables are not defined.

Title: Re: ecard database error
Post by: rickdrew on January 22, 2007, 09:57:41 pm

I'm starting to discover that this "fully integrated" plugin aMember sells is nothing of the sort and in fact has broken numerous features in Coppermine.  I looked at a lot of gallery programs and really, really (really!) prefered Coppermine over other programs out there (and I have usd a few of them!)  If they can't resolve them, I'm dumping the aMember software.

Thanks

Rick Drew