Sql Question About Phpbb

[Extreme]

i run a forums using phpBB 2.0.22 and have put on a mod that is giving me problems. I want to remove this mod but am not sure about the SQL modification I made. I have the files backed up from before the mod going in but with the SQL mod, how do I remove the mod? do I need to put in a new SQL mod to negate first one or is nothing required beyond the files being changed to backed up version of the said files? the phpB mod in question was Spelling cow which is a spellchecker. now I just want it gone

[TCH-Bruce]

Well do you know what was altered in the database? Were tables added? If so you would just need to drop those tables from the database. Check with the author of the mod, I'm sure they will tell you how to remove it.

[Jeren]

If you took a database backup prior to installing the mod, you could also take a look at the database structure from then and compare it to now. That could give you an idea of what is different, too.

[Extreme]

Actually none were added to my knowledge. The first code to go in was this

>ALTER TABLE `phpbb_users` ADD `user_autospell` TINYINT( 1 ) DEFAULT '1';

I dont know when it started to be exact but all i know is that I cannot post anything on my boards while on my phone. This may sound small to some being that myself and all others can still post, but when you do as much work as i do using my phone *TREO 680* What it does is cripple me. Now this mod started to get on my nerves and i did a second modification to the table in order to turn off the autospeller

>ALTER TABLE phpbb_users MODIFY user_autospell TINYINT( 1 ) DEFAULT '0';

At this point it has proven to be more of a hassle than anything and my true goal is to have the tables fixed and the backed up files put in and call it a day. Then only thing i dont know how to do is the SQL stuff

[TCH-Bruce]

Well the question is do you have a backup of the database? If so you can restore it through cpanel. If you don't you may be able to open a help desk ticket and see if they have a backup prior to when the mod was made. Of course in doing so any posts made since the backup was made will be lost.

[Extreme]

which is somethign i reall cant afford

[Jeren]

Might I ask which mod it was that was installed and now giving you problems?

[Extreme]

the spelling cow mod

[Bob Crabb]

I tried the Spelling Cow mod on a phpbb2 message board about a year ago, and didn't like it either. I just checked the install file for the mod version 1.6.0, and it looks as though the only SQL change done by this mod is adding a field `user_autospell` to the 'phpbb_users' table.

 

The easiest way to remove it, if you do not feel comfortable with SQL, would be through phpMyadmin. In the left frame of the phpMyadmin screen, click on the text link phpbb_users (not the icon to the left of the text link). That should display the structure of the phpbb_users table, which should look like this:

 

Find the field 'user_autospell'. Check the box in that line, then scroll down to where you see Check/Uncheck All with selected ... (series of icons) Do not click the check/uncheck links, but click the X icon. This will bring up a confirmation box (READ THE ACTION in the box) then you can confirm the action. PRIOR to doing this, though, it would be a good idea to make a backup of your forum database through cPanel. Then if you mess something up, you can easily restore the database through cPanel.

 

Please note: cPanel is the best way to back up your phpBB2 forum database if you have modified your board, because the backup through the forum admin panel will only back up the core phpBB database tables.

 

Now, if you really don't want to do all this, then just delete the script changes in the mod and leave the database alone. Having that field in the users table shouldn't do any harm, since the spelling cow mod is the only script that queries that field.

 

I hope this helps.

 

--Bob

[Extreme]

dude...you rock!!!

 

i just woke up and have somethings to do but i will do this when i get back. i will let you know how it goes

[Bob Crabb]

One other thought -- You probably already know this, but if you choose to back out the database change, be sure that you remove the script changes first.

[Extreme]

after my wifes doctor appt, the order will be...backup, phpadmin, remove table, remove script, new backup. test and hope for best

[Extreme]

i am not seeing what you mean...

 

http://i232.photobucket.com/albums/ee252/tregonia/wetf.jpg

 

this is what i see in myphpadmin

Edited October 25, 2007 by Extreme

[Bob Crabb]

You have to select the appropriate database first. You do that with the drop down in the left frame.

 

Personally, I would remove the spelling cow script changes before making any database changes. Secondly, you do not want to drop any tables, just a field in the phpbb_users table. Also, please note that this having that field in the users table probably won't cause any harm, so the database change in removing the spelling cow mod, while ideal, is not critical or essential in returning your forum to its prior to mod state.

[TCH-Bruce]

And for goodness sake, before you do anything with phpadmin download a backup of your database! Just a friendly warning.

[Extreme]

ayeaye bruce

[Extreme]

so for the back up is it

 

file / backups / Download or generate a full backup

 

is this the direction i want to take?

[TCH-Bruce]

Close, file / backups / Download MySQL database. Pick your database file.

[Extreme]

ok...its removed successfully and to my knowledge all is working fine. However i have to clear my boards to loggin to it with my phone or else i would loose all my highlighted new posts.

 

hmmm....why is that. why is it when you loggin to check something, all the new posts are highlighted or whatever your template looks like and then if you loggout and back in none are highlighted anymore? Is this a question for phpBB?

[TCH-Bruce]

Yes, I would ask the folks at phpBB about that one.

[Extreme]

darn...i removed it and still i cannot post from my phone. hmmm...now what?

[Jeren]

ok...its removed successfully and to my knowledge all is working fine. However i have to clear my boards to loggin to it with my phone or else i would loose all my highlighted new posts.

 

hmmm....why is that. why is it when you loggin to check something, all the new posts are highlighted or whatever your template looks like and then if you loggout and back in none are highlighted anymore? Is this a question for phpBB?

 

With standard phpBB2 (not sure about 3), the flags for new posts don't stick if you log out and log back in. There are mods that'll keep the flags and posts set as unread, but that's not a feature in phpBB2 by default. (I'm still playing with 3, so I'll get back to you on whether or not 3 does the same thing).

[Extreme]

good to hear...i realllyknow nothing to phpBB3 so perhaps you will be the source of info.

 

Someone mentioned my problem with my phone might be in in my phone but others say the host. I dont know to be honest. I just need to isolate the problem. Someone mentioned turning on cookies and i cant help but think they are on due to the fact that this is one of the very few sirte i have issues with and the thought of it being my own kinnda sucks