[Split] Problems with RC6 / Release of RC7

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Get Involved
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
User avatar
Nicholas the Italian
Registered User
Posts: 170
Joined: Tue Nov 21, 2006 5:18 pm

Re: Read this if you are experiening problems with RC6

Post by 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).
Whatever I say, it's not my fault.
User avatar
karlsemple
Former Team Member
Posts: 39802
Joined: Mon Nov 01, 2004 8:54 am
Location: Hereford, UK
Contact:

Re: Read this if you are experiening problems with RC6

Post by karlsemple »

karlsemple wrote: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 ;)
Image
The_Descendant
Registered User
Posts: 233
Joined: Thu Sep 13, 2007 5:48 pm

Re: Read this if you are experiening problems with RC6

Post by 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.
User avatar
karlsemple
Former Team Member
Posts: 39802
Joined: Mon Nov 01, 2004 8:54 am
Location: Hereford, UK
Contact:

Re: Read this if you are experiening problems with RC6

Post by karlsemple »

The_Descendant wrote: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.
Image
User avatar
wmtipton
Registered User
Posts: 564
Joined: Thu Apr 26, 2007 8:16 pm
Contact:

Re: Read this if you are experiening problems with RC6

Post by 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 :)
mysql database backup software - mysql Workbench
The_Descendant
Registered User
Posts: 233
Joined: Thu Sep 13, 2007 5:48 pm

Re: Read this if you are experiening problems with RC6

Post by 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
Registered User
Posts: 233
Joined: Thu Sep 13, 2007 5:48 pm

Re: Read this if you are experiening problems with RC6

Post by The_Descendant »

wmtipton wrote: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.
User avatar
Nicholas the Italian
Registered User
Posts: 170
Joined: Tue Nov 21, 2006 5:18 pm

Re: Read this if you are experiening problems with RC6

Post by 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.
Whatever I say, it's not my fault.
The_Descendant
Registered User
Posts: 233
Joined: Thu Sep 13, 2007 5:48 pm

Re: Read this if you are experiening problems with RC6

Post by 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. :lol:
The_Descendant
Registered User
Posts: 233
Joined: Thu Sep 13, 2007 5:48 pm

Re: Read this if you are experiening problems with RC6

Post by 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. :(
User avatar
wmtipton
Registered User
Posts: 564
Joined: Thu Apr 26, 2007 8:16 pm
Contact:

Re: Read this if you are experiening problems with RC6

Post by wmtipton »

The_Descendant wrote:
wmtipton wrote: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 :)
mysql database backup software - mysql Workbench
The_Descendant
Registered User
Posts: 233
Joined: Thu Sep 13, 2007 5:48 pm

Re: Read this if you are experiening problems with RC6

Post by The_Descendant »

I don't have a backup so the rebuilding is what I want. :?
User avatar
r4wMUnt34q
Registered User
Posts: 167
Joined: Sat Aug 19, 2006 5:41 am
Location: Hard to explain :)
Contact:

Re: Read this if you are experiening problems with RC6

Post by r4wMUnt34q »

I hope there will be less problems when RC7 comes out.
User avatar
karlsemple
Former Team Member
Posts: 39802
Joined: Mon Nov 01, 2004 8:54 am
Location: Hereford, UK
Contact:

Re: Read this if you are experiening problems with RC6

Post by karlsemple »

The_Descendant wrote: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;
Image
nightclaw
Registered User
Posts: 20
Joined: Wed Jul 11, 2007 2:44 pm
Name: Sebastian
Contact:

Re: Read this if you are experiening problems with RC6

Post by 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.
Locked

Return to “[3.0.x] Support Forum”