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: erroro messages database  (Read 1084 times)

0 Members and 1 Guest are viewing this topic.

axial63

  • Coppermine newbie
  • Country: nl
  • Offline Offline
  • Gender: Male
  • Posts: 12
erroro messages database
« on: December 17, 2018, 10:22:19 pm »

Hello,
after a long weekend downloading files and new-installing cpg i still recive errors in the logfiles.

That also accours after manualy upgrading cpg1.5.46, the upgrade with the released installer_stub evrytime went wrong...

To be sure the error was in the programm i did a new install this weekend.

The error messages are:

Quote
Dec 17, 2018 at 06:24 PM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id
FROM cpg16x_pictures AS r
INNER JOIN cpg16x_albums AS a ON a.aid = r.aid
WHERE (1)
AND approved = 'YES'
ORDER BY ctime ASC, pid ASC
LIMIT 0 ,-4886' in include/functions.inc.php on line 1626 the following error was encountered:
1064 : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-4886' at line 7
3x

Quote
Dec 17, 2018 at 08:28 PM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id
FROM cpg16x_pictures AS r
INNER JOIN cpg16x_albums AS a ON a.aid = r.aid
WHERE (1)
AND r.owner_id = '3'
AND approved = 'YES'
ORDER BY ctime ASC, pid ASC
LIMIT 0 ,-6114' in include/functions.inc.php on line 1682 the following error was encountered:
1064 : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-6114' at line 8
3x

Quote
Dec 17, 2018 at 08:11 PM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id
FROM cpg16x_pictures AS r
INNER JOIN cpg16x_albums AS a ON a.aid = r.aid
WHERE (r.aid = 206)
AND approved = 'YES'
AND hits > 0
ORDER BY hits ASC, pid DESC
LIMIT 0 ,-20' in include/functions.inc.php on line 1730 the following error was encountered:
1064 : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-20' at line 8
1x

Quote
Dec 17, 2018 at 04:42 PM - While executing query 'SELECT cid FROM cpg16x_categories WHERE lft BETWEEN AND ' in include/functions.inc.php on line 49 the following error was encountered:
1064 : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND' at line 1
100x

Quote
31 // only add when we are at the top level, cat == 0
32 function get_meta_album_set($cat)
33 {
34     global $CONFIG, $lft, $rgt, $RESTRICTEDWHERE, $FORBIDDEN_SET_DATA, $CURRENT_ALBUM_KEYWORD, $CURRENT_CAT_DEPTH;
35     if ($cat == USER_GAL_CAT) {
36         $RESTRICTEDWHERE   = "WHERE (category > " . FIRST_USER_CAT;
37         $CURRENT_CAT_DEPTH = -1;
38
39     } elseif ($cat > FIRST_USER_CAT) {
40        $RESTRICTEDWHERE   = "WHERE (category = $cat";
41        $CURRENT_CAT_DEPTH = -1;
42
43    } elseif ($cat > 0) {
44        $result = cpg_db_query("SELECT rgt, lft, depth FROM {$CONFIG['TABLE_CATEGORIES']} WHERE cid = $cat LIMIT 1");
45        list($rgt, $lft, $CURRENT_CAT_DEPTH) = $result->fetchRow(true);
46        $RESTRICTEDWHERE = "INNER JOIN {$CONFIG['TABLE_CATEGORIES']} AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN $lft AND $rgt";
47
48        if (empty($CURRENT_ALBUM_KEYWORD)) {
49            $result = cpg_db_query("SELECT cid FROM {$CONFIG['TABLE_CATEGORIES']} WHERE lft BETWEEN $lft AND $rgt");
50            $categories = array();
51            while($row = $result->fetchAssoc()) {
52                $categories[] = $row['cid'];
53            }
54            $result->free();
55            $categories = implode(', ', $categories);
56
57            $result = cpg_db_query("SELECT keyword FROM {$CONFIG['TABLE_ALBUMS']} WHERE category IN ($categories)");
58            if ($result->numRows() > 0) {
59                $CURRENT_ALBUM_KEYWORD = array();
60                while($row = $result->fetchAssoc()) {
61                    if(!empty($row['keyword'])) {
62                        $CURRENT_ALBUM_KEYWORD[] = $row['keyword'];
63                    }
64                }
65            }
66            $result->free();
67        }
functions.inc.php

I'm out off resorses: HELP :)

Logged

ron4mac

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Posts: 1137
Re: erroro messages database
« Reply #1 on: December 18, 2018, 01:50:48 am »

Have you ran the update file? ( http://<your site>/update.php )
Logged

axial63

  • Coppermine newbie
  • Country: nl
  • Offline Offline
  • Gender: Male
  • Posts: 12
Re: erroro messages database
« Reply #2 on: December 18, 2018, 12:53:42 pm »

Hello Ron,

thank  you for the reply.

Ofcourse i did ran the update.php file and the option: update database... Multiple times…   :o

But hee, what the hack, i run it again…   8)

Also ran: Version Check: Came out: OK V

Errors i find at this moment:

Quote
Dec 18, 2018 at 12:47 PM - While executing query 'SELECT cid FROM cpg16x_categories WHERE lft BETWEEN AND ' in include/functions.inc.php on line 49 the following error was encountered:
1064 : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND' at line 1

Quote
Dec 18, 2018 at 12:48 PM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id
FROM cpg16x_pictures AS r
INNER JOIN cpg16x_albums AS a ON a.aid = r.aid
WHERE (r.aid = 209)
AND approved = 'YES'
ORDER BY ctime ASC, pid ASC
LIMIT 0 ,-60' in include/functions.inc.php on line 1626 the following error was encountered:
1064 : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-60' at line 7

Quote
Dec 18, 2018 at 12:48 PM - While executing query 'SELECT cid FROM cpg16x_categories WHERE lft BETWEEN AND ' in include/functions.inc.php on line 49 the following error was encountered:
1064 : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND' at line 1
Logged

axial63

  • Coppermine newbie
  • Country: nl
  • Offline Offline
  • Gender: Male
  • Posts: 12
Re: erroro messages database
« Reply #3 on: December 19, 2018, 12:30:21 am »

Debugger is now on 'normal'

messages:
Quote
/include/init.inc.php
Notice line 195: Undefined index: log_retention
in every screen

Quote
/include/logger.inc.php
Warning line 77: file_get_contents(logs/hupload.log.php): failed to open stream: No such file or directory
only whyle visiting log_file : h5upload
Logged

axial63

  • Coppermine newbie
  • Country: nl
  • Offline Offline
  • Gender: Male
  • Posts: 12
Re: erroro messages database
« Reply #4 on: December 22, 2018, 01:56:26 pm »

Still get messages that logfiles don't exist or can't be found.

1. when i try to open the index.html logfile
Quote

Logs :: indexhtml

Debug-information 

Messages

/include/init.inc.php
Notice line 195: Undefined index: log_retention

/include/logger.inc.php
Warning line 77: file_get_contents(logs/indexhtml.log.php): failed to open stream: No such file or directory

and

2. When i try to open de h5upload logfile
Quote
Logs :: hupload

Debug-information

Messages
 
/include/init.inc.php
Notice line 195: Undefined index: log_retention

/include/logger.inc.php
Warning line 77: file_get_contents(logs/hupload.log.php): failed to open stream: No such file or directory

And still the database logfile is filling al the time whit this messages:
Quote
Dec 22, 2018 at 10:55 AM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id
FROM cpg16x_pictures AS r
INNER JOIN cpg16x_albums AS a ON a.aid = r.aid
WHERE (1)
AND approved = 'YES'
ORDER BY ctime ASC, pid ASC
LIMIT 0 ,-3563' in include/functions.inc.php on line 1626 the following error was encountered:
1064 : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-3563' at line 7
ca. 1 every hour.
Quote
Dec 22, 2018 at 11:06 AM - While executing query 'SELECT cid FROM cpg16x_categories WHERE lft BETWEEN AND ' in include/functions.inc.php on line 49 the following error was encountered:
1064 : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND' at line 1
ca. 100 every hour.

Enybody who knows a workarround or solution?
Logged

ron4mac

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Posts: 1137
Re: erroro messages database
« Reply #5 on: December 22, 2018, 03:16:10 pm »

The log files warnings are something that we can take care of in an update.

The database errors may indicate a problem with your database.  I will try to discover the cause.
Logged

ron4mac

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Posts: 1137
Re: erroro messages database
« Reply #6 on: December 22, 2018, 04:15:23 pm »

I've looked into this and I am quite certain that there is no problem with your database. I believe these logged database errors are coming from external entities (bots, spiders, other sites) trying to access your gallery with improper links.
example: http://foto.destormvogels.nl/index.php?cat=30
Something trying to link to a non-existing category.

If you look in your site access logs you will likely see such accesses.

You should make sure that none are coming from your Joomla site (old, incorrect links).

We may be able to do some work to try to validate such bad links prior to trying to access the database; thus reducing these kind of entries in the log.
Logged

axial63

  • Coppermine newbie
  • Country: nl
  • Offline Offline
  • Gender: Male
  • Posts: 12
Re: erroro messages database
« Reply #7 on: December 22, 2018, 05:30:28 pm »

OKe Thanks!

I will look in to more information about the incomming traffic...

From the Joomla site it's almost impossible, there is only one (1) direct link and no deep linking to photo's.

Again,
Many thanks

and Happy Holidays!!
Logged

axial63

  • Coppermine newbie
  • Country: nl
  • Offline Offline
  • Gender: Male
  • Posts: 12
Re: erroro messages database
« Reply #8 on: December 23, 2018, 01:32:19 am »

Indeed...

Al errors listed above that where found in the database logfile where coused by Bots and Spiders.

So i'v made an robots.txt file and after installing that the logfiles are empty. (atleast for the last hour)  ;D

Thank you for pointing the wright way.  8)
Logged
Pages: [1]   Go Up
 

Page created in 0.055 seconds with 22 queries.