HTML Logo by World Wide Web Consortium (www.w3.org). Click to learn more about our commitment to accessibility and standards.

Moving forward with Composr

ocPortal has been relaunched as Composr CMS, which is now in beta. ocPortal 9 will be superseded by Composr 10.

Head over to compo.sr for our new site, and to our migration roadmap. Existing ocPortal member accounts have been mirrored.


Critical Error

Login / Search

 [ Join | More ]
 Add topic 
Posted
Rating:
#46510 (In Topic #10151)

Fan in action

site suddenly died :(

I spent 2 weeks getting the site exactly how I wanted, then I opened it to my visitors.
Everything was fine for a day, then today I went to the site (planned on making a backup today) and see this:
ocPortal error
The website's first database query (checking the page request is not from a banned IP address) has failed. This almost always means that the database is not set up correctly, which in turns means that either backend database configuration has changed (perhaps the database has been emptied), or the configuration file (info.php) has been incorrectly altered (perhaps to point to an empty database). It could also mean that the usersubmitban_ip table alone is missing or corrupt, but this is unlikely. As this is an error due to the website's environment being externally altered by unknown means, the website cannot continue to function or solve the problem itself.

Details here are intended for the website/system-administrator, not for regular website users. If you are a regular website user, please let the website staff deal with this problem.

Depending on the error, and only if the website installation finished, you may need to edit the installation options (the info.php file).

ocProducts maintains full documentation for all procedures and tools. These may be found on the ocPortal website. If you are unable to easily solve this problem, we may be contacted from our website and can help resolve it for you.




I checked the info file, everything was the same as before, but when i went into phpmyadmin, the tables for ocp had magically disappeared. :o The files are still in my directory, but the tables in my database are gone…and I have no clue how, I'm the only one with access to it.

So now I'm wondering what happened and if I just lost out on 2 weeks worth of work. :'(
Back to the top
 
Posted
Rating:
#46511
Avatar

Hi,

Sorry to hear that.

Contact your webhost asap. It's almost certainly a problem on their end and if you're quick they should have backups.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#46528
Avatar

Community saint

I've had an identical experience with my hosts in the past. They removed my database after months of running ocPortal on their servers.

The reason they gave was that their server was being overloaded and from a cursory investigation they had come to the conclusion that the script(s) used by ocPortal was their best-guess scenario as to the source for the overload.

So they removed my database.

After threatening 'legal action' and 'bad press' for their actions, they recanted and restored my database. I have since corresponded with them in some detail and they have apologised profusely for what they did, and also admitted that their actions were dictated by their 'ignorance' of how ocPortal functions. Apparently they are a bit wiser now.

Perhaps you have a host who is thinking along the same lines?

Take my advice. I'm not using it!

View my working ocPortal site (version 9.x.x) at Anglo-Indian Portal
Back to the top
 
Posted
Rating:
#46532
Avatar

Community saint

Wow that would to me not be a good host or a good thing fo a host to do.
2 of my hosts have always contacted me if they think I am causing loads on their servers. they then work with me and get the issue fixed. Like one time when the track back thing was causing a high load, they worked with me and I just ended up turning the track back off which solved the issue.



I run http://otakuplayground.com and am hopping to make themes and other things for ocportal even though I no longer use it for otakuplayground.com I still love it and feel it could go far with the right help. It needs themes and needs people to advertise for it.
Back to the top
 
Posted
Rating:
#46537

Fan in action

thanks for replying

the databases on our server were "pruned" and somehow my ocportal one got deleted
I'm still trying to figure out what to do

The files are still there, its just the database that has gone missing. So I'll probably have to delete all the files first then run the install again and then re-setup everything if there is no backup:'(
Back to the top
 
Posted
Rating:
#46540
Avatar

There shouldn't be any need to delete your files. In fact any custom comcode pages will still be there, as they are saved in txt format.

If your host wiped out your database, then ask them for a backup.

Back to the top
 
Posted
Rating:
#46542
Avatar

Community saint

amichan said

… that would to me not be a good host or a good thing fo a host to do … they then work with me and get the issue fixed.

Yup, and Yup, Amy.

That is what they admitted they SHOULD have done, and these days they are careful to approach me first before doing anything that would affect the account. That incident turned out to be a user with a phpNuke account with a very badly written and insecure module that allowed somebody to access the account and cause havoc on the server. Of course, it is the MAIN reason I use ocP, and my web hosts, who have familiarised themselves with the software, tend to agree.

wicked said

… the databases on our server were "pruned" …

If they 'pruned' the databases, then they should be making every effort to restore them. As Allen said, "… ask them for a backup."

Good luck with your quest.

Take my advice. I'm not using it!

View my working ocPortal site (version 9.x.x) at Anglo-Indian Portal
Back to the top
 
Posted
Rating:
#46543
Avatar

Community saint

Yes ask them for a back up as thats not right for them to do, no reason they should have done that.


Oh and to reply to what fletch said yes ocportal has the best security I have ever seen. Its not to resource intensive well actually the script it self runs pretty well just the track back can cause cpu issues and thats the only thing I have ever seen cause issues, you can have all the blocks open and it does not slow down, I have seen other scripts that if you have all the blocks open it slows the system down an increases load.


I run http://otakuplayground.com and am hopping to make themes and other things for ocportal even though I no longer use it for otakuplayground.com I still love it and feel it could go far with the right help. It needs themes and needs people to advertise for it.
Back to the top
 
Posted
Rating:
#46638
Avatar

Fan in training

Thanks for the heads up on the trackbacks…



B.
Back to the top
 
Posted
Rating:
#46838

Fan in action

well i decided to start completely fresh, made a new database, removed all the site files in ftp (after backing up my custom ones to my desktop), ocportal was completely gone.
I went to install it with the instant transfer version, it said it installed successfully, but when I go to the site, it gives me another critical error

ocPortal errorThe website's first database query (checking the page request is not from a banned IP address) has failed. This almost always means that the database is not set up correctly, which in turns means that either backend database configuration has changed (perhaps the database has been emptied), or the configuration file (info.php) has been incorrectly altered (perhaps to point to an empty database). It could also mean that the usersubmitban_ip table alone is missing or corrupt, but this is unlikely. As this is an error due to the website's environment being externally altered by unknown means, the website cannot continue to function or solve the problem itself.

Details here are intended for the website/system-administrator, not for regular website users. If you are a regular website user, please let the website staff deal with this problem.

Depending on the error, and only if the website installation finished, you may need to edit the installation options (the info.php file).

ocProducts maintains full documentation for all procedures and tools. These may be found on the ocPortal website. If you are unable to easily solve this problem, we may be contacted from our website and can help resolve it for you.




I check in phpmyadmin and the new database I used for this install, is completely empty
No tables found in database.


I dont understand how it installed successfully but made no tables in the database. what is going on? is this something caused by my server?
Back to the top
 
There are too many online users to list.
Control functions:

Quick reply   Contract

Your name:
Your message: