Database updating problem.

Support for upgrading any version of your phpBB3 installation
Forum rules
READ: StarTrekGuide.com Board Rules

Support for upgrading any version of phpBB3 to the most recent version.

Re: Database updating problem.

Postby stitch626 » 26 Jun 2008, 06:30

Understood but this is impossible.

I only have 3 databases on my server. I have my main board, my testboard and a photo gallery and they are all clearly named so there is no confusion. I have double checked my config.php file to just make extra sure it is indeed pointing to the correct database. Also I would like to mention that I just recently did a bigdump for this board so naturally I had to point bigdump in the correct direction.

Anyway for what it's worth, this problem was happening even before the bigdump.
User avatar
stitch626    
STG Moderator Leader
STG Moderator Leader
 
Posts: 3185
Joined: 08 Feb 2007, 20:47
Location: Michigan
Favorite Team: Detroit Red Wings
Gender: Male
phpBB Knowledge: 7




phpBB Academy at StarTrekGuide
Support STG
Using PayPal Donate

Re: Database updating problem.

Postby Highway of Life » 26 Jun 2008, 12:36

Try changing some config value in your ACP, change...
Say, -> Board Config -> Change sitename and site description.
Copy the values before you change them, paste them here, then paste your chagnes.
Then query the DB:
Code: Select all
SELECT * FROM phpbb_config WHERE config_name IN ('sitename', 'site_desc');

If that information is correct, go to your board index and see if the sitename and site description did indeed change.
Watch out! I might do a code wheelie!

User avatar
Highway of Life    
STG Jedi Master
STG Jedi Master
 
Posts: 10458
Joined: 08 May 2006, 05:23
Location: Beware of Programmers carrying screwdrivers
Gender: Male
phpBB Knowledge: 10

Re: Database updating problem.

Postby stitch626 » 26 Jun 2008, 17:48

Ok it is confirmed. This database is definitely the one connected to my board.
Attachments
before.JPG
after.JPG
User avatar
stitch626    
STG Moderator Leader
STG Moderator Leader
 
Posts: 3185
Joined: 08 Feb 2007, 20:47
Location: Michigan
Favorite Team: Detroit Red Wings
Gender: Male
phpBB Knowledge: 7

Re: Database updating problem.

Postby Highway of Life » 26 Jun 2008, 18:46

Now, with your sitename and site_desc changed, go to your update panel and see what it says now.
Also, open up your /cache/data_global.php file and see what your sitename, site_desc, and version values are now.
Watch out! I might do a code wheelie!

User avatar
Highway of Life    
STG Jedi Master
STG Jedi Master
 
Posts: 10458
Joined: 08 May 2006, 05:23
Location: Beware of Programmers carrying screwdrivers
Gender: Male
phpBB Knowledge: 10

Re: Database updating problem.

Postby stitch626 » 26 Jun 2008, 18:58

This is getting very interesting...

Nothing has changed in the Update panel. Still says I need to update. The data_global.php did change to reflect the sitename and site description.

I copied this from the file.
'site_desc' => 'This is After',
'sitename' => 'This is After',
User avatar
stitch626    
STG Moderator Leader
STG Moderator Leader
 
Posts: 3185
Joined: 08 Feb 2007, 20:47
Location: Michigan
Favorite Team: Detroit Red Wings
Gender: Male
phpBB Knowledge: 7

Re: Database updating problem.

Postby Highway of Life » 26 Jun 2008, 19:11

stitch626 wrote:Nothing has changed in the Update panel. Still says I need to update. The data_global.php did change to reflect the sitename and site description.
What about the version variable within the data_global.php file now?
Watch out! I might do a code wheelie!

User avatar
Highway of Life    
STG Jedi Master
STG Jedi Master
 
Posts: 10458
Joined: 08 May 2006, 05:23
Location: Beware of Programmers carrying screwdrivers
Gender: Male
phpBB Knowledge: 10

Re: Database updating problem.

Postby stitch626 » 26 Jun 2008, 19:13

Still the same as before:
'version_update_from' => '3.0.0',

Edit: Um, Don't know what's going on but I tried something just for kicks and giggles. I tried to switch the cache system for the style I am using from files system to database and there were no changes but when I tried to change it back I received this error and now it seems to be stuck on database. I wonder if this has anything to do with the update panel not updating.


Warning
The template file was unwritable so the template set is now stored in the database containing the modified file.
User avatar
stitch626    
STG Moderator Leader
STG Moderator Leader
 
Posts: 3185
Joined: 08 Feb 2007, 20:47
Location: Michigan
Favorite Team: Detroit Red Wings
Gender: Male
phpBB Knowledge: 7

Re: Database updating problem.

Postby Highway of Life » 26 Jun 2008, 23:16

stitch626 wrote:Still the same as before:
'version_update_from' => '3.0.0',
Wait, that is different now... but what is your phpbb_version, specifically. :)

You might want to ensure your cache directory is writeable (777)
Watch out! I might do a code wheelie!

User avatar
Highway of Life    
STG Jedi Master
STG Jedi Master
 
Posts: 10458
Joined: 08 May 2006, 05:23
Location: Beware of Programmers carrying screwdrivers
Gender: Male
phpBB Knowledge: 10

Re: Database updating problem.

Postby topdown » 26 Jun 2008, 23:55

Why does it say that ?
'version_update_from' => '3.0.0',


I just went and looked at my WU site which was updated and it has the normal variable

Code: Select all
'version' => '3.0.1',


What file is it that generates the info in the data_globle.php ? thats creating this version_update_from and the answer 3.0.0

Maybe the ACP is just reading the # under the variable containing version in it.

Edit: NM found the file that generates it, I suppose you knew off the top of your head HoL :rotfl: Its the only one in that dir acm/acm_file.php


That files code might be worth looking into
Do not PM me for Support unless I give permission in a post......PM's only help one, posts help everyone !
User avatar
topdown    
STG Styles Leader
STG Styles Leader
 
Posts: 3022
Joined: 01 Oct 2007, 22:56
Location: Handyman's harddrive
Favorite Team: STG Teams
Gender: Male
phpBB Knowledge: 9

Re: Database updating problem.

Postby stitch626 » 27 Jun 2008, 17:59

According to the column in my config table I am at 3.0.1 See screen shot. As fo the cache directory permissions were set at 775 which should be sufficient but just for kicks I changed it to 777.
Attachments
config.JPG
User avatar
stitch626    
STG Moderator Leader
STG Moderator Leader
 
Posts: 3185
Joined: 08 Feb 2007, 20:47
Location: Michigan
Favorite Team: Detroit Red Wings
Gender: Male
phpBB Knowledge: 7

PreviousNext

Return to phpBB3 upgrade support

Who is online

Users browsing this forum: No registered users and 2 guests