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: Strange errors clicking on gallery name  (Read 2995 times)

0 Members and 1 Guest are viewing this topic.

Swansea_Jack

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 49
Strange errors clicking on gallery name
« on: January 18, 2013, 11:51:02 am »

Hi Guys

i thought id already posted this on here but i cant find it.

anyway im getting strange errors when clicking from the thumbnail page back to the main sub folder, highlighted on the attached pic. this is the full error

While executing query 'SELECT a.aid, a.title, a.description, a.thumb, a.keyword, category, visibility, filepath, filename, url_prefix, pwidth, pheight, a.owner  FROM cpg15x_albums AS a  LEFT JOIN cpg15x_pictures AS p ON a.thumb=p.pid  WHERE a.category = 11   ORDER BY  LIMIT 0,3' in index.php on line 795

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 'LIMIT 0,3' at line 1


im no programmer so dont really understand what this refers to.  this has happened since i started resizing my pics prior to uploading them - currently at 800 x 600.  it also happens with every theme i try.  ive already removed and reuploaded the whole coppermine folder from a freshly downloaded version.  the only other change is that im now running on a Linux server not 2003

ive also now lost the ability to be able to view the larger image when clicked on from an intermediate size.  All these things seem to have happened at the same time  ive tried GD 1, GD 2 and imagemagick (although i dont think this is supported by fasthosts)

ive enclose the two files showing what happens - the first (critical error pt 1) is what im actually clikcing on the second the result.

I hope someone can shed some light on this for me.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Strange errors clicking on gallery name
« Reply #1 on: January 18, 2013, 12:28:34 pm »

Please post a link to your gallery.
Logged

Swansea_Jack

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 49
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Strange errors clicking on gallery name
« Reply #3 on: January 18, 2013, 02:22:51 pm »

Did you run update.php after the upgrade?
Logged

Swansea_Jack

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 49
Re: Strange errors clicking on gallery name
« Reply #4 on: January 18, 2013, 03:16:21 pm »

ive just re run it now as a precaution and it did have 3 or so 'oks' on there.

however,

im now getting a server i/o error uploading batch files and on a single file upload there is no resizing taking place, the file is displayed at 3 or 4 times the size it should be.  Should add that the file is 4000x3000 pixels and about 5.9mb

are the two related or do i need to start a new thread ?
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Strange errors clicking on gallery name
« Reply #5 on: January 18, 2013, 03:18:10 pm »

Please start a new thread for those issues. Please also add to that thread which version you used prior the update.
Logged

Swansea_Jack

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 49
Re: Strange errors clicking on gallery name
« Reply #6 on: January 18, 2013, 03:41:28 pm »

will do

Thanks Andre - see you on the next thread :)
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Strange errors clicking on gallery name
« Reply #7 on: January 18, 2013, 03:45:21 pm »

So the initial issue is fixed?
Logged

Swansea_Jack

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 49
Re: Strange errors clicking on gallery name
« Reply #8 on: January 18, 2013, 03:48:45 pm »

yes running the update.php seems to have prevented the critical error from appearing but still getting the resizing and i/o errors on upload, as per my new thread.

ill mark this as resolved
Logged
Pages: [1]   Go Up
 

Page created in 0.023 seconds with 19 queries.