Advanced search  

News:

cpg1.5.42 maintenance release - upgrade recommended
The Coppermine development team is releasing an update for Coppermine in order to fix several minor issues. All fixes are not security critical, so if your gallery is running fine with cpg1.5.36, cpg1.5.38 or cpg1.5.40 you don't need to upgrade. If you are running an older version than cpg1.5.36, you must update to this latest version as soon as possible because of the security impact!
[more]

Pages: [1] 2   Go Down

Author Topic: click categories gives database query error  (Read 16626 times)

0 Members and 1 Guest are viewing this topic.

shinsui

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 9
    • thorinsgate
click categories gives database query error
« on: June 28, 2010, 11:58:04 AM »

If I click on my album categories, i.e. (http://thorinsgate.nl/index.php?cat=2) I get this while logged in as administrator:

Template error
Failed to find block 'file_line' (#<!-- BEGIN file_line -->(.*?)<!-- END file_line -->#s) in :

                    <div class="{CSS_CLASS}">
                        <h2>{HEADER_TXT}</h2>
                        <span class="cpg_user_message">{MESSAGE}</span>


                        <br /><br />
                    </div>

If I'm -NOT- logged in I see this Critical error
There was an error while processing a database query
warning on my screen.

This is NOT an upgrade issue. I got this doing an upgrade, but when I could not get rid of this I did a fresh install of the latest coppermine and recreated all albums. alas, the issue remains. Is this a known bug?

Thx, Dick
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15039
Re: click categories gives database query error
« Reply #1 on: June 28, 2010, 02:21:36 PM »

Quote
Forbidden

You don't have permission to access /index.php on this server.
Logged

shinsui

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 9
    • thorinsgate
Re: click categories gives database query error
« Reply #2 on: June 28, 2010, 03:39:57 PM »

You're right. Because I am reinstalling my photobase I closed Apache (thorinsgate.nl) for the outside world. I'd forgotten about it. It's opened for now. Not much to see yet. I first want to make sure the error can be solved before I reinstall all my older albums again. I love what I''ve seen so far. Coppermine is my favo over gallery3. Hope to hear from you.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15039
Re: click categories gives database query error
« Reply #3 on: June 28, 2010, 03:49:50 PM »

Please enable debug mode.
Logged

shinsui

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 9
    • thorinsgate
Re: click categories gives database query error
« Reply #4 on: June 28, 2010, 07:04:46 PM »

DONE. Is enabled for everyone. Hope this is not unsafe?
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15039
Re: click categories gives database query error
« Reply #5 on: June 28, 2010, 07:49:31 PM »

Quote
mySQL error: Lost connection to MySQL server during query
Please google for that error message.
Logged

shinsui

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 9
    • thorinsgate
Re: click categories gives database query error
« Reply #6 on: June 28, 2010, 08:08:07 PM »

Please google for that error message.
I think this is too easy. I run quite a few databases (three for TYPO3, a CMS system, another three for some Wordpress installations and some for Textpad and a few test sites. The -ALL- work well and have NO database query errors. Not had the former coppermine release btw. It ran fast and well too. It has to be someting in the code that trickers this MySQL error.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15039
Re: click categories gives database query error
« Reply #7 on: June 28, 2010, 08:32:32 PM »

You're the first person who reports that issue. It seems that nobody else has that issue. I cannot replicate it in my testbeds, so you have to perform some tests or give us more information about your MySQL settings etc.
cpg1.5.6 performs a lot of other db queries that don't return errors.
Logged

shinsui

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 9
    • thorinsgate
Re: click categories gives database query error
« Reply #8 on: June 28, 2010, 09:47:22 PM »

Tell me about the tests you want performed. I'm very curious myself too, because, as said, other software that heavely uses MySQL/PHP does not have issues.
Logged

shinsui

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 9
    • thorinsgate
Re: click categories gives database query error
« Reply #9 on: June 28, 2010, 10:20:38 PM »

Another thing. I just performed a check with a testbed for coppermine 1.5.6. I had the same category and two -EMPTY albums. Clicking on the category did not generate an error. Then I filled one album with pictures, clicked on the category again and got the same error as describes for my main photosite.
Logged

Phill Luckhurst

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4273
    • Windsurf.me
Re: click categories gives database query error
« Reply #10 on: June 28, 2010, 11:14:18 PM »

It is a strange one that I cvannot replicate. On my testbed I get that error message if I type in a cat number that doesn't exist. The mesage is a little missleading and I am not sure why the software thinks for some reason cat=2 on your setup is not there.
Logged
It is a mistake to think you can solve any major problems just with potatoes.

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15039
Re: click categories gives database query error
« Reply #11 on: June 29, 2010, 08:11:39 AM »

@Phill: don't draw the wrong conclusions from the improper error message "There was an error while processing a database query". If you enable debug mode, you'll get different error messages.
Logged

Phill Luckhurst

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4273
    • Windsurf.me
Re: click categories gives database query error
« Reply #12 on: June 29, 2010, 08:37:28 AM »

I think what I wrote came accross incorrectly. It is just that the error message seems wrong to me if an incorrect cat link is given. I think a
Code: [Select]
$lang_errors['non_exist_cat'] = 'The selected category does not exist'; message should be displayed. For example look here - http://coppermine-gallery.net/demo/cpg15x/index.php?cat=5 . There I miss-type the cat number to 5 instead of 2 and we get the database error rather than the correct error message. This part of the thread should be in the bug section I think.
Logged
It is a mistake to think you can solve any major problems just with potatoes.

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15039
Re: click categories gives database query error
« Reply #13 on: June 29, 2010, 08:52:19 AM »

Please lets only discuss the error message here, that shinsui gets if he re-enables debug mode:
Quote
mySQL error: Lost connection to MySQL server during query

I'll have a look at the issue (wrong error message) you reported now. Currently no need for an extra thread in the bugs board, unless I cannot fix it instantly ;)
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15039
Re: click categories gives database query error
« Reply #14 on: June 29, 2010, 09:10:01 AM »

I think a
Code: [Select]
$lang_errors['non_exist_cat'] = 'The selected category does not exist'; message should be displayed.
Fixed in r7725.
Logged

Phill Luckhurst

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4273
    • Windsurf.me
Re: click categories gives database query error
« Reply #15 on: June 29, 2010, 09:32:09 AM »

Well done Andre
Logged
It is a mistake to think you can solve any major problems just with potatoes.

shinsui

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 9
    • thorinsgate
Re: click categories gives database query error
« Reply #16 on: June 29, 2010, 07:07:24 PM »

Does this mean the error will be gone in a future update?
Newly created categories show the same error.
The pictures are accessable, the albums are, but clicking on a category does not work.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15039
Re: click categories gives database query error
« Reply #17 on: June 29, 2010, 07:33:57 PM »

Does this mean the error will be gone in a future update?
No. I just fixed an issue Phill detected while testing your issue.

If you want to know it for sure, update your gallery with the latest svn checkout.

This still applies:
You're the first person who reports that issue. It seems that nobody else has that issue. I cannot replicate it in my testbeds, so you have to perform some tests or give us more information about your MySQL settings etc.
cpg1.5.6 performs a lot of other db queries that don't return errors.
and re-enabling debug mode cannot hurt.
Logged

shinsui

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 9
    • thorinsgate
Re: click categories gives database query error
« Reply #18 on: June 29, 2010, 08:25:42 PM »

Debug mode is re-enabled.
And about your second quote: I already asked you what tests I could perform to help finding the solution. I did not get an answer to this question though. I don't want to bug about, I know how busy most of you are, I also don't want to complain, but it does not work and that's odd. The 1.4 series worked very well.
Logged

shinsui

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 9
    • thorinsgate
Re: click categories gives database query error
« Reply #19 on: June 29, 2010, 08:28:33 PM »

It is a strange one that I cvannot replicate. On my testbed I get that error message if I type in a cat number that doesn't exist. The mesage is a little missleading and I am not sure why the software thinks for some reason cat=2 on your setup is not there.
I'm not sure either. Fact is however that NO category whatsoever seems to exist. If I create a new one and create some albums in it it too does not exist, be it cat=3 cat=4, you name it. The albums and pictures are found (and exist). Categories can't be clicked on.
Logged
Pages: [1] 2   Go Up
 

Page created in 0.073 seconds with 20 queries.