• [PLUGIN] Batch Import From ZIP Files 5 0 5 1
Currently:  

Author Topic: [PLUGIN] Batch Import From ZIP Files  (Read 250012 times)

0 Members and 2 Guests are viewing this topic.

sax-1

  • Guest
batch_zip_import - Fehlermeldung...
« Reply #60 on: May 22, 2006, 11:01:19 AM »
Hallo zusammen,

ich habe die 4images Galerie installiert und den o.g. Patch.
Wenn ich jetzt die zip Datei entpacken möchte bekomme ich folgenge Meldung.
Was mache ich falsch???
Schon mal danke für Deine Hilfe

Viele Grüße
Roman

Warning: opendir(): open_basedir restriction in effect. File(/) is not within the allowed path(s): (/var/www/web793/html/:/var/www/web793/phptmp/:/var/www/web793/files/:/var/www/web793/atd/) in /var/www/web793/html/4images/4images/admin/plugins/.php on line 452

Warning: opendir(/): failed to open dir: Operation not permitted in /var/www/web793/html/4images/4images/admin/plugins/batch_zip_import.php on line 452

0 images in .

Import category ...
DB Error: Bad SQL Query: SELECT cat_order FROM 4images_categories WHERE cat_parent_id = ORDER BY cat_order DESC LIMIT 1
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY cat_order DESC LIMIT 1' at line 4

DB Error: Bad SQL Query: INSERT INTO 4images_categories (cat_id, cat_name, cat_description, cat_parent_id, cat_order, auth_viewcat, auth_viewimage, auth_download, auth_upload, auth_directupload, auth_vote, auth_sendpostcard, auth_readcomment, auth_postcomment) VALUES (2, '', '', , 10, 0, 0, 2, 2, 9, 0, 0, 0, 0)
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 10, 0, 0, 2, 2, 9, 0, 0, 0, 0)' at line 4
FAILED


Import finished!



Offline honda2000

  • 4images Guru
  • *******
  • Posts: 3.263
    • View Profile
    • Wir machen Internet!
Re: batch_zip_import - Fehlermeldung...
« Reply #61 on: May 22, 2006, 09:05:41 PM »
du willst  ne zipt-Datei auf dem server entpacken??

wie das denn??

hast du einen Root-Server??

sax-1

  • Guest
Re: batch_zip_import - Fehlermeldung...
« Reply #62 on: May 23, 2006, 08:12:12 AM »
k.A. wohl eher nicht...
Mir wurde gesagt damit geht das damit!?

Offline honda2000

  • 4images Guru
  • *******
  • Posts: 3.263
    • View Profile
    • Wir machen Internet!
Re: batch_zip_import - Fehlermeldung...
« Reply #63 on: May 23, 2006, 09:19:57 PM »
nein, du musst den zip-File (4images) auf deinem Rechner enpacken, so wie die ordner sind, auf dienen Server laden, im Ordner docks die Inatallation_deutsch.txt lesen und die install.php auf dem Server öffnen, bzw. beim ersten aufruf der domain kommt die eingabemaske der Installtion von ganz allein!

Offline dezina

  • Newbie
  • *
  • Posts: 40
    • View Profile
    • Dezina Skins, Templates, Themes
Re: [PLUGIN] Batch Import From ZIP Files
« Reply #64 on: August 11, 2006, 08:07:24 AM »
Used this excellent mod on previous versions.
Will it work with latest 4Images 1.73 release or
are further modifications to script required please?
 :?

Offline dezina

  • Newbie
  • *
  • Posts: 40
    • View Profile
    • Dezina Skins, Templates, Themes
Re: [PLUGIN] Batch Import From ZIP Files
« Reply #65 on: August 11, 2006, 10:57:06 AM »
Checked and tested myself,
this mod for Batch Import from Zip Files
works fine on 4Images Gallery release 1.73
 :flag-en:  :mrgreen:

Offline kaze

  • Newbie
  • *
  • Posts: 12
    • View Profile
Batch ZIP Import nicht mehr möglich (Error)
« Reply #66 on: August 16, 2006, 01:39:21 PM »
Hi Leute,

ich habe seither immer den Batch ZIP Import Mod eingesetzt um viele Bilder auf einmal hochzuladen.

Doch seit einiger Zeit funktioniert der Mod nicht mehr.
Dabei habe ich nichts verändert (auch nicht an der Datenbank usw)

Der Upload funktioniert nicht mehr und ich kriege stattdessen immer folgende Fehlermeldung:

Quote
Warning: opendir() [function.opendir]: open_basedir restriction in effect. File(/) is not within the allowed path(s): (/tmp:/bin:/usr:/is/htdocs/wp1036795_0P59S4DAEY) in /is/htdocs/wp1036795_0P59S4DAEY/www/gallery/admin/plugins/batch_zip_import.php on line 452

Warning: opendir(/) [function.opendir]: failed to open dir: Operation not permitted in /is/htdocs/wp1036795_0P59S4DAEY/www/knk/gallery/admin/plugins/batch_zip_import.php on line 452

0 images in .

Import category ...
DB Error: Bad SQL Query: SELECT cat_order FROM gallery_categories WHERE cat_parent_id = ORDER BY cat_order DESC LIMIT 1
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY cat_order DESC LIMIT 1' at line 4

DB Error: Bad SQL Query: INSERT INTO gallery_categories (cat_id, cat_name, cat_description, cat_parent_id, cat_order, auth_viewcat, auth_viewimage, auth_download, auth_upload, auth_directupload, auth_vote, auth_sendpostcard, auth_readcomment, auth_postcomment) VALUES (103, '', '', , 10, 0, 0, 2, 2, 9, 0, 0, 0, 0)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 10, 0, 0, 2, 2, 9, 0, 0, 0, 0)' at line 4
FAILED


Import finished!

Ich habe definitiv nichts an meinen DB geändert, zumal ich mich da eh viel zu wenig auskenne....

Wäre über die Lösung meines Problems sehr dankbar.

Bis dann
Kaze

Offline MauiJim

  • Pre-Newbie
  • Posts: 2
    • View Profile
Re: [PLUGIN] Batch Import From ZIP Files
« Reply #67 on: September 23, 2006, 07:30:28 PM »
I need the files please!

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: [PLUGIN] Batch Import From ZIP Files
« Reply #68 on: September 23, 2006, 07:52:27 PM »
file attached to the post now.
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

JuBu.org

  • Guest
Re: [PLUGIN] Batch Import From ZIP Files
« Reply #69 on: September 27, 2006, 11:04:30 AM »
hey, i'm new in this forum but i use the gallery 1,5 years.
i'm from germany and my english is very bad.

ok, zum thema...
ich habe das selbe problem wie die beiden anderen.

weiß einer mittlerweile bescheid woran es liegen könnte?
im anhang ist die genannte datei.

please help me!

Quote
Warning: opendir(): open_basedir restriction in effect. File(/) is not within the allowed path(s): (/tmp:/bin:/usr:/is/htdocs/49945) in /is/htdocs/49945/www.jugend-buchholz.de/4images/admin/plugins/batch_zip_import.php on line 453

Warning: opendir(/): failed to open dir: Operation not permitted in /is/htdocs/49945/www.jugend-buchholz.de/4images/admin/plugins/batch_zip_import.php on line 453

0 images in .
Import category ...
DB Error: Bad SQL Query: SELECT cat_order FROM 4images_categories WHERE cat_parent_id = ORDER BY cat_order DESC LIMIT 1
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY cat_order DESC LIMIT 1' at line 4

DB Error: Bad SQL Query: INSERT INTO 4images_categories (cat_id, cat_name, cat_description, cat_parent_id, cat_order, auth_viewcat, auth_viewimage, auth_download, auth_upload, auth_directupload, auth_vote, auth_sendpostcard, auth_readcomment, auth_postcomment) VALUES (63, '', '', , 10, 0, 0, 2, 2, 9, 0, 0, 0, 0)
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 10, 0, 0, 2, 2, 9, 0, 0, 0, 0)' at line 4
FAILED

Import finished!


Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: [PLUGIN] Batch Import From ZIP Files
« Reply #70 on: September 28, 2006, 02:52:15 AM »
[KNOWN BUGS]
-----------------------------------------------
U can not have ANY files in the root of your .zip archive
All importing files MUST be located inside a folder in the .zip file.
e.i.
This archive tree is wrong:

/summer.jpg
/winter.jpg
/thumbnails/summer.jpg
/thumbnails/winter.jpg


This archive tree is correct:

/seasons/summer.jpg
/seasons/winter.jpg
/seasons/thumbnails/summer.jpg
/seasons/thumbnails/winter.jpg

Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

JuBu.org

  • Guest
Re: [PLUGIN] Batch Import From ZIP Files
« Reply #71 on: September 28, 2006, 12:15:54 PM »
Hey, Thank You!!!
This was it!

Danke nochmal, ihr seid die Besten!!!

emanon

  • Guest
Re: [PLUGIN] Batch Import From ZIP Files
« Reply #72 on: January 12, 2007, 10:08:33 PM »
Hi there,

I installed the mod. It works ALMOST 100%, it unzips, imports etc. But it puts the subcategorys in the Root/Main folder no matter what i choose in the Batch ZIP Import menu for "Subcategory under".

I use 1.7.4.

Anyone please??

Offline m.a

  • Jr. Member
  • **
  • Posts: 83
    • View Profile
Re: [PLUGIN] Batch Import From ZIP Files
« Reply #73 on: February 06, 2007, 02:01:50 AM »
Hi,
Thank You V@no!!!
I installed the mod. And it works without Problem!
perfect and prime.

I use 1.7.4. too

Best Regards
m.a

toby86

  • Guest
Re: [PLUGIN] Batch Import From ZIP Files
« Reply #74 on: February 12, 2007, 10:03:31 PM »
I wrote a little modification for the Batch-script:

If the exif-date of the image can be extracted, it will be stored as the picture's date in the database..
Please save your original file, I won't guarantee for anything! For me it works fine and stable.


Open "batch_zip_import.php"

Find:
Code: [Select]
    for ($i = $batchstart; $i <= $batchend; $i++) {
      $file = $files[$i];

Before add:
Code: [Select]
  function tf_get_exif_info($exif) {
  $exif_match = array();
  $exif_match['DateTimeOriginal'] = "datetime";

  $exif_array = array();
  if (is_array($exif)) {
foreach ($exif as $key => $val) {
  if (isset($exif_match[$key])) {
$exif_info = $val;
if ($key == "DateTimeOriginal") {
  $tf_exif_date_raw = preg_replace("/([0-9]{4}):([0-9]{2}):([0-9]{2})/", "\\3.\\2.\\1", $exif_info);
  $tf_exif_date_raw = explode(' ', $tf_exif_date_raw);
  $tf_exif_date_raw[0] = explode('.', $tf_exif_date_raw[0]);
  $tf_exif_date_raw[1] = explode(':', $tf_exif_date_raw[1]);
 
  $tf_exif_date = mktime( $tf_exif_date_raw[1][0], $tf_exif_date_raw[1][1], $tf_exif_date_raw[1][2], $tf_exif_date_raw[0][1], $tf_exif_date_raw[0][0], $tf_exif_date_raw[0][2] );
}
  }
}
  }
  return $tf_exif_date;
}



Find:
Code: [Select]
      $image_date = ($use_image_filemtime) ? filemtime($dir_array[$cat]['cat_path']."/".$file) : time();


Replace with:
Code: [Select]
  $src = $dir_array[$cat]['cat_path']."/".$file;
  if(function_exists('exif_read_data') && $exif_data = @exif_read_data($src, 'EXIF')) {
  $image_date = tf_get_exif_info($exif_data);
  } else {
  //fallback
  $image_date = ($use_image_filemtime) ? filemtime($dir_array[$cat]['cat_path']."/".$file) : time();
  }


Find:
Code: [Select]
show_radio_row("Use file modification time as date", "useimagefiletime", $use_image_filemtime);

Replace with:
Code: [Select]
show_radio_row("Use file modification time as date if exif-information can't be extracted", "useimagefiletime", $use_image_filemtime);


Find:
Code: [Select]
  }else{
$use_image_filemtime = 0;
}

Replace with:
Code: [Select]
  }else{
$use_image_filemtime = 1;
}

Save "batch_zip_import.php" & upload