8.2c to 9.0 --Mysql tables not updating properly!!! :: Archived

mortal.seraphim

Here's the rows that are created in a new install.

Code::

$installer->add_query('INSERT', 'bbconfig', "'allow_html', '0'");
$installer->add_query('INSERT', 'bbconfig', "'allow_html_tags', 'b,i,u,pre'");
$installer->add_query('INSERT', 'bbconfig', "'allow_bbcode', '1'");
$installer->add_query('INSERT', 'bbconfig', "'allow_smilies', '1'");
$installer->add_query('INSERT', 'bbconfig', "'allow_sig', '1'");
$installer->add_query('INSERT', 'bbconfig', "'allow_namechange', '0'");
$installer->add_query('INSERT', 'bbconfig', "'allow_theme_create', '0'");
$installer->add_query('INSERT', 'bbconfig', "'allow_avatar_local', '1'");
$installer->add_query('INSERT', 'bbconfig', "'allow_avatar_remote', '1'");
$installer->add_query('INSERT', 'bbconfig', "'allow_avatar_upload', '0'");
$installer->add_query('INSERT', 'bbconfig', "'override_user_style', '1'");
$installer->add_query('INSERT', 'bbconfig', "'posts_per_page', '15'");
$installer->add_query('INSERT', 'bbconfig', "'topics_per_page', '50'");
$installer->add_query('INSERT', 'bbconfig', "'hot_threshold', '25'");
$installer->add_query('INSERT', 'bbconfig', "'max_poll_options', '10'");
$installer->add_query('INSERT', 'bbconfig', "'max_inbox_privmsgs', '100'");
$installer->add_query('INSERT', 'bbconfig', "'max_sentbox_privmsgs', '100'");
$installer->add_query('INSERT', 'bbconfig', "'max_savebox_privmsgs', '100'");
$installer->add_query('INSERT', 'bbconfig', "'board_email_sig', 'Thanks,  Webmaster @ MySite.com'");
$installer->add_query('INSERT', 'bbconfig', "'smtp_delivery', '0'");
$installer->add_query('INSERT', 'bbconfig', "'smtp_host', ''");
$installer->add_query('INSERT', 'bbconfig', "'require_activation', '0'");
$installer->add_query('INSERT', 'bbconfig', "'flood_interval', '15'");
$installer->add_query('INSERT', 'bbconfig', "'board_email_form', '0'");
$installer->add_query('INSERT', 'bbconfig', "'default_style', '1'");
$installer->add_query('INSERT', 'bbconfig', "'default_dateformat', 'D M d, Y g:i a'");
$installer->add_query('INSERT', 'bbconfig', "'board_timezone', '0'");
$installer->add_query('INSERT', 'bbconfig', "'prune_enable', '0'");
$installer->add_query('INSERT', 'bbconfig', "'coppa_fax', ''");
$installer->add_query('INSERT', 'bbconfig', "'coppa_mail', ''");
$installer->add_query('INSERT', 'bbconfig', "'board_startdate', '".gmtime()."'");
$installer->add_query('INSERT', 'bbconfig', "'default_lang', 'english'");
$installer->add_query('INSERT', 'bbconfig', "'smtp_username', ''");
$installer->add_query('INSERT', 'bbconfig', "'smtp_password', ''");
$installer->add_query('INSERT', 'bbconfig', "'record_online_users', '2'");
$installer->add_query('INSERT', 'bbconfig', "'record_online_date', '1034668530'");
$installer->add_query('INSERT', 'bbconfig', "'version', '.0.0'");
$installer->add_query('INSERT', 'bbconfig', "'enable_confirm', '0'");
$installer->add_query('INSERT', 'bbconfig', "'sendmail_fix', '0'");

I compared these to the ones that I currently have in my table and 20 of them are not in my table (from smtp_delivery down)

Unless I'm missing something, none of them seem to store the setting for PM quick reply.

Nuance · Gold Supporter Offline Joined: Dec 30, 2004 Posts: 223

Yeah, I don't see anything that looks like it would hold the values for pm quick reply toggles. I've submitted a formal bug report on this issue, so I guess we just wait and see what turns up.

mortal.seraphim

Good call, I guess we'll see what happens, hopefully someone will figure it out.

Thanks for helping me today.

Śyama_Dāsa

58 rows- here are my values locally atm

Code::

INSERT INTO `cms_bbconfig` VALUES ('config_id', '1');
INSERT INTO `cms_bbconfig` VALUES ('board_disable', '0');
INSERT INTO `cms_bbconfig` VALUES ('sitename', 'MySite.com');
INSERT INTO `cms_bbconfig` VALUES ('site_desc', '');
INSERT INTO `cms_bbconfig` VALUES ('cookie_name', 'cms_phpbb');
INSERT INTO `cms_bbconfig` VALUES ('cookie_path', '/');
INSERT INTO `cms_bbconfig` VALUES ('cookie_domain', '');
INSERT INTO `cms_bbconfig` VALUES ('allow_html', '1');
INSERT INTO `cms_bbconfig` VALUES ('allow_html_tags', 'b,i,u,pre');
INSERT INTO `cms_bbconfig` VALUES ('allow_bbcode', '1');
INSERT INTO `cms_bbconfig` VALUES ('allow_smilies', '1');
INSERT INTO `cms_bbconfig` VALUES ('allow_sig', '1');
INSERT INTO `cms_bbconfig` VALUES ('allow_namechange', '0');
INSERT INTO `cms_bbconfig` VALUES ('allow_theme_create', '0');
INSERT INTO `cms_bbconfig` VALUES ('allow_avatar_local', '1');
INSERT INTO `cms_bbconfig` VALUES ('allow_avatar_remote', '1');
INSERT INTO `cms_bbconfig` VALUES ('allow_avatar_upload', '0');
INSERT INTO `cms_bbconfig` VALUES ('override_user_style', '1');
INSERT INTO `cms_bbconfig` VALUES ('posts_per_page', '15');
INSERT INTO `cms_bbconfig` VALUES ('topics_per_page', '50');
INSERT INTO `cms_bbconfig` VALUES ('hot_threshold', '25');
INSERT INTO `cms_bbconfig` VALUES ('max_poll_options', '10');
INSERT INTO `cms_bbconfig` VALUES ('max_sig_chars', '255');
INSERT INTO `cms_bbconfig` VALUES ('max_inbox_privmsgs', '100');
INSERT INTO `cms_bbconfig` VALUES ('max_sentbox_privmsgs', '100');
INSERT INTO `cms_bbconfig` VALUES ('max_savebox_privmsgs', '100');
INSERT INTO `cms_bbconfig` VALUES ('board_email_sig', 'Thanks,  Webmaster @ MySite.com');
INSERT INTO `cms_bbconfig` VALUES ('board_email', 'Webmaster@MySite.com');
INSERT INTO `cms_bbconfig` VALUES ('smtp_delivery', '0');
INSERT INTO `cms_bbconfig` VALUES ('smtp_host', '');
INSERT INTO `cms_bbconfig` VALUES ('require_activation', '0');
INSERT INTO `cms_bbconfig` VALUES ('flood_interval', '20');
INSERT INTO `cms_bbconfig` VALUES ('board_email_form', '1');
INSERT INTO `cms_bbconfig` VALUES ('avatar_filesize', '6144');
INSERT INTO `cms_bbconfig` VALUES ('avatar_max_width', '80');
INSERT INTO `cms_bbconfig` VALUES ('avatar_max_height', '80');
INSERT INTO `cms_bbconfig` VALUES ('avatar_path', 'images/avatars');
INSERT INTO `cms_bbconfig` VALUES ('avatar_gallery_path', 'images/avatars');
INSERT INTO `cms_bbconfig` VALUES ('smilies_path', 'images/smiles');
INSERT INTO `cms_bbconfig` VALUES ('default_style', '1');
INSERT INTO `cms_bbconfig` VALUES ('default_dateformat', 'D M d, Y g:i a');
INSERT INTO `cms_bbconfig` VALUES ('board_timezone', '0');
INSERT INTO `cms_bbconfig` VALUES ('prune_enable', '0');
INSERT INTO `cms_bbconfig` VALUES ('privmsg_disable', '0');
INSERT INTO `cms_bbconfig` VALUES ('gzip_compress', '0');
INSERT INTO `cms_bbconfig` VALUES ('coppa_fax', '');
INSERT INTO `cms_bbconfig` VALUES ('coppa_mail', '');
INSERT INTO `cms_bbconfig` VALUES ('board_startdate', '1094194401');
INSERT INTO `cms_bbconfig` VALUES ('default_lang', 'english');
INSERT INTO `cms_bbconfig` VALUES ('smtp_username', '');
INSERT INTO `cms_bbconfig` VALUES ('smtp_password', '');
INSERT INTO `cms_bbconfig` VALUES ('record_online_users', '2');
INSERT INTO `cms_bbconfig` VALUES ('record_online_date', '1034668530');
INSERT INTO `cms_bbconfig` VALUES ('server_name', 'MySite.com');
INSERT INTO `cms_bbconfig` VALUES ('server_port', '80');
INSERT INTO `cms_bbconfig` VALUES ('version', '.0.0');
INSERT INTO `cms_bbconfig` VALUES ('enable_confirm', '0');
INSERT INTO `cms_bbconfig` VALUES ('sendmail_fix', '0');

Nuance · Gold Supporter Offline Joined: Dec 30, 2004 Posts: 223

hmmm... my tables match up with your's akamu-- any thoughts on why me and mortal can't save our pm quick reply settings?

Phoenix

It would appear that at least these 2 these fields are missing,
ropm_quick_reply 1
ropm_quick_reply_bbc 1

However, they are remnants in my database, and I can't find them in any recent DFC release. My last test on a new install was not the most recent releases, so it appears I may have misled you earlier Sad

They do update in the database, but just don't show any change in radio button status in the config display.

Bottom line, there is an install bug for at least these fields, as well as a bug in the config display.

Nuance · Gold Supporter Offline Joined: Dec 30, 2004 Posts: 223

Thanks for posting which two fields are missing; I can insert them manually to make it work. Your help with this is very much appreciated.

mortal.seraphim

YAY! It works now... coolness.

Tank863

How do you insert these 2 lines?
What is the code?

Thanks/...

mortal.seraphim

I just manually inserted the rows into the bbconfig table...

Phoenix

INSERT INTO `cms_bbconfig` VALUES ('ropm_quick_reply', '1');
INSERT INTO `cms_bbconfig` VALUES ('ropm_quick_reply_bbc', '1');

where cms = your prefix.

vitnicalt

Upgrading from 8.2c to 9.0.1.1 in italian, i had this error message:
ALTER TABLE cms_history ADD language varchar(30) NOT NULL
Nome colonna duplicato 'language'

I think there is a strange database's tables situation!
I had to comment a few lines in cpg9x.inc to continue the istallation:

Code::

//$installer->add_query('DEL', 'referer', 'rid');	rimossa13/02/2005	
//$installer->add_query('DEL', 'topics', 'topicname');	rimossa

//if (isset($tablelist['pages'])) {
//    $installer->add_query('CHANGE', 'pages', '`clanguage` `language` varchar(30) NOT NULL DEFAULT ""', '`language` `clanguage` varchar(30) NOT NULL DEFAULT ""');
//}

But i can't go on like this!! Where is a SQL reference for Dragonfly 9.0.0.1?

I'm trying on a localserver, before upgrading a site on line. But, if I backup the Database of 8.2c, will I be able to restore it on 9.0.0.1?

Thanks a lot!