Sign up guide

Hitman47 · Post by **Hitman47** » Tue Jul 15, 2008 4:21 am

isn't working, click on it for more info. Needs to be fixed ASAP!!!

Post by **AngelOne** » Tue Jul 15, 2008 4:41 am

OMG no WiKi...

This is what it displayed to me when I tried to open it. Do we have a WiKi doctor in the house.

Database error
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
(SQL query hidden)
from within function "MediaWikiBagOStuff::_doinsert". MySQL returned error "1044: Access denied for user: 'dbo171665982@%' to database 'db171665982' (db456.perfora.net)".

Post by **Goggles** » Tue Jul 15, 2008 11:27 am

if I had to take a wild guess, it would be that the database query string is posting a false username... according to the error message it's trying access the database as user "dbo171665982@%". I don't that those last two characters (@%) are supposed to be there. Looks like an error from within a config file that's probably easily fixable... let me see if my FTP access gets me in there.

Post by **Goggles** » Tue Jul 15, 2008 11:36 am

Confirmed: the correct username to access the database is dbo171665982. The unwanted two extra characters @% are causing the login issue. Now we just need to find where those characters are being added, and stop it.

Post by **Goggles** » Tue Jul 15, 2008 11:51 am

Update:

Our web host's Admin Console reports that the database that stores our Wiki info is unavailable. The database is connectable using PHPMyAdmin, which makes this a weird message to be receiving...

However, I was able to determine that the total size of the database is 143.3MB. Our limit, according to our host, is 100MB. It could very well be that they removed/denied access to the database for the root account because we're over the limit.

Post by **AngelOne** » Tue Jul 15, 2008 11:59 am

Roger that Goggles,

Guess we have to keep a careful eye on the amount of data used on the WiKi and weed out or archive the old stuff, so not to exceed the limit.

The question is now, WHO is going to reduce the size and get the WiKi online again?

Once again, thanks for your time and effort.

:angel1:

Post by **Goggles** » Tue Jul 15, 2008 12:20 pm

I made a backup of the wikimedia database.

Warning: the GC database (seperate from the wiki) is also over the limit at 114MB.

Post by **Goggles** » Tue Jul 15, 2008 12:47 pm

I was able to trim the database and reduce it's size to under the limit. I made backups of the entire database, and individually to the tables I edited. All that remains is for the write access for the user account to return... no clue how to do that, or when it will happen :/ Maybe we should submit a ticket to the web host?

Post by **Goggles** » Tue Jul 15, 2008 1:36 pm

Update:

write access is back - restoring a few links and it should be back to normal.

Post by **Von_Krieg** » Tue Jul 15, 2008 2:50 pm

Thanks Goggles!

AlbinoKalle69 · Post by **AlbinoKalle69** » Tue Jul 15, 2008 3:22 pm

goggles - they do something!

Hitman47 · Post by **Hitman47** » Tue Jul 15, 2008 6:06 pm

Goggles for general!

Post by **Stonie** » Tue Jul 15, 2008 11:43 pm

Hitman47_088 wrote:Goggles for general!

Goggles for Executive Senator. :jump:

Hit the donate button for campaign funding

Post by **Goggles** » Wed Jul 16, 2008 12:00 am

Wiki is back up and running.

THIS WILL NOT LAST

We will have a repeat of today's dead wiki experience pretty quickly. We'll need a volunteer to jump into the admin console of the wiki and delete as much spam as they can find!

StarLord · Post by **StarLord** » Wed Jul 16, 2008 12:52 am

Spam? Isnt there any password on that Wiki? Might be a good idea to put something like that...