1
4images Forum & Community
The forum for all 4images gallery administrators
News:
Check the new Tutorial subforum with helpfull guides and tutorials for modifications and tweaks.
Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
2
Discussion & Troubleshooting / Re: Error message : DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id,....
« on: April 08, 2007, 12:05:04 PM »use this
http://www.4homepages.de/forum/index.php?topic=10184.msg53697#msg53697
or upgrade your version of 1.7.4
greets ivan
Solution provided there worked like a charm !
Thx a lot Ivan !
3
Discussion & Troubleshooting / Error message : DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id,....
« on: March 04, 2007, 07:00:11 PM »
Hello,
"suddenly", i got this error message on top of my website :
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 NOT IN (0) AND c.cat_id = i.cat_id ORDER BY i.image_rating DESC LIMIT 1
Unknown column 'i.user_id' in 'on clause'
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 c.cat_id = i.cat_id AND i.cat_id IN (0, 6, 4, 3, 2, 16, 7, 14, 19, 9, 24, 12, 10, 18, 20) ORDER BY i.image_date DESC LIMIT 4
Unknown column 'i.user_id' in 'on clause'
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/****/public_html/includes/db_mysql.php on line 116
--------------------------------------------------------------------------------------------------------------------------------------------------
I still can see the pages, but they load very slow and some functions don't work anymore.
Someone who understands this error message, and has a hint what to do to solve it ??
Thx a lot !!
"suddenly", i got this error message on top of my website :
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 NOT IN (0) AND c.cat_id = i.cat_id ORDER BY i.image_rating DESC LIMIT 1
Unknown column 'i.user_id' in 'on clause'
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 c.cat_id = i.cat_id AND i.cat_id IN (0, 6, 4, 3, 2, 16, 7, 14, 19, 9, 24, 12, 10, 18, 20) ORDER BY i.image_date DESC LIMIT 4
Unknown column 'i.user_id' in 'on clause'
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/****/public_html/includes/db_mysql.php on line 116
--------------------------------------------------------------------------------------------------------------------------------------------------
I still can see the pages, but they load very slow and some functions don't work anymore.
Someone who understands this error message, and has a hint what to do to solve it ??
Thx a lot !!
4
Discussion & Troubleshooting / only possible to download once
« on: September 27, 2006, 08:26:00 PM »
Hello,
On my site it is possible to download a picture only once.
If i try to download it a second time, i get redirected to the homepage.
If i leave the page, and enter it again, i can download the picture again ( once ).
Is this some side-effect from a mod ?
I have no idea...
Thx
On my site it is possible to download a picture only once.
If i try to download it a second time, i get redirected to the homepage.
If i leave the page, and enter it again, i can download the picture again ( once ).
Is this some side-effect from a mod ?
I have no idea...
Thx
5
Templates & Styles (Requests & Discussions) / Re: pictures in landscape style and portrait style
« on: September 27, 2006, 06:40:51 AM »
do i put this in jpg.html ?
because if i do so, i get a blank details.html page.
because if i do so, i get a blank details.html page.
6
Templates & Styles (Requests & Discussions) / Re: pictures in landscape style and portrait style
« on: September 26, 2006, 08:23:54 PM »
all my pics have the same proportions
some widht="610" height="875"
some widht="875" height="610"
i don't want to show them real size (=too big) on screen.
i want to show them 1/2 their size
so
width="310" height="437"
or
width="437" height="310"
if i use {width_height}, i see the real proportions, and that's too big.
Is there a solution for this ?
thx a lot.
some widht="610" height="875"
some widht="875" height="610"
i don't want to show them real size (=too big) on screen.
i want to show them 1/2 their size
so
width="310" height="437"
or
width="437" height="310"
if i use {width_height}, i see the real proportions, and that's too big.
Is there a solution for this ?
thx a lot.
7
Templates & Styles (Requests & Discussions) / pictures in landscape style and portrait style
« on: September 25, 2006, 05:24:53 PM »
Hello,
in default, all pictures in my site are shown in portrait-style ( vertical).
This is de code in the jpg.html file that makes they are shown that way :
<!-- Template file for JPG Files -->
<img src="{media_src}" border="0" title="{image_name}" alt="{image_name}" width="310" height="437" />
<br>
but how can i show my pixtures that are made in "landscape-style", horizontal ?
the code for these pics should be like
<img src="{media_src}" border="0" title="{image_name}" alt="{image_name}" width="437" height="310" />
Thx for any Help.
in default, all pictures in my site are shown in portrait-style ( vertical).
This is de code in the jpg.html file that makes they are shown that way :
<!-- Template file for JPG Files -->
<img src="{media_src}" border="0" title="{image_name}" alt="{image_name}" width="310" height="437" />
<br>
but how can i show my pixtures that are made in "landscape-style", horizontal ?
the code for these pics should be like
<img src="{media_src}" border="0" title="{image_name}" alt="{image_name}" width="437" height="310" />
Thx for any Help.
8
Discussion & Troubleshooting / Re: Will 4images 1.7.1 work on MySQL 4.1.15 ???
« on: September 19, 2006, 08:04:05 PM »
my server will be upgraded from php 4.4.1 to 4.4.4.
Should i be worried ?
Should i be worried ?
9
Chit Chat / Re: Website hacked
« on: September 03, 2006, 09:31:04 AM »
Problem was that i was running an old, outdated, and insecure version of cPanel (WHM) on my server.
They gained access to my account through it.
Cpanel updated and problem solved.
They gained access to my account through it.
Cpanel updated and problem solved.
10
Chit Chat / Website hacked
« on: September 02, 2006, 04:57:28 PM »
Hello,
my site www.schoolplaten.com was hacked today
Someone had any idea how to solve this ??
all security patches were installed.
my site www.schoolplaten.com was hacked today
Someone had any idea how to solve this ??
all security patches were installed.
11
Mods & Plugins (Releases & Support) / Re: [MOD] Contact Form
« on: May 28, 2006, 09:46:09 AM »
Open and change all your lang/xxxxxx/main.php
add this:Code: [Select]$lang['secure_required'] = "You copied the secure code wrong.";
$lang['comment_secure_pleasecopy'] = "(Please copy!)";
$lang['comment_secure_scode'] = "Secure Code";
before ?>
Open contact.php
find:Code: [Select]if ($action == "") {
$action = "mailform";
}
add after:Code: [Select]/* ## Safety script ## */
mt_srand((double)microtime()*1000000);
$comment_sicherheit = mt_rand(000001,999999);
$comment_sicherheit = str_replace('=', '´|´', base64_encode(base64_encode($comment_sicherheit)));
/* ## Safety script ## */
find:Code: [Select]// if(!$error && $sender_email != "" && MailChek($sender_email, 2)) {
// $msg .= (($msg != "") ? "<br />" : "").$lang['invalid_email_format'];
// $sendprocess = 1;
// $error = 1;
// }
add after:Code: [Select]if (($sicherheit_code == "") || ($sicherheit_code != str_replace('´|´', '=', base64_decode(base64_decode($sicherheit_dec))) )) {
$msg .= (($msg != "") ? "<br />" : "").$lang['secure_required'];
$error = 1;
}
find:Code: [Select]"sender_email" => $sender_email,
add after:Code: [Select]"comment_sicherheit" => $comment_sicherheit,
"comment_secure_scode" => $lang['comment_secure_scode'],
"comment_secure_pleasecopy" => $lang['comment_secure_pleasecopy'],
Open templates/xxxxxxxx/contact_mailform.html
find:Code: [Select]<tr>
<td align="right" valign="top"><b>{lang_message}</b></td>
<td align="left" valign="top"><textarea name="message" cols="60" rows="10" wrap="VIRTUAL" id="message" tabindex="4">{message}</textarea>
</td>
</tr>
add after:Code: [Select]<tr>
<td width="90" valign="top"><b>{comment_secure_scode}</b><br />{comment_secure_pleasecopy}</td>
<td><input type="text" name="sicherheit_code" size="15" class="commentinput" /> <img src="sicherheit.php?z={comment_sicherheit}" alt="{comment_secure_scode}" title="{comment_secure_pleasecopy}" /></td>
</tr>
find:Code: [Select]<input type="hidden" name="user_id" value="{user_id}" />
add after:Code: [Select]<input type="hidden" name="sicherheit_dec" value="{comment_sicherheit}" />
Hello,
i did all these steps, and it all seems fine on the contact.php page, but if i send a message, i always get the message the security code i entered was wrong.....
12
Plugins / Re: [Plugin] Import images from external webspace (Beta)
« on: May 27, 2006, 10:00:36 AM »
i got it to work !
great mod
my settings were not correct
in my case :
ext. FTP-Pfad der Bilder is /public_html/picturedirectory
ext. HTTP-Pfad der Bilder is /picturedirectory
Note : i think there may be a security problem with this mod :
in import_webimages_config.inc , you put the ftp address, username and password of the external site where images are hosted.
However, if a user tries to browse an INC file directly, its content will be displayed.
So if the included file contains confidential information or information you do not want any users to see, it is better to use an .php extension.
i called mine : import_webimages_config.inc.php
great mod
my settings were not correct
in my case :
ext. FTP-Pfad der Bilder is /public_html/picturedirectory
ext. HTTP-Pfad der Bilder is /picturedirectory
Note : i think there may be a security problem with this mod :
in import_webimages_config.inc , you put the ftp address, username and password of the external site where images are hosted.
However, if a user tries to browse an INC file directly, its content will be displayed.
So if the included file contains confidential information or information you do not want any users to see, it is better to use an .php extension.
i called mine : import_webimages_config.inc.php
13
Templates & Styles (Releases & Support) / Re: [Template] Next generation template "Wallpaper" + PSD source for Free Download!
« on: May 23, 2006, 09:44:26 PM »
it worked ( description tag )
Thx Maxpaul !!
Thx Maxpaul !!
14
Templates & Styles (Releases & Support) / Re: [Template] Next generation template "Wallpaper" + PSD source for Free Download!
« on: May 22, 2006, 06:09:55 PM »
Hey Maxpaul, really great template !
Can you tell me how you did the addition of dynamic <meta tags> ?
( especially dynamic keywords -> <meta name="keywords"....)
Thx
Can you tell me how you did the addition of dynamic <meta tags> ?
( especially dynamic keywords -> <meta name="keywords"....)
Thx
15
Mods & Plugins (Requests & Discussions) / add picture to multiple categories
« on: May 18, 2006, 07:10:59 PM »
Hello,
when you upload pictures trough acp, you can choose the category the picture has to belong to.
Problem is somethimes pictures can belong to more than one categories.
So picture A can belong to category B, C and D, at the same time.
Is there a way to fix this ? to choose diffrent categories for the same picture ?
I know you can copy pics to other categories, but that is also to 1 category at once, and quite time-consuming.
Thx for any help.
when you upload pictures trough acp, you can choose the category the picture has to belong to.
Problem is somethimes pictures can belong to more than one categories.
So picture A can belong to category B, C and D, at the same time.
Is there a way to fix this ? to choose diffrent categories for the same picture ?
I know you can copy pics to other categories, but that is also to 1 category at once, and quite time-consuming.
Thx for any help.