Author Topic: DB Error -- Urgent Help Please  (Read 7112 times)

0 Members and 1 Guest are viewing this topic.

Offline Fastian

  • Full Member
  • ***
  • Posts: 199
    • View Profile
DB Error -- Urgent Help Please
« on: July 06, 2006, 10:18:41 PM »
I don’t know what happen. Everything was working fine yesterday & I haven’t changed a single thing since a long time.
But today when I opened my site I was getting the following  DB error message.
Can’t login as admin. Nothing :(

Code: [Select]
DB Error: Bad SQL Query: SELECT setting_name, setting_value FROM 4images_settings
User 'site_wallpapers' has exceeded the 'max_questions' resource (current value: 50000)

Please tell me what to do.  :cry:
I m not a  Programmer.
          But
I m a Good Learner.

Offline Fastian

  • Full Member
  • ***
  • Posts: 199
    • View Profile
Re: DB Error -- Urgent Help Please
« Reply #1 on: July 06, 2006, 10:59:48 PM »
@ ivan

Thanks for the reply.
May i know the cause of this error ??
My other site on the same account is working just fine. I am experiencing problem only with 4Images.
I am also asking my Host about it. (Chatting with them right now)
« Last Edit: July 06, 2006, 11:10:50 PM by Fastian »
I m not a  Programmer.
          But
I m a Good Learner.

Offline Fastian

  • Full Member
  • ***
  • Posts: 199
    • View Profile
Re: DB Error -- Urgent Help Please
« Reply #2 on: July 06, 2006, 11:13:51 PM »
Ok.
I Quick fix from my host.
Thank God, the site is back. :)

Sorry for the trouble. I didn’t know that this issue is related to the host not the 4images & I was so worried that I started this topic.
But still I would to know the cause if someone could through some light on this issue
I m not a  Programmer.
          But
I m a Good Learner.

Offline Fastian

  • Full Member
  • ***
  • Posts: 199
    • View Profile
Re: DB Error -- Urgent Help Please
« Reply #3 on: September 04, 2006, 01:20:54 PM »
Hi guys

Its a bit old topic but I have got this error message twice in the past 24 hours.  Every time I contacted my host the problem was solved in minutes. But now I am getting worried why is this happening again & again??

My site doesn’t have so many daily visitors yet I am exceeding queries limit. So there is something wrong with the script (my installation not with 4images itself).
Most probably some mod that I have installed. So, is there any way around to check exactly which query is giving so much load on the server??

I m not a  Programmer.
          But
I m a Good Learner.

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: DB Error -- Urgent Help Please
« Reply #4 on: September 04, 2006, 01:56:16 PM »
In v1.7.3 its possible to see that information...
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 Fastian

  • Full Member
  • ***
  • Posts: 199
    • View Profile
Re: DB Error -- Urgent Help Please
« Reply #5 on: September 04, 2006, 02:17:19 PM »
In v1.7.3 its possible to see that information...

My Bad. I am currently using v1.1.7 with all bugfix installed.

I have don some heavy modification thats why still sticking to this version.
Currently i am trying my best to move to the new version but it will take some time coz of my studies.

So is it possible to know the reason with v 1.7.1 ??

"50000" queries is a little too much for my site coz today i am only having around 400 page views.
I m not a  Programmer.
          But
I m a Good Learner.

Offline Fastian

  • Full Member
  • ***
  • Posts: 199
    • View Profile
Re: DB Error -- Urgent Help Please
« Reply #6 on: September 05, 2006, 10:14:16 AM »
V@no please help
This thing is getting serious  :cry:
This happend again today.  :cry:

Yesterday i was testing how many queries a page need. So, my hope age was taking around 130-140 queries. Other pages were around 40-70, Is that normal ??
I have also enabled cache feature yesterday but still it happen agian today.

The last mod i installed was "Treat bots as user" "Memberlist" & "User Avatar"
Still i am on v1.7.1

// Edited..
I have removed "Treat Bots as a user" Mod. Have checked Queries for different pages. Now sending PM to V@no. Hopefully i will ge this thing sorted out soon .
« Last Edit: September 05, 2006, 03:25:29 PM by Fastian »
I m not a  Programmer.
          But
I m a Good Learner.