Adult Script Pro Community Forums

The forum is here for legacy reasons. No new posts will be created. User registration is disabled! If you have any questions, please email us or check https://www.adultscriptpro.com for more details!

You are not logged in.

Pages: 1

#1 2011-08-13 12:16:45

thiva7
Member
Registered: 2011-04-30
Posts: 1,022

1.0rc2 to 1.0rc3 upgrade problem

when i go to domain.com/install/upgrade-1.0rc2-to-1.0rc3.php?a=upgrade

i get this error

Query: UPDATE player SET config = 'a:44:{s:8:\"autoPlay\";s:4:\"true\";s:13:\"autoBuffering\";s:4:\"true\";s:12:\"bufferLength\";i:3;s:7:\"scaling\";s:3:\"fit\";s:15:\"backgroundColor\";s:7:\"#222222\";s:18:\"backgroundGradient\";s:4:\"none\";s:11:\"buttonColor\";s:7:\"#8C072A\";s:15:\"buttonOverColor\";s:7:\"#AF0A38\";s:11:\"bufferColor\";s:7:\"#445566\";s:14:\"bufferGradient\";s:4:\"none\";s:9:\"timeColor\";s:7:\"#bfac2e\";s:11:\"timeBgColor\";s:7:\"#555555\";s:13:\"durationColor\";s:7:\"#ffffff\";s:11:\"sliderColor\";s:7:\"#BF0B3D\";s:14:\"sliderGradient\";s:4:\"none\";s:13:\"progressColor\";s:7:\"#8C072A\";s:16:\"progressGradient\";s:4:\"none\";s:17:\"volumeSliderColor\";s:7:\"#000000\";s:20:\"volumeSliderGradient\";s:4:\"none\";s:12:\"borderRadius\";i:0;s:12:\"tooltipColor\";s:7:\"#5F747C\";s:16:\"tooltipTextColor\";s:7:\"#ffffff\";s:6:\"height\";i:24;s:7:\"opacity\";N;s:22:\"canvas_backgroundColor\";s:7:\"#000000\";s:25:\"canvas_backgroundGradient\";s:4:\"none\";s:4:\"play\";s:4:\"true\";s:6:\"volume\";s:4:\"true\";s:4:\"mute\";s:4:\"true\";s:4:\"time\";s:4:\"true\";s:4:\"stop\";s:5:\"false\";s:8:\"playlist\";s:5:\"false\";s:10:\"fullscreen\";s:4:\"true\";s:8:\"tooltips\";s:1:\"1\";s:3:\"adv\";i:1;s:8:\"adv_text\";i:1;s:9:\"adv_image\";i:1;s:9:\"adv_media\";i:1;s:7:\"license\";s:0:\"\";s:4:\"logo\";s:0:\"\";s:3:\"top\";i:0;s:4:\"left\";i:0;s:6:\"bottom\";i:5;s:5:\"right\";i:20;}', config_cache = 'a:44:{s:8:\"autoPlay\";s:4:\"true\";s:13:\"autoBuffering\";s:4:\"true\";s:12:\"bufferLength\";i:3;s:7:\"scaling\";s:3:\"fit\";s:15:\"backgroundColor\";s:7:\"#222222\";s:18:\"backgroundGradient\";s:4:\"none\";s:11:\"buttonColor\";s:7:\"#8C072A\";s:15:\"buttonOverColor\";s:7:\"#AF0A38\";s:11:\"bufferColor\";s:7:\"#445566\";s:14:\"bufferGradient\";s:4:\"none\";s:9:\"timeColor\";s:7:\"#bfac2e\";s:11:\"timeBgColor\";s:7:\"#555555\";s:13:\"durationColor\";s:7:\"#ffffff\";s:11:\"sliderColor\";s:7:\"#BF0B3D\";s:14:\"sliderGradient\";s:4:\"none\";s:13:\"progressColor\";s:7:\"#8C072A\";s:16:\"progressGradient\";s:4:\"none\";s:17:\"volumeSliderColor\";s:7:\"#000000\";s:20:\"volumeSliderGradient\";s:4:\"none\";s:12:\"borderRadius\";i:0;s:12:\"tooltipColor\";s:7:\"#5F747C\";s:16:\"tooltipTextColor\";s:7:\"#ffffff\";s:6:\"height\";i:24;s:7:\"opacity\";N;s:22:\"canvas_backgroundColor\";s:7:\"#000000\";s:25:\"canvas_backgroundGradient\";s:4:\"none\";s:4:\"play\";s:4:\"true\";s:6:\"volume\";s:4:\"true\";s:4:\"mute\";s:4:\"true\";s:4:\"time\";s:4:\"true\";s:4:\"stop\";s:5:\"false\";s:8:\"playlist\";s:5:\"false\";s:10:\"fullscreen\";s:4:\"true\";s:8:\"tooltips\";s:1:\"1\";s:3:\"adv\";i:1;s:8:\"adv_text\";i:1;s:9:\"adv_image\";i:1;s:9:\"adv_media\";i:1;s:7:\"license\";s:0:\"\";s:4:\"logo\";s:0:\"\";s:3:\"top\";i:0;s:4:\"left\";i:0;s:6:\"bottom\";i:5;s:5:\"right\";i:20;}', WHERE player_id = 1 LIMIT 1
Error Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE player_id = 1 LIMIT 1' at line 4
Error Number: 1064

Offline

#2 2011-08-13 15:13:08

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: 1.0rc2 to 1.0rc3 upgrade problem

Erm, i tested this and the probably edited again. Edit install/upgrade-1.0rc2-to-1.0rc3.php and replace:

        $db->query("UPDATE #__player
                    SET config = '".$db->escape(serialize($config))."',
                        config_cache = '".$db->escape(serialize($config_cache))."',
                    WHERE player_id = ".(int) $player['player_id']."
                    LIMIT 1");

with:

        $db->query("UPDATE #__player
                    SET config = '".$db->escape(serialize($config))."',
                        config_cache = '".$db->escape(serialize($config_cache))."'
                    WHERE player_id = ".(int) $player['player_id']."
                    LIMIT 1");

Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

#3 2011-08-13 15:26:38

thiva7
Member
Registered: 2011-04-30
Posts: 1,022

Re: 1.0rc2 to 1.0rc3 upgrade problem

new one hmm

Query: INSERT INTO adv_groups SET adv_group_name = 'Video Category Square', adv_group_desc = 'Video Category Square Advertising', adv_group_slug = 'video-category-square'
Error Message: Duplicate entry 'Video Category Square' for key 'adv_group_name'
Error Number: 1062

Offline

#4 2011-08-13 16:41:01

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: 1.0rc2 to 1.0rc3 upgrade problem

Ok. Thats probably because you already added the Advertising Group fix. Edit the upgrade file again and comment out (with //) the following lines:

   // updating player configurations with license/logo
    $db->query("SELECT player_id, config, config_cache
                FROM #__player");
    $players    = $db->fetch_rows();
    $pupdate    = array(
        'license'   => '',
        'logo'      => '',
        'top'       => 0,
        'left'      => 0,
        'bottom'    => 5,
        'right'     => 20
    );
    foreach ($players as $player) {
        $config         = array_merge(unserialize($player['config']), $pupdate);
        $config_cache   = array_merge(unserialize($player['config_cache']), $pupdate);
        $db->query("UPDATE #__player
                    SET config = '".$db->escape(serialize($config))."',
                        config_cache = '".$db->escape(serialize($config_cache))."',
                    WHERE player_id = ".(int) $player['player_id']."
                    LIMIT 1");
    }

    // updating some advertising groups
    $db->query("INSERT INTO #__adv_groups
                SET adv_group_name = 'Video Category Square',
                    adv_group_desc = 'Video Category Square Advertising',
                    adv_group_slug = 'video-category-square'");

Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

#5 2011-08-13 16:41:17

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: 1.0rc2 to 1.0rc3 upgrade problem

Or you can actually delete the above lines.

Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

#6 2011-08-13 17:45:25

thiva7
Member
Registered: 2011-04-30
Posts: 1,022

Re: 1.0rc2 to 1.0rc3 upgrade problem

symtab wrote:

Ok. Thats probably because you already added the Advertising Group fix. Edit the upgrade file again and comment out (with //) the following lines:

   // updating player configurations with license/logo
    $db->query("SELECT player_id, config, config_cache
                FROM #__player");
    $players    = $db->fetch_rows();
    $pupdate    = array(
        'license'   => '',
        'logo'      => '',
        'top'       => 0,
        'left'      => 0,
        'bottom'    => 5,
        'right'     => 20
    );
    foreach ($players as $player) {
        $config         = array_merge(unserialize($player['config']), $pupdate);
        $config_cache   = array_merge(unserialize($player['config_cache']), $pupdate);
        $db->query("UPDATE #__player
                    SET config = '".$db->escape(serialize($config))."',
                        config_cache = '".$db->escape(serialize($config_cache))."',
                    WHERE player_id = ".(int) $player['player_id']."
                    LIMIT 1");
    }

    // updating some advertising groups
    $db->query("INSERT INTO #__adv_groups
                SET adv_group_name = 'Video Category Square',
                    adv_group_desc = 'Video Category Square Advertising',
                    adv_group_slug = 'video-category-square'");

ok i delete this lines but now i get this : 

Query: ALTER video_categories ADD `auto_term` varchar(255) NOT NULL default ''
Error Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'video_categories ADD `auto_term` varchar(255) NOT NULL default ''' at line 1
Error Number: 1064

Offline

#7 2011-08-13 18:02:16

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: 1.0rc2 to 1.0rc3 upgrade problem

WTF...so basically all queries dont work smile) nice. All of them worked for me when i upgraded sad((
Checking if i still have your cpanel access.

PS: I did the upgrade for you. Dont run the upgrade script again.

Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

#8 2011-08-13 18:07:37

thiva7
Member
Registered: 2011-04-30
Posts: 1,022

Re: 1.0rc2 to 1.0rc3 upgrade problem

i send u mail with my full server and site acceess to can see what is rong smile

Offline

Pages: 1

Board footer

Powered by FluxBB