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.


Topics - hyde101

Pages: [1]
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 / 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

3
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.

4
I am already running a site with

4images/data/fullsize/####.jpg
4images/data/thumbs/####.jpg

so now I installed a clean 4images with

4images2/

directory.
I have already copied all the info from config.php and tried to change constants.php as well, but it didn't help.
DB works perfectly, all names, descriptions, user db, etc came over, but non of the images show up.

How can I fix this?

I tried to define the paths, but was not successful.

They are both on same server. just 4images and 4images2
Thank You.

5
I would like to add mandatory field for members.

I am running 1.7 and I have a lot of spams on my site, I believe they figured out a way to activate by robot and come back and post junk everywhere.
I cannot afford upgrade to 1.7.4 because of all the modifications I have done to my site.

All I need is a logical/mandatory field for Comments posting AND/OR registration.
I asked around how to add CAPTCHA to 1.7 but I was told it may not be possible. If it is possible I can just add captcha that would be great, if not I would like to add something like a random question that they would have to fill before commenting otherwise it would not accept it.

Thanks in advance.

6
Chit Chat / Mass e-mailer for 4images members
« on: September 26, 2005, 05:47:54 PM »
My host does not allow me to send more than 50 or 60 e-mails at a time.
I have over 1000 members on my 4images, and I want to give them updates on what is going on with the site.

Does anybody know of a free easy to use mailer that will allow sending out mails maybe 10 at a time , with 1 minute intervals or variable?

Please let me know.
Thank You

7
Discussion & Troubleshooting / Signature Colors and resolution problem
« on: September 15, 2005, 10:23:17 PM »
How come my signature:



cannot be displayed in full color? I try every setting, but when I use high quality background for my signature, it just doesn't look right, and as you can see some thumbs are also suffering from this problem.
 :cry:

What can I do about this?
If this is because of GD version, how can I find the GD version on the server?
Thanks

 :|

8
Mods & Plugins (Requests & Discussions) / Link / Toplist Database
« on: August 23, 2005, 10:29:17 PM »
Would it be possible to create a mod for a Link Database with options of:

1) Users submit their own webpages
2) It sorts the rank weekly  (up/down)
3) It shows click through
4) allows people to comment on the links


Even if non of the above options would be available, the simple and bare toplist/links database with Clickthrough number next to it would be enough.

Or maybe something similar to Gossamer Links? (I don't know why it costs so much!  :oops: )

Thanks.

9
Discussion & Troubleshooting / Copy Users to any other db
« on: March 18, 2005, 04:06:03 PM »
Hi,

I couldn't find this topic which was already going on for some time...

Since 4images holds users in db w/each having their own attributes, can we just copy their e-mail address & username, later import these to another table, with the e-mail & nicks, and finally run a small script to send them an e-mail which we previously created randomly to the same table?.

I guess v@no is the man to do it, but since I am not too good with this, I don't want to mess up anything. ;)  :oops:

maybe
select username from username_table
select email from username_table

boy, now I know I should have studied more when I took sql in college.. you never know when they can be handy..  :|

Pages: [1]