Something is really wrong

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
ReidarAxl
Registered User
Posts: 13
Joined: Wed Nov 24, 2004 1:56 pm

Something is really wrong

Post by ReidarAxl » Wed Nov 24, 2004 2:00 pm

the problem is here: http://www.axlnco.com/Forum/phpBB2/index.php


I havent done anything to screw it up, it just happend! What can I do?

Please help me! :) :?:

cbloom
Registered User
Posts: 42
Joined: Mon Nov 17, 2003 3:46 pm
Contact:

Post by cbloom » Wed Nov 24, 2004 2:07 pm

Obviously it's some problem with your database. Unfortunately, it's impossible for us to determine the exact problem just from that error page. It would help if you could post what version of phpBB you're running, what type and version of database your using and what type and version of server software (Apache, Microsoft IIS, etc). Any background info that led up to the problem would help, too.
Find XBOX Live gamers - Upload your picture, search by state/country/city & meetup in the new forums!
http://www.gamertagdatabase.com

User avatar
Darlof
Former Team Member
Posts: 7111
Joined: Wed Jul 10, 2002 7:53 pm
Location: AR, USA
Name: Darrell
Contact:

Post by Darlof » Wed Nov 24, 2004 2:31 pm

Try searching for this error you get ... http://www.phpbb.com/phpBB/viewtopic.ph ... base+theme would have shown up

ReidarAxl
Registered User
Posts: 13
Joined: Wed Nov 24, 2004 1:56 pm

Post by ReidarAxl » Wed Nov 24, 2004 3:15 pm

Where can I find phpbb_config

refering to http://www.phpbb.com/phpBB/viewtopic.ph ... base+theme

cbloom
Registered User
Posts: 42
Joined: Mon Nov 17, 2003 3:46 pm
Contact:

Post by cbloom » Wed Nov 24, 2004 3:18 pm

It's one of the tables in your phpBB database. If you changed the Table Prefix setting during the install of phpBB then it will be named "<your prefix>config"
Find XBOX Live gamers - Upload your picture, search by state/country/city & meetup in the new forums!
http://www.gamertagdatabase.com

ReidarAxl
Registered User
Posts: 13
Joined: Wed Nov 24, 2004 1:56 pm

Post by ReidarAxl » Wed Nov 24, 2004 5:03 pm

Okey.. I've found it, but what i'm I looking for? I'm a newbee!

I don't know what wrong or how too fix it?

User avatar
prince_of_oreon
Registered User
Posts: 2422
Joined: Wed Dec 18, 2002 10:01 pm
Location: Kvlt øf Ørëøñ ¤ þøµær øƒ †æh

Post by prince_of_oreon » Wed Nov 24, 2004 5:53 pm

If you merely want to get use of your forum back in phpMyAdmin browse the phpBB_config table (where 'phpBB' is your table prefix), edit the row 'default_style' and set the value to 1.

cheers!

ReidarAxl
Registered User
Posts: 13
Joined: Wed Nov 24, 2004 1:56 pm

Post by ReidarAxl » Wed Nov 24, 2004 6:20 pm

there is no such thing in there... I'm lost.. help me... heeelp mee

cbloom
Registered User
Posts: 42
Joined: Mon Nov 17, 2003 3:46 pm
Contact:

Post by cbloom » Wed Nov 24, 2004 6:24 pm

create a new row:

INSERT INTO `<your config table name>` VALUES ('default_style', '1');
Find XBOX Live gamers - Upload your picture, search by state/country/city & meetup in the new forums!
http://www.gamertagdatabase.com

ReidarAxl
Registered User
Posts: 13
Joined: Wed Nov 24, 2004 1:56 pm

Post by ReidarAxl » Wed Nov 24, 2004 6:53 pm

Okey, i've done this. But I can understand how that can fix my problem.

this just keeps showing up when I try to enter my forum:

phpBB : Critical Error

Could not query database for theme info

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near '' at line 3

cbloom
Registered User
Posts: 42
Joined: Mon Nov 17, 2003 3:46 pm
Contact:

Post by cbloom » Wed Nov 24, 2004 6:59 pm

reinstall?
Find XBOX Live gamers - Upload your picture, search by state/country/city & meetup in the new forums!
http://www.gamertagdatabase.com

ReidarAxl
Registered User
Posts: 13
Joined: Wed Nov 24, 2004 1:56 pm

Post by ReidarAxl » Wed Nov 24, 2004 7:09 pm

what about the users? do they get removed if I do that?

And is there somwhere where I can reinstall it?

cbloom
Registered User
Posts: 42
Joined: Mon Nov 17, 2003 3:46 pm
Contact:

Post by cbloom » Wed Nov 24, 2004 7:38 pm

OK, so the logical thing to do here would be to backup all of your tables except for the config, theme and theme_name. Then do a clean re-install of phpBB. Afterwards, import all of your saved tables, overwritting the current ones. This will leave you with all of youe existing user/post/etc data but give you clean config and theme tables. Just make sure that you reinstall the same version of phpBB that you have installed now. Otherwise, your saved tables may not be in the proper format.
Find XBOX Live gamers - Upload your picture, search by state/country/city & meetup in the new forums!
http://www.gamertagdatabase.com

ReidarAxl
Registered User
Posts: 13
Joined: Wed Nov 24, 2004 1:56 pm

Post by ReidarAxl » Wed Nov 24, 2004 8:30 pm

okey... here's my problem now.. I have a hierd mysql database, and there i use a online thing thats called phpMyAdmin 2.5.6! And I don't think i can take any backups there....

:arrow: (the problem guy) :?

cbloom
Registered User
Posts: 42
Joined: Mon Nov 17, 2003 3:46 pm
Contact:

Post by cbloom » Wed Nov 24, 2004 8:43 pm

In phpMyAdmin, select your current phpBB database. Click the export tab. In the "Export" multi-select list, select all of the tables except for the user, themes and themes_name tables. Make sure the options to export both the SQL and the data are checked. Under SQL, make sure the "add drop table" option is checked. Under Data, make sure "complete inserts" is checked. Check "Save As File" and select "gzipped" for the compression. Then click Go. Save your file whem prompted to do so.

Now remove phpBB by dropping all of the existing tables and deleting all of your files, then reinstall from scratch (just follow the directions in the install file). Make sure that your table prefix remains the same durring setup.

Now, once you've got your new board up and running, go back to phpMyAdmin. Select your new DB and click the SQL table. Use the browse button to find the file you saved in the first step and click Go. Your old data should overwrite the new data.

I would HIGHLY recommend that you back up all of your files prior to this. And you may want to make a second backup of the current database (including all of the tables this time) before you start dropping tables. Alsom if you're not familiar with FTP, find someone who is or else you may run into trouble. If your hosting provider set up the forum initially, contact them after you complete the first step and ask them to reinstall phpBB for you.

Good luck and happy turkey (or tofurkey for us vegitarians) day.
Find XBOX Live gamers - Upload your picture, search by state/country/city & meetup in the new forums!
http://www.gamertagdatabase.com

Locked

Return to “2.0.x Support Forum”

cron