« previous next »
Pages: [1]

Author Topic: I have a bug : categorie  (Read 4611 times)

0 Members and 1 Guest are viewing this topic.

Offline satine88

  • Sr. Member
  • ****
  • Posts: 265
    • View Profile
I have a bug : categorie
« on: January 26, 2008, 05:25:50 PM »
Hello,
I have a bug:

Quote
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 (scriptwall_images i, scriptwall_categories c) LEFT JOIN scriptwall_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_name ASC, image_id ASC LIMIT 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 '' at line 6

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

http://www.wallpaper-gratuit.net/categories.php?cat_id=1
Thank you !
Logged

Offline thunderstrike

  • 4images Guru
  • *******
  • Posts: 2.327
    • View Profile
Re: I have a bug : categorie
« Reply #1 on: January 26, 2008, 05:35:18 PM »
Logged
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 satine88

  • Sr. Member
  • ****
  • Posts: 265
    • View Profile
Re: I have a bug : categorie
« Reply #2 on: January 26, 2008, 05:41:51 PM »
Thank you:)


I just made the change, but it does nothing.


 Thank you for your help
Logged

Offline thunderstrike

  • 4images Guru
  • *******
  • Posts: 2.327
    • View Profile
Re: I have a bug : categorie
« Reply #3 on: January 26, 2008, 05:54:27 PM »
- 4images version
- PHP version
- mySQL version
- MOD install ?

?

[Edit] - is possible for post block of categories.php file where is say:

Quote
ORDER BY image_name ASC, image_id ASC LIMIT 0

?

I search for this and no can find in ZIP file I download of 4images ...
Logged
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 satine88

  • Sr. Member
  • ****
  • Posts: 265
    • View Profile
Re: I have a bug : categorie
« Reply #4 on: January 26, 2008, 07:00:35 PM »
I have change :
Quote
ORDER BY image_name ASC, image_id ASC LIMIT 0

and, new error :

Quote
An unexpected error occured. Please try again later.

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

An unexpected error occured. Please try again later.

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

- 4images version : 4images 1.7.4
- PHP version : php5
- mySQL version : ?
- MOD install :
http://www.4homepages.de/forum/index.php?topic=7700.0
http://www.4homepages.de/forum/index.php?topic=17829.0

Thks
Logged

Offline satine88

  • Sr. Member
  • ****
  • Posts: 265
    • View Profile
Re: I have a bug : categorie
« Reply #5 on: January 26, 2008, 07:06:18 PM »
I have uplod categorie.php for the 4images1.7.4.rar ... and is good :)

Thks
Logged
Pages: [1]
« previous next »