[Split] Problems with RC6 / Release of RC7

[Tripp]

I'm trying to update and I've been getting fatal errors due to mods. I just removed what it told me and got it all almost updated. Once it updates, it wants to check the files again to make sure they updated correctly.

Collecting file differences
Currently having differences about 0 from 389 files collected.
Please wait until file collection finished.

It just sits there at 0.

[The_Descendant]

Run the update again and you should find that all files have been updated.

[NeilUK]

I have the "invalid form" error but I am getting in the proSilver style. I have uploaded the new style files from the full package. In fact I used the full package option for upgrading RC5 to RC6, deleting all files first and then copying back the config file and then using database_update file. SubSilver works fine (apart from strangely telling me I have an unread PM when the inbox and outboxes are empty!)
But proSilver just won't have it, I used the SQL command mentioned earlier that clears the cache but no luck

Any Ideas?

(EDIT) - Its ok , I got the error for 5 mins or so but then worked fine. I guess there is a delay when using the SQL cache command


Thanks

[karlsemple]

I have the "invalid form" error but I am getting in the proSilver style. I have uploaded the new style files from the full package. In fact I used the full package option for upgrading RC5 to RC6, deleting all files first and then copying back the config file and then using database_update file. SubSilver works fine (apart from strangely telling me I have an unread PM when the inbox and outboxes are empty!)
But proSilver just won't have it, I used the SQL command mentioned earlier that clears the cache but no luck

Any Ideas?

it is likely that your board is still using the copy of prosilver which is stored in the database and thus out of date, you might want to read the sticky at the top of this forum on common RC6 updating issues and run the script to empty your styles_template_data database table to see if that helps

[r4wMUnt34q]

I did a fresh RC6 installation on XAMPPlite 1.6.4 and I cant purge my cache, delete the admin log after I click on "Yes" in the "Do you want to carry out this operation?", because it shows error 404... Should I post it to bug reports ?

[NeilUK]

Thanks Karl

I was just editing my post at the same time you replied, it never ceases to amaze me how quickly you and other members of the team reply. The SQL query did work, I guess there is a delay before it happening

Any ideas why subSilver2 thinks I have an unread pm?

[Tripp]

Got it updated and thought I had it all worked out until someone tried posting and got:

The submitted form was invalid. Try submitting again.

So I went and tried to post and got the same thing.

[The_Descendant]

Last night I updated my RC5 to RC6, now everything worked perfectly. However, I was having the Administrator problem, so I followed Highway of Life's thing directly, BUT actually deleted the files straight from the database in PHPmyadmin. Ya know the Template_id and things? Well, I deleted those, anyway I can get them back? I feel really, REALLY stupid now. And now I'm getting this:

SQL ERROR [ mysql4 ]

Unknown column 't.template_id' in 'field list' [1054]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

P.S. I have not made a backup. ;-;

Just quoting myself just in case someone hasn't seen this problem but knows the solution.

[Tripp]

Well, you just learned a good lesson. Always backup database.

[The_Descendant]

Yes... Thanks for the Tremendous help, thats solved all my problems. All I had to do was build a Time Machine to go back and backup my database.

Sarcasm!

Look, if you can't help me then don't bother posting.

[Nicholas the Italian]

Not sure I understand what you did or whether there is a way back; anyway, try asking your provider if they have a backup.

[karlsemple]

Assuming you are running mysql 4.1 or 5 Try running this sql query in phpmyadmin

Code: Select all

DROP TABLE IF EXISTS `phpbb3_styles_template`;
CREATE TABLE IF NOT EXISTS `phpbb_styles_template` (
  `template_id` smallint(4) unsigned NOT NULL auto_increment,
  `template_name` varchar(255) collate utf8_bin NOT NULL default '',
  `template_copyright` varchar(255) collate utf8_bin NOT NULL default '',
  `template_path` varchar(100) collate utf8_bin NOT NULL default '',
  `bbcode_bitfield` varchar(255) collate utf8_bin NOT NULL default 'kNg=',
  `template_storedb` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`template_id`),
  UNIQUE KEY `tmplte_nm` (`template_name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=3 ;

INSERT INTO `phpbb_styles_template` (`template_id`, `template_name`, `template_copyright`, `template_path`, `bbcode_bitfield`, `template_storedb`) VALUES 
(1, 0x70726f73696c766572, 0xc2a92070687042422047726f7570, 0x70726f73696c766572, 0x6c4e673d, 1);

DROP TABLE IF EXISTS `phpbb_styles_template_data`;
CREATE TABLE IF NOT EXISTS `phpbb3_styles_template_data` (
  `template_id` smallint(4) unsigned NOT NULL default '0',
  `template_filename` varchar(100) collate utf8_bin NOT NULL default '',
  `template_included` text collate utf8_bin NOT NULL,
  `template_mtime` int(11) unsigned NOT NULL default '0',
  `template_data` mediumtext collate utf8_bin NOT NULL,
  KEY `tid` (`template_id`),
  KEY `tfn` (`template_filename`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

[wmtipton]

Since Im not really into PHP or anything and dont want to deal with extra work now and then having to keep updating possibly a few more times before a gold release (and happy with RC5 as well)....is holding out for a gold release an ok idea for someone like me....or will the update from RC5 to a gold release be something that isnt going to be possible....ie, Ill still have to go from RC5 to RC6 first or something ?

Id rather do the work ONCE later at a gold release than possibly do it now and a few more times till gold.

[The_Descendant]

SQL query:

INSERT INTO `phpbb_styles_template` ( `template_id` , `template_name` , `template_copyright` , `template_path` , `bbcode_bitfield` , `template_storedb` )
VALUES ( 1, 0x70726f73696c766572, 0xc2a92070687042422047726f7570, 0x70726f73696c766572, 0x6c4e673d, 1 ) ;

MySQL said: Documentation
#1054 - Unknown column 'template_id' in 'field list'

Now what do I do?

[karlsemple]

If your forum is modified you are still going to have to use the patch or auto updater which means doing the RC5-RC6 update later on and then the RC7 update and etc.....(assuming there is more RC releases) My honest opinion is you would be better biting the bullet and getting it updated now