Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: [Solved]: Picture comment error  (Read 5435 times)

0 Members and 1 Guest are viewing this topic.

Hot Rides

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 108
  • I am
    • Hot Rides Show & Cruise
[Solved]: Picture comment error
« on: April 19, 2008, 08:34:08 pm »

Get an error when leaving a picture comment.

~~~~~~~~~
While executing query "SELECT *,  AS auto_subscribe_comment FROM `dodgeste_smf1`.smf_members WHERE ID_MEMBER = '1'" on Resource id #27

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 auto_subscribe_comment FROM `dodgeste_smf1`.smf_members WHERE ID_MEMBER = '1'' at line 1
~~~~~~~~~

Any idea where I should start looking to fix? or has anyone seen this before?

site= www.hot-rides.net/coppermine
user= testuser
password= testpassword

Thanks in advance for the help
« Last Edit: April 21, 2008, 02:36:24 pm by Joachim Müller »
Logged

Stramm

  • Moderator
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Picture comment error
« Reply #1 on: April 20, 2008, 01:03:31 pm »

have you uploaded all modpack files properly (especially bridge/smf10.inc.php)

Hot Rides

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 108
  • I am
    • Hot Rides Show & Cruise
Re: Picture comment error
« Reply #2 on: April 21, 2008, 12:26:19 pm »

have you uploaded all modpack files properly (especially bridge/smf10.inc.php)
I have been editing on smf10.inc.php
I will double check to see it ifts the modpack version, but I dont see how my code could effect this
I also noticed, Im geting the same error when uploading a picture now.
Logged

Hot Rides

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 108
  • I am
    • Hot Rides Show & Cruise
Re: Picture comment error
« Reply #3 on: April 21, 2008, 12:42:53 pm »

I have been editing on smf10.inc.php
I will double check to see it ifts the modpack version, but I dont see how my code could effect this
I also noticed, Im geting the same error when uploading a picture now.
Ok, did that, now Im getting an album doesnt exsist error
Logged

Stramm

  • Moderator
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Picture comment error
« Reply #4 on: April 21, 2008, 01:08:02 pm »

Tried and haven't had any problems at all
http://hot-rides.net/coppermine/displayimage.php?pos=-284

Hot Rides

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 108
  • I am
    • Hot Rides Show & Cruise
Re: Picture comment error
« Reply #5 on: April 21, 2008, 01:27:31 pm »

ok, im glad the comments are working now, any idea why im having trouble uploading?
Logged

Hot Rides

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 108
  • I am
    • Hot Rides Show & Cruise
Re: Picture comment error
« Reply #6 on: April 21, 2008, 01:40:03 pm »

ok, im glad the comments are working now, any idea why im having trouble uploading?
nevermind, its fixed
http://coppermine.svn.sourceforge.net/viewvc/coppermine/trunk/cpg1.4.x/db_input.php?r1=3338&r2=3364
was the problem, forgot I had done that when I upgrade to the latest version.

matter is solved
Logged
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 19 queries.