This topic was marked solved by Nao, on July 25th, 2017, 07:32 PM
[AeMe] The database value you're trying to insert does not exist: id_file

Franky

  • Posts: 16
[AeMe] Re: The database value you're trying to insert does not exist: id_file
« Reply #15, on April 23rd, 2016, 09:54 PM »
Go to Media over the menu button

Database error
File: /xxxxxxxxxxxxxxxxxxxxxxxxxxx/wedge/gz/app/media_Subs-Media.php  (root =>gz => http://wedge.org/pub/bugs/8781/aeva-cache-of-aeva-sites/msg297060/#msg297060)
Line: 3605

Code: (php) [Select]
3594function aeva_resetTransparency($id_file, $path)
3595{
3596 $is_transparent = aeva_isTransparent($path);
3597 wesql::query('
3598 UPDATE {db_prefix}media_files
3599 SET transparency = {string:transparency}
3600 WHERE WHERE id_file = id_file',
3601 array(
3602 'id_file' => $id_file,
3603 'transparency' => $is_transparent ? 'transparent' : 'opaque',
3604 )
3605 );
3606 return $is_transparent;
3607}
Line 3605:    
Code: (php) [Select]
);

Nao

  • Dadman with a boy
  • Posts: 16,079
[AeMe] Re: The database value you're trying to insert does not exist: id_file
« Reply #17, on July 25th, 2017, 07:35 PM »
Apologies for missing out on this topic for so long... I posted in it at the beginning, then forgot about it, and it came at a time when I was putting Wedge behind me and moving on to my next venture (which, at the time, didn't involve Wedge... But ended up involving it, because that's who I am.)
The worst thing here, is that it was a very straightforward fix (just testing if $id_file is empty before calling the query), but I wanted to know WHY it happened in the first place. Now I have my answer because it happened at Wedge.org (uploading a link to an embedded video.)
Still, I hope there aren't more game-breaking bugs like this one... (?)

Franky

  • Posts: 16