Need some help in using the forum? Post your questions here!

Moderators: Ambiguity, SeaQuenchal, virtueone

 

Postby aikoonodera » Sat May 07, 2016 8:46 am

User avatar
  aikoonodera
Posts: 167
Joined: Wed Apr 15, 2015 2:16 pm
Location: Austin, TX

Subject title: "General Error" via the Critique Board

I wasn't entirely sure how exactly this might be tagged, so when I went searching for a post that might explain the issue, I couldn't find any. For now, I'm going to assume this is the first.
So. I can't access the critique board. I'm getting this:

"GENERAL ERROR
SQL ERROR [ mysql4 ]
Table 's' is marked as crashed and should be repaired [1194]
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists."

I've included a screenshot below. This might be a host issue, or it could be unique to this board. I've had no other issues outside of this, and this is "critique board specific" from the way it's acting. I also tried to click on old topics in the critique board from my posts list, and it gives me the same error, so it's not just the front page of the critiques.

I hope this is just an issue on my end. If it is, I could probably fix it, but it's so late I'll probably have to sleep on it for now.

(Also, sorry the image is cropped; it was too big.)
um.png
I want to be your princess.

Art Facebook (usually the most up to date)
Art tumblr
Deviantart
Sketchbook (huge skill difference from first posts to now)

 

Postby Ambiguity » Sat May 07, 2016 1:18 pm

User avatar
  Ambiguity
Posts: 5511
Joined: Thu May 17, 2012 7:55 am
Location: Your dreams

This happens once in a blue moon, my guess is it's the host doing maintenance, it usually fixes within a day or so.

 

Postby Gryephon » Sat May 07, 2016 4:20 pm

User avatar
  Gryephon
Posts: 494
Joined: Sun Aug 03, 2014 9:38 pm

Yeah, it's happening on my my end but on the arena board not the critique board.
If you clean a vacuum cleaner, you become a vacuum cleaner.

Sketchbook: Click Here
Deviant: Click Here

 

Postby Snakebreath » Sat May 07, 2016 6:26 pm

User avatar
  Snakebreath
Posts: 2042
Joined: Sat Apr 13, 2013 3:16 pm
Location: Nova Scotia, Canada

I guess this means I win this weeks Arena posting, since no one else can submit :lol:

 

Postby Gryephon » Sat May 07, 2016 7:35 pm

User avatar
  Gryephon
Posts: 494
Joined: Sun Aug 03, 2014 9:38 pm

Snakebreath wrote:I guess this means I win this weeks Arena posting, since no one else can submit :lol:

Ahh, so your sabotaged it! Smart.

cheated piratesgif2.gif
If you clean a vacuum cleaner, you become a vacuum cleaner.

Sketchbook: Click Here
Deviant: Click Here

 

Postby jr-107 » Sun May 08, 2016 8:39 am

User avatar
  jr-107
Posts: 29
Joined: Sun May 08, 2016 8:09 am
Location: Chatonville, Sonchamp, France

Hello ...
I am a newcomer, and the problem you're having is in my domain of expertise.
As Sycra's videos really helped me a lot theses last weeks, I would really like to
return the favour by helping freely on the problem.

please let me know ...

jr :D

 

Postby Alphawolfin » Sun May 08, 2016 1:31 pm

User avatar
  Alphawolfin
Posts: 487
Joined: Thu Apr 16, 2015 1:37 am
Location: Im Wald bei den Wolfen

I feel like this lil boy when facing that error....
It´s pretty graphical
3. Semester now specialise on your strenght... but on what if there are so many? I guess it´s illustration for now.

 

Postby BlackScorp » Sun May 08, 2016 7:48 pm

  BlackScorp
Posts: 12
Joined: Sun May 08, 2016 10:36 am

as a webdeveloper i know that it is really dangerous to use outdated version of database (mysql4, current version is 5.7.x) i think this board is also an outdated version. i mean you dont use windows 2k with macromedia photoshop or do you? ;)

 

Postby Ambiguity » Mon May 09, 2016 12:50 am

User avatar
  Ambiguity
Posts: 5511
Joined: Thu May 17, 2012 7:55 am
Location: Your dreams

How do we update the database? I've noticed an increase in spambots trying to post since this error started showing up. We have updated the phpboard version and changed out to a more advanced captcha, but we still experience problems like not being able to login on the first try without captcha.

 

Postby BlackScorp » Mon May 09, 2016 9:13 am

  BlackScorp
Posts: 12
Joined: Sun May 08, 2016 10:36 am

Ambiguity wrote:How do we update the database? I've noticed an increase in spambots trying to post since this error started showing up. We have updated the phpboard version and changed out to a more advanced captcha, but we still experience problems like not being able to login on the first try without captcha.



Well it depends, usually the hosting provider can take care of it uppon request. Some hosting providers has the options in the administration tools and if you have a VPS then you have to check which OS is installed on the server. If you have Debian/Ubuntu the command line "sudo apt-get update mysql" should be enough, if you have Suse/Redhat/Arch then i cannot tell anything since iam not familiar with the systems

 

Postby jr-107 » Mon May 09, 2016 11:50 am

User avatar
  jr-107
Posts: 29
Joined: Sun May 08, 2016 8:09 am
Location: Chatonville, Sonchamp, France

Your hosting provider is supposed to follow up the critical updates to the database and the other pieces of software you use.
Is it a shared hosting or a dedicated platform ? Do you have any idea of the number of hits your platform has to serve ?

Attacks by denial of service are a common issue, beside the captcha system, you must make sure there is no other entry point to your posting system ...
A study of you logs should be a very good start to imagine how to detect quite instantaneously these kind of attacks and automatically blacklist the source
of them.

jr

 

Postby Ambiguity » Mon May 09, 2016 3:41 pm

User avatar
  Ambiguity
Posts: 5511
Joined: Thu May 17, 2012 7:55 am
Location: Your dreams

BlackScorp wrote:Well it depends, usually the hosting provider can take care of it uppon request.

Hm, I see, I think Sycra is the only one who could take of that part then, I don't know if he'd even know what to ask for though as he didn't setup the site himself.

jr-107 wrote:Is it a shared hosting or a dedicated platform ? Do you have any idea of the number of hits your platform has to serve ?

No idea, Matej might since he set the site up. I'll ask him to come check out the error and see what he can do.

jr-107 wrote:Attacks by denial of service are a common issue, beside the captcha system, you must make sure there is no other entry point to your posting system ...
A study of you logs should be a very good start to imagine how to detect quite instantaneously these kind of attacks and automatically blacklist the source
of them.

If you're referring to an IP ban, we can't do it cause the board is set up so we all share the same IP address(for privacy?), so when you ban someone that way you ban the entire board.


By the way, I'm just a moderator so there is nothing I can really do, but I thought I'd ask in case there is a quick fix SeaQuenchal could do without me having to get a hold of another admin.

 

Postby Gryephon » Mon May 09, 2016 5:38 pm

User avatar
  Gryephon
Posts: 494
Joined: Sun Aug 03, 2014 9:38 pm

Ambiguity wrote:I thought I'd ask in case there is a quick fix SeaQuenchal could do without me having to get a hold of another admin.



https://www.phpbb.com/community/viewtop ... 6&t=589766

it's from 2009, but might help.
If you clean a vacuum cleaner, you become a vacuum cleaner.

Sketchbook: Click Here
Deviant: Click Here

 

Postby Oli » Tue May 10, 2016 6:06 pm

User avatar
  Oli
Posts: 2663
Joined: Thu Jul 10, 2014 4:26 pm
Location: Bruxelles

Snakebreath wrote:I guess this means I win this weeks Arena posting, since no one else can submit :lol:


Ya'll can also send me the file via PM and I can try to post it in your name so there is no winning by default :D but by now there are other entries, so this is just in case.
My sketchbook | My dA | My Facebook

Life is too short for bad coffee!

 

Postby aikoonodera » Tue May 10, 2016 9:04 pm

User avatar
  aikoonodera
Posts: 167
Joined: Wed Apr 15, 2015 2:16 pm
Location: Austin, TX

For those curious, I'm still getting the error. It happens for different parts of the site on my phone though.
Kinda sucks, because it worked for a few hours one day, and then stopped again.
I want to be your princess.

Art Facebook (usually the most up to date)
Art tumblr
Deviantart
Sketchbook (huge skill difference from first posts to now)

 

Postby Ambiguity » Wed May 11, 2016 2:50 am

User avatar
  Ambiguity
Posts: 5511
Joined: Thu May 17, 2012 7:55 am
Location: Your dreams

Still trying to work on it guys, bare with me please.

 

Postby aikoonodera » Wed May 11, 2016 4:50 am

User avatar
  aikoonodera
Posts: 167
Joined: Wed Apr 15, 2015 2:16 pm
Location: Austin, TX

Ambiguity wrote:Still trying to work on it guys, bare with me please.


Don't worry, I figured I'd just give a status update. It worked for a few minutes today so I managed to make a post.
I want to be your princess.

Art Facebook (usually the most up to date)
Art tumblr
Deviantart
Sketchbook (huge skill difference from first posts to now)

 

Postby Gryephon » Thu May 12, 2016 12:29 am

User avatar
  Gryephon
Posts: 494
Joined: Sun Aug 03, 2014 9:38 pm

Ambiguity wrote:Still trying to work on it guys, bare with me please.


Hey ambiguity, you could try setting up a completely new critique and arena board to see if that'll fix it temporarily. Maybe call it Critique Board 2.0 or something. And then rename the old one to "Critique archive" or something until ya'll fix up the the table bug in the old ones (which will probably never happen) It's probably the easiest solution for now. I doubt the new boards would have the bug, not immediatly since there is a number of other functioning boards (Help center, lounge, sketchbook, et cetera.)
If you clean a vacuum cleaner, you become a vacuum cleaner.

Sketchbook: Click Here
Deviant: Click Here

 

Postby Ambiguity » Thu May 12, 2016 6:33 am

User avatar
  Ambiguity
Posts: 5511
Joined: Thu May 17, 2012 7:55 am
Location: Your dreams

I'm still trying to get a hold of one of the admins, they're the only ones who can do something.

 

Postby perkexpert » Fri May 13, 2016 9:20 am

User avatar
  perkexpert
Posts: 879
Joined: Fri Jun 22, 2012 1:37 pm
Location: Germany

Hi Ambi, just to let you know: I'm still experiencing this problem, the interesting thing is, that a refresh sometimes solves the problem. I get the problem across all boards.
Homo sapiens non urinat in ventum
Facebook: https://www.facebook.com/artofhannesmangelsdorf/
Homepage: www.perkexpert.com

 

Postby Ambiguity » Fri May 13, 2016 9:47 am

User avatar
  Ambiguity
Posts: 5511
Joined: Thu May 17, 2012 7:55 am
Location: Your dreams

A global announcement has been made concerning this issue, and I will leave it up until something can be done about the error.


Return to Help Center

Who is online

Users browsing this forum: No registered users and 1 guest