4images Forum & Community
Welcome, Guest. Please login or register.
Did you miss your activation email?
October 18, 2018, 09:46:22 AM

Login with username, password and session length
Search:     Advanced search
Togle to toolbar
Translate this page with =>
Translate this page >
* Home Help Search Login Register
 
+  4images Forum & Community
|-+  4images Help / Hilfe
| |-+  Error Messages / Fehlermeldungen
| | |-+  An unexpected error occured. Please try again later
0 Members and 3 Guests are viewing this topic. « previous next »
Pages: [1] 2 3 4 5 6 » »» Print
Author Topic: An unexpected error occured. Please try again later  (Read 302244 times)
V@no
If you don't tell me what to do, I won't tell you where you should go :)
Administrator
4images Guru
*****
Offline Offline

Posts: 17849

Thank You
-Given: 47
-Receive: 577

mmm PHP...


View Profile WWW
« 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:

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

Replace it with:
1
        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:
1
      if (isset($user_info['user_level']) && $user_info['user_level'] == ADMIN){

Replace it with:
1
      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 » Logged

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)
Noeck
Pre-Newbie

Offline Offline

Posts: 1

Thank You
-Given: 0
-Receive: 1


View Profile
« 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
Logged
V@no
If you don't tell me what to do, I won't tell you where you should go :)
Administrator
4images Guru
*****
Offline Offline

Posts: 17849

Thank You
-Given: 47
-Receive: 577

mmm PHP...


View Profile WWW
« 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'
Logged

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)
icetoopz
Pre-Newbie

Offline Offline

Posts: 2

Thank You
-Given: 0
-Receive: 1


View Profile
« 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
1
2
3
-) 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
Logged
V@no
If you don't tell me what to do, I won't tell you where you should go :)
Administrator
4images Guru
*****
Offline Offline

Posts: 17849

Thank You
-Given: 47
-Receive: 577

mmm PHP...


View Profile WWW
« Reply #4 on: June 14, 2009, 05:54:43 PM »

Welcome to 4images forum.

Did you apply the changes from the first post?
Logged

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)
icetoopz
Pre-Newbie

Offline Offline

Posts: 2

Thank You
-Given: 0
-Receive: 1


View Profile
« 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!
Logged
V@no
If you don't tell me what to do, I won't tell you where you should go :)
Administrator
4images Guru
*****
Offline Offline

Posts: 17849

Thank You
-Given: 47
-Receive: 577

mmm PHP...


View Profile WWW
« 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.
Logged

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)
tuefteloma
Newbie
*
Offline Offline

Posts: 19

Thank You
-Given: 0
-Receive: 0


View Profile WWW
« 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
Logged

wenn du lächelst, lächelt die ganze Welt zurück

herzliche Grüsse

tuefteloma
musedisorder
Pre-Newbie

Offline Offline

Posts: 2

Thank You
-Given: 0
-Receive: 0


View Profile
« 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
Logged
V@no
If you don't tell me what to do, I won't tell you where you should go :)
Administrator
4images Guru
*****
Offline Offline

Posts: 17849

Thank You
-Given: 47
-Receive: 577

mmm PHP...


View Profile WWW
« 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?
Logged

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)
SirIon
Pre-Newbie

Offline Offline

Posts: 1

Thank You
-Given: 0
-Receive: 1


View Profile
« 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 » Logged
V@no
If you don't tell me what to do, I won't tell you where you should go :)
Administrator
4images Guru
*****
Offline Offline

Posts: 17849

Thank You
-Given: 47
-Receive: 577

mmm PHP...


View Profile WWW
« 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.
Logged

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)
arabcine
Jr. Member
**
Offline Offline

Posts: 87

Thank You
-Given: 0
-Receive: 2


View Profile
« 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 » Logged
V@nо
Addicted member
******
Offline Offline

Posts: 1223

Thank You
-Given: 11
-Receive: 17


View Profile
« 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.
Logged

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.
arabcine
Jr. Member
**
Offline Offline

Posts: 87

Thank You
-Given: 0
-Receive: 2


View Profile
« 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

* Chat-Suppot.txt (4.54 KB - downloaded 5 times.)
Logged
Pages: [1] 2 3 4 5 6 » »» Print 
« previous next »
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF | SMF © 2015, Simple Machines Valid XHTML 1.0! Valid CSS!
Page created in 0.052 seconds with 19 queries.
Post your comments here