After JUpload I get: There was an error while processing a database query

[LSD]

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.

[etienne_sf]

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

[LSD]

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: ;

[etienne_sf]

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

[LSD]

Hey Etienne,

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

[etienne_sf]

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

[LSD]

here it is, cheers

[etienne_sf]

Hi,

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

Etienne

[LSD]

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.

[etienne_sf]

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

[LSD]

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.

[etienne_sf]

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

[LSD]

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