• [MOD] multiupload 5 0 5 1
Currently:  

Author Topic: [MOD] multiupload  (Read 298147 times)

0 Members and 1 Guest are viewing this topic.

Offline bensen

  • Pre-Newbie
  • Posts: 5
    • View Profile
Re: [MOD] multiupload
« Reply #165 on: October 05, 2007, 07:38:18 PM »
so ive installed multiupload and the mulitupload files (3th time). ive edited the mysql5-error-related files. ive checkt the chsmod 777 folders. ive

http://www.4homepages.de/forum/index.php?topic=10184.15 done!
http://www.4homepages.de/forum/index.php?topic=3958.0 done!

Code: [Select]
DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.user_name FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND i.cat_id = 1 AND c.cat_id = i.cat_id ORDER BY image_date DESC LIMIT 0, 9
Unknown column 'i.user_id' in 'on clause'

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/web14/web/gallery/includes/db_mysql.php on line 116

doesnt work! my webspace is OK. i was running wordpress, joomla and phpkit on it!
« Last Edit: October 05, 2007, 07:52:21 PM by bensen »

Offline thunderstrike

  • 4images Guru
  • *******
  • Posts: 2.327
    • View Profile
Re: [MOD] multiupload
« Reply #166 on: October 05, 2007, 08:53:36 PM »
Ok, here is special debug for you -

In includes/db_mysql.php file,

find:

Quote
function query($query = "") {

add after:

Code: [Select]
global $self_url, $action;

find:

Quote
$this->error("<b>Bad SQL Query</b>: ".htmlentities($query)."<br /><b>".mysql_error()."</b>");

add after:

Code: [Select]
$this->error(stripslashes($self_url . ((!empty($action)) ? "?action=" . $action : "")));

Save file - refresh page and you see source PHP file for error. Please post the file you see.
8 steps need when ask question -

- PHP version (ACP - > phpinfo())
- mySQL version (ACP - > phpinfo())
- 4images version
- Post screenshot / URL
- Post code in BB Code (no need full file for code) or post attach file
- It doesn't work. What is say - what is do for no work
- Install MOD ? If so - please say (troubleshooting)
- Read FAQ ? Install Bug fixes ?

Offline bensen

  • Pre-Newbie
  • Posts: 5
    • View Profile
Re: [MOD] multiupload
« Reply #167 on: October 05, 2007, 09:10:04 PM »
Code: [Select]
DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.user_name FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND i.cat_id = 1 AND c.cat_id = i.cat_id ORDER BY image_date DESC LIMIT 0, 9
Unknown column 'i.user_id' in 'on clause'

DB Error: categories.php?cat_id=1

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/web14/web/gallery/includes/db_mysql.php on line 118

Offline thunderstrike

  • 4images Guru
  • *******
  • Posts: 2.327
    • View Profile
Re: [MOD] multiupload
« Reply #168 on: October 05, 2007, 09:13:35 PM »
Quote
DB Error: categories.php?cat_id=1

Here. ;)

Now post attach of this file - I check.
8 steps need when ask question -

- PHP version (ACP - > phpinfo())
- mySQL version (ACP - > phpinfo())
- 4images version
- Post screenshot / URL
- Post code in BB Code (no need full file for code) or post attach file
- It doesn't work. What is say - what is do for no work
- Install MOD ? If so - please say (troubleshooting)
- Read FAQ ? Install Bug fixes ?

Offline bensen

  • Pre-Newbie
  • Posts: 5
    • View Profile
Re: [MOD] multiupload
« Reply #169 on: October 05, 2007, 09:16:43 PM »
thank you

Offline thunderstrike

  • 4images Guru
  • *******
  • Posts: 2.327
    • View Profile
Re: [MOD] multiupload
« Reply #170 on: October 05, 2007, 09:17:38 PM »
Problem is here -

Quote
FROM ".IMAGES_TABLE." i,  ".CATEGORIES_TABLE." c

replace with:

Code: [Select]
FROM (".IMAGES_TABLE." i,  ".CATEGORIES_TABLE." c)
8 steps need when ask question -

- PHP version (ACP - > phpinfo())
- mySQL version (ACP - > phpinfo())
- 4images version
- Post screenshot / URL
- Post code in BB Code (no need full file for code) or post attach file
- It doesn't work. What is say - what is do for no work
- Install MOD ? If so - please say (troubleshooting)
- Read FAQ ? Install Bug fixes ?

Offline bensen

  • Pre-Newbie
  • Posts: 5
    • View Profile
Re: [MOD] multiupload
« Reply #171 on: October 05, 2007, 09:20:42 PM »
great thank you 1000 times.

but its curious that there is an error :/

i automatically replaced all files with text editor strg + h

Offline thunderstrike

  • 4images Guru
  • *******
  • Posts: 2.327
    • View Profile
Re: [MOD] multiupload
« Reply #172 on: October 05, 2007, 09:21:38 PM »
Download original ZIP file from this site. You see ( ... ) in it. Error is yours.  8)
8 steps need when ask question -

- PHP version (ACP - > phpinfo())
- mySQL version (ACP - > phpinfo())
- 4images version
- Post screenshot / URL
- Post code in BB Code (no need full file for code) or post attach file
- It doesn't work. What is say - what is do for no work
- Install MOD ? If so - please say (troubleshooting)
- Read FAQ ? Install Bug fixes ?

Offline bensen

  • Pre-Newbie
  • Posts: 5
    • View Profile
Re: [MOD] multiupload
« Reply #173 on: October 05, 2007, 09:27:28 PM »
i also did! i installed the whole package 3 times. 2 times with original server files.

Offline thunderstrike

  • 4images Guru
  • *******
  • Posts: 2.327
    • View Profile
Re: [MOD] multiupload
« Reply #174 on: October 05, 2007, 09:30:57 PM »
When the download of ZIP ?
8 steps need when ask question -

- PHP version (ACP - > phpinfo())
- mySQL version (ACP - > phpinfo())
- 4images version
- Post screenshot / URL
- Post code in BB Code (no need full file for code) or post attach file
- It doesn't work. What is say - what is do for no work
- Install MOD ? If so - please say (troubleshooting)
- Read FAQ ? Install Bug fixes ?

Offline bensen

  • Pre-Newbie
  • Posts: 5
    • View Profile
Re: [MOD] multiupload
« Reply #175 on: October 05, 2007, 09:39:52 PM »
when creating a category in the acp!


Warning: ftp_mkdir() [function.ftp-mkdir]: ./../data/media/2: No such file or directory in /var/www/web14/web/gallery/admin/categories.php on line 96

Warning: ftp_mkdir() [function.ftp-mkdir]: ./../data/thumbnails/2: No such file or directory in /var/www/web14/web/gallery/admin/categories.php on line 96

Warning: Cannot modify header information - headers already sent by (output started at /var/www/web14/web/gallery/admin/categories.php:96) in /var/www/web14/web/gallery/includes/functions.php on line 114

Offline thunderstrike

  • 4images Guru
  • *******
  • Posts: 2.327
    • View Profile
Re: [MOD] multiupload
« Reply #176 on: October 05, 2007, 09:43:04 PM »
I no see function name: ftp_mkdir in admin/categories.php file and nothing to do with this MOD. Please create new topic in request & discussions if see new problems with 4images.
8 steps need when ask question -

- PHP version (ACP - > phpinfo())
- mySQL version (ACP - > phpinfo())
- 4images version
- Post screenshot / URL
- Post code in BB Code (no need full file for code) or post attach file
- It doesn't work. What is say - what is do for no work
- Install MOD ? If so - please say (troubleshooting)
- Read FAQ ? Install Bug fixes ?

Offline bensen

  • Pre-Newbie
  • Posts: 5
    • View Profile
Re: [MOD] multiupload
« Reply #177 on: October 05, 2007, 09:44:51 PM »
nothing to do with this mod? the error is caused of the install of this mod  :roll:

Offline thunderstrike

  • 4images Guru
  • *******
  • Posts: 2.327
    • View Profile
Re: [MOD] multiupload
« Reply #178 on: October 05, 2007, 09:46:06 PM »
Ah ! so now you say the source of error (step 6 - my signature).  :roll:

Ok, so again I no see ftp_mkdir in admin/categories.php file ... if you see ... please rename to: mkdir.
8 steps need when ask question -

- PHP version (ACP - > phpinfo())
- mySQL version (ACP - > phpinfo())
- 4images version
- Post screenshot / URL
- Post code in BB Code (no need full file for code) or post attach file
- It doesn't work. What is say - what is do for no work
- Install MOD ? If so - please say (troubleshooting)
- Read FAQ ? Install Bug fixes ?

Offline bensen

  • Pre-Newbie
  • Posts: 5
    • View Profile
Re: [MOD] multiupload
« Reply #179 on: October 05, 2007, 09:48:49 PM »
i dont know what u mean

/e

PHP Version 5.2.0-8+etch7

mysql Client API version    5.0.32

4images Version: 1.7.4