An unexpected error occured. Please try again later

[sandramichelle]

Hello,

I'm having the same error message and cannot decipher it.

I followed the instructions in the first post and received this:


An unexpected error occured. Please try again later.

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, 18, 21, 22, 29, 41, 23, 28, 30, 24, 31, 36, 17, 25, 32, 37, 19, 26, 33, 38, 20, 27, 34, 39, 35, 40), 37) AND c.cat_id = i.cat_id
            LIMIT 256, 1
Operand should contain 1 column(s)

I do not know where to go from here and would be SO grateful for some help on how to make the error message disappear.  Thank you!

[Rembrandt]

Welcom to the Forum!

  WHERE i.image_active = 1 AND i.cat_id NOT IN ((0, 18, 21, 22, 29, 41, 23, 28, 30, 24, 31, 36, 17, 25, 32, 37, 19, 26, 33, 38, 20, 27, 34, 39, 35, 40), 37) ...

i think the error come from  "40), 37)"

mfg Andi

[sandramichelle]

Thank you very much for your quick reply!

How do I go about fixing that?  I'm very much a novice at this, so any directions would be very much appreciated.

[Rembrandt]

post the corrupt sql query here.

[sandramichelle]

is this what you mean?


An unexpected error occured. Please try again later.

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, 18, 21, 22, 29, 41, 23, 28, 30, 24, 31, 36, 17, 25, 32, 37, 19, 26, 33, 38, 20, 27, 34, 39, 35, 40), 37) AND c.cat_id = i.cat_id
            LIMIT 256, 1
Operand should contain 1 column(s)

[Rembrandt]

i mean the php code

[sandramichelle]

I'm so sorry... I wasn't lying when I said I am REALLY a novice at this. LOL
I can paste the .php code here.  From which file?  There appear to be several.   

[Rembrandt]

you have made a modification?
 make them undo

[sandramichelle]

i haven't modified anything.  the error code was already there.

[V@no]

Ok, then let me ask you this:
1) Did you just install the gallery and that error showed right the way? - I doubt it.
2) Where (what page) exactly this error shows?
3) What did you do before the error started showing?

[sandramichelle]

Hi V@no.  Thanks for trying to help me.

1.  I had the previous version of 4images installed and did not have the error message.  I upgraded to the most current version and then I noticed the error message.  The only things I did in between were add some categories and upload images.  I did not change anything within the coding, itself.  I ended up uninstalling and reinstalling the gallery from scratch into a new database.  The error message returned.

2.  This error shows on every page if the user is NOT logged in.  It disappears if the person is registered and logged in.  But I would like people to be able to view certain categories without needing to be a registered user.

3.  See #1.

Thank you!

[V@no]

I suspect the error comes from random image code. To confirm/deny that, try to disable random image via includes/constants.php:
define('SHOW_RANDOM_IMAGE', 0);
define('SHOW_RANDOM_CAT_IMAGE', 0);
(these two lines are already there, change 1 to 0

If error is gone, then show block of code from includes/functions.php between
function get_random_image_cache() {
and
function format_file_size($file_size = 0) {

[sandramichelle]

V@no, you were right.  I spoke to the other person with admin rights who tried to make a category invisible from random image by modifying the functions.php file.  I did not know she had done this.  I just restored it with the original file and the error message went away.  Thank you very much!

Now I need to go find a way to make a category invisible... because what she did, did not work.

I really appreciate all of the help!

[V@no]

in global.php find:
  $cat_id_sql = get_auth_cat_sql("auth_viewcat", "NOTIN");

Replace it with:
  $cat_id_sql = get_auth_cat_sql("auth_viewcat", "NOTIN") . ",37";

(assuming the category ID you are trying to hide is 37)

[sandramichelle]

Thanks, V@no!  Everything is working perfectly.  You guys are great!