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

0 Members and 1 Guest are viewing this topic.

Offline V@nо

  • Addicted member
  • ******
  • Posts: 1.223
    • View Profile
Re: An unexpected error occured. Please try again later
« Reply #15 on: December 07, 2009, 08:12:00 PM »
saying "causing issues" without saying what issues is pretty much useless answer.
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 #16 on: December 09, 2009, 08:11:13 PM »
dear i changed the company of web hosting and i still get same problem i think the problem with php or mysql in the script becuase all in my web work fine vb and other etc

please help me to fix this



Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/arabcine/public_html/bi3/includes/db_mysql.php on line 116


An unexpected error occured. Please try again later.
Bad SQL Query: SELECT u.*, l.*
              FROM 4images_users u, 4images_lightboxes l
              WHERE u.user_id = 1 AND l.user_id = u.user_idMySQL server has gone away


An unexpected error occured. Please try again later.
Bad SQL Query: SELECT *
                FROM 4images_users
                WHERE user_id = 1MySQL server has gone away


An unexpected error occured. Please try again later.
Bad SQL Query: SELECT id, type, message, date, expire
              FROM 4images_ban
              WHERE ((type = 1 AND (62 BETWEEN ip1_start AND ip1_end) AND (150 BETWEEN ip2_start AND ip2_end) AND (55 BETWEEN ip3_start AND ip3_end) AND (6 BETWEEN ip4_start AND ip4_end)) OR (type = 2 AND ('62.150.55.6' LIKE hostname)))MySQL server has gone away


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) AND c.cat_id = i.cat_id
            LIMIT 114, 1MySQL server has gone away


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, i.image_pric, i.image_phon, 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 8MySQL server has gone away


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/arabcine/public_html/bi3/includes/db_mysql.php on line 116

An unexpected error occured. Please try again later.
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, 13) AND i.cat_id NOT IN (0) AND i.cat_id NOT IN (0)
        ORDER BY c.comment_date DESC
        LIMIT 5MySQL server has gone away


An unexpected error occured. Please try again later.
Bad SQL Query: SELECT user_name, user_id
          FROM 4images_users
          WHERE user_level > 1
          ORDER BY user_id DESCMySQL server has gone away


Offline arabcine

  • Jr. Member
  • **
  • Posts: 87
    • View Profile
Re: An unexpected error occured. Please try again later
« Reply #17 on: December 13, 2009, 08:49:59 PM »
please i change the server and still i got error like this message tell me what i can do to fix this?

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 #18 on: December 13, 2009, 11:12:59 PM »
What is mysql version on the server?
http://dev.mysql.com/doc/refman/4.1/en/gone-away.html
or
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

none of the possible causes indicates there is a problem with 4images...

and besides, if you had 4images working before and this started happening all of the sudden, do you still believe it causes by 4images?
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 #19 on: December 20, 2009, 07:19:42 PM »
The database is just too slow. Queries, i think

now the tech, told me to do Optimizing MySQL: Queries and Indexes

how anyone can help me ?


www.q8bi3.com and see it's very slow , i changed the hosting 3 times but still get slow....
« Last Edit: December 20, 2009, 10:10:09 PM by arabcine »

Offline arabcine

  • Jr. Member
  • **
  • Posts: 87
    • View Profile
Re: An unexpected error occured. Please try again later
« Reply #20 on: December 21, 2009, 10:05:21 PM »
anyone can help me please

Offline alekseyn1

  • Full Member
  • ***
  • Posts: 102
    • View Profile
    • My Project
Re: An unexpected error occured. Please try again later
« Reply #21 on: December 22, 2009, 03:07:11 PM »
enable statistics info and debugging in includes/constants.php and then you will see all the timings of the 4images...

Code: [Select]
// Debug contants
define("PRINT_STATS", 1);
define("PRINT_QUERIES", 1);
define('PRINT_CACHE_MESSAGES', 1);

Offline arabcine

  • Jr. Member
  • **
  • Posts: 87
    • View Profile
Re: An unexpected error occured. Please try again later
« Reply #22 on: December 22, 2009, 04:57:21 PM »
it's enbled but nothing

please V@no 
 answer me to fix this , i changed the hosting but i still got this slow you can vist and see
« Last Edit: December 23, 2009, 12:53:08 AM by arabcine »

Offline nojillys

  • Pre-Newbie
  • Posts: 1
    • View Profile
Re: An unexpected error occured. Please try again later
« Reply #23 on: January 25, 2010, 10:41:33 AM »
Thanks for this. I have been having trouble with this code for a whole week. Im glad I joined this community because I do have a lot of problems with the PHP scripts and how to redirect sort of stuff. Thank you for sharing this.

Offline alekseyn1

  • Full Member
  • ***
  • Posts: 102
    • View Profile
    • My Project
Re: An unexpected error occured. Please try again later
« Reply #24 on: January 25, 2010, 05:32:40 PM »
it's enbled but nothing

please V@no 
 answer me to fix this , i changed the hosting but i still got this slow you can vist and see

well it's impossible that you see nothing... after you enable those settings, you will see exactly how much time each MySQL query takes... then find the one that takes longest and check the syntax... most probably you will find the error....

Offline Kudrev

  • Pre-Newbie
  • Posts: 1
    • View Profile
Re: An unexpected error occured. Please try again later
« Reply #25 on: January 28, 2010, 01:21:00 PM »
After uploading image file on monitor appeared a blank page ''member.php". Image is not uploading. What is it? Thanks... :(

Offline kknich

  • Pre-Newbie
  • Posts: 1
    • View Profile
Re: An unexpected error occured. Please try again later
« Reply #26 on: February 04, 2010, 10:08:15 PM »
Hello, after I press ALT key my debug msg is:

Could not connect to the database server (mysql hostname and database name).

The error is random, it doesn't appear all the time. After refresh, it usually goes away. My web hosting is the problem, huh?  :?

Offline romieyo

  • Pre-Newbie
  • Posts: 1
    • View Profile
Re: An unexpected error occured. Please try again later
« Reply #27 on: February 16, 2010, 10:14:11 PM »
Sorry. I don't know how to make threads, so I'll ask in here.
Can you guys help me.  I think something is wrong with my root folder for wakaba, I get this message
"Template Error: Couldn't open Template ./templates/34/whos_online.html"
how do I fix that?

Rembrandt

  • Guest
Re: An unexpected error occured. Please try again later
« Reply #28 on: February 17, 2010, 05:42:43 AM »
Welcome to the Forum!
...
"Template Error: Couldn't open Template ./templates/34/whos_online.html"
how do I fix that?
your template, is missing the "whos_online.html".
copy from the original templates the "whos_online.html" in your templates folder.

mfg Andi

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 #29 on: February 17, 2010, 06:39:07 AM »
Login to ACP (in  the address type http://yoursite/admin/) and then login. Then go to Settings and select different template.
You have a folder "34" in templates folder which is not valid 4images template.
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)