Welcome to RCF - WHF

~^Karen^~ · Nov 26, 2006

Dont think my ranks in admin is working properly, i was trying to add a new rank and i havent even tried it in a long time so i dunno if its just recently it aint working or what anyway the new rank added i called it test manager anyway i remembered i forgot to click on the yes button to choose special rank, went to edit it and it says "you must select a rank" I then tried to add another rank with clicking on special rank and it wouldnt let me, cant remember what the error message was though! This is all on my live forum! It aint important but mite be if i wanna change things around!

Nightrider · Sep 25, 2004

The auto_increment setting wasn't assigned to your rank_id field like it should have been. This is what I had to do in your phpMyAdmin to correct the problem on the phpbb_ranks table. I clicked on the edit icon next to rank_id on the Structure tab:

Then I changed the Extra setting to auto_increment, then I pressed the Save button:

That corrected the problem. Of course I had to delete the Test manager record since it's rank_id was set incorrectly, then I re-added it...

headbang

~^Karen^~ · Nov 26, 2006

oh ok, il remember that for next time! Thanks Applause

Nightrider · Sep 25, 2004

Let's hope there isn't a next time. The settings shouldn't be changing once you get them set. I really had to look around quite a while to find this since I don't use phpMyAdmin to maintain my database. Problems like this are a lot easier to fix using MySql-Front...

headbang

~^Karen^~ · Nov 26, 2006

I wouldnt know i get everyone else to do my dirty work when it comes to the database im so scared of messing things up, when i created that test database few weeks ago that was good for me lol

Nightrider · Sep 25, 2004

If you maintain good backups of your database, then the fear factor shouldn't be nearly as bad. You should be able to recover from any mistake if you are prepared. With your fear, you are probably much less likely to make a mistake than someone who actually has very little fear of it. I imagine that you would double and tripple check every move before acting, which could save you from doing something dumb that would need to be fixed. I'm probably more likely to make a mistake in the database than you are. I could probably fix my mistakes faster though...

munky2

~^Karen^~ · Nov 26, 2006

lol, i do a back up of the database every week at least with that security mod iv got i disable the back up until needed coz it just takes up a lot of room, but i make sure its on a couple times in the week so i always have a good back up!

Nightrider · Sep 25, 2004

Yes, those automatic database backups can eat up a lot of space quickly. I installed the phpBB Security MOD on our Test forum, then forgot about it. I had noticed that we were using a lot of web space in our CPanel, but it never occured to me that the automatic database backups from the Test forum was responsible. I deleted over 6 GB of database backups from the Test forum yesterday. I sure am glad we had a lot of space or it could have shut us down until I found the cause...

Shocked

~^Karen^~ · Nov 26, 2006

i keep on track of it coz i know iv had probs with space on mine with one of the other hosts iv been on, but i really dont think it will run out, my friend kept saying it slows the forum down and with all the posts i keep etc, but i can see how thats possible myself unless im running out of space, but im sure its unlimited or so much that theres no way i can fill it all up!

Nightrider · Sep 25, 2004

It really shouldn't slow down your server anymore than storing 1000 files on your PC would slow it down more than storing 100 files on your PC. Storing files does not affect the performance of the server unless it is running out of space on the HDD and is spending a lot of time swapping files back and forth and everything becomes fragmented...

munky2