Author Topic: An unexpected error occured. Please try again later  (Read 417009 times)

0 Members and 1 Guest are viewing this topic.

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
An unexpected error occured. Please try again later
« on: February 15, 2009, 08:10:51 PM »
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)){
« Last Edit: October 20, 2009, 04:52:53 AM by V@no »
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline Noeck

  • Pre-Newbie
  • Posts: 1
    • View Profile
Re: An unexpected error occured. Please try again later
« Reply #1 on: April 17, 2009, 02:32:44 PM »
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

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: An unexpected error occured. Please try again later
« Reply #2 on: April 17, 2009, 02:56:09 PM »
Welcome to 4images forum.

The solution you can find there:
Unknown column 'i.user_id' in 'on clause'
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline icetoopz

  • Pre-Newbie
  • Posts: 2
    • View Profile
Re: An unexpected error occured. Please try again later
« Reply #3 on: June 14, 2009, 11:03:33 AM »
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

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: An unexpected error occured. Please try again later
« Reply #4 on: June 14, 2009, 05:54:43 PM »
Welcome to 4images forum.

Did you apply the changes from the first post?
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline icetoopz

  • Pre-Newbie
  • Posts: 2
    • View Profile
Re: An unexpected error occured. Please try again later
« Reply #5 on: June 14, 2009, 06:38:21 PM »
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!

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: An unexpected error occured. Please try again later
« Reply #6 on: June 14, 2009, 06:47:53 PM »
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.
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline tuefteloma

  • Newbie
  • *
  • Posts: 19
    • View Profile
    • Tueftelomas Hobby-Album
Re: An unexpected error occured. Please try again later
« Reply #7 on: June 21, 2009, 09:48:18 AM »
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
wenn du lächelst, lächelt die ganze Welt zurück

herzliche Grüsse

tuefteloma

Offline musedisorder

  • Pre-Newbie
  • Posts: 2
    • View Profile
Re: An unexpected error occured. Please try again later
« Reply #8 on: September 16, 2009, 06:07:53 AM »
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

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: An unexpected error occured. Please try again later
« Reply #9 on: September 16, 2009, 02:38:12 PM »
Welcome to 4images forum.

Did you follow the instructions provided in the first post of this topic?
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline SirIon

  • Pre-Newbie
  • Posts: 1
    • View Profile
Re: An unexpected error occured. Please try again later
« Reply #10 on: October 22, 2009, 11:54:33 PM »
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?
« Last Edit: October 23, 2009, 12:39:50 AM by SirIon »

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: An unexpected error occured. Please try again later
« Reply #11 on: October 23, 2009, 01:03:21 AM »
Welcome to 4images forum.

It could be a temporary glitch on the server, if this problem persists, try contact your server administrator.
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline arabcine

  • Jr. Member
  • **
  • Posts: 87
    • View Profile
Re: An unexpected error occured. Please try again later
« Reply #12 on: December 02, 2009, 06:14:31 PM »
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

« Last Edit: December 02, 2009, 06:30:20 PM by arabcine »

Offline V@nо

  • Addicted member
  • ******
  • Posts: 1.223
    • View Profile
Re: An unexpected error occured. Please try again later
« Reply #13 on: December 02, 2009, 07:11:41 PM »
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.
Your first three "must do" before you ask a question:
If I asked you to PM me, I meant PM to my primary account, this account doesn't accept PMs.

Offline arabcine

  • Jr. Member
  • **
  • Posts: 87
    • View Profile
Re: An unexpected error occured. Please try again later
« Reply #14 on: December 07, 2009, 07:39:04 PM »
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