Web Hosting Vodahost    

Home Take The Royal Tour! Order Now Features Prices
Go Back   Web Hosting > VodaHost Web Hosting Support > mySQL & PHP

Notices

mySQL & PHP Discussions, information and help with mySQL and PHP.

Reply
 
LinkBack Thread Tools
  #1  
Old 03-03-2008, 06:04 AM
Staff Sergeant
 
Join Date: Oct 2007
Posts: 40
Default I think I messed up my Mysql

Hi everyone,

I'm not panicking yet, hoping that my php forum database in Mysql will become normal again.

Is it possible to reset all the values of a Mysql db back to their default values?

I'm using phpbb3, and was successful in adding a mod called user_notify mod. But this mod will only affect the users who will register after my changes. Things were fine until I decided to manually alter the values of the old users, too so they could receive an email telling them someone replied to their posts. Now I get this message in my forum's ACP each time I try to access the board settings/avatar settings/post settings, etc...

[phpBB Debug] PHP Notice: in file /adm/index.php on line 149: Cannot modify header information - headers already sent by (output started at /language/en/acp/board.php:1)
[phpBB Debug] PHP Notice: in file /adm/index.php on line 151: Cannot modify header information - headers already sent by (output started at /language/en/acp/board.php:1)
[phpBB Debug] PHP Notice: in file /adm/index.php on line 152: Cannot modify header information - headers already sent by (output started at /language/en/acp/board.php:1)
[phpBB Debug] PHP Notice: in file /adm/index.php on line 153: Cannot modify header information - headers already sent by (output started at /language/en/acp/board.php:1)

I'm sure this problem result from my stupid attempts to manually modify my users' user_notify values inside mysql. I suddenly thought I was Naval Design. :(
So, Is there a button i can click on to reset the default values? Help, please...

P.S. I made a back up of the forum before making these manual changes, I restored them but I get the same message above.

Herman
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2  
Old 03-03-2008, 06:15 AM
Watdaflip's Avatar
Brigadier General
 
Join Date: Sep 2005
Location: Cincinnati, Ohio
Posts: 1,643
Default Re: I think I messed up my Mysql

It isn't a MySQL error, atleast not based on the error.

Chances are its an error caused the mod you installed.
Have you installed a language pack, or did you make changes to any language files? (Guessing based on the error).

If you aren't sure what exactly is causing it then try overriding the admin control panel with the original one from the phpbb 3 download, and then install reinstall the mod. Also I would check and make sure (if you have more then 1 mod installed), that none interfere with another (like both requiring an edit on the same line).
__________________

Register/Login Script
Do you use a Password Protected Directory? Need a way to allow users to make their own account, try my .htaccess Login Script
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3  
Old 03-03-2008, 06:52 AM
Staff Sergeant
 
Join Date: Oct 2007
Posts: 40
Default Re: I think I messed up my Mysql

Quote:
Have you installed a language pack, or did you make changes to any language files? (Guessing based on the error).
Yes, there was this php file in my phpbb3 - language folder that i was asked to alter in order to install that mod. I pasted a code in it.

Well, i'm already happy to learn that Mysql is OK. How do you think i can resolve this problem? Any suggestion is welcome...Thanks in advance!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT +1. The time now is 02:58 PM.


Powered by vBulletin® Version 3.7.1
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC7
2007 VodaHost.com - All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54