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: After JUpload I get: There was an error while processing a database query  (Read 11964 times)

0 Members and 1 Guest are viewing this topic.

LSD

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 20

Hi Etienne,

Not sure if this is related to JUpload although I only get this error when using JUpload

So after Jupload uploads, and the confirmation screen comes up, when I click ok, I get this error:


There was an error while processing a database query.

With debug enabled I get:

While executing query "SELECT p.*,a.category FROM cpg_pictures as p INNER JOIN cpg_albums as a ON a.aid=p.aid WHERE  p.aid = -1 and p.owner_id = 0  ORDER BY p.ctime LIMIT -1, 25" on 0

mySQL error:


Also it seems to logout while doing that query.

I have full debug info if required:

If not related can you point me into the right direction please: I use Coppermine Photo Gallery 1.4.25 (stable) + SMF SMF 1.1.10: Bridged.


Logged

etienne_sf

  • Moderator
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 908
    • Wiki
Re: After JUpload I get: There was an error while processing a database query
« Reply #1 on: November 25, 2009, 05:36:29 pm »

Hi,

  Yes I need the full debug, for analysis. At least, I need the MySql error...

A question, as you talked about being logged out: was this upload a big one (lots of pictures, or long upload) ?


Etienne
Logged

LSD

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 20
Re: After JUpload I get: There was an error while processing a database query
« Reply #2 on: November 26, 2009, 11:31:49 pm »

Hey i've tried 1 pic to -20 pic same effect.

Full Debug:
USER:
------------------
Array
(
    [ID] => 799b531cafa6f52068856c7b84378122
    [am] => 1
    [lang] => english
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 0
    [user_name] => Guest
    [groups] => Array
        (
           
  • => 1

        )

    [group_quota] => 0
    [can_rate_pictures] => 0
    [can_send_ecards] => 0
    [can_post_comments] => 1
    [can_upload_pictures] => 1
    [can_create_albums] => 0
    [pub_upl_need_approval] => 0
    [priv_upl_need_approval] => 0
    [upload_form_config] => 3
    [num_file_upload] => 5
    [num_URI_upload] => 3
    [custom_user_upload] => 0
    [disk_max] => 0
    [disk_min] => 0
    [ufc_max] => 3
    [ufc_min] => 3
    [has_admin_access] => 0
    [group_name] => Guests
    [can_see_all_albums] => 0
    [group_id] => 1
)

==========================
Queries:
------------------
Array
(
   
  • => SELECT extension, mime, content, player FROM cpg_filetypes; (0s)
  • [1] => select * from cpg_plugins order by priority asc; (0s)
        [2] => SELECT * FROM cpg_bridge (0s)
        [3] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg_usergroups WHERE group_id in (1) (0s)
        [4] => SELECT group_name FROM  cpg_usergroups WHERE group_id= 1 (0s)
        [5] => DELETE FROM cpg_banned WHERE expiry < '2009-11-24 16:44:18' (0s)
        [6] => SELECT * FROM cpg_banned WHERE (ip_addr='203.87.108.141' OR ip_addr='203.87.108.141' OR user_id=0) AND brute_force=0 (0s)
        [7] => SELECT aid FROM cpg_albums WHERE visibility != '0' AND visibility !='10000' AND visibility NOT IN (1) (0s)
        [8] =>  SELECT category  FROM cpg_albums  WHERE aid = 61  (0s)
        [9] =>  SELECT cid, name, parent, description  FROM cpg_categories  WHERE cid = 10011  AND   (cid < 10000 or cid = 10000) (0s)
        [10] => SELECT count(*) FROM cpg_pictures as p WHERE  p.aid = -1 and p.owner_id = 0  (0s)
        [11] => SELECT p.*,a.category FROM cpg_pictures as p INNER JOIN cpg_albums as a ON a.aid=p.aid WHERE  p.aid = -1 and p.owner_id = 0  ORDER BY p.ctime LIMIT -1, 25 (0s)
    )

    ==========================
    GET :
    ------------------
    Array
    (
       
[file] => jupload/jupload
    [action] => edit_uploaded_pics
    [album] => 61
    [nb_pictures] => 1
    [jupload] =>
)

==========================
POST :
------------------
Array
(
)

==========================
Page generated in 0.121 seconds - 12 queries in 0 seconds - Album set : AND aid NOT IN (3,4,9,12,21,22,23,24,25,26,28,29,30,32,33,34,35,36,38,40,42,43,44,45,46,47,49,50,51,52,54,56,57,58) ; Meta set: ;
Logged

etienne_sf

  • Moderator
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 908
    • Wiki
Re: After JUpload I get: There was an error while processing a database query
« Reply #3 on: November 27, 2009, 12:52:07 pm »

Hi,

  The debug output I need is the JUpload one.

Please read this page for details: http://forum.coppermine-gallery.net/index.php/topic,53168.0.html
(search for 'How to get the debug output ?')

Etienne
Logged

LSD

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 20
Re: After JUpload I get: There was an error while processing a database query
« Reply #4 on: December 07, 2009, 03:36:37 am »

Hey Etienne,

the full debug message doesn't fit in here, was a specific part you were after in the message?
Logged

etienne_sf

  • Moderator
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 908
    • Wiki
Re: After JUpload I get: There was an error while processing a database query
« Reply #5 on: December 07, 2009, 12:07:00 pm »

hi,

  You can't attach it as a text file ?


If it's the case, I'll PM you my mail, so that you send it to me this way.

Etienne
Logged

LSD

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 20
Re: After JUpload I get: There was an error while processing a database query
« Reply #6 on: December 08, 2009, 03:07:13 am »

here it is, cheers
Logged

etienne_sf

  • Moderator
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 908
    • Wiki
Re: After JUpload I get: There was an error while processing a database query
« Reply #7 on: December 08, 2009, 10:37:24 am »

Hi,

  This one is a success. Does it mean that the problem is solved ?

Etienne
Logged

LSD

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 20
Re: After JUpload I get: There was an error while processing a database query
« Reply #8 on: December 10, 2009, 12:08:13 am »

Hi,

Nope not done, when i enable the debug, JUpload doesn't got through the step to review uploaded pics. So that's why it's probably works.

But without debug on it goes all the way till it brakes.
Logged

etienne_sf

  • Moderator
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 908
    • Wiki
Re: After JUpload I get: There was an error while processing a database query
« Reply #9 on: December 10, 2009, 09:31:48 am »

Hi,


But without debug on it goes all the way till it brakes.

  Hum, won't be easy, if I can't know what's happening... :-\

While executing query "SELECT p.*,a.category FROM cpg_pictures as p INNER JOIN cpg_albums as a ON a.aid=p.aid WHERE  p.aid = -1 and p.owner_id = 0  ORDER BY p.ctime LIMIT -1, 25" on 0

This query is processed when displaying the uploaded pictures. So, I guess, pictures are uploaded correctly, but you can't update their properties.

1- Right ?

You say it seems to be deconnected:
2- Are you sure ? It's very strange, as other queries are executed before this one !  And it's confirmed by what you pasted, here above ... if the message posted on  26-11-2009, 22:31:49 is based on a upload that didn't work. (can you confirm this upload did not work).

Etienne
Logged

LSD

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 20
Re: After JUpload I get: There was an error while processing a database query
« Reply #10 on: December 10, 2009, 01:17:32 pm »

Hey,

Upload works just the properties page after doesn't display and it LOGs OUT.

The pictures are still there, although I have to relogin after upload and manually go to Properties page.
Logged

etienne_sf

  • Moderator
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 908
    • Wiki
Re: After JUpload I get: There was an error while processing a database query
« Reply #11 on: December 11, 2009, 09:27:52 am »

Hum, hum,

1) Do you know the MySql error that occurs ?

2) Is there any specific parameter on the URL, that could be lost ?
(for instance ... a session ID)

3) Can you check that the domain name in the URL is the same on the upload page, and then on the 'edit uploaded picture page'. If not exactly the same, some cookies may be lost, which makes you unrecognized from the server.

4) If all these are wrong, can you give an access (at least upload right with JUpload, to begin with) on your system ?
I'll then send you a PM, with my mail.

Etienne
Logged

LSD

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 20
Re: After JUpload I get: There was an error while processing a database query
« Reply #12 on: December 14, 2009, 01:28:53 am »

Hum, hum,



2) Is there any specific parameter on the URL, that could be lost ?
(for instance ... a session ID)

3) Can you check that the domain name in the URL is the same on the upload page, and then on the 'edit uploaded picture page'. If not exactly the same, some cookies may be lost, which makes you unrecognized from the server.

4) If all these are wrong, can you give an access (at least upload right with JUpload, to begin with) on your system ?
I'll then send you a PM, with my mail.

Etienne

Hi Etienne number 3 was different in gallery, so after I made forum and Gallery come off the same URL all started working correctly.

Thank you HEAPS as always wicked help
Logged
Pages: [1]   Go Up
 

Page created in 0.034 seconds with 19 queries.