Thread: Problem with Image Upload by a Group

hello experts,

i have a problem if i upload a image in a group.

use dolphin 6.0.2

you can see screenshot.
this mail i get

PHP Code:

Query:

                                            INSERT INTO `GroupsGallery` SET 
                                                `groupID` = 1,
                                                `ext`     = 'jpg',
                                                `width`   = ,
                                                `height`  = ,
                                                `width_`  = ,
                                                `height_` = ,
                                                `by`      = 1,
                                                `seed`    = 'b9d2025f1f'
                                            

Mysql error:
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 '
                                                `height`  = ,
                                                `width_`  = ,
                                                `height_` = ,
    ' at line 4

Found error in file /srv/www/web14/html/group_actions.php
at line 135. Called db_res function 
with erroneous argument #0

Debug backtrace:
Array
(
    [1] => Array
        (
            [file] => /srv/www/web14/html/group_actions.php
            [line] => 135
            [function] => db_res
            [args] => Array
                (
                    [0] => 
                                            INSERT INTO `GroupsGallery` SET 
                                                `groupID` = 1,
                                                `ext`     = 'jpg',
                                                `width`   = ,
                                                `height`  = ,
                                                `width_`  = ,
                                                `height_` = ,
                                                `by`      = 1,
                                                `seed`    = 'b9d2025f1f'
                                            
                )

        )

)


Called script: /group_actions.php

Request parameters:
Array
(
    [ID] => 1
    [a] => upload
    [do_submit] => Submit
    [sLanguage] => Deutsch
    [memberID] => 1
    [memberPassword] => ...


--
Auto-report system 


i hope anybody can help me.

sorry for my bad english!

greetz

shouldnt it look like this??

<snip>

$query = "

INSERT INTO `GroupsGallery` SET

`groupID` = $groupID,

`ext` = '$Ext',

`width` = $imgWidth,

`height` = $imgHeight,

`width_` = $imgWidth_,

`height_` = $imgHeight_,

`by` = $memberID,

`seed` = '$seed'

";

<snip>

hello this is my group_actions.php

line 123-135

PHP Code:

                                        $query = "
                                            INSERT INTO `GroupsGallery` SET
                                                `groupID` = $groupID,
                                                `ext`     = '$Ext',
                                                `width`   = $imgWidth,
                                                `height`  = $imgHeight,
                                                `width_`  = $imgWidth_,
                                                `height_` = $imgHeight_,
                                                `by`      = $memberID,
                                                `seed`    = '$seed'
                                            ";

                                        db_res( $query ); 


Quick Fix :

PHP Code:

                             $query = "
                                            INSERT INTO `GroupsGallery` SET
                                                `groupID` = $groupID,
                                                `ext`     = '$Ext',
                                                `width`   = '$imgWidth',
                                                `height`  = '$imgHeight',
                                                `width_`  = '$imgWidth_',
                                                `height_` = '$imgHeight_',
                                                `by`      = '$memberID',
                                                `seed`    = '$seed'
                                            ";

                                        db_res( $query ); 


cool three guys have the exact same thing so hopefully yours is fixed now

hello,

i have edit as mark says.

after this i can upload a image but i dont show see image and this info i get...

PHP Code:

Warning: tempnam(): open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/srv/www/web14/:/srv/www/htdocs/phpMyAdmin/:/srv/www/htdocs/confixx/html/gesperrt/) in /srv/www/web14/html/group_actions.php on line 88

Warning: move_uploaded_file(): Unable to move '/srv/www/web14/phptmp/phphLc1SH' to '' in /srv/www/web14/html/group_actions.php on line 90

Warning: getimagesize(_): failed to open stream: No such file or directory in /srv/www/web14/html/group_actions.php on line 112

Warning: rename(,/srv/www/web14/html/groups/gallery/1_2_d6a617c4e0.jpg): No such file or directory in /srv/www/web14/html/group_actions.php on line 139

Warning: rename(_,/srv/www/web14/html/groups/gallery/1_2_d6a617c4e0_.jpg): No such file or directory in /srv/www/web14/html/group_actions.php on line 140

Warning: chmod(): No such file or directory in /srv/www/web14/html/group_actions.php on line 142

Warning: chmod(): No such file or directory in /srv/www/web14/html/group_actions.php on line 143 


after i delete a image i get...

PHP Code:

Warning: unlink(/srv/www/web14/html/groups/gallery/1_3_2ab50add24_.jpg): No such file or directory in /srv/www/web14/html/inc/groups.inc.php on line 721

Warning: unlink(/srv/www/web14/html/groups/gallery/1_3_2ab50add24.jpg): No such file or directory in /srv/www/web14/html/inc/groups.inc.php on line 722

Warning: Cannot modify header information - headers already sent by (output started at /srv/www/web14/html/inc/groups.inc.php:721) in /srv/www/web14/html/group_actions.php on line 285 


This is where the error started :

Warning: tempnam(): open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/srv/www/web14/:/srv/www/htdocs/phpMyAdmin/:/srv/www/htdocs/confixx/html/gesperrt/) in /srv/www/web14/html/group_actions.php on line 88

To fix that first :

IN file group_actions.php

look for this :

PHP Code:

$tempImg = tempnam( '/tmp', 'Dol_' ); 


Replace it with :

PHP Code:

$tempImg = tempnam( $site['tmp'], 'Dol_' ); 


did that do it real?

hello,

i have change the code but i have the same problem...

goodness what does your database look like? the errors say theres nowhere to put the pics.

PHP Code:

CREATE TABLE `Groups` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `categID` int(10) unsigned NOT NULL default '0',
  `Name` varchar(64) NOT NULL default '',
  `open_join` tinyint(1) NOT NULL default '0',
  `hidden_group` tinyint(1) NOT NULL default '0',
  `members_post_images` tinyint(1) NOT NULL default '0',
  `members_invite` tinyint(1) NOT NULL default '0',
  `Country` varchar(2) NOT NULL default '',
  `City` varchar(64) NOT NULL default '',
  `About` varchar(255) NOT NULL default '',
  `Desc` text NOT NULL,
  `thumb` int(10) unsigned NOT NULL default '0',
  `creatorID` int(10) unsigned NOT NULL default '0',
  `created` date NOT NULL default '0000-00-00',
  `status` enum('Active','Suspended') NOT NULL default 'Active',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; 


maybe table is corrupt reload this baby and checker out