[Split] Problems with RC6 / Release of RC7

[Nicholas the Italian]

There's a little error in the query karl gave you.
Line 1 should be

Code: Select all

DROP TABLE `phpbb_styles_template`;

(assuming you gave phpbb_ prefix to your tables).

[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;

??? mine includes the drop table command

[The_Descendant]

I changed it to DROP TABLE (instead of IF EXISTS), and now its deleted the whole thing and I have this error:

Table '(SQL_DATABASE).phpbb_styles_template_data' doesn't exist [1146]

SQL database replaces my SQL database.

[karlsemple]

I changed it to DROP TABLE (instead of IF EXISTS), and now its deleted the whole thing and I have this error:

Table '(SQL_DATABASE).phpbb_styles_template_data' doesn't exist [1146]

SQL database replaces my SQL database.

change phpbb_ to match your table prefix if it is not the default.

[wmtipton]

Can I get clarification on something ?

Im using the Arrow style for my boards with RC5.
If I do manage somehow to update to RC6...am I understanding this correctly that I wont be able to use Arrow anymore until its also changed to work with RC6 ?

thanks

[The_Descendant]

It is my default, and when I search for the table it is just not there anymore. With the query you gave me (karlsemple) it used to still be there. So, is this good... or bad?

[The_Descendant]

Can I get clarification on something ?

Im using the Arrow style for my boards with RC5.
If I do manage somehow to update to RC6...am I understanding this correctly that I wont be able to use Arrow anymore until its also changed to work with RC6 ?

thanks

No you won't be able to use it. You should go to the place where you got the style and it should have the update there soon enough. However, if you follow the detailed steps you'll be able to convert it to phpBB 3.0.x RC6 yourself.

[Nicholas the Italian]

The_Descendant, this is the query Karl gave you:

Code: Select all

DROP TABLE IF EXISTS `phpbb3_styles_template`; // the prefix is wrong! this table doesn't exist - won't be removed
CREATE TABLE IF NOT EXISTS `phpbb_styles_template`... // the table still exists, so does nothing
INSERT INTO `phpbb_styles_template` ... // still using the old table, with the missing field => error

DROP TABLE IF EXISTS `phpbb_styles_template_data`; // prefix is correct, table is dropped
CREATE TABLE IF NOT EXISTS `phpbb3_styles_template_data` ... // and here is recreated

I changed phpbb3_ to phpbb_, the "IF EXISTS" part is optional (and karl, I would avoid it as it hides whether something went wrong before ).

So, make sure you remove both tables and recreate them, plus insert the default value in the first one.

[The_Descendant]

I get this problem now...

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists. in (SITE INFO HERE)/public_html/includes/db/dbal.php on line 589

I hope upgrading to Gold isn't as hard.

[The_Descendant]

Sorry to be so troublesome Nicholas, but do you suppose you could edit the code fully? I'm not good with any of this phpmyadmin things and I get confused easily.

[wmtipton]

Can I get clarification on something ?

Im using the Arrow style for my boards with RC5.
If I do manage somehow to update to RC6...am I understanding this correctly that I wont be able to use Arrow anymore until its also changed to work with RC6 ?

thanks

No you won't be able to use it. You should go to the place where you got the style and it should have the update there soon enough. However, if you follow the detailed steps you'll be able to convert it to phpBB 3.0.x RC6 yourself.

Thanks.
Thats enough for me to wait for a while before changing anything.
Ive worked really hard to get my main site and all of my forums to look the same, until Im sure that I can update the software and get it all up and running looking like it is all in one sitting Im just not moving from RC5.

Thanks for the help guys

[The_Descendant]

I don't have a backup so the rebuilding is what I want.

[r4wMUnt34q]

I hope there will be less problems when RC7 comes out.

[karlsemple]

Sorry to be so troublesome Nicholas, but do you suppose you could edit the code fully? I'm not good with any of this phpmyadmin things and I get confused easily.

Code: Select all

DROP TABLE IF EXISTS `phpbb_styles_template`;
CREATE TABLE `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` VALUES (1, 0x70726f73696c766572, 0xc2a92070687042422047726f7570, 0x70726f73696c766572, 0x6c4e673d, 1);

DROP TABLE IF EXISTS `phpbb_styles_template_data`;
CREATE TABLE `phpbb_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;

[nightclaw]

Hi, when a user tries to use the 'lost password' function the following error occurs.
i today did the update from rc5->6 with the auto-updater
i'm using pro-silver style and only 3 mods, which should not interfere with this function
(seo url, mod update check, evil quick reply)
the error log is empty

Code: Select all

General Error
SQL ERROR [ mysqli ]

Data too long for column 'user_newpasswd' at row 1 [1406]

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