An unexpected error occured. Please try again later

[V@no]

This error shows when something went wrong in database querying.

Normally such error shows for non-admin members and guests, so if that is the case, try login as admin and see if any details about the error revealed.

If login is not possible or no error shows for admin, you can do the following:

in includes/db_mysql.php find:

        echo "<br /><font color='#FF0000'><b>An unexpected error occured. Please try again later.</b></font><br />";

Replace it with:
        echo "<br /><span onclick=\"if(event.altKey)this.getElementsByTagName('SPAN')[0].style.display='block';\"><font color='#FF0000'><b>An unexpected error occured. Please try again later.</b></font><span style=\"display:none;\"><pre style=\"border:1px solid black;padding:3px;\">".$errmsg."</pre></span></span><br />";


Now when such error shows, press and hold ALT key and click on the red message, it should show you more detailed message.
Or you can highlight the error message, copy it into clipboard and then paste into a text editor.

Once the problem was solved I would recommend you remove these changes, because the detailed error message could possible be used to hack your site.

[EDIT]
If you receive that error during 4images installation process, then find:
      if (isset($user_info['user_level']) && $user_info['user_level'] == ADMIN){

Replace it with:
      if (!defined("4IMAGES_ACTIVE") || (isset($user_info['user_level']) && $user_info['user_level'] == ADMIN)){

[Noeck]

Hallo

Ich bekomme folgende Fehlermeldung im 4Images 1.7.6, MySQL Version 5.0.77,  PHP Version 5.2.9:

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 NOT IN (0) ORDER BY 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 /home/httpd/vhosts/......./httpdocs/nkofoto/includes/db_mysql.php on line 116

Mit freundlichem Gruss
Noeck

[V@no]

Welcome to 4images forum.

The solution you can find there:
Unknown column 'i.user_id' in 'on clause'

[icetoopz]

Hello. I use the latest version of 4images Gallery, but a strange problem. When first entering the site from any browser error message in red: An unexpected error occured. Please try again later. and below it

Code: [Select]

-) in / var / www / html / includes / sessions.php on line 101

Warning: Cannot modify header information - headers already sent by (output started at / var / www / html / includes / db_mysql.php: 192) in / var / www / html / includes / sessions.php on line 101
Please help me, replaced with a new file and still no deal. I expect your help. Thank you

[V@no]

Welcome to 4images forum.

Did you apply the changes from the first post?

[icetoopz]

Hi.Yes, I did and the message from key ALT + click on red message is:

Bad SQL Query: DELETE FROM 4images_sessions
            WHERE session_lastaction < 1244996120
Incorrect key file for table './piczz_piczz/4images_sessions.MYI'; try to repair it

Please, help me.I can't understand this error.
Thank you so much!

[V@no]

This error means that your database (specifically 4images_sessions.MYI file) probably is corrupted. Try erase everything from 4images_sessions table (use phpmyadmin or such)

If that doesn't help contact your server administrator. They might need restart the database server to fix this.

[tuefteloma]

hallo

bei mir gab es diese Fehlermeldung auch einige Male, geholfen hat das Löschen der kompletten Datenbank, neue Datenbank erstellen und dann die Daten noch hochladen.

Durch das Löschen der kompletten Datenbank ist sicher gestellt, dass wirklich alle Dateien gelöscht sind.

Gruss tuefteloma

[musedisorder]

i keep getting this messege on the installation page, i fill in the needed data and when i  click on "start installation" i get this error messege "An unexpected error occured.  Please try again later. " i've followed all possible fixes and avenues and checked to see if the version i have 1. 7. 7 MySQL ver.  5. 0. 51-community that comes with the web server, not sure what i am doing wrong, or what the problem is * heavy sigh* :? any help would be appreciated to get past this problem

[V@no]

Welcome to 4images forum.

Did you follow the instructions provided in the first post of this topic?

[SirIon]

Hallo, ich nutze die Galerie schon eine ganze Weile. Als ich heute ein Bild hochgeladen hab kam auf einmal die Fehlermeldung: "
An unexpected error occured. Please try again later." Details: "Could not connect to the database server (localhost, xxxxxx)"

Was kann das sein?

[V@no]

Welcome to 4images forum.

It could be a temporary glitch on the server, if this problem persists, try contact your server administrator.

[arabcine]

i always got this error in my web and how i can fix it

and it's be sometimes slowly



this message.

An unexpected error occured. Please try again later.

An unexpected error occured. Please try again later.

An unexpected error occured. Please try again later.

Warning: Cannot modify header information - headers already sent by (output started at /home/arabcine/public_html/bi3/includes/db_mysql.php:192) in /home/arabcine/public_html/bi3/admin/admin_functions.php on line 168

Warning: Cannot modify header information - headers already sent by (output started at /home/arabcine/public_html/bi3/includes/db_mysql.php:192) in /home/arabcine/public_html/bi3/admin/admin_functions.php on line 169

Warning: Cannot modify header information - headers already sent by (output started at /home/arabcine/public_html/bi3/includes/db_mysql.php:192) in /home/arabcine/public_html/bi3/admin/admin_functions.php on line 170




and this

DB Error: Bad SQL Query: SELECT c.image_id, c.comment_id, c.user_id as comment_user_id, c.user_name as guest_user_name, c.comment_headline, c.comment_text, c.comment_date, i.cat_id, i.user_id, i.image_name, i.image_media_file, i.image_thumb_file, u.user_name as user_name, s.user_name as comment_user_name , i.image_pric, i.image_phon, s.user_pm_inbox as comment_user_pm_inbox, u.user_pm_inbox as image_user_user_pm_inbox, s.user_pm_sentbox as comment_user_pm_sentbox, u.user_pm_sentbox as image_user_user_pm_sentbox, s.user_pm_email as comment_user_pm_email, u.user_pm_email as image_user_user_pm_email, s.user_pm_popup as comment_user_pm_popup, u.user_pm_popup as image_user_user_pm_popup FROM 4images_comments c LEFT JOIN 4images_images i ON i.image_id = c.image_id LEFT JOIN 4images_users u ON u.user_id = i.user_id LEFT JOIN 4images_users s ON s.user_id = c.user_id WHERE i.image_active = 1 AND i.image_allow_comments = 1 AND i.cat_id NOT IN (0) AND i.cat_id NOT IN (0) AND i.cat_id NOT IN (0) ORDER BY c.comment_date DESC LIMIT 5
MySQL server has gone away

[V@nо]

your last error indicates problem with your mysql server. you should contact host administrator.
p.s.
 all other messages are caused by that last message.

[arabcine]

your last error indicates problem with your mysql server. you should contact host administrator.
p.s.
 all other messages are caused by that last message.

my hosting from hostgotor
 i did bu they said:

(12:26:44 AM) Keith Ka: Just a moment as I check the server.  
(12:34:10 AM) Keith Ka: From all of my checking, this is going back to an issue with how the gallery is coded. You may want to contact http://www.4homepages.de/ to see if they can optimize their script.  
(12:36:10 AM) Osama: and then?  
(12:37:02 AM) Keith Ka: They will have to look into why their script is causing issues, I'm afraid.


and see attach