I am having trouble uploading with g2. All was fine for a while and tonight I am having trouble. I can upload and the files are in the directory (they show with ftp) but gallery2 doesn't see them.
The gallery in question is http://photos.mainemillers.com/gallery2/v/misc/lenox/
Images are greyscale and 1633x2133 size
Also the database size is out of whack cPanel shows: MySQL Disk Space 4.81 Megabytes for 3 different databases
Disk Usage
Total
Item Value
Total size of gallery 97.92 MB
Total size of albums 90.74 MB
Total size of derivatives 3.05 MB
Total size of database 42.95 GB <----------------seems high?
Total size 43.05 GB
Available space 585.80 GB / 625.70 GB (6%)
Breakdown
# Album Size
1 Scout 16.16 MB
2 Birds 34.02 MB
3 Jasper 8.27 MB
4 Pepper 14.01 MB
5 Clementine 5.73 MB
6 Calypso 6.02 MB
7 Family & Friends 24.11 MB
8 Catch - All Album 16.45 MB
9 Lenox Shoe Articles 9.42 MB <---------nothing visible in album
10 Misc Odd Ball Stuff 7.02 MB
One last thing. I was invited to beta test reinvigorate stats program but cannot figure out how to incorporate the javascript. If anyone is using it that would be a great help.
Gallery version = 2.2 core 1.2.0
PHP version = 4.4.4 cgi
Webserver = WebServerX
Database = mysqlt 4.1.21-standard, lock.system=flock
Toolkits = ArchiveUpload, Exif, Gd
Acceleration = none, none
Operating system = Linux sh112.surpasshosting.com 2.6.9-42.0.10.ELsmp #1 SMP Tue Feb 27 09:40:21 EST 2007 x86_64
Default theme = matrix
gettext = enabled
Locale = en_US
Browser = Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.3) Gecko/20070309 Firefox/2.0.0.3
Rows in GalleryAccessMap table = 11
Rows in GalleryAccessSubscriberMap table = 19
Rows in GalleryUser table = 2
Rows in GalleryItem table = 19
Rows in GalleryAlbumItem table = 6
Rows in GalleryCacheMap table = 0
Posted: Mon, 2007-04-16 01:32
Posts: 32509
> I can upload and the files are in the directory (they show with ftp) but gallery2 doesn't see them.
how do you upload files to g2?
you should never upload files directly into g2data/ yourself.
> Total size of database 42.95 GB
who's reporting that number? phpmyadmin? cpanel?
check in phpmyadmin which table is using xx GB. if it's CacheMap, well, that would be somewhat reasonable. but it would be still very large.
and please click "run" in site admin -> maintenance -> system information. it says you got 11 items in your g2. i guess that's a very old value and you've got many more items now.
--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
Posts: 17
Sorry, I uploaded with the web interface through gallery2 and the files are in the correct album folder, I checked via ftp when gallery showed no upload.
It was from within gallery that showed the large size db using statistics module>disk usage
This is from myPHPadmin:
Table Action RecordsTip Type Collation Size Overhead
49 table(s) Sum 2,557 MyISAM latin1_swedish_ci 1.6 MiB 0 B
none of the tables are using xxGB. cachemap is using 48KiB sessionmap is the largest at 128KiB
OOPS, forgot to re-run, sorry:
Gallery version = 2.2.1 core 1.2.0.1
PHP version = 4.4.4 cgi
Webserver = WebServerX
Database = mysqlt 4.1.21-standard, lock.system=flock
Toolkits = ArchiveUpload, Exif, Gd, Thumbnail, SquareThumb
Acceleration = none, none
Operating system = Linux sh112.surpasshosting.com 2.6.9-42.0.10.ELsmp #1 SMP Tue Feb 27 09:40:21 EST 2007 x86_64
Default theme = carbon
gettext = enabled
Locale = en_US
Browser = Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.3) Gecko/20070309 Firefox/2.0.0.3
Rows in GalleryAccessMap table = 14
Rows in GalleryAccessSubscriberMap table = 54
Rows in GalleryUser table = 5
Rows in GalleryItem table = 52
Rows in GalleryAlbumItem table = 11
Rows in GalleryCacheMap table = 0
thanks,
matt
Posts: 32509
> It was from within gallery that showed the large size db using statistics module>disk usage
the stats module has some bugs. it reports crazy disk usage numbers. you can ignore them.
btw: it's not an official module, that's why you can't expect it to have gallery-grade quality.
@discrepancy between g2data/albums/ and what you see in G2:
one explanation could be that there was an error at the end of upload processing and that the database changes were rolled back.
did you see a success page when you clicked upload?
--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
Posts: 17
I will ignore that module then, thanks.
come to think of it, no, I don't remember a success page but could be mistaken. I was doing something else in another tab and noticed that "loading" on the tab was gone and it said "home gallery" which is my top level album. Like I mentioned the images uploaded to the album folder just not recognized.
Should I delete them with ftp and re-upload them? or is there a different way to go about re-uploading like overwrite?
thanks again,
matt
Posts: 17
I tried to upload a new photo in an existing album and got no success page. I was just taken back to the front page of the gallery (top level album). I also cannot rebuild thumbnails it hangs at 65 of 123 and never completes.
thanks,
matt
Posts: 32509
no success page -> that means something went very bad. an error can be assumed to have happened, which explains why the database transaction hasn't been committed.
which explains why you don't see the new files.
first, please remove the files in your g2data/albums/ folder that are not shown in your g2 web albums.
are there any errors in your php error log?
FAQ: What is the webserver error log?
if not, i suggest you enable "buffered" debug mode and try to add 1-2 files again.
FAQ: How to set/use Gallery in debug mode?
--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
Posts: 17
>first, please remove the files in your g2data/albums/ folder that are not shown in your g2 web albums.
does the method matter? Can I just ftp and delete the files? Should I remove the album as well?
webserver error:
[Mon Apr 16 14:29:49 2007] [error] [client 70.16.66.172] Premature end of script headers: /home/mainemil/public_html/photos/gallery2/main.php
I did edit the config.php file but where is the debug output? I cannot find it anywhere.
thanks again,
matt
Posts: 32509
since you can't delete items you don't see through g2's webinterface, you need to delete those files via FTP (or a web-ftp interface of your host's).
@debug output:
it should be printed to the browser. but it seems that the error occurs before it can print the output... doh.
switch to "logged" debug mode. see the explanations in config.php.
--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
Posts: 17
I deleted the files via ftp and turned on debug in logging mode and tried to re-upload one of the files. No go so here is the debug log:
http://mainemillers.com/temp/log.txt
it's long
matt
Posts: 32509
Thanks, that's very helpful.
It dies at:
> 2007-04-16 16:00:51 [85c027524498cb92fa92edfb50ab4634] GdToolkit::performOperation(image/jpeg,crop,/home/mainemil/public_html/photos/gallery2/g2data_2007/albums/misc/lenox/2-15-34.jpg,/home/mainemil/public_html/photos/gallery2/g2data_2007/cache/derivative/6/5/653.dat,0|16.97990926766|100|66.040181464679)
or in short: it dies at trying to generate a thumbnail for one of your images with the GD toolkit.
suggestion:
disable the gd module. try to activate either netpbm or imagemagick.
--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
Posts: 17
I tried to go to the get more plugins page and it sends me back to the top level album and never gets that page here is the logfile for that
http://mainemillers.com/temp/log2.txt
Is this install just hosed and I should delete and start over?
thanks,
matt
Posts: 32509
> I tried to go to the get more plugins page and it sends me back to the top level album and never gets that page here is the logfile for that
sounds like yet another php error. (probably a memory limit issue).
since you just got ~50 items in your g2 (that's what your database says), i'd recommend reinstalling g2. it's probably the fastest way to get it working again.
this time, don't install/activate the gd module.
--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
Posts: 17
Thank you for your help today. Is the memory limit something I control or are we talking RAM on the server?
matt
Posts: 32509
Usually, physical RAM isn't the issue. Your php's configuration file (php.ini) sets the memory_limit.
see:
FAQ: PHP memory_limit - Why do I get the error Allowed memory size of Xxx bytes exhausted?
--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
Posts: 17
I did set that to 64mb and that seemed to be fine. What could I have done to corrupt things? Is that easy to tell so I don't do it again?
matt
Posts: 32509
put a phpinfo file into your g2 folder to see if your php settings changes actually take effect.
--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
Posts: 17
they did and when uploading it showed max64MB on the upload page. I just trashed the whole install and will reinstall shortly once I download again.
Do you think it's safe to "reuse" the images and reload from the server? I moved them to another folder to eliminate the upload again.
matt
Posts: 32509
are you sure you aren't confusing the memory_limit with the post / upload limit?
filesize vs. memory size
--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
Posts: 17
yep, maybe I am confusing that.
matt
Posts: 32509
please put a phpinfo file into your g2 folder and link to it here.
you can find instructions for that here: FAQ: What information is required when I ask for help in the forums?
--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
Posts: 17
Ok, here is phpinfo:
http://photos.mainemillers.com/gallery2/phpinfo.php
I did a reinstall and there are no photos uploaded yet
and the "get more plugins" page isn't working.The only thing I have done to this install so far is deactivate gd and activate imagemagick.
I was trying to download the module to upload from server since all the images are still on the server in another folder.
matt
Posts: 32509
http://photos.mainemillers.com/gallery2/phpinfo.php
shows that your file upload limit is 2 MB. fils you upload must be smaller than 2 MB and you can't upload more than a total of 8MB at once (e.g. 4 files of 1.9 MB each).
@memory limit:
your php doesn't have a memory limit. but it's php-cgi and the per process limit might be low.
you'd have to check with your webhost to find about the per process / php memory limit (ulimit -a).
--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
Posts: 17
thanks for reminding me I upped the file size back to 64MB and will contact the admin about per process limits.
matt
Posts: 17
here is the info from support:
I am currently showing that our php does not have a limit. Here is the information pertaining to this:
core file size (blocks, -c) 1000000
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 4096
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 14335
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
I hope this helps. Please let us know if we can further assist you in this matter.
matt
Posts: 17
THANKS for all the help today!!! I think I have everything working now. One thing my wife mentioned was that I started to have trouble about the time I tried to password an album could that module have done the damage? I am also using imagemagick instead of gd.
matt