XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Modules Support forums / 
  3. Module usage questions 
  4.  / uploading photos error with myalbum-p
Register
11
tom
Re: Config Check

  • 2004/1/22 19:35

  • tom

  • Friend of XOOPS

  • Posts: 1359

  • Since: 2002/9/21


ok below is mine, all seems fine except for the 644DB error: UPDATE photo table when uploading.

I know I'm prob missing something really simple, but I just can't get it to work pmsl

Environment Check
PHP directive 'safe_mode' (both ok): off
PHP directive 'file_uploads' (need on): on
PHP directive 'register_globals' (both ok): on
PHP directive 'upload_max_filesize': 20M byte
PHP directive 'post_max_size': 8M byte
PHP directive 'open_basedir': nothing
PHP directive 'upload_tmp_dir': ok
Table Check
Photos table: ghu_myalbum_photos ok
Number of Photos: 376

Descriptions table: ghu_myalbum_text ok
Number of Descriptions: 376

Categories table: ghu_myalbum_cat ok
Number of Categories: 7

Votedata table: ghu_myalbum_votedata ok
Number of Votedata: 157

Comments table: ghu_xoopscomments ok
Number of Comments: 1068

Config Check
Pipe for images: GD
Check 'GD2' work correctly under your GD bundled with PHP
If the page linked from here don't display correctly, you should give up working your GD as truecolor mode.

Directory for Photos: /homepages/156/d745fd874/htdocs/ghu/modules/myalbum/photos ok

Photos & Thumbs Link Check
Now, checking .....................................ok
12
GIJOE
Re: Batch

  • 2004/1/22 20:53

  • GIJOE

  • Quite a regular

  • Posts: 265

  • Since: 2003/8/13


Quote:

damon wrote:
I was using /var/www/html/... rahter than /home/virtual/site12/fst/var/www/html/tmp.

It is hard to type certainly.
I'll implement the codes trying ~/(path) if abosolute path is failed.

Quote:

Any thoughts of changing code to allow the filename to be added to the path so that individual images already on server can be added, with their own title and description? This would be easier than uploading a bunch and then going back and editing each one. I haven't spent a ton of time looking at the functionality, so it may be there already, in another place.

What you say is justified.
But I won't add big feature as myAlbum-P any more.
If I make another photo album module,
I'll implement such features in the module.
13
GIJOE
Re: Config Check

  • 2004/1/22 21:08

  • GIJOE

  • Quite a regular

  • Posts: 265

  • Since: 2003/8/13


Quote:

tom wrote:
ok below is mine, all seems fine except for the 644DB error: UPDATE photo table when uploading.

Hmmm...
It looks strange.
I don't know the codes like output '644'.

Any way try this code and tell me the result.
line 138 in submit.php
$xoopsDB->query( "UPDATE $table_photos SET res_x={$dim[0]}, res_y={$dim[1]} WHERE lid=$newid") or die( "DB error: UPDATE photo table[color=ff0000] {$dim[0]}:{$dim[1]}:{$newid}:{$table_photos}[/color]" ) ;

14
tom
Re: Config Check

  • 2004/1/22 23:11

  • tom

  • Friend of XOOPS

  • Posts: 1359

  • Since: 2002/9/21


I tried as you suggested and got a slightly different error:

644DB error: UPDATE photo table ::1:xoopstable_myalbum_photos

I tried the module on another site (Test site) and it works fine, now both are on the same server, but different DB's.

Not sure why this is happening.
15
tom
Re: Config Check

  • 2004/1/23 0:20

  • tom

  • Friend of XOOPS

  • Posts: 1359

  • Since: 2002/9/21


As I mentioned above, I have it working on one site within the same server.

Now although the error the occurs it still uploads something to the server, but it is auto CHMOD with 204, I don't know this is happening, but as I said it only does it on one site.

Can I just double check, what versions of XOOPS will this work with?
16
tom
Re: Config Check

  • 2004/1/23 0:25

  • tom

  • Friend of XOOPS

  • Posts: 1359

  • Since: 2002/9/21


with php debug on I get the following error/warning when submitting as well as the one I detailed above:

Warning: getimagesize: Unable to open '/homepages/45/d76774874/htdocs/ghosts-uk/modules/myalbum/photos/16.jpg' for reading. in /homepages/45/d76774874/htdocs/ghosts-uk/modules/myalbum/submit.php on line 137

CHMODs are correct on the directories.
17
GIJOE
Re: Config Check

  • 2004/1/23 2:08

  • GIJOE

  • Quite a regular

  • Posts: 265

  • Since: 2003/8/13


hi tom.
Quote:

I tried as you suggested and got a slightly different error:
644DB error: UPDATE photo table ::1:xoopstable_myalbum_photos

The result of the experiment has an important factor.
Perhaps your DB has reset autoincrement field though you had 376 photos already.

try this code:
line 103 in submit.php
$cid = isset( $_POST['cid'] ) ? $_POST['cid'] : 0 ;
    [d]$newid = $xoopsDB->genId( $table_photos."_lid_seq" ) ;[/d][color=ff0000]
    $rs = $xoopsDB->query( "SELECT MAX(lid) FROM $table_photos" ) ;
    list( $newid ) = $xoopsDB->fetchRow( $rs ) ;

[/color]    // Check if upload file name specified


Probably the version of GD is not the matter.
18
tom
Re: Config Check

  • 2004/1/23 21:23

  • tom

  • Friend of XOOPS

  • Posts: 1359

  • Since: 2002/9/21


I edited the code as you said and still get the '644DB error: INSERT photo table'

This is a little weird, this includes me updating the module, uninstalling and re-installing.

Thanks for all this help it is much appreciated.
19
tom
Re: Config Check

  • 2004/1/26 18:50

  • tom

  • Friend of XOOPS

  • Posts: 1359

  • Since: 2002/9/21


just woundering if you can offer any more help, thanks for all the help you've offered so far.
20
damon
Re: Config Check

  • 2004/1/29 13:09

  • damon

  • Just popping in

  • Posts: 11

  • Since: 2004/1/15


Any thought on why I still can't upload pictures with the interface?

damon
« 1 (2) 3 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

118 user(s) are online (81 user(s) are browsing Support Forums)

Members: 0

Guests: 118

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits