Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: [Solved]: Picture comment error  (Read 5581 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.018 seconds with 19 queries.