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.


Messages - hyde101

Pages: [1] 2 3 4 5 ... 8
1
What kind of information does sessionvars hold in database?
What would I lose if I emptied it?

Additionally, I just got a warning from my host:

your account has been flagged up by the administrators for taking up too many resources on the database server. Please note that being on a shared hosting platform the database server resources are shared amongst other users. There has been a performance drop on the server due to the resources that are been taken up by your database.

sql_by_user 4images db3920000 418229 110729TT4:01:43 7/21 DELETE
FROM 4images_sessionvars   WHERE session_id NOT IN ('0b47a44b3c0e2f4
e0e6401a5afee2f36', 'c4a224debb9f42877c8ddb3f7d57f421',
...
..
.
.

2
Discussion & Troubleshooting / Re: Suddenly started getting DB errors
« on: July 25, 2011, 10:09:46 PM »
Thanks, but I have so many modifications, it just is not feasible, unless I go with a plain version.
This is the reason why I could not upgrade in the first place. I would have to modify so many files and I did not keep track of most of them. I tried before with a copy of my existing install, everything is all over the place.

3
Discussion & Troubleshooting / Re: Suddenly started getting DB errors
« on: July 25, 2011, 10:03:48 PM »
Thank you very much, there were so many lines of errors, I didn't know where to begin.

4
Discussion & Troubleshooting / Suddenly started getting DB errors
« on: July 25, 2011, 09:34:38 PM »
Please take a look at my site. Recently 1and1 deleted my database, and they are claiming I deleted it but they cannot show any proof when or by which IP it was deleted.
Anyway, I restored an earlier version I had from last year, but I had not done any changes to the site during last 3 years anyway, but the site won't take it.

www.34tr.com

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 c.cat_id = i.cat_id AND i.cat_id IN (0, 68, 1, 32, 23, 15, 8, 29, 24, 33, 30, 17, 16, 9, 40, 67, 5, 13, 38, 26, 54, 3, 65, 2, 52, 34, 53, 43, 14, 55, 7, 46, 57, 50, 10, 6, 51, 56, 42, 60, 11, 44, 61, 48, 62, 28, 4, 47, 12, 27, 39, 41, 45, 49, 58, 59, 63, 64, 66) ORDER BY i.image_votes DESC, i.image_rating DESC
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, 68, 1, 32, 23, 15, 8, 29, 24, 33, 30, 17, 16, 9, 40, 67, 5, 13, 38, 26, 54, 3, 65, 2, 52, 34, 53, 43, 14, 55, 7, 46, 57, 50, 10, 6, 51, 56, 42, 60, 11, 44, 61, 48, 62, 28, 4, 47, 12, 27, 39, 41, 45, 49, 58, 59, 63, 64, 66) ORDER BY i.image_hits DESC, i.image_hits ASC
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, 68, 1, 32, 23, 15, 8, 29, 24, 33, 30, 17, 16, 9, 40, 67, 5, 13, 38, 26, 54, 3, 65, 2, 52, 34, 53, 43, 14, 55, 7, 46, 57, 50, 10, 6, 51, 56, 42, 60, 11, 44, 61, 48, 62, 28, 4, 47, 12, 27, 39, 41, 45, 49, 58, 59, 63, 64, 66) ORDER BY i.image_comments DESC, i.image_comments ASC
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, 68, 1, 32, 23, 15, 8, 29, 24, 33, 30, 17, 16, 9, 40, 67, 5, 13, 38, 26, 54, 3, 65, 2, 52, 34, 53, 43, 14, 55, 7, 46, 57, 50, 10, 6, 51, 56, 42, 60, 11, 44, 61, 48, 62, 28, 4, 47, 12, 27, 39, 41, 45, 49, 58, 59, 63, 64, 66) ORDER BY i.image_downloads DESC, i.image_downloads ASC
Unknown column 'i.user_id' in 'on clause'

DB Error: Bad SQL Query: SELECT DISTINCT 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 RAND()
Unknown column 'i.user_id' in 'on clause'

DB Error: Bad SQL Query: SELECT IF(i.image_date >= 1310758246,RAND()+1,1) as random_no, 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, 68, 1, 32, 23, 15, 8, 29, 24, 33, 30, 17, 16, 9, 40, 67, 5, 13, 38, 26, 54, 3, 65, 2, 52, 34, 53, 43, 14, 55, 7, 46, 57, 50, 10, 6, 51, 56, 42, 60, 11, 44, 61, 48, 62, 28, 4, 47, 12, 27, 39, 41, 45, 49, 58, 59, 63, 64, 66) ORDER BY random_no DESC, i.image_date DESC LIMIT 3
Unknown column 'i.user_id' in 'on clause'

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /xxxx/7/xxxxxxxxx/htdocs/4images/includes/db_mysql.php on line 116

5
I already edited the config.php to match the previous database (points to same database), yes, it works now. :)
Although it is a good idea to point /templates to the default one because it gets messed up easily.

6
I have a similar question, (wow this topic is old, but to the point!)
I have two 4images in the same host, just under different directories. Is there anyway to tell 4images to go up one folder and grab media from another folder?

I have
webspace/4images/data/media/
and
webspace/4imagesNEW/data/media/

Is there anyway to get data from a root or parent directory? Something like

define('MEDIA_DIR', '../4imagesNEW/data/media');

I just want to move my data to the new installation while retaining the old one so I can keep working on the original one.

7
Discussion & Troubleshooting / Re: Mass Email Error
« on: June 18, 2007, 10:57:06 PM »
v@no, I have 5000 users, and when I select over 50 or 60 users at one time I am having problems with E-mail.
I think it could be that my Hosting Company (1and1) disabled so many e-mail requests at one time. So it must be done at portion by portion. It will take forever to send them all as it already takes long to do 50 users.

Is there any program that any one of you know, with an option to load e-mail addresses and it can send 1 by 1 to the receipient list. Like mass mailer or something like that, by using my Database of members who selected to recive e-mails from admins.

I wanna send some news to the members, but i cannot. I haven't been able to for a very long time. :(

8
Español / Castellano / Re: [MOD] Integrar Google VIDEO y YouTube
« on: June 15, 2007, 04:42:17 PM »
Youtube works perfectly well! However google video doesn't. :(

9
how do you use a different player?

10
Discussion & Troubleshooting / Re: want to password protect gallery
« on: June 15, 2007, 05:26:42 AM »
I want to give someone just a password to access into a certain category. Similar to Gallery 2.
Is that possible? I don't want them to go through the trouble of registering or logging in. Can we just protect a certain directory with a password.

I know I can just tell them to login using a certain user and password but people generally have hard time remembering both.

11
it's gotta be easy, you can probably change the way it retrieves images, instead it can retrieve and display text.
Instead of taking <img> it can do php include <name of the article.php> something like that.
All those articles could be stored in db instead of images, but, to be honest, I think you should look for a different script for that. I think any forum software that allows ratings would be your best bet. You just have to modify the template and take out the unnecessary parts.

Good luck

12
Mods & Plugins (Releases & Support) / Re: Signature image v2.22
« on: June 11, 2007, 12:13:40 AM »
Thank You, but that only does work on some images, and not on others, not sure why :(

13
Hi,

I was wondering how could I add multiple ratings for each picture?
For example

Colors: 1-5
Scene: 1-5
Quality: 1-5
Originality: 1-5
etc..
etc..

I would like to be able to change the number of rating categories there are, in case I need to add something else or remove one that's not needed.

I assume the way it could be done is add new db fields for each images that links to the rating, and just add them in the template to the bottom of the picture.
I would appreciate any help.

14
Mods & Plugins (Releases & Support) / Re: Signature image v2.22
« on: June 10, 2007, 07:47:47 PM »
How can we resize the random thumb on the signature. I looked for the line in the php where I could specify the thumb size, i couldn't find it :(

15
Fixed:
I defined them as:

// Data paths
define('MEDIA_DIR', '../4images/data/FULLS');
define('THUMB_DIR', '../4images/data/THUMBS');
define('MEDIA_TEMP_DIR', '../4images/data/tmp_media');
define('THUMB_TEMP_DIR', '../4images/data/tmp_thumbnails');
define('DATABASE_DIR', '../4images/data/database');
define('TEMPLATE_DIR', 'templates');

and at the top i defined the URL

define('SCRIPT_URL', 'http://MY SERVER/4images2'); //no trailing slash

it worked.
:)

Pages: [1] 2 3 4 5 ... 8