Cant migrate sounds and video

Database access error. Description: Table 'eesychee_dolphin.RayMp3Tokens' doesn't existDatabase access error. Description: Table 'eesychee_dolphin.RayVideoTokens' doesn't exist

'eesychee_dolphin'  IS MY 6.16 DOLPHIN DATABASE

'RayMp3Tokens' doesent exist in 6.16

Why is it looking for that table there when the table only exists in D7??

Cant migrate sounds or video ,same as RC1 problem

Hello, are you sure that you indicated path for dolphin6 ?

Yes Im sure, it migrated photos, profile, profile pics just fine...

Also none of my ads pictures were migrated... only some of the ads were migrated, not all of them too

I can give you my ftp details, so you can check and do a test migrate again if you wish

I posted this bug before here, when RC1 came out, but I thought RC2 would have the fix for this

Can you help me please? Can you check why is it looking into D6 database for 'RayMp3Tokens'  table

1. RayMp3Tokens must be placed into your  Dolphin 7 DB (will need to check it)
2.Can you show us full error description ?

Original cron email error:

Database access error. Description: Table 'eesychee_dolphin.RayMp3Tokens' doesn't existDatabase access error. Description: Table 'eesychee_dolphin.RayVideoTokens' doesn't exist

Please understand: I DO have table RayMp3Tokens in D7

Look at error on top, 'eesychee_dolphin'  is my D6 site database name

So script is looking in my original D6 site for that table, and gives me this error, and cant copy my music or videos

My new D7 site: www.eesycheesy.com/newdesign     notice it copied most of other thigs, only not mp3s or videos, and not all ads..and no ad pics at all...  Look at that site, and my D6 original eesycheesy.com 

Also, please make users with larger sites aware that they need to contact their host to allocate more memory before doing migration

I needed hostforweb to upgrade my script memory to 128mb, I kept receiving these emails when I had only 64mb memory:

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 15488 bytes) in /home/eesychee/public_html/newdesign/inc/classes/BxDolImageResize.php on line 433

I have around 7k profiles, and 6k ads, seems like a lot of memory is needed..

I can give you all details and you can try migrating old site to new site yourself, and insert your email to receive bug and error reports yourself too, so that you will see all the error emails that you will receive,including ads errors,blogs errers, its saying duplicate entry..and then it stops migrating..only 340 of my ads were migrated, out of 6000, because I received email error of duplicate entry 

Example:

Mysql error: Duplicate entry '133' for key 1

Found error in the file '/home/eesychee/public_html/newdesign/modules/boonex/data_migration/classes/BxDataMigrationBlogs.php' at line 127.
Called 'query' function with erroneous argument #0

Some more migrations errors I received:

Catchable fatal error: Object of class BxDataMigrationProfilesCustomFields could not be converted to string in /home/eesychee/public_html/newdesign/modules/boonex/data_migration/classes/BxDataMigrationProfilesCustomFields.php on line 99

THIS ONE IS A VERY LONG CRON EMAIL, 1 MB IN SIZE, I CAN FORWARD TO YOUR EMAIL IF YOU WANT:

Seems stream 0 codec frame rate differs from container frame rate: 1000.00 (1000/1) -> 25.00 (25/1)
Input #0, flv, from '/home/eesychee/public_html/ray/modules/movie/files/1.flv':
  Duration: 00:01:51.46, start: 0.000000, bitrate: 64 kb/s
    Stream #0.0: Video: flv, yuv420p, 350x250, 25 tbr, 1k tbn, 1k tbc
    Stream #0.1: Audio: mp3, 44100 Hz, stereo, s16, 64 kb/s
Output #0, mp4, to '/home/eesychee/public_html/newdesign/flash/modules/video/files/1.mp4':
    Stream #0.0: Video: mpeg4, yuv420p, 176x144, q=2-31, 512 kb/s, 25 tbn, 25 tbc
    Stream #0.1: Audio: libmp3lame, 44100 Hz, mono, s16, 64 kb/s
Stream mapping:

Can you make adjustment to migration script, so that even if it pauses, stops because of errors, it will resume migrating where it left off? And if it fails to succesfully migrate some fields, profiles, ads,blogs,etc.. it will give report at the end, what needs to be manually migrated? So that it provides report of what was NOT migrated

Try to execute these MySql queries via your PhpMyAdmin tool

--
-- Table structure for table `RayMp3Tokens`
--

CREATE TABLE `RayMp3Tokens` (
`ID` int(11) NOT NULL default '0',
`Token` varchar(32) NOT NULL default '',
`Date` int(20) NOT NULL default '0',
PRIMARY KEY `TokenId` (`ID`,`Token`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Table structure for table `RayVideoFiles`
--

CREATE TABLE `RayVideoTokens` (
`ID` int(11) NOT NULL default '0',
`Token` varchar(32) NOT NULL default '',
`Date` int(20) NOT NULL default '0',
PRIMARY KEY `TokenId` (`ID`,`Token`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Ok I executed that query, and restarded migration of sounds and video, and immediately got this errors emails:

1

Database access error. Description: Unknown column 'Status' in 'where clause'Database access error. Description: Table 'eesychee_dolphin.RayVideoFiles' doesn't exist

2

Database error in

Query:

SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1

Mysql error: MySQL server has gone away

Found error in the file '/home/eesychee/public_html/newdesign/inc/classes/BxDolEmailTemplates.php' at line 31.
Called 'getOne' function with erroneous argument #0.

3.

<div style="border:2px solid red;padding:4px;width:600px;margin:0px auto;">
                    <div style="text-align:center;background-color:red;color:white;font-weight:bold;">Error</div>
                    <div style="text-align:center;">Database query error</div>
                            </div>

Can you guys please provide manual instructions, for migration

The main things that I cant migrate is sounds, videos,ads,ads pictures

Plus, my cron is setup to run every minute.. is this a problem? Is this waht might be causing my MySQL server timeout errors?

My host told me that all the myslq timeouts are caused by too many resources being used, and my sql timing out and not responding. Maybe its because my cron is running every minute, and the script is trying to migrate too much at onece?

bump