• [Plugin] Batch Import 5 0 5 1
Currently:  

Author Topic: [Plugin] Batch Import  (Read 294768 times)

0 Members and 1 Guest are viewing this topic.

Offline jcjp

  • Pre-Newbie
  • Posts: 2
    • View Profile
Re: [Plugin] Batch Import
« Reply #150 on: June 05, 2006, 02:09:24 PM »
Muy buenas:

Es posible que Batch_import compare la estructura de directorios y las imagenes existentes en el mismo con el contenido de la base de datos


Gracias

Offline m4rci

  • Pre-Newbie
  • Posts: 6
    • View Profile
Re: [Plugin] Batch Import
« Reply #151 on: June 11, 2006, 06:34:08 PM »
Hi,
ich glaub des prob gabs schonma wurde aba nur in english beantwortet(kann english net sooo gut^^)
des wegen kann mir jemand hierbei helfen?

Warning: opendir(): open_basedir restriction in effect. File(/) is not within the allowed path(s): (/var/www/vhosts/dj-m4rci.de/subdomains/signaturen/httpdocs:/tmp) in /var/www/vhosts/dj-m4rci.de/subdomains/signaturen/httpdocs/admin/plugins/batch_zip_import.php on line 452

Warning: opendir(/): failed to open dir: Operation not permitted in /var/www/vhosts/dj-m4rci.de/subdomains/signaturen/httpdocs/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 (19, '', '5', , 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

Offline idijotaz

  • Jr. Member
  • **
  • Posts: 79
    • View Profile
    • CLON Entertainment
Re: [Plugin] Batch Import
« Reply #152 on: June 11, 2006, 07:05:07 PM »
when im copying images... everything ok, but dont make me thumbnails, and when im traying to make it with auto-thumbnailer, it makes thumbnails but dont show it  :evil:

Offline idijotaz

  • Jr. Member
  • **
  • Posts: 79
    • View Profile
    • CLON Entertainment
Re: [Plugin] Batch Import
« Reply #153 on: June 12, 2006, 05:46:41 PM »
anyone can help?  :?

Offline babyjuker

  • Pre-Newbie
  • Posts: 1
    • View Profile
Re: [Plugin] Batch Import
« Reply #154 on: June 17, 2006, 08:05:23 AM »
can someone please help me with trying to  get this plugin to work properly.  i've tried all types of ways and nothing seems to be at all suscessful.

$data_src_path = "/public_html/hqgallery/admin/plugins";

results in me getting "The data source path "/public_html/hqgallery/admin/plugins" seems to be incorrect!" i've even tried on my computer but that doesn't work neither what am i doing wrong? i'd really  like to use this hack

Offline dolphinpixie

  • Pre-Newbie
  • Posts: 1
    • View Profile
Re: [Plugin] Batch Import
« Reply #155 on: August 04, 2006, 05:11:51 PM »
Hi,

I have read all the post to try and figure out what is going wrong. Like a few people here I have the following error:

Warning: opendir(): open_basedir restriction in effect. File(/) is not within the allowed path(s): (/home/tgmmarke/:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/tgmmarke/public_html/gallery/admin/plugins/batch_import.php on line 315

Warning: opendir(/): failed to open dir: Operation not permitted in /home/tgmmarke/public_html/gallery/admin/plugins/batch_import.php on line 315

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 (5, '', '', , 10, 0, 0, 2, 2, 9, 0, 0, 0, 2)
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, 2)' at line 4
FAILED

Import finished!


I saw the response from Jan about putting the image folder inside the plugin folder. I did this but I am still getting this error. Any help would be greatly appreciated.

Thanks in advance.
Aimee


Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Administrator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: [Plugin] Batch Import
« Reply #156 on: August 04, 2006, 08:45:35 PM »
What is in your $data_src_path  ?
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)

Offline ocdotcom

  • Newbie
  • *
  • Posts: 12
    • View Profile
Re: [Plugin] Batch Import
« Reply #157 on: September 29, 2006, 05:08:33 AM »
What can I say - awesome! Saves me a lot of time. Worked for me right out of the box! Thanks!

Offline blue22deep

  • Newbie
  • *
  • Posts: 29
    • View Profile
Re: [Plugin] Batch Import
« Reply #158 on: October 19, 2006, 11:04:00 PM »
hmmm...lets see...this never been asked before (wich is kind of wierd...)
you can try put this line into .htaccess (on top):[qcode]php_value error_log "/full/local/path/to/where/log/file/will/be/saved/phperrors.log"[/qcode]this is the best way.

if .htaccess is not acceptible you can try insert into global.php (just below <?php):[qcode]ini_set("error_log", "/full/local/path/to/where/log/file/will/be/saved/phperrors.log");[/qcode]
dont forget change the path where that error log will be saved, for security reason this file should not be accessible from the web, so place it somewhere outside of the web root..

Well, bin some time now since i last had the time to try figure this out...

Where do you want me to put the .htaccess file...??

Best Regards
Carsten, Denmark
Best Regards
Carsten, Denmark

Offline MDMC

  • Newbie
  • *
  • Posts: 22
    • View Profile
batch_import problem
« Reply #159 on: November 08, 2006, 10:15:18 PM »
Hi,

hab ein Problem mit dem PlugIn, immer wenn ich es ausfhre sacht es mir:

Quote
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 (41, '', '', , 10, 0, 0, 0, 9, 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, 0, 9, 9, 0, 0, 0, 0)' at line 4
FAILED

Import finished!

Meine Gallery liegt auf Funpic...

Offline WhoMe

  • Newbie
  • *
  • Posts: 17
    • View Profile
Re: [Plugin] Batch Import
« Reply #160 on: December 29, 2006, 03:23:45 AM »
Im getting the following error when i try to import images.
Code: [Select]
1 images in . Importing image 1 to 1
Import category ...
DB Error: Bad SQL Query: SELECT cat_order FROM cov_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 cov_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 (10, '', '', , 10, 0, 0, 2, 2, 9, 0, 0, 0, 2)
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, 2)' at line 4
FAILED

1. Importing image .autofsck
Copy Image: Error while copying image /.autofsck
Skipping.....

Import finished!
[Back]
I have the "new" image-folder (test) with 5 images in the /plugin -folder.
The path is correct batch_import.php.

Whats wrong?  8O

Offline WhoMe

  • Newbie
  • *
  • Posts: 17
    • View Profile
Re: [Plugin] Batch Import
« Reply #161 on: December 30, 2006, 03:19:19 AM »
Im getting the following error when i try to import images.
Code: [Select]
1 images in . Importing image 1 to 1
Import category ...
DB Error: Bad SQL Query: SELECT cat_order FROM cov_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 cov_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 (10, '', '', , 10, 0, 0, 2, 2, 9, 0, 0, 0, 2)
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, 2)' at line 4
FAILED

1. Importing image .autofsck
Copy Image: Error while copying image /.autofsck
Skipping.....

Import finished!
[Back]
I have the "new" image-folder (test) with 5 images in the /plugin -folder.
The path is correct batch_import.php.

Whats wrong?  8O
Any help on this, please!?  :(
Or is there a better import/batch function/mod?

Offline will

  • Pre-Newbie
  • Posts: 1
    • View Profile
Re: [Plugin] Batch Import
« Reply #162 on: March 06, 2007, 10:49:06 PM »
Hi guys

Hopefully this will be a great mod, now I have uploaded 40 files to my server to import and I get:

The data source path "home/content/w/i/l/willtaka05/html/Covers" seems to be incorrect!

Now do I have to put the files in my 4images folder for it to read it or doesn't it matter?

Thanks :lol:

Offline skidpics

  • Jr. Member
  • **
  • Posts: 61
    • View Profile
Re: [Plugin] Batch Import
« Reply #163 on: August 07, 2007, 04:40:24 PM »
Love the plugin, but when I try to use it, nothing happens.  It simply refreshes my main gallery page within the ACP right frame..  Any suggestions on what could be causing that?  I was using the batch zip import yesterday, and it quit working also, with the same results..  Would this be  a cause of 'zip' being turned off somewhere?  I get no error messge, just a main gallery refresh within the acp right frame

Offline riotz

  • Pre-Newbie
  • Posts: 1
    • View Profile
Re: [Plugin] Batch Import
« Reply #164 on: October 02, 2007, 01:56:28 PM »
Great plugin, just what I needed.

I have one problem though, I created the folder structure in the import directory to match existing categories, as I wanted to add the new images to the cats already setup on my site.  However, it didn't add the new images to the existing cats, it created identical categories & subcats for the new images.  Is it supposed to work this way, and if so, is there any simple fix to have it import new images to existing categories?