Upgrade fail - I flipping should have known.

Reply·Subscribe
CALTRADE
CALTRADEAdvanced
2898 posts
0
 

I followed the instructions like a cookbook, and just destroyed my site.   Here is what I got on the last step where you log into the admin panel:   Can anyone help me.  I am trying not to be pissed.

......................

Database query error
Query:
SELECT `Name` FROM `sys_localization_languages` AS `l` INNER JOIN `Profiles` AS `p` ON (`p`.`LangID` = `l`.`ID`) WHERE `p`.`ID` = 3311
Mysql error:
Column 'Name' in field list is ambiguous
 
Found error in the file '/var/www/vhosts/CALTRADE.com/httpdocs/community/inc/languages.inc.php' at line 151.
Called 'fromMemory' function with erroneous argument #2.

Debug backtrace:
Array
(
    [1] => Array
        (
            [file] => /var/www/vhosts/CALTRADE.com/httpdocs/community/inc/classes/BxDolDb.php
            [line] => 237
            [function] => error
            [class] => BxDolDb
            [object] => BxDolDb Object
                (
                    [error_checking] => 1
                    [error_message] => Column 'Name' in field list is ambiguous
                    [host] => localhost
                    [port] => 
                    [socket] => 
                    [dbname] => robgcaltrade7
                    [user] => *****
                    [password] => *****
                    [link] => Resource id #25
                    [current_res] => 
                    [current_arr_type] => 1
                    [oParams] => BxDolParams Object
                        (
                            [_oDb] => BxDolDb Object
 *RECURSION*
                            [_oCache] => BxDolCacheFile Object
                                (
                                    [sPath] => /var/www/vhosts/CALTRADE.com/httpdocs/community/cache/
                                )

                            [_sCacheFile] => sys_options_8fbd6f0b68e8b19c2e096f883e093f08.php
                            [_aParams] => [truncated]
                        )

                    [oDbCacheObject] => BxDolCacheFile Object
                        (
                            [sPath] => /var/www/vhosts/CALTRADE.com/httpdocs/community/cache/
                        )

                )

            [type] => ->
            [args] => Array
                (
                    [0] => Database query error
                    [1] => 
                    [2] => SELECT `Name` FROM `sys_localization_languages` AS `l` INNER JOIN `Profiles` AS `p` ON (`p`.`LangID` = `l`.`ID`) WHERE `p`.`ID` = 3311
                )

        )

    [2] => Array
        (
            [file] => /var/www/vhosts/CALTRADE.com/httpdocs/community/inc/classes/BxDolDb.php
            [line] => 135
            [function] => res
            [class] => BxDolDb
            [object] => BxDolDb Object
                (
                    [error_checking] => 1
                    [error_message] => Column 'Name' in field list is ambiguous
                    [host] => localhost
                    [port] => 
                    [socket] => 
                    [dbname] => robgcaltrade7
                    [user] => *****
                    [password] => *****
                    [link] => Resource id #25
                    [current_res] => 
                    [current_arr_type] => 1
                    [oParams] => BxDolParams Object
                        (
                            [_oDb] => BxDolDb Object
 *RECURSION*
                            [_oCache] => BxDolCacheFile Object
                                (
                                    [sPath] => /var/www/vhosts/CALTRADE.com/httpdocs/community/cache/
                                )

                            [_sCacheFile] => sys_options_8fbd6f0b68e8b19c2e096f883e093f08.php
                            [_aParams] => [truncated]
                        )

                    [oDbCacheObject] => BxDolCacheFile Object
                        (
                            [sPath] => /var/www/vhosts/CALTRADE.com/httpdocs/community/cache/
                        )

                )

            [type] => ->
            [args] => Array
                (
                    [0] => SELECT `Name` FROM `sys_localization_languages` AS `l` INNER JOIN `Profiles` AS `p` ON (`p`.`LangID` = `l`.`ID`) WHERE `p`.`ID` = 3311
                )

        )

    [3] => Array
        (
            [function] => getOne
            [class] => BxDolDb
            [object] => BxDolDb Object
                (
                    [error_checking] => 1
                    [error_message] => Column 'Name' in field list is ambiguous
                    [host] => localhost
                    [port] => 
                    [socket] => 
                    [dbname] => robgcaltrade7
                    [user] => *****
                    [password] => *****
                    [link] => Resource id #25
                    [current_res] => 
                    [current_arr_type] => 1
                    [oParams] => BxDolParams Object
                        (
                            [_oDb] => BxDolDb Object
 *RECURSION*
                            [_oCache] => BxDolCacheFile Object
                                (
                                    [sPath] => /var/www/vhosts/CALTRADE.com/httpdocs/community/cache/
                                )

                            [_sCacheFile] => sys_options_8fbd6f0b68e8b19c2e096f883e093f08.php
                            [_aParams] => [truncated]
                        )

                    [oDbCacheObject] => BxDolCacheFile Object
                        (
                            [sPath] => /var/www/vhosts/CALTRADE.com/httpdocs/community/cache/
                        )

                )

            [type] => ->
            [args] => Array
                (
                    [0] => SELECT `Name` FROM `sys_localization_languages` AS `l` INNER JOIN `Profiles` AS `p` ON (`p`.`LangID` = `l`.`ID`) WHERE `p`.`ID` = 3311
                )

        )

    [4] => Array
        (
            [file] => /var/www/vhosts/CALTRADE.com/httpdocs/community/inc/classes/BxDolDb.php
            [line] => 572
            [function] => call_user_func_array
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => BxDolDb Object
                                (
                                    [error_checking] => 1
                                    [error_message] => Column 'Name' in field list is ambiguous
                                    [host] => localhost
                                    [port] => 
                                    [socket] => 
                                    [dbname] => robgcaltrade7
                                    [user] => *****
                                    [password] => *****
                                    [link] => Resource id #25
                                    [current_res] => 
                                    [current_arr_type] => 1
                                    [oParams] => BxDolParams Object
                                        (
                                            [_oDb] => BxDolDb Object
 *RECURSION*
                                            [_oCache] => BxDolCacheFile Object
                                                (
                                                    [sPath] => /var/www/vhosts/CALTRADE.com/httpdocs/community/cache/
                                                )

                                            [_sCacheFile] => sys_options_8fbd6f0b68e8b19c2e096f883e093f08.php
                                            [_aParams] => [truncated]
                                        )

                                    [oDbCacheObject] => BxDolCacheFile Object
                                        (
                                            [sPath] => /var/www/vhosts/CALTRADE.com/httpdocs/community/cache/
                                        )

                                )

                            [1] => getOne
                        )

                    [1] => Array
                        (
                            [0] => SELECT `Name` FROM `sys_localization_languages` AS `l` INNER JOIN `Profiles` AS `p` ON (`p`.`LangID` = `l`.`ID`) WHERE `p`.`ID` = 3311
                        )

                )

        )

    [5] => Array
        (
            [file] => /var/www/vhosts/CALTRADE.com/httpdocs/community/inc/languages.inc.php
            [line] => 151
            [function] => fromMemory
            [class] => BxDolDb
            [object] => BxDolDb Object
                (
                    [error_checking] => 1
                    [error_message] => Column 'Name' in field list is ambiguous
                    [host] => localhost
                    [port] => 
                    [socket] => 
                    [dbname] => robgcaltrade7
                    [user] => *****
                    [password] => *****
                    [link] => Resource id #25
                    [current_res] => 
                    [current_arr_type] => 1
                    [oParams] => BxDolParams Object
                        (
                            [_oDb] => BxDolDb Object
 *RECURSION*
                            [_oCache] => BxDolCacheFile Object
                                (
                                    [sPath] => /var/www/vhosts/CALTRADE.com/httpdocs/community/cache/
                                )

                            [_sCacheFile] => sys_options_8fbd6f0b68e8b19c2e096f883e093f08.php
                            [_aParams] => [truncated]
                        )

                    [oDbCacheObject] => BxDolCacheFile Object
                        (
                            [sPath] => /var/www/vhosts/CALTRADE.com/httpdocs/community/cache/
                        )

                )

            [type] => ->
            [args] => Array
                (
                    [0] => profile_lang_3311
                    [1] => getOne
                    [2] => SELECT `Name` FROM `sys_localization_languages` AS `l` INNER JOIN `Profiles` AS `p` ON (`p`.`LangID` = `l`.`ID`) WHERE `p`.`ID` = 3311
                )

        )

    [6] => Array
        (
            [file] => /var/www/vhosts/CALTRADE.com/httpdocs/community/inc/languages.inc.php
            [line] => 42
            [function] => getProfileLangName
            [args] => Array
                (
                )

        )

    [7] => Array
        (
            [file] => /var/www/vhosts/CALTRADE.com/httpdocs/community/inc/languages.inc.php
            [line] => 11
            [function] => getCurrentLangName
            [args] => Array
                (
                    [0] => 
                )

        )

    [8] => Array
        (
            [file] => /var/www/vhosts/CALTRADE.com/httpdocs/community/inc/admin_design.inc.php
            [line] => 12
            [args] => Array
                (
                    [0] => /var/www/vhosts/CALTRADE.com/httpdocs/community/inc/languages.inc.php
                )

            [function] => require_once
        )

    [9] => Array
        (
            [file] => /var/www/vhosts/CALTRADE.com/httpdocs/community/inc/admin.inc.php
            [line] => 11
            [args] => Array
                (
                    [0] => /var/www/vhosts/CALTRADE.com/httpdocs/community/inc/admin_design.inc.php
                )

            [function] => require_once
        )

    [10] => Array
        (
            [file] => /var/www/vhosts/CALTRADE.com/httpdocs/community/inc/design.inc.php
            [line] => 9
            [args] => Array
                (
                    [0] => /var/www/vhosts/CALTRADE.com/httpdocs/community/inc/admin.inc.php
                )

            [function] => require_once
        )

    [11] => Array
        (
            [file] => /var/www/vhosts/CALTRADE.com/httpdocs/community/inc/profiles.inc.php
            [line] => 9
            [args] => Array
                (
                    [0] => /var/www/vhosts/CALTRADE.com/httpdocs/community/inc/design.inc.php
                )

            [function] => require_once
        )

    [12] => Array
        (
            [file] => /var/www/vhosts/CALTRADE.com/httpdocs/community/administration/index.php
            [line] => 9
            [args] => Array
                (
                    [0] => /var/www/vhosts/CALTRADE.com/httpdocs/community/inc/profiles.inc.php
                )

            [function] => require_once
        )

)
Settings:
array (
  'ext_nav_menu_enabled' => 'on',
  'ext_nav_menu_top_position' => 'bottom',
  'sys_security_impact_threshold_log' => '-1',
  'sys_security_impact_threshold_block' => '-1',
  'sys_security_form_token_enable' => 'on',
  'sys_security_form_token_lifetime' => '86400',
  'sys_recaptcha_key_public' => '',
  'sys_recaptcha_key_private' => '',
  'enable_watermark' => '',
  'transparent1' => '0',
  'Water_Mark' => '',
  'lang_default' => 'en',
  'sys_calendar_starts_sunday' => '',
  'time_format_php' => 'H:i',
  'short_date_format_php' => 'd.m.Y',
  'date_format_php' => 'd.m.Y H:i',
  'time_format' => '%H:%i',
  'short_date_format' => '%d.%m.%Y',
  'date_format' => '%d.%m.%Y %H:%i',
  'enable_member_store_ip' => 'on',
  'ipBlacklistMode' => '2',
  'ipListGlobalType' => '0',
  'sys_dnsbl_enable' => '',
  'sys_uridnsbl_enable' => 'on',
  'sys_akismet_enable' => '',
  'sys_akismet_api_key' => '',
  'sys_antispam_block' => '',
  'sys_antispam_report' => 'on',
  'enable_cache_system' => 'on',
  'sys_db_cache_enable' => 'on',
  'sys_db_cache_engine' => 'File',
  'sys_cache_memcache_host' => '',
  'sys_cache_memcache_port' => '11211',
  'sys_pb_cache_enable' => 'on',
  'sys_pb_cache_engine' => 'File',
  'sys_mm_cache_engine' => 'File',
  'sys_template_cache_enable' => '',
  'sys_template_cache_engine' => 'FileHtml',
  'sys_template_cache_css_enable' => '',
  'sys_template_cache_js_enable' => '',
  'sys_template_cache_compress_enable' => 'on',
  'tags_non_parsable' => 'hi, hey, hello, all, i, i'm, i'd, am, for, in, to, a, the, on, it's, is, my, of, are, from, i'm, me, you, and, we, not, will, at, where, there, business',
  'tags_min_rating' => '2',
  'tags_perpage_browse' => '100',
  'tags_show_limit' => '100',
  'enable_modrewrite' => 'on',
  'permalinks_browse' => 'on',
  'categ_perpage_browse' => '30',
  'categ_show_limit' => '50',
  'categ_show_columns' => '3',
  'sys_tmp_version' => '7.1.0.B1',
  'license_code' => '3K8MHZQA',
  'license_expiration' => '0',
  'license_checksum' => '9f68431c839d419262e9d72b7052b543',
  'enable_dolphin_footer' => '',
  'sys_ftp_login' => '',
  'sys_ftp_password' => '',
  'sys_ftp_dir' => '',
  'splash_editor' => 'on',
  'splash_code' => '<div class="bx-splash" style="position:relative; height:237px; background-repeat:no-repeat; background-position:0px 0px; background-image:url(templates/base/images/bx_splash_image.jpg)">
    <div class="bx-splash-txt-bg" style="position:absolute; z-index:1; bottom:0px; width:100%; height:96px; background-color:#ffffff; opacity:0.7;">
        <img src="templates/base/images/spacer.gif" />
    </div>
    <div class="bx-splash-txt" style="position:absolute; z-index:2; bottom:0px; width:100%; height:96px;">
        <div class="bx-splash-txt-cnt bx-def-margin" style="position:relative; opacity:1.0;">
            <div class="bx-splash-txt-l1" style="font-size: 36px;">Welcome to the community!</div>
            <div class="bx-splash-txt-l2 bx-def-font-grayed" style="font-size:14px;">This social networking site is powered by <a href="http://www.boonex.com/dolphin">Dolphin Community Software</a> from BoonEx.</div>
            <div class="bx-splash-action bx-def-padding-sec-topbottom" style="position:absolute; top:0px; right:0px;">
                <button class="bx-btn bx-btn-primary" onclick="window.open ('join.php','_self');">Join</button>
                <button class="bx-btn" style="margin-left:10px;" onclick="showPopupLoginForm(); return false;">Login</button>
            </div>
        </div>
    </div>
</div>',
  'splash_visibility' => 'index',
  'splash_logged' => 'on',
  'sys_html_fields' => 'a:12:{s:6:"system";a:4:{i:0;s:12:"POST.message";i:1;s:15:"REQUEST.message";i:2;s:12:"POST.CmtText";i:3;s:15:"REQUEST.CmtText";}s:5:"blogs";a:4:{i:0;s:13:"POST.PostText";i:1;s:16:"REQUEST.PostText";i:2;s:16:"POST.Description";i:3;s:19:"REQUEST.Description";}s:6:"groups";a:2:{i:0;s:9:"POST.desc";i:1;s:12:"REQUEST.desc";}s:4:"news";a:2:{i:0;s:12:"POST.content";i:1;s:15:"REQUEST.content";}s:5:"forum";a:4:{i:0;s:15:"POST.topic_text";i:1;s:18:"REQUEST.topic_text";i:2;s:14:"POST.post_text";i:3;s:17:"REQUEST.post_text";}s:3:"ads";a:2:{i:0;s:12:"POST.Message";i:1;s:15:"REQUEST.Message";}s:8:"articles";a:2:{i:0;s:12:"POST.content";i:1;s:15:"REQUEST.content";}s:6:"events";a:2:{i:0;s:16:"POST.Description";i:1;s:19:"REQUEST.Description";}s:5:"sites";a:2:{i:0;s:16:"POST.description";i:1;s:19:"REQUEST.description";}s:5:"store";a:2:{i:0;s:9:"POST.desc";i:1;s:12:"REQUEST.desc";}s:8:"feedback";a:2:{i:0;s:12:"POST.content";i:1;s:15:"REQUEST.content";}s:19:"system_profile_html";a:4:{i:0;s:20:"POST.DescriptionMe.0";i:1;s:20:"POST.DescriptionMe.1";i:2;s:23:"REQUEST.DescriptionMe.0";i:3;s:23:"REQUEST.DescriptionMe.1";}}',
  'sys_json_fields' => '',
  'sys_exceptions_fields' => 'a:3:{s:22:"system_email_templates";a:344:{i:0;s:36:"POST.bx_events_admin_become_fan_Body";i:1;s:39:"REQUEST.bx_events_admin_become_fan_Body";i:2;s:39:"POST.bx_events_admin_become_fan_Subject";i:3;s:42:"REQUEST.bx_events_admin_become_fan_Subject";i:4;s:29:"POST.bx_events_broadcast_Body";i:5;s:32:"REQUEST.bx_events_broadcast_Body";i:6;s:32:"POST.bx_events_broadcast_Subject";i:7;s:35:"REQUEST.bx_events_broadcast_Subject";i:8;s:36:"POST.bx_events_fan_become_admin_Body";i:9;s:39:"REQUEST.bx_events_fan_become_admin_Body";i:10;s:39:"POST.bx_events_fan_become_admin_Subject";i:11;s:42:"REQUEST.bx_events_fan_become_admin_Subject";i:12;s:30:"POST.bx_events_fan_remove_Body";i:13;s:33:"REQUEST.bx_events_fan_remove_Body";i:14;s:33:"POST.bx_events_fan_remove_Subject";i:15;s:36:"REQUEST.bx_events_fan_remove_Subject";i:16;s:30:"POST.bx_events_invitation_Body";i:17;s:33:"REQUEST.bx_events_invitation_Body";i:18;s:33:"POST.bx_events_invitation_Subject";i:19;s:36:"REQUEST.bx_events_invitation_Subject";i:20;s:32:"POST.bx_events_join_confirm_Body";i:21;s:35:"REQUEST.bx_events_join_confirm_Body";i:22;s:35:"POST.bx_events_join_confirm_Subject";i:23;s:38:"REQUEST.bx_events_join_confirm_Subject";i:24;s:31:"POST.bx_events_join_reject_Body";i:25;s:34:"REQUEST.bx_events_join_reject_Body";i:26;s:34:"POST.bx_events_join_reject_Subject";i:27;s:37:"REQUEST.bx_events_join_reject_Subject";i:28;s:32:"POST.bx_events_join_request_Body";i:29;s:35:"REQUEST.bx_events_join_request_Body";i:30;s:35:"POST.bx_events_join_request_Subject";i:31;s:38:"REQUEST.bx_events_join_request_Subject";i:32;s:23:"POST.bx_events_sbs_Body";i:33;s:26:"REQUEST.bx_events_sbs_Body";i:34;s:26:"POST.bx_events_sbs_Subject";i:35;s:29:"REQUEST.bx_events_sbs_Subject";i:36;s:27:"POST.bx_forum_notifier_Body";i:37;s:30:"REQUEST.bx_forum_notifier_Body";i:38;s:30:"POST.bx_forum_notifier_Subject";i:39;s:33:"REQUEST.bx_forum_notifier_Subject";i:40;s:36:"POST.bx_groups_admin_become_fan_Body";i:41;s:39:"REQUEST.bx_groups_admin_become_fan_Body";i:42;s:39:"POST.bx_groups_admin_become_fan_Subject";i:43;s:42:"REQUEST.bx_groups_admin_become_fan_Subject";i:44;s:29:"POST.bx_groups_broadcast_Body";i:45;s:32:"REQUEST.bx_groups_broadcast_Body";i:46;s:32:"POST.bx_groups_broadcast_Subject";i:47;s:35:"REQUEST.bx_groups_broadcast_Subject";i:48;s:36:"POST.bx_groups_fan_become_admin_Body";i:49;s:39:"REQUEST.bx_groups_fan_become_admin_Body";i:50;s:39:"POST.bx_groups_fan_become_admin_Subject";i:51;s:42:"REQUEST.bx_groups_fan_become_admin_Subject";i:52;s:30:"POST.bx_groups_fan_remove_Body";i:53;s:33:"REQUEST.bx_groups_fan_remove_Body";i:54;s:33:"POST.bx_groups_fan_remove_Subject";i:55;s:36:"REQUEST.bx_groups_fan_remove_Subject";i:56;s:30:"POST.bx_groups_invitation_Body";i:57;s:33:"REQUEST.bx_groups_invitation_Body";i:58;s:33:"POST.bx_groups_invitation_Subject";i:59;s:36:"REQUEST.bx_groups_invitation_Subject";i:60;s:32:"POST.bx_groups_join_confirm_Body";i:61;s:35:"REQUEST.bx_groups_join_confirm_Body";i:62;s:35:"POST.bx_groups_join_confirm_Subject";i:63;s:38:"REQUEST.bx_groups_join_confirm_Subject";i:64;s:31:"POST.bx_groups_join_reject_Body";i:65;s:34:"REQUEST.bx_groups_join_reject_Body";i:66;s:34:"POST.bx_groups_join_reject_Subject";i:67;s:37:"REQUEST.bx_groups_join_reject_Subject";i:68;s:32:"POST.bx_groups_join_request_Body";i:69;s:35:"REQUEST.bx_groups_join_request_Body";i:70;s:35:"POST.bx_groups_join_request_Subject";i:71;s:38:"REQUEST.bx_groups_join_request_Subject";i:72;s:23:"POST.bx_groups_sbs_Body";i:73;s:26:"REQUEST.bx_groups_sbs_Body";i:74;s:26:"POST.bx_groups_sbs_Subject";i:75;s:29:"REQUEST.bx_groups_sbs_Subject";i:76;s:28:"POST.bx_store_broadcast_Body";i:77;s:31:"REQUEST.bx_store_broadcast_Body";i:78;s:31:"POST.bx_store_broadcast_Subject";i:79;s:34:"REQUEST.bx_store_broadcast_Subject";i:80;s:22:"POST.bx_store_sbs_Body";i:81;s:25:"REQUEST.bx_store_sbs_Body";i:82;s:25:"POST.bx_store_sbs_Subject";i:83;s:28:"REQUEST.bx_store_sbs_Subject";i:84;s:22:"POST.t_Activation_Body";i:85;s:25:"REQUEST.t_Activation_Body";i:86;s:25:"POST.t_Activation_Subject";i:87;s:28:"REQUEST.t_Activation_Subject";i:88;s:22:"POST.t_AdminEmail_Body";i:89;s:25:"REQUEST.t_AdminEmail_Body";i:90;s:25:"POST.t_AdminEmail_Subject";i:91;s:28:"REQUEST.t_AdminEmail_Subject";i:92;s:18:"POST.t_BuyNow_Body";i:93;s:21:"REQUEST.t_BuyNow_Body";i:94;s:21:"POST.t_BuyNow_Subject";i:95;s:24:"REQUEST.t_BuyNow_Subject";i:96;s:18:"POST.t_BuyNow_Body";i:97;s:21:"REQUEST.t_BuyNow_Body";i:98;s:21:"POST.t_BuyNow_Subject";i:99;s:24:"REQUEST.t_BuyNow_Subject";i:100;s:19:"POST.t_BuyNowS_Body";i:101;s:22:"REQUEST.t_BuyNowS_Body";i:102;s:22:"POST.t_BuyNowS_Subject";i:103;s:25:"REQUEST.t_BuyNowS_Subject";i:104;s:19:"POST.t_BuyNowS_Body";i:105;s:22:"REQUEST.t_BuyNowS_Body";i:106;s:22:"POST.t_BuyNowS_Subject";i:107;s:25:"REQUEST.t_BuyNowS_Subject";i:108;s:27:"POST.t_bx_files_report_Body";i:109;s:30:"REQUEST.t_bx_files_report_Body";i:110;s:30:"POST.t_bx_files_report_Subject";i:111;s:33:"REQUEST.t_bx_files_report_Subject";i:112;s:26:"POST.t_bx_files_share_Body";i:113;s:29:"REQUEST.t_bx_files_share_Body";i:114;s:29:"POST.t_bx_files_share_Subject";i:115;s:32:"REQUEST.t_bx_files_share_Subject";i:116;s:28:"POST.t_bx_photos_report_Body";i:117;s:31:"REQUEST.t_bx_photos_report_Body";i:118;s:31:"POST.t_bx_photos_report_Subject";i:119;s:34:"REQUEST.t_bx_photos_report_Subject";i:120;s:27:"POST.t_bx_photos_share_Body";i:121;s:30:"REQUEST.t_bx_photos_share_Body";i:122;s:30:"POST.t_bx_photos_share_Subject";i:123;s:33:"REQUEST.t_bx_photos_share_Subject";i:124;s:28:"POST.t_bx_sounds_report_Body";i:125;s:31:"REQUEST.t_bx_sounds_report_Body";i:126;s:31:"POST.t_bx_sounds_report_Subject";i:127;s:34:"REQUEST.t_bx_sounds_report_Subject";i:128;s:27:"POST.t_bx_sounds_share_Body";i:129;s:30:"REQUEST.t_bx_sounds_share_Body";i:130;s:30:"POST.t_bx_sounds_share_Subject";i:131;s:33:"REQUEST.t_bx_sounds_share_Subject";i:132;s:28:"POST.t_bx_videos_report_Body";i:133;s:31:"REQUEST.t_bx_videos_report_Body";i:134;s:31:"POST.t_bx_videos_report_Subject";i:135;s:34:"REQUEST.t_bx_videos_report_Subject";i:136;s:27:"POST.t_bx_videos_share_Body";i:137;s:30:"REQUEST.t_bx_videos_share_Body";i:138;s:30:"POST.t_bx_videos_share_Subject";i:139;s:33:"REQUEST.t_bx_videos_share_Subject";i:140;s:19:"POST.t_Compose_Body";i:141;s:22:"REQUEST.t_Compose_Body";i:142;s:22:"POST.t_Compose_Subject";i:143;s:25:"REQUEST.t_Compose_Subject";i:144;s:24:"POST.t_Confirmation_Body";i:145;s:27:"REQUEST.t_Confirmation_Body";i:146;s:27:"POST.t_Confirmation_Subject";i:147;s:30:"REQUEST.t_Confirmation_Subject";i:148;s:18:"POST.t_Forgot_Body";i:149;s:21:"REQUEST.t_Forgot_Body";i:150;s:21:"POST.t_Forgot_Subject";i:151;s:24:"REQUEST.t_Forgot_Subject";i:152;s:21:"POST.t_FreeEmail_Body";i:153;s:24:"REQUEST.t_FreeEmail_Body";i:154;s:24:"POST.t_FreeEmail_Subject";i:155;s:27:"REQUEST.t_FreeEmail_Subject";i:156;s:25:"POST.t_FriendRequest_Body";i:157;s:28:"REQUEST.t_FriendRequest_Body";i:158;s:28:"POST.t_FriendRequest_Subject";i:159;s:31:"REQUEST.t_FriendRequest_Subject";i:160;s:25:"POST.t_MemExpiration_Body";i:161;s:28:"REQUEST.t_MemExpiration_Body";i:162;s:28:"POST.t_MemExpiration_Subject";i:163;s:31:"REQUEST.t_MemExpiration_Subject";i:164;s:19:"POST.t_Message_Body";i:165;s:22:"REQUEST.t_Message_Body";i:166;s:22:"POST.t_Message_Subject";i:167;s:25:"REQUEST.t_Message_Subject";i:168;s:23:"POST.t_MessageCopy_Body";i:169;s:26:"REQUEST.t_MessageCopy_Body";i:170;s:26:"POST.t_MessageCopy_Subject";i:171;s:29:"REQUEST.t_MessageCopy_Subject";i:172;s:21:"POST.t_Rejection_Body";i:173;s:24:"REQUEST.t_Rejection_Body";i:174;s:24:"POST.t_Rejection_Subject";i:175;s:27:"REQUEST.t_Rejection_Subject";i:176;s:26:"POST.t_sbsAdsComments_Body";i:177;s:29:"REQUEST.t_sbsAdsComments_Body";i:178;s:29:"POST.t_sbsAdsComments_Subject";i:179;s:32:"REQUEST.t_sbsAdsComments_Subject";i:180;s:23:"POST.t_sbsAdsRates_Body";i:181;s:26:"REQUEST.t_sbsAdsRates_Body";i:182;s:26:"POST.t_sbsAdsRates_Subject";i:183;s:29:"REQUEST.t_sbsAdsRates_Subject";i:184;s:31:"POST.t_sbsArticlesComments_Body";i:185;s:34:"REQUEST.t_sbsArticlesComments_Body";i:186;s:34:"POST.t_sbsArticlesComments_Subject";i:187;s:37:"REQUEST.t_sbsArticlesComments_Subject";i:188;s:31:"POST.t_sbsArticlesComments_Body";i:189;s:34:"REQUEST.t_sbsArticlesComments_Body";i:190;s:34:"POST.t_sbsArticlesComments_Subject";i:191;s:37:"REQUEST.t_sbsArticlesComments_Subject";i:192;s:28:"POST.t_sbsArticlesRates_Body";i:193;s:31:"REQUEST.t_sbsArticlesRates_Body";i:194;s:31:"POST.t_sbsArticlesRates_Subject";i:195;s:34:"REQUEST.t_sbsArticlesRates_Subject";i:196;s:28:"POST.t_sbsArticlesRates_Body";i:197;s:31:"REQUEST.t_sbsArticlesRates_Body";i:198;s:31:"POST.t_sbsArticlesRates_Subject";i:199;s:34:"REQUEST.t_sbsArticlesRates_Subject";i:200;s:32:"POST.t_sbsBlogpostsComments_Body";i:201;s:35:"REQUEST.t_sbsBlogpostsComments_Body";i:202;s:35:"POST.t_sbsBlogpostsComments_Subject";i:203;s:38:"REQUEST.t_sbsBlogpostsComments_Subject";i:204;s:29:"POST.t_sbsBlogpostsRates_Body";i:205;s:32:"REQUEST.t_sbsBlogpostsRates_Body";i:206;s:32:"POST.t_sbsBlogpostsRates_Subject";i:207;s:35:"REQUEST.t_sbsBlogpostsRates_Subject";i:208;s:31:"POST.t_sbsFeedbackComments_Body";i:209;s:34:"REQUEST.t_sbsFeedbackComments_Body";i:210;s:34:"POST.t_sbsFeedbackComments_Subject";i:211;s:37:"REQUEST.t_sbsFeedbackComments_Subject";i:212;s:31:"POST.t_sbsFeedbackComments_Body";i:213;s:34:"REQUEST.t_sbsFeedbackComments_Body";i:214;s:34:"POST.t_sbsFeedbackComments_Subject";i:215;s:37:"REQUEST.t_sbsFeedbackComments_Subject";i:216;s:28:"POST.t_sbsFeedbackRates_Body";i:217;s:31:"REQUEST.t_sbsFeedbackRates_Body";i:218;s:31:"POST.t_sbsFeedbackRates_Subject";i:219;s:34:"REQUEST.t_sbsFeedbackRates_Subject";i:220;s:28:"POST.t_sbsFeedbackRates_Body";i:221;s:31:"REQUEST.t_sbsFeedbackRates_Body";i:222;s:31:"POST.t_sbsFeedbackRates_Subject";i:223;s:34:"REQUEST.t_sbsFeedbackRates_Subject";i:224;s:27:"POST.t_sbsNewsComments_Body";i:225;s:30:"REQUEST.t_sbsNewsComments_Body";i:226;s:30:"POST.t_sbsNewsComments_Subject";i:227;s:33:"REQUEST.t_sbsNewsComments_Subject";i:228;s:27:"POST.t_sbsNewsComments_Body";i:229;s:30:"REQUEST.t_sbsNewsComments_Body";i:230;s:30:"POST.t_sbsNewsComments_Subject";i:231;s:33:"REQUEST.t_sbsNewsComments_Subject";i:232;s:24:"POST.t_sbsNewsRates_Body";i:233;s:27:"REQUEST.t_sbsNewsRates_Body";i:234;s:27:"POST.t_sbsNewsRates_Subject";i:235;s:30:"REQUEST.t_sbsNewsRates_Subject";i:236;s:24:"POST.t_sbsNewsRates_Body";i:237;s:27:"REQUEST.t_sbsNewsRates_Body";i:238;s:27:"POST.t_sbsNewsRates_Subject";i:239;s:30:"REQUEST.t_sbsNewsRates_Subject";i:240;s:27:"POST.t_sbsPollComments_Body";i:241;s:30:"REQUEST.t_sbsPollComments_Body";i:242;s:30:"POST.t_sbsPollComments_Subject";i:243;s:33:"REQUEST.t_sbsPollComments_Subject";i:244;s:24:"POST.t_sbsPollRates_Body";i:245;s:27:"REQUEST.t_sbsPollRates_Body";i:246;s:27:"POST.t_sbsPollRates_Subject";i:247;s:30:"REQUEST.t_sbsPollRates_Subject";i:248;s:30:"POST.t_sbsProfileComments_Body";i:249;s:33:"REQUEST.t_sbsProfileComments_Body";i:250;s:33:"POST.t_sbsProfileComments_Subject";i:251;s:36:"REQUEST.t_sbsProfileComments_Subject";i:252;s:26:"POST.t_sbsProfileEdit_Body";i:253;s:29:"REQUEST.t_sbsProfileEdit_Body";i:254;s:29:"POST.t_sbsProfileEdit_Subject";i:255;s:32:"REQUEST.t_sbsProfileEdit_Subject";i:256;s:27:"POST.t_sbsProfileRates_Body";i:257;s:30:"REQUEST.t_sbsProfileRates_Body";i:258;s:30:"POST.t_sbsProfileRates_Subject";i:259;s:33:"REQUEST.t_sbsProfileRates_Subject";i:260;s:28:"POST.t_sbsSitesComments_Body";i:261;s:31:"REQUEST.t_sbsSitesComments_Body";i:262;s:31:"POST.t_sbsSitesComments_Subject";i:263;s:34:"REQUEST.t_sbsSitesComments_Subject";i:264;s:25:"POST.t_sbsSitesRates_Body";i:265;s:28:"REQUEST.t_sbsSitesRates_Body";i:266;s:28:"POST.t_sbsSitesRates_Subject";i:267;s:31:"REQUEST.t_sbsSitesRates_Subject";i:268;s:26:"POST.t_sbsWallUpdates_Body";i:269;s:29:"REQUEST.t_sbsWallUpdates_Body";i:270;s:29:"POST.t_sbsWallUpdates_Subject";i:271;s:32:"REQUEST.t_sbsWallUpdates_Subject";i:272;s:26:"POST.t_sbsWallUpdates_Body";i:273;s:29:"REQUEST.t_sbsWallUpdates_Body";i:274;s:29:"POST.t_sbsWallUpdates_Subject";i:275;s:32:"REQUEST.t_sbsWallUpdates_Subject";i:276;s:33:"POST.t_sbs_bx_files_comments_Body";i:277;s:36:"REQUEST.t_sbs_bx_files_comments_Body";i:278;s:36:"POST.t_sbs_bx_files_comments_Subject";i:279;s:39:"REQUEST.t_sbs_bx_files_comments_Subject";i:280;s:30:"POST.t_sbs_bx_files_rates_Body";i:281;s:33:"REQUEST.t_sbs_bx_files_rates_Body";i:282;s:33:"POST.t_sbs_bx_files_rates_Subject";i:283;s:36:"REQUEST.t_sbs_bx_files_rates_Subject";i:284;s:34:"POST.t_sbs_bx_photos_comments_Body";i:285;s:37:"REQUEST.t_sbs_bx_photos_comments_Body";i:286;s:37:"POST.t_sbs_bx_photos_comments_Subject";i:287;s:40:"REQUEST.t_sbs_bx_photos_comments_Subject";i:288;s:31:"POST.t_sbs_bx_photos_rates_Body";i:289;s:34:"REQUEST.t_sbs_bx_photos_rates_Body";i:290;s:34:"POST.t_sbs_bx_photos_rates_Subject";i:291;s:37:"REQUEST.t_sbs_bx_photos_rates_Subject";i:292;s:34:"POST.t_sbs_bx_sounds_comments_Body";i:293;s:37:"REQUEST.t_sbs_bx_sounds_comments_Body";i:294;s:37:"POST.t_sbs_bx_sounds_comments_Subject";i:295;s:40:"REQUEST.t_sbs_bx_sounds_comments_Subject";i:296;s:31:"POST.t_sbs_bx_sounds_rates_Body";i:297;s:34:"REQUEST.t_sbs_bx_sounds_rates_Body";i:298;s:34:"POST.t_sbs_bx_sounds_rates_Subject";i:299;s:37:"REQUEST.t_sbs_bx_sounds_rates_Subject";i:300;s:34:"POST.t_sbs_bx_videos_comments_Body";i:301;s:37:"REQUEST.t_sbs_bx_videos_comments_Body";i:302;s:37:"POST.t_sbs_bx_videos_comments_Subject";i:303;s:40:"REQUEST.t_sbs_bx_videos_comments_Subject";i:304;s:31:"POST.t_sbs_bx_videos_rates_Body";i:305;s:34:"REQUEST.t_sbs_bx_videos_rates_Body";i:306;s:34:"POST.t_sbs_bx_videos_rates_Subject";i:307;s:37:"REQUEST.t_sbs_bx_videos_rates_Subject";i:308;s:22:"POST.t_SpamReport_Body";i:309;s:25:"REQUEST.t_SpamReport_Body";i:310;s:25:"POST.t_SpamReport_Subject";i:311;s:28:"REQUEST.t_SpamReport_Subject";i:312;s:26:"POST.t_SpamReportAuto_Body";i:313;s:29:"REQUEST.t_SpamReportAuto_Body";i:314;s:29:"POST.t_SpamReportAuto_Subject";i:315;s:32:"REQUEST.t_SpamReportAuto_Subject";i:316;s:24:"POST.t_Subscription_Body";i:317;s:27:"REQUEST.t_Subscription_Body";i:318;s:27:"POST.t_Subscription_Subject";i:319;s:30:"REQUEST.t_Subscription_Subject";i:320;s:22:"POST.t_TellFriend_Body";i:321;s:25:"REQUEST.t_TellFriend_Body";i:322;s:25:"POST.t_TellFriend_Subject";i:323;s:28:"REQUEST.t_TellFriend_Subject";i:324;s:29:"POST.t_TellFriendProfile_Body";i:325;s:32:"REQUEST.t_TellFriendProfile_Body";i:326;s:32:"POST.t_TellFriendProfile_Subject";i:327;s:35:"REQUEST.t_TellFriendProfile_Subject";i:328;s:25:"POST.t_UserConfirmed_Body";i:329;s:28:"REQUEST.t_UserConfirmed_Body";i:330;s:28:"POST.t_UserConfirmed_Subject";i:331;s:31:"REQUEST.t_UserConfirmed_Subject";i:332;s:22:"POST.t_UserJoined_Body";i:333;s:25:"REQUEST.t_UserJoined_Body";i:334;s:25:"POST.t_UserJoined_Subject";i:335;s:28:"REQUEST.t_UserJoined_Subject";i:336;s:17:"POST.t_VKiss_Body";i:337;s:20:"REQUEST.t_VKiss_Body";i:338;s:20:"POST.t_VKiss_Subject";i:339;s:23:"REQUEST.t_VKiss_Subject";i:340;s:25:"POST.t_VKiss_visitor_Body";i:341;s:28:"REQUEST.t_VKiss_visitor_Body";i:342;s:28:"POST.t_VKiss_visitor_Subject";i:343;s:31:"REQUEST.t_VKiss_visitor_Subject";}s:12:"deanos_tools";a:4:{i:0;s:18:"POST.dbcsDTphpcode";i:1;s:21:"REQUEST.dbcsDTphpcode";i:2;s:19:"POST.dbcsDTsqlquery";i:3;s:22:"REQUEST.dbcsDTsqlquery";}s:6:"system";a:1:{i:0;s:20:"COOKIE.memberSession";}}',
  'cmdDay' => '11',
  'tags_last_parse_time' => '0',
  'cupid_last_cron' => '0',
  'sys_show_admin_help' => 'on',
  'sys_main_logo' => '1260046264.png',
  'main_div_width' => '1140px',
  'sys_template_cache_image_enable' => '',
  'sys_template_cache_image_max_size' => '5',
  'sys_sitemap_enable' => '',
  'sys_captcha_default' => 'sys_recaptcha',
  'sys_editor_default' => 'sys_tinymce',
  'sys_template_page_width_max' => '1600',
  'sys_template_page_width_min' => '774',
  'nav_menu_elements_on_line_gst' => '12',
  'nav_menu_elements_on_line_usr' => '12',
  'enable_template' => '',
  'template' => 'uni',
  'match_percent' => '200',
  'view_match_percent' => 'on',
  'enable_match' => 'on',
  'db_clean_vkiss' => '90',
  'db_clean_mem_levels' => '30',
  'db_clean_banners_info' => '60',
  'db_clean_members_visits' => '90',
  'db_clean_profiles' => '0',
  'db_clean_msg' => '365',
  'sys_ps_enabled_group_7' => '',
  'sys_ps_enabled_group_6' => '',
  'sys_ps_enabled_group_5' => '',
  'sys_ps_enabled_group_3' => 'on',
  'sys_ps_enabled_group_4' => 'on',
  'sys_ps_enabled_group_2' => '',
  'sys_ps_enabled_group_1' => '',
  'sys_ps_enable_default_values' => '',
  'sys_ps_enable_create_group' => '',
  'site_email_notify' => 'caltrade@gmail.com',
  'site_title' => 'California International Business Community',
  'site_email' => 'caltrade@gmail.com',
  'sys_album_auto_app' => 'on',
  'newusernotify' => 'on',
  'autoApproval_ifNoConfEmail' => '',
  'enable_promotion_membership' => '',
  'promotion_membership_days' => '7',
  'autoApproval_ifJoin' => '',
  'autoApproval_ifProfile' => 'on',
  'expire_notification_days' => '1',
  'expire_notify_once' => 'on',
  'msgs_per_start' => '20',
  'useLikeOperator' => 'on',
  'enable_gd' => 'on',
  'boonexAffID' => '',
  'default_country' => 'US',
  'enable_contact_form' => 'on',
  'feeds_enable' => 'on',
  'news_enable' => '',
  'sys_album_default_name' => 'Hidden',
  'enable_tiny_in_comments' => '',
  'sys_make_album_cover_last' => 'on',
  'MetaKeyWords' => '',
  'bx_avatar_permalinks' => 'on',
  'bx_avatar_quality' => '90',
  'bx_avatar_site_avatars' => 'on',
  'blogAutoApproval' => 'on',
  'blog_step' => '10',
  'max_blogs_on_home' => '3',
  'max_blog_preview' => '256',
  'bx_blogs_iconsize' => '45',
  'bx_blogs_thumbsize' => '110',
  'bx_blogs_bigthumbsize' => '340',
  'bx_blogs_imagesize' => '800',
  'permalinks_blogs' => 'on',
  'permalinks_module_chat' => 'on',
  'bx_store_max_rss_num' => '10',
  'permalinks_module_news' => 'on',
  'category_auto_app_bx_news' => 'on',
  'news_autoapprove' => 'on',
  'news_comments' => 'on',
  'news_votes' => 'on',
  'news_index_number' => '10',
  'news_member_number' => '10',
  'news_per_page' => '10',
  'news_rss_length' => '10',
  'bx_photos_activation' => 'on',
  'category_auto_app_bx_photos' => 'on',
  'bx_photos_allowed_exts' => 'jpg png gif',
  'bx_photos_profile_album_name' => '{nickname}'s photos',
  'bx_photos_mode_index' => 'last',
  'bx_photos_number_all' => '12',
  'bx_photos_number_index' => '8',
  'bx_photos_number_top' => '5',
  'bx_photos_number_user' => '4',
  'bx_photos_number_related' => '4',
  'bx_photos_number_previous_rated' => '4',
  'bx_photos_number_browse' => '8',
  'bx_photos_number_albums_browse' => '8',
  'bx_photos_number_albums_home' => '4',
  'bx_photos_icon_width' => '32',
  'bx_photos_icon_height' => '32',
  'bx_photos_thumb_width' => '64',
  'bx_photos_thumb_height' => '64',
  'bx_photos_file_width' => '750',
  'bx_photos_file_height' => '750',
  'bx_photos_browse_width' => '140',
  'bx_photos_browse_height' => '140',
  'bx_photos_flickr_photo_api' => '',
  'bx_photos_number_albums_public_objects' => '4',
  'bx_photos_rss_feed_on' => 'on',
  'bx_photos_permalinks' => 'on',
  'simple_messenger_update_time' => '3000',
  'simple_messenger_visible_messages' => '25',
  'simple_messenger_allowed_chatbox' => '3',
  'simple_messenger_procces_smiles' => 'on',
  'simple_messenger_blink_counter' => '4',
  'bx_simple_messenger_permalinks' => 'on',
  'category_auto_app_bx_sounds' => 'on',
  'bx_sounds_allowed_exts' => 'mp3 wav',
  'bx_sounds_profile_album_name' => '{nickname}'s sounds',
  'bx_sounds_mode_index' => 'last',
  'bx_sounds_number_all' => '12',
  'bx_sounds_number_index' => '8',
  'bx_sounds_number_top' => '4',
  'bx_sounds_number_user' => '4',
  'bx_sounds_number_related' => '4',
  'bx_sounds_number_previous_rated' => '4',
  'bx_sounds_number_browse' => '8',
  'bx_sounds_number_albums_browse' => '8',
  'bx_sounds_number_albums_home' => '4',
  'bx_sounds_file_width' => '600',
  'bx_sounds_file_height' => '600',
  'bx_sounds_browse_width' => '140',
  'bx_sounds_browse_height' => '102',
  'bx_sounds_permalinks' => 'on',
  'shoutbox_block_sec' => '86400',
  'category_auto_app_bx_videos' => 'on',
  'bx_videos_allowed_exts' => 'avi flv mpg wmv mp4 m4v mov divx xvid',
  'bx_videos_profile_album_name' => '{nickname}'s videos',
  'bx_videos_mode_index' => 'last',
  'bx_videos_number_all' => '12',
  'bx_videos_number_index' => '8',
  'bx_videos_number_top' => '4',
  'bx_videos_number_user' => '4',
  'bx_videos_number_related' => '4',
  'bx_videos_number_previous_rated' => '4',
  'bx_videos_number_browse' => '8',
  'bx_videos_number_albums_browse' => '8',
  'bx_videos_number_albums_home' => '4',
  'bx_videos_file_width' => '600',
  'bx_videos_file_height' => '600',
  'bx_videos_browse_width' => '140',
  'bx_videos_browse_height' => '102',
  'bx_photos_header_cache' => '0',
  'bx_videos_max_file_size' => '64',
  'bx_videos_permalinks' => 'on',
  'bx_files_mode_index' => 'last',
  'bx_files_number_all' => '10',
  'bx_files_number_albums_browse' => '10',
  'bx_files_number_albums_home' => '4',
  'bx_files_number_index' => '2',
  'bx_files_number_featured' => '4',
  'bx_files_number_top' => '4',
  'bx_files_number_user' => '4',
  'bx_files_number_related' => '4',
  'bx_files_thumb_width' => '64',
  'bx_files_activation' => 'on',
  'category_auto_app_bx_files' => 'on',
  'bx_files_allowed_exts' => '',
  'bx_files_profile_album_name' => '{nickname}'s files',
  'bx_files_permalinks' => 'on',
  'bx_groups_permalinks' => 'on',
  'bx_groups_autoapproval' => 'on',
  'bx_groups_author_comments_admin' => 'on',
  'bx_groups_max_email_invitations' => '10',
  'category_auto_app_bx_groups' => 'on',
  'bx_groups_perpage_view_fans' => '6',
  'bx_groups_perpage_browse_fans' => '30',
  'bx_groups_perpage_main_recent' => '10',
  'bx_groups_perpage_browse' => '14',
  'bx_groups_perpage_profile' => '4',
  'bx_groups_perpage_homepage' => '5',
  'bx_groups_homepage_default_tab' => 'featured',
  'bx_groups_max_rss_num' => '10',
  'bx_ads_max_live_days' => '365',
  'bx_ads_enable_paid' => 'on',
  'bx_ads_auto_approving' => 'on',
  'permalinks_module_ads' => 'on',
  'permalinks_module_articles' => 'on',
  'category_auto_app_bx_articles' => 'on',
  'articles_autoapprove' => 'on',
  'articles_comments' => 'on',
  'articles_votes' => 'on',
  'articles_index_number' => '10',
  'articles_member_number' => '10',
  'bx_sites_cache_days' => '7',
  'articles_per_page' => '10',
  'articles_rss_length' => '10',
  'enable_crss_module' => 'on',
  'crss_AutoApprove_RSS' => 'on',
  'category_auto_app_bx_events' => 'on',
  'bx_events_permalinks' => 'on',
  'bx_events_autoapproval' => 'on',
  'bx_events_main_upcoming_event_from_featured_only' => '',
  'bx_events_max_email_invitations' => '10',
  'bx_events_perpage_main_upcoming' => '10',
  'bx_events_perpage_main_recent' => '4',
  'bx_events_perpage_main_past' => '6',
  'bx_events_perpage_participants' => '9',
  'bx_events_perpage_browse_participants' => '30',
  'bx_events_perpage_browse' => '14',
  'bx_events_perpage_homepage' => '5',
  'bx_events_homepage_default_tab' => 'upcoming',
  'bx_events_perpage_profile' => '5',
  'bx_events_max_rss_num' => '10',
  'feedback_autoapprove' => '',
  'feedback_comments' => 'on',
  'bx_gsearch_permalinks' => 'on',
  'bx_gsearch_block_tabbed' => 'on',
  'bx_gsearch_block_images' => 'on',
  'bx_gsearch_separate_tabbed' => 'on',
  'bx_gsearch_separate_images' => 'on',
  'enable_poll' => 'on',
  'profile_poll_num' => '4',
  'profile_page_polls' => '2',
  'index_page_polls' => '2',
  'profile_poll_act' => 'on',
  'category_auto_app_bx_poll' => 'on',
  'bx_poll_permalinks' => 'on',
  'MetaDescription' => 'California International Business Community',
  'sys_member_info_thumb_icon' => 'sys_avatar_icon',
  'shoutbox_update_time' => '7000',
  'shoutbox_allowed_messages' => '30',
  'shoutbox_process_smiles' => 'on',
  'shoutbox_clean_oldest' => '172800',
  'bx_sites_permalinks' => 'on',
  'bx_sites_autoapproval' => 'on',
  'bx_sites_comments' => 'on',
  'bx_sites_votes' => 'on',
  'bx_sites_per_page' => '10',
  'bx_sites_max_rss_num' => '10',
  'category_auto_app_bx_sites' => 'on',
  'bx_sites_key_id' => '',
  'bx_sites_secret_key' => '',
  'bx_sites_account_type' => 'No Automated Screenshots',
  'bx_sounds_uploader_switcher' => 'flash,regular,record',
  'pmt_default_currency_sign' => '&#36;',
  'pmt_default_currency_code' => 'USD',
  'sys_member_info_thumb' => 'sys_avatar',
  'sys_member_info_info' => 'sys_headline',
  'bx_videos_uploader_switcher' => 'flash,regular,record,embed',
  'bx_photos_uploader_switcher' => 'flash,regular,record,embed',
  'bx_files_uploader_switcher' => 'flash,regular',
  'category_auto_app_bx_blogs' => 'on',
  'top_members_max_num' => '8',
  'sys_member_info_name' => 'sys_username',
  'featured_num' => '8',
  'friends_per_page' => '14',
  'search_end_age' => '75',
  'bx_store_permalinks' => 'on',
  'bx_store_autoapproval' => 'on',
  'bx_store_product_of_the_day_from_featured_only' => '',
  'category_auto_app_bx_store' => 'on',
  'bx_store_perpage_main_recent' => '10',
  'bx_store_homepage_default_tab' => 'featured',
  'bx_store_perpage_homepage' => '5',
  'bx_store_perpage_profile' => '4',
  'feedback_votes' => 'on',
  'feedback_index_number' => '3',
  'feedback_snippet_length' => '200',
  'feedback_per_page' => '3',
  'permalinks_module_payment' => 'on',
  'mbp_type' => '',
  'permalinks_module_membership' => 'on',
  'feedback_rss_length' => '10',
  'member_online_time' => '1',
  'search_start_age' => '18',
  'bx_store_perpage_browse' => '14',
  'permalinks_module_feedback' => 'on',
  'enable_cmts_profile_delete' => 'on',
  'reg_by_inv_only' => '',
  'zodiac' => '',
  'anon_mode' => 'on',
  'dbcs_DT_sapp' => '10',
  'dbcs_DT_stpp' => '10',
  'dbcs_DT_alpp' => '10',
  'dbcs_DT_logguests' => '0',
  'votes' => '',
  'enable_global_couple' => '',
  'permalinks_module_pageac' => 'on',
  'pmt_site_admin' => '',
  'bx_sites_debug' => 'off',
  'bx_sites_inside_pages' => 'off',
  'bx_sites_custom_msg_url' => '',
  'bx_sites_thumb_size' => 'lg',
  'bx_sites_thumb_size_custom' => '',
  'bx_sites_full_size' => '',
  'bx_sites_max_height' => '',
  'bx_sites_native_res' => '',
  'bx_sites_widescreen_y' => '',
  'bx_sites_redo' => 'off',
  'bx_sites_delay' => '',
  'bx_sites_quality' => '',
  'bx_sounds_max_file_size' => '32',
  'bx_files_max_file_size' => '32',
)
Called script: /community/administration/index.php
Request parameters:
Array
(
    [memberSession] => zPs?!7pqm!X9T6RvgT5V/VyVEpW?rE+w
    [memberID] => 3311
    [memberPassword] => altered... b99792a9cc424d8
    [__gads] => ID=06edf44bf432520e:T=1334454775:S=ALNI_MYJIhEp0Qiz_NnHnX8dHkDKgYGiQw
    [__utma] => 30824493.538014680.1351388089.1351388089.1352605820.2
    [__utmz] => 30824493.1352605820.2.2.utmccn=(referral)|utmcsr=caltrade.com|utmcct=/mainmenu/index.htm|utmcmd=referral
    [PHPSESSID] => 2fa511ff2f5f667c9fd3c82fe5b6355a
    [__utmc] => 30824493
)
Quote · 11 Nov 2012
dolphin_jay
dolphin_jayPremium
2095 posts
0
 

Did you create a backup of the files and database ?  if so restore and try again.

https://dolphin-techs.com - Skype: Dolphin Techs
Quote · 11 Nov 2012
CALTRADE
CALTRADEAdvanced
2898 posts
0
 

Yes, I created a backup, but what good would that do?  I can take the next several hours rebuilding the old site to destroy it again?  I was hoping someone might know how to fix. 

Quote · 11 Nov 2012
CALTRADE
CALTRADEAdvanced
2898 posts
0
 

DolphinJay, are you saying restore just the database or rebuild the entire old site and try again?  If you are saying rebuild the old site and try again that doesn't make much sense, because - scientific method - no variables have changed -  assume the exact thing will happen again.   If you are saying restore just the database, I could try that, but I always thought the upgrade changed some files, so it seems like it could make it work.  If you know that is not the case, however, I could try that. 

Quote · 11 Nov 2012
SkyForum
SkyForumPremium
3790 posts
0
 

What most people are doing is making a copy of their live site, then testing the upgrade on that copy. Once they are successful, then they apply it to their live site.

just sayin....

http://towtalk.net ... Hosted by Zarconia.net!
Quote · 11 Nov 2012
modzzz
modzzzPremium
6116 posts
0
 

The problem is caused because you have added a custom field called Name to your Profiles table . If this field is not presently being used by your site then remove it, otherwise you will have to modify some code.

See code change needed below :

In inc/languages.inc.php

Find (at line 151) :

        return $GLOBALS['MySQL']->fromMemory('profile_lang_' . $iProfile, 'getOne', 'SELECT `Name` FROM `sys_localization_languages` AS `l` INNER JOIN `Profiles` AS `p` ON (`p`.`LangID` = `l`.`ID`) WHERE `p`.`ID` = ' . $iProfile);

Replace with :

      return $GLOBALS['MySQL']->fromMemory('profile_lang_' . $iProfile, 'getOne', 'SELECT `sys_localization_languages`.`Name` FROM `sys_localization_languages` AS `l` INNER JOIN `Profiles` AS `p` ON (`p`.`LangID` = `l`.`ID`) WHERE `p`.`ID` = ' . $iProfile);

 

Paypal email is jeromemingo@gmail.com - http://www.boonex.com/market/posts/modzzz
Quote · 11 Nov 2012
CALTRADE
CALTRADEAdvanced
2898 posts
0
 

Modezz - awesome!!!!   I was thinking that was probably the problem.  The first_name / last_name construct didn't work for me, but I thought I had named it something other than "name" - apparently not.  I really, really appreciate your response.  I will try this.

Rob

Quote · 11 Nov 2012
modzzz
modzzzPremium
6116 posts
0
 

The replace in my last post is wrong, see correction below :

 

Replace with :

      return $GLOBALS['MySQL']->fromMemory('profile_lang_' . $iProfile, 'getOne', 'SELECT `l`.`Name` FROM `sys_localization_languages` AS `l` INNER JOIN `Profiles` AS `p` ON (`p`.`LangID` = `l`.`ID`) WHERE `p`.`ID` = ' . $iProfile);

Paypal email is jeromemingo@gmail.com - http://www.boonex.com/market/posts/modzzz
Quote · 11 Nov 2012
CALTRADE
CALTRADEAdvanced
2898 posts
0
 

Awesome - just was coming back here with the new sql error when I found this.  Looks like it worked.

You are my hero modzzz

Quote · 11 Nov 2012
AlexT
AlexTNavigator
6101 posts
1
 

http://www.boonex.com/trac/dolphin/ticket/2877

Rules → http://www.boonex.com/terms
Quote · 12 Nov 2012
Reply ›
 
 
Home
Features
Pricing
Hosting
Support
About
StartDemo
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.

Blogs

Dolphin.Pro News
BoonEx News
Our Journey
Social Software World
Community Voice

Help

Support Forums
Documentation
BoonEx at GitHub
Knowledge Base
Contact Support Team

Product

Dolphin.Pro Features
Live Demo & Sandbox
Download Packages
Pricing & Order
Contact Sales Team

Company

Contact Us
About BoonEx
Privacy Policy
Terms & Conditions
© BoonEx Pty Ltd