Data migration

hi

when i try to configure the path for the data migration, it keep giving me this : Possible attack!!! All data has been collected and sent to the site owner for analysis....

in the email i got this :

I get the error that it cannot find directory or header.inc.php file not found.

when i go to my dir with dolphin 6.1.6 it does not have the header.inc.php file anywhere in the root.

any ideas on this one?

hello,

my install runs so far.

but the migration doesn´t work.

i setup the cron.php in my cpanel.

i put in the path to my old site and then wanted to move the data from profiles.

it was a long time working and now it says profiles transfered.

but no profiles are transfered.

Got the same issue as you man....

no luck either...:(

OK, i commented the security.inc.php on the header, and all working great

the profiles where transfered correctly, , image, blog, ads, forum, migrate well...

having error for video : PHP Fatal error:  Call to undefined function getConverterTmpl() in /subdomains/dev/httpdocs/v2/modules/boonex/data_migration/classes/BxDataMigrationVideos.php on line 221

blogs are transfered  but not image got this : PHP Warning:  chmod(): No such file or directory in /subdomains/dev/httpdocs/v2/modules/boonex/data_migration/classes/BxDataMigrationBlogs.php on line 136

friends are not transfered,..

Avatar was not set for profiles

TY

popy

POPY

how did you get this to work? now that my migration tool has already run and it says 0 transferred how do i get it to run again? when i try it says profiles already transferred....any ideas out there? Boonex has great ideas but no support!!

and also does anyone know what this error means in my email?

<br />
<b>Warning</b>:  Call-time pass-by-reference has been deprecated in <b>/home/content/90/5058690/

David

 Wich version of PHP and mysql do you use..??

   did you install the beta in the same server of your 6

i installed in the same server in other directory like /v2 or /v7b8,

popy

I keep on getting these emails with these errors when migrating, I got over 50  error emails

Warning: chmod(): Operation not permitted in /home/eesychee/public_html/newdesign/plugins/phpids/IDS/Caching/File.php on line 150

I use godaddy for my hosting. do you think that could be an issue?

i use php5+

mysql is Server version: 5.0.67.d7

everything is on the same server. I dont know what im doing wrong..

migration tool says complete but it is not

wich version of 6.1.X do you use..?

bye the way, friend list are not transfered, so i modified the scripts, for import friend list, there is my modif inside the transformprofiles function

$sQuery = "SELECT * FROM `FriendList`";
            $rResult = mysql_query($sQuery, $this -> rOldDb);
    while( $aRow = mysql_fetch_assoc($rResult) )
             {
     $sQuery =
                     "
                      INSERT INTO
                       `sys_friend_list`
                      SET
                       `ID`   = '{$aRow['ID']}',
                       `Profile`    = '{$aRow['Profile']}',
                       `Check`       = '{$aRow['Check']}',
                       `When`      = '{$aRow['Date']}'
       ";
       
       $iResult = (int) $this -> oMigrationModule -> _oDb -> query($sQuery);
               if($iResult <= 0) {
               return 'Database error. Cannot insert friend list in the database.';
               }
    }

wish it help some of you

popy

Hi, we will add all the missing component to

Delete row  from `bx_data_migration_transfers` where module name = 'profiles' and start module again

Hi

SashaE, think you should check the avatar migration too, it copy all the file over the directory correctly, but not update the profile for the avatar....

ty

popy

tickets was created :
http://www.boonex.com/trac/dolphin/ticket/1414
http://www.boonex.com/trac/dolphin/ticket/1415

Did you install the avatar module before transfer?

Yes, installed properlly, like i said before, the avatar are tranfered over the  /modules/boonex/avatar/data/images/  i have inside all image from profiles, but the link inside the DB was not set

popy

Another point

Membership level are not transfered too, then we need to update all users membership level...

popy

Hm.......

Will need to think about membership transfer

Can you show your site's URL?

http://dev.echangiste-pq.com/v2/

for the membership level, i'm writing right now a function for this, i will post it in the forum when it will complete,

i'm writing one too, for all custom profiles field that can be trasfered too, then with this Complete profile will be transfer....

regard

popy

There is my code for membership level migration.... added inside the transformProfiles function...

$sQuery = "Select * from `MemLevels`";
    $rResult = mysql_query($sQuery, $this -> rOldDb);
     while( $aRow = mysql_fetch_assoc($rResult) )
             {
    if( !$this -> isLevelExisting($aRow['Name']) ) {
                     // escape all data;
                     $aRow = $this -> escapeData($aRow);
     
       $sQuery =
                     "
                      INSERT INTO
                       `sys_acl_levels`
                      SET
                       `ID`   = '{$aRow['ID']}',
                       `Name`    = '{$aRow['Name']}',
                       `Icon`       = 'member.png',
                       `Description`    = 'imported',
                       `Active`      = '{$aRow['Active']}',
                       `Purchasable`     = '{$aRow['Purchasable']}',
                       `Removable`        = '{$aRow['Removable']}'
       ";
      $iResult = (int) $this -> oMigrationModule -> _oDb -> query($sQuery);
               if($iResult <= 0) {
               return 'Database error. Cannot insert MembershipLevel in the database.';
               } 
     }
    }
   
    $sQuery = "SELECT * FROM `ProfileMemLevels`";
            $rResult = mysql_query($sQuery, $this -> rOldDb);
    while( $aRow = mysql_fetch_assoc($rResult) )
             {
     $sQuery =
                     "
                      INSERT INTO
                       `sys_acl_levels_members`
                      SET
                       `IDMember`   = '{$aRow['IDMember']}',
                       `IDLevel`    = '{$aRow['IDLevel']}',
                       `DateStarts`       = '{$aRow['DateStarts']}',
                       `DateExpires`      = '{$aRow['DateExpires']}',
       `TransactionID`       = '{$aRow['TransactionID']}'
       ";
       
       $iResult = (int) $this -> oMigrationModule -> _oDb -> query($sQuery);
               if($iResult <= 0) {
               return 'Database error. Cannot insert MembershipLevel in the database.';
               }
    }

popy

Hi popy,

can you tell me which file did you opened and modified.


I tried to transfer profiles but they still is profiles in queue...


Can you tell me what you did? :/

 did you set the crontab correctly...???

i modified the /modules/boonex/data_migration/classes/BxDataMigrationProfiles.php

popy

I get this info about cron job when i installed dolphin.

MAILTO=mail@mail.net
* * * * * cd /home2/site/public_html/site.net/D-7v8/periodic; /usr/local/bin/php -q cron.php

And what did you modified there precise?

 you have to setup the cron job via your admin panel of your hosting provider (cpanel, plesk, etc)

popy

SashaE

 did you think about the membership transfers..? will you add it ..?

and what about custom profiles fields...???

popy

Yes I've same problem with u Popy.

Hello,

We are decided to add new modules :
1. Transfer all membership levels
2. Transfer all custom fields from `profiles` and `prevalues` tables

tickets :

http://www.boonex.com/trac/dolphin/ticket/1440
http://www.boonex.com/trac/dolphin/ticket/1441

 thank you, with the custom field, is these field will be transfered when we will transfer the profile..?

popy

Wow... lot of very good news here :-) Thank you popy1970 and Sasha for everything you have done to transfer all profile related datas ;-)

TY Micheal....

 bye the way, video not convert got this : PHP Fatal error:  Call to undefined function getConverterTmpl() in /subdomains/dev/httpdocs/v2/modules/boonex/data_migration/classes/BxDataMigrationVideos.php on line 221

i added the function inside the module, and all is ok now....

popy

 Hi 

I just saw that Groups are not transfered too, will you add this module too inside the data migration...?

popy

Poppy . . .   when you said you "added the function inside the module, and all is ok now ...."   Can you share the function code you added for this?  I am getting the same PHP Fatal error when trying to migrate videos.

Hello video module was fixed, try to update the BxDataMigrationVideos.php

SashaE - thanks for the information!

I did the update in the admin area, and I am now running the video migration again (First cleaning out the DB Table and files folder so I get a fresh start)

First thing I noticed is that I immediately got a cron email

Fatal error: Call to undefined function  getconvertertmpl() in /home/bustingh/public_html/testD7RC/modules/boonex/data_migration/classes/BxDataMigrationVideos.php on line 221

When I started the Video Transfer, the module said "Processing"

Then, it appeared that it converted one video  and now it says "Videos Transfer Now"

Here, it seems to maybe have hung up or quit?   I will let it run for an hour more and see if anything more has been done, but it almost looks as if it is still failing for me.

SashaE,

No matte what I do I still get the same cron error and the video migration stops after the first conversion.

I have uninstalled and reinstalled both the Data Migration module and the Videos module.  I have also updated them both in the Admin area.

But still, when I run the video migration, it says "processing" for a few minutes and then it switches to "Videos Transfer Now"

That is where it ends.   Id does create the first video file in flash/modules/videos/files/

But it does NOT insert any information into the RayVideoFiles table, as instructed.

At this point, I get a cron email :

Fatal error: Call to undefined function  getconvertertmpl() in /home/bustingh/public_html/testD7RC/modules/boonex/data_migration/classes/BxDataMigrationVideos.php on line 221

And it does not do anything else from here. .  .

I know you guys said the function inside the module . . but it appears it is still not there ????

Update:

I was able to get my Data Migration VIDEO module working finally.

After two days of scratching my head and hunting through code, I decided to add this bit of code to the BxDataMigrationVideos.php file - just below require_once('BxDataMigrationData.php');

I am not sure if ALL of this is needed, but it worked for me so I will keep it

Here is the code I added and the video migration worked perfect:

function getVideoSize($sInputFile)

{

global $sFfmpegPath;

global $sFilesPath;

if(!file_exists($sInputFile) || filesize($sInputFile)==0)

{

if(strpos($sInputFile, $sFilesPath) === FALSE) return $sInputFile;

else return VIDEO_SIZE_16_9;

}

$sFile = $sFilesPath . time() . IMAGE_EXTENSION;

if(convertVideoFile($sFile, $sFfmpegPath . " -y -i " . $sInputFile . " -ss 0 -vframes 1 -an -sameq -f image2 " . $sFile))

{

$aSize = getimagesize($sFile);

@unlink($sFile);

$iRelation = $aSize[0]/$aSize[1];

$i169Dif = abs($iRelation - 16/9);

$i43Dif = abs($iRelation - 4/3);

if($i169Dif > $i43Dif) return VIDEO_SIZE_4_3;

else return VIDEO_SIZE_16_9;

}

return VIDEO_SIZE_16_9;

}

function getConverterTmpl($sInputFile, $sSize, $bSound = true, $bRecorded = false)

{

global $sModule;

global $sFfmpegPath;

$sSound = $bRecorded ? " -ar 44100 " : " -acodec libmp3lame -ar 44100 ";

if(!$bSound) $sSound = " -an ";

$sTmpl = $sFfmpegPath . " -y -i " . $sInputFile . " -r " . getVideoFps() . " -s " . getVideoSize($sSize) . $sSound;

if(getSettingValue($sModule, "sameQuality") == TRUE_VAL) $sTmpl .= "-sameq ";

return $sTmpl;

}

function getVideoFps()

{

global $sModule;

$iFps = getSettingValue($sModule, "fps");

if(empty($iFps) || !is_int($iFps) || $iFps < 10)

$iFps = 25;

return $iFps;

}

function convertVideoFile($sFile, $sCommand)

{

@popen($sCommand, "r");

return file_exists($sFile) && filesize($sFile) > 0;

}

function convertMainVideo($sId, $sTmpl = "", $bRecorded = false)

{

global $sFilesPath;

global $sModule;

global $sFfmpegPath;

$sTempFile = $sFilesPath . $sId;

if(!file_exists($sTempFile)) $sTempFile .= TEMP_FILE_NAME;

$sPlayFile = $sTempFile . PLAY_EXTENSION;

$bResult = true;

if(!file_exists($sPlayFile) || filesize($sPlayFile)==0)

{

if(empty($sTmpl)) $sTmpl = getConverterTmpl($sTempFile, $sTempFile, true, $bRecorded) . " -vfilters hflip ";

$bResult = convertVideoFile($sPlayFile, $sTmpl . $sPlayFile);

if(!$bResult)

{

$sTmpl = getConverterTmpl($sTempFile, $sTempFile, false);

$bResult = convertVideoFile($sPlayFile, $sTmpl . $sPlayFile);

}

}

return $bResult && grabImages($sPlayFile, $sTempFile);

}

function convertVideo($sId)

{

global $sModule;

global $sFfmpegPath;

global $sFilesPath;

$sTempFile = $sFilesPath . $sId;

$sSourceFile = $sTempFile;

$sTmpl = "";

if(file_exists($sTempFile) && filesize($sTempFile)>0) $sTmpl = getConverterTmpl($sTempFile, $sTempFile);

else

{

$sSourceFile .= PLAY_EXTENSION;

if(file_exists($sSourceFile) && filesize($sSourceFile)>0)

$sTmpl = getConverterTmpl($sSourceFile, $sSourceFile);

}

if(empty($sTmpl)) return false;

$sDBModule = DB_PREFIX . ucfirst($sModule);

getResult("UPDATE `" . $sDBModule . "Files` SET `Date`='" . time() . "', `Status`='" . STATUS_PROCESSING . "' WHERE `ID`='" . $sId . "'");

$bResult = convertMainVideo($sId, $sTmpl);

if(!$bResult) return false;

$sSaveFile = $sTempFile . SAVE_EXTENSION;

$sSaveCommand = $sTmpl . $sSaveFile;

$sMobileFile = $sTempFile . MOBILE_EXTENSION;

$sMobileCommand = getConverterTmpl($sSourceFile, "qcif") . "-b 180 -sameq -ab 64 -acodec libmp3lame -ac 1 " . $sMobileFile;

$bResult = convertVideoFile($sSaveFile, $sSaveCommand) && convertVideoFile($sMobileFile, $sMobileCommand);

if($bResult)

{

$sAutoApprove = getSettingValue($sModule, "autoApprove") == TRUE_VAL ? STATUS_APPROVED : STATUS_DISAPPROVED;

getResult("UPDATE `" . $sDBModule . "Files` SET `Date`='" . time() . "', `Status`='" . $sAutoApprove . "' WHERE `ID`='" . $sId . "'");

}

else

{

getResult("UPDATE `" . $sDBModule . "Files` SET `Status`='" . STATUS_FAILED . "' WHERE `ID`='" . $sId . "'");

}

deleteTempFiles($sId);

return $bResult;

}

function grabImages($sInputFile, $sOutputFile, $iSecond = 0, $bForse = false)

{

$sImageFile = $sOutputFile . IMAGE_EXTENSION;

$sThumbFile = $sOutputFile . THUMB_FILE_NAME . IMAGE_EXTENSION;

if(!$bForse && file_exists($sImageFile) && filesize($sImageFile)>0) $bResult = true;

else $bResult = convertVideoFile($sImageFile, getGrabImageTmpl($sInputFile, $sImageFile, "", $iSecond));

if(!$bResult) return false;

if(!$bForse && file_exists($sThumbFile) && filesize($sThumbFile)>0) $bResult = true;

else $bResult = convertVideoFile($sThumbFile, getGrabImageTmpl($sInputFile, $sThumbFile, THUMB_SIZE, $iSecond));

return $bResult;

}

function getGrabImageTmpl($sInputFile, $sOutputFile, $sSize = "", $iSecond = 0)

{

global $sFfmpegPath;

$sCommand = $sFfmpegPath . " -y -i " . $sInputFile . " -ss " . $iSecond . " -vframes 1 -an -sameq -f image2 ";

if(!empty($sSize)) $sCommand .= "-s " . $sSize . " ";

return $sCommand . $sOutputFile;

}

function deleteTempFiles($sUserId, $bSourceOnly = false)

{

global $sFilesPath;

$sTempFile = $sUserId . TEMP_FILE_NAME;

@unlink($sFilesPath . $sUserId);

@unlink($sFilesPath . $sTempFile);

if($bSourceOnly) return;

@unlink($sFilesPath . $sTempFile . IMAGE_EXTENSION);

@unlink($sFilesPath . $sTempFile . THUMB_FILE_NAME . IMAGE_EXTENSION);

@unlink($sFilesPath . $sTempFile . PLAY_EXTENSION);

@unlink($sFilesPath . $sTempFile . SAVE_EXTENSION);

}

/**

* Delete file

* @param $sFile - file identificator

* @return $bResult - result of operation (true/false)

*/

function deleteVideo($sFile)

{

global $sFilesPath;

global $oDb;

global $sModule;

$sDBModule = DB_PREFIX . ucfirst($sModule);

getResult("DELETE FROM `" . $sDBModule . "Files` WHERE `ID`='" . $sFile . "'");

if(mysql_affected_rows($oDb->rLink))

video_parseTags($sFile);

$sFileName = $sFilesPath . $sFile;

@unlink($sFileName);

$bResult =  @unlink($sFileName . PLAY_EXTENSION) &&

@unlink($sFileName . SAVE_EXTENSION) &&

@unlink($sFileName . IMAGE_EXTENSION) &&

@unlink($sFileName . THUMB_FILE_NAME . IMAGE_EXTENSION);

return $bResult;

}

function getToken($sId)

{

global $sFilesPath;

global $sModule;

$sDBModule = DB_PREFIX . ucfirst($sModule);

if(file_exists($sFilesPath . $sId . PLAY_EXTENSION))

{

$iCurrentTime = time();

$sToken = md5($iCurrentTime);

getResult("INSERT INTO `" . $sDBModule . "Tokens`(`ID`, `Token`, `Date`) VALUES('" . $sId . "', '" . $sToken . "', '" . $iCurrentTime . "')");

return $sToken;

}

return "";

}

Hi, I got all transfer excep Sounds, can somebody help me?? I don´t know what to do. I unistalled data-migration mod and reinstall again with new version, but nothing change

I have a problem ?


http://www.boonex.com/unity/forums/topic/Dolphin-7-error.htm#topic/Dolphin-7-error.htm

I had the same problem when I first started with the RC version.

It was a cronjob problem.

You have to rewrite the cronjob.

This is what I did:

- I did a clean install on a new subdomain.

- changed the install cronjob to:

MAILTO=your@email.tld
* * * * * /usr/local/bin/php -q /your/dolphindir/periodic/cron.php

- Installed all modules in adminpanel

- started transferring profiles

- then transferred photos, videos etc

with this new cronjob everything worked for me

 What sounds are meant to transfer over? When I did the migration it said sounds were all transferred but in the brackets it had a big fat zero.

migration is a cronjob thing.

maybe this will help too

http://www.boonex.com/unity/forums/#topic/Cron-Jobs-Migrations-Videos.htm

here is my cron file

-----------------------------------------

<?php
/***************************************************************************
* Dolphin Smart Community Builder
* -----------------
* begin : Mon Mar 23 2006
* copyright : (C) 2006 BoonEx Group
* website : http://www.boonex.com/
* This file is part of Dolphin - Smart Community Builder
*
* Dolphin is free software. This work is licensed under a Creative Commons Attribution 3.0 License.
* http://creativecommons.org/licenses/by/3.0/
*
* Dolphin is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
* without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
* See the Creative Commons Attribution 3.0 License for more details.
* You should have received a copy of the Creative Commons Attribution 3.0 License along with Dolphin,
* see license.txt file; if not, write to marketing@boonex.com
***************************************************************************/

$GLOBALS['bx_profiler_disable'] = true;

$aPathInfo = pathinfo(__FILE__);
require_once ($aPathInfo['dirname'] . '/../inc/header.inc.php');
require_once(BX_DIRECTORY_PATH_INC . 'utils.inc.php');
require_once(BX_DIRECTORY_PATH_INC . 'profiles.inc.php' );
require_once(BX_DIRECTORY_PATH_CLASSES . 'BxDolDb.php');

define('BX_DOL_CRON_EXECUTE', '1');

MAILTO=contact@khadhormedia.com
* * * * * cd /home/khadhorm/public_html/periodic; /usr/local/bin/php -q cron.php
0 0 * * * /usr/local/bin/php cs /home/khadhorm/public_html/periodic/cmd.php
*/10 * * * * /usr/local/bin/php cd /home/khadhorm/public_html/periodic/notifies.php
* */1 * * * /usr/local/bin/php cd /home/khadhorm/public_html/periodic/cupid.php


/*
* This file is used for cron jobs. He is started system cron every minute.
* The file runs jobs at regular intervals. These jobs are listed in `sys_cron_jobs` table.
*
* Fields shark_cron_jobs table:
* id - key for the table
* name - job name to be executed
* time - format of entries are five fields of numbers specifying the minute,
* hour, day of the month, month and day of the week that a task must be executed.
*
* * * * * *
* | | | | |
* | | | | +--- day of week(0-6 with 0=Sunday)
* | | | +----- month(1-12)
* | | +------- day of month(1-31)
* | +--------- hour(0-23)
* +----------- minute(0-59)
*
* class - class name which will run
* file - path to class file
* eval - source code which will run
*
* The time numbers can be given as a comma separated list of simple numbers,
* ranges("2-5" is the same as "2,3,4,5"). A single "*" can be used in a field to indicate all
* valid numbers in that field, so it translates to "always". If a given time is valid in all five
* fields then a module function is executed. Here are a few examples that illustrate the possibilities:
*
* will run at 16:10:
* 10 16
* will run at 2:00 on saturday:
* 0 2 * * 6
* will run at midnight on new years:
* 0 0 1 1 0
* will run every 15 minutes:
* *\/15
* will run at 22:00 on work weekdays:
* 0 22 * * 1-5
* will run each 23 minutes, 2:00, 4:00 ..., everyday
* 23 0-23/2
*
* Example add new cron job:
*
* 1. Create new class inherited from "BxDolCron" and add method "processing"
*
* class BxDolCronMy extends BxDolCron {
*
* function processing()
* {
* // insert code
* }
* }
*
* 2. Add record in `sys_cron_jobs` table
*
* @see an example of BxDolCronNotifies, BxDolCronCupid, BxDolCronCmd.
*
*
* Memberships/ACL:
* Doesn't depend on user's membership.
*
*
* Alerts:
* no alerts available
*
*/
function getRange($iLow, $iHigh, $iStep)
{
$aResult = array();
for ($i = $iLow; $i <= $iHigh && $iStep; $i += $iStep)
$aResult[] = $i;
return $aResult;
}

function getPeriod($sPeriod, $iLow, $iHigh)
{
$aRes = array();
$iStep = 1;
$sErr = '';

do
{
if (!$sPeriod)
{
$sErr = 'Variable sPeriod is emply';
break;
}

$aParam = split('/', $sPeriod);

if (count($aParam) > 2)
{
$sErr = 'Error of format for string assigning period';
break;
}

if (count($aParam) == 2 && is_numeric($aParam[1]))
$iStep = $aParam[1];

$sPeriod = $aParam[0];

if ($sPeriod != '*')
{
$aParam = split('-', $sPeriod);

if (count($aParam) > 2)
{
$sErr = 'Error of format for string assigning period';
break;
}

if (count($aParam) == 2)
$aRes = getRange($aParam[0], $aParam[1], $iStep);
else
$aRes = split(',', $sPeriod);
}
else
$aRes = getRange($iLow, $iHigh, $iStep);
}
while(false);

if ($sErr)
{
// show error or add to log
}

return $aRes;
}

function checkCronJob($sPeriods)
{
$aParam = split(' ', ereg_replace(" +", ' ', trim($sPeriods)));
$bRes = true;
$aDate = getdate(time());

for ($i = 0; $i < count($aParam); $i++)
{
switch ($i)
{
case 0:
$aRes = getPeriod($aParam[$i], 0, 59);
$bRes = in_array($aDate['minutes'], $aRes);
break;
case 1:
$aRes = getPeriod($aParam[$i], 0, 23);
$bRes = in_array($aDate['hours'], $aRes);
break;
case 2:
$aRes = getPeriod($aParam[$i], 1, 31);
$bRes = in_array($aDate['mday'], $aRes);
break;
case 3:
$aRes = getPeriod($aParam[$i], 1, 12);
$bRes = in_array($aDate['mon'], $aRes);
break;
case 4:
$aRes = getPeriod($aParam[$i], 0, 6);
$bRes = in_array($aDate['wday'], $aRes);
break;
}

if (!$bRes)
break;
}

return $bRes;
}

function runJob($aJob)
{
if(!empty($aJob['file']) && !empty($aJob['class']) && file_exists(BX_DIRECTORY_PATH_ROOT . $aJob['file'])) {
if(!class_exists($aJob['class']))
require_once(BX_DIRECTORY_PATH_ROOT . $aJob['file']);

$oHandler = new $aJob['class']();
$oHandler->processing();
}
else if(!empty($aJob['eval'])) {
require_once( BX_DIRECTORY_PATH_CLASSES . 'BxDolService.php');
eval($aJob['eval']);
}
}

$oDb = new BxDolDb();

$aJobs = $oDb->fromCache('sys_cron_jobs', 'getAll', 'SELECT * FROM `sys_cron_jobs`');
foreach ($aJobs as $aRow)
{
if (checkCronJob($aRow['time']))
runJob($aRow);
}

?>

-------

Create a new cron:

MAILTO=contact@khadhormedia.com
* * * * * /usr/local/bin/php -q /home/khadhorm/public_html/periodic/cron.php

I think I wrote your path to root corectly, but check it again please.

It must be the complete path to your rootdirectory!

I had this same problem too and someone else rewrote the cron for me from the original one

to

That worked for me.

I have this problem after file modification. htaccess:

http://www.boonex.com/trac/dolphin/wiki/6.1.6to7.0

----

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.

----------

Options -MultiViews

<IfModule mod_php4.c>
php_flag register_globals Off
</IfModule>
<IfModule mod_php5.c>
php_flag allow_url_include Off
php_flag register_globals Off
</IfModule>

<IfModule mod_rewrite.c>
RewriteEngine on
RewriteBase /
RewriteRule ^articles/{0,1}$ m/articles/index/ [QSA,L,R=permanent]
RewriteRule ^articles/entry/([^/.]+)/{0,1}$ m/articles/view/$1 [QSA,L,R=permanent]
RewriteRule ^articles/entry/{0,1}$ m/articles/view/$1 [QSA,L,R=permanent]
RewriteRule ^articles/category/([^/.]+)/{0,1}$ m/articles/category/$1 [QSA,L,R=permanent]

RewriteRule ^news/{0,1}$ m/news/index/ [QSA,L,R=permanent]
RewriteRule ^news/([^/.]+)/{0,1}$ m/news/view/$1 [QSA,L,R=permanent]

RewriteRule ^ads/search/{0,1}$ classifieds.php?SearchForm=1 [QSA,L,R=permanent]
RewriteRule ^ads/my/{0,1}$ modules/boonex/ads/classifieds.php?action=my_page [QSA,L,R=permanent]
RewriteRule ^ads/new/{0,1}$ modules/boonex/ads/classifieds.php?action=show_all_ads [QSA,L,R=permanent]

RewriteRule ^events/{0,1}$ m/events/home/ [QSA,L,R=permanent]
RewriteRule ^events/all/([0-9]+)/([0-9]+)/{0,1}$ m/events/browse/upcoming/$2/$1 [QSA,L,R=permanent]
RewriteRule ^events/part/{0,1}$ m/events/browse/upcoming/ [QSA,L,R=permanent]
RewriteRule ^events/search/{0,1}$ m/events/browse/ [QSA,L,R=permanent]
RewriteRule ^events/search/([^/.]+)/{0,1}$ m/events/browse/tag/$1 [QSA,L,R=permanent]
RewriteRule ^events/my/{0,1}$ m/events/browse/my [QSA,L,R=permanent]
RewriteRule ^events/new/{0,1}$ m/events/browse/upcoming [QSA,L,R=permanent]
RewriteRule ^events/entry/([^/.]+)/{0,1}$ m/events/view/$1 [QSA,L,R=permanent]
RewriteRule ^events/part/([^/.]+)/{0,1}$ m/events/browse_participants/$1 [QSA,L,R=permanent]

RewriteRule ^groups/all/{0,1}$ m/groups/home/ [QSA,L,R=permanent]
RewriteRule ^groups/entry/([^/.]+)/{0,1}$ m/groups/view/$1 [QSA,L,R=permanent]
RewriteRule ^groups/category/([^/.]+)/{0,1}$ m/groups/browse/category/$1 [QSA,L,R=permanent]
RewriteRule ^groups/keyword/([^/.]+)/{0,1}$ m/groups/browse/tag/$1 [QSA,L,R=permanent]

RewriteRule ^photo/all/([0-9]+)/([0-9]+)/{0,1}$ m/photos/browse/all/&page=$2&per_page=$1 [QSA,L,R=permanent]
RewriteRule ^photo/gallery_top/{0,1}$ m/photos/browse/top/ [QSA,L,R=permanent]
RewriteRule ^photo/gallery_top/([0-9]+)/([0-9]+)/{0,1}$ m/photos/browse/top/&page=$2&per_page=$1 [QSA,L,R=permanent]
RewriteRule ^photo/gallery_top/([0-9]+)/([0-9]+)/{0,1}$ m/photos/top/&page=$2&per_page=$1 [QSA,L,R=permanent]
RewriteRule ^photo/gallery_tag/([^/.]+)/([0-9]+)/([0-9]+)/{0,1}$ m/photos/browse/tag/$1&page=$3&per_page=$2 [QSA,L,R=permanent]
RewriteRule ^photo/gallery_tag/([^/.]+)/([0-9]+)/([0-9]+)/$ m/photos/browse/tag/$1&page=$3&per_page=$2 [QSA,L,R=permanent]
RewriteRule ^photo/gallery_tag/([^/.]+)/{0,1}$ m/photos/browse/tag/$1 [QSA,L,R=permanent]
RewriteRule ^photo/gallery/all/([^/.]+)/([0-9]+)/([0-9]+)$ m/photos/albums/browse/owner/$1&page=$3&per_page=$2 [QSA,L,R=permanent]
RewriteRule ^photo/gallery/all/([^/.]+)/([0-9]+)/([0-9]+)/$ m/photos/albums/browse/owner/$1&page=$3&per_page=$2 [QSA,L,R=permanent]
RewriteRule ^photo/gallery/all/([^/.]+)/{0,1}$ m/photos/albums/browse/owner/$1 [QSA,L,R=permanent]
RewriteRule ^photo/gallery/([^/.]+)/{0,1}$ m/photos/view/$1 [QSA,L,R=permanent]
RewriteRule ^photo/gallery/{0,1}$ m/photos/view/$1 [QSA,L,R=permanent]

RewriteRule ^music/all/([0-9]+)/([0-9]+)/{0,1}$ m/sounds/browse/all/&page=$2&per_page=$1 [QSA,L,R=permanent]
RewriteRule ^music/gallery_top/{0,1}$ m/sounds/browse/top/ [QSA,L,R=permanent]
RewriteRule ^music/gallery_top/([0-9]+)/([0-9]+)/{0,1}$ m/sounds/browse/top/&page=$2&per_page=$1 [QSA,L,R=permanent]
RewriteRule ^music/gallery_top/([0-9]+)/([0-9]+)/{0,1}$ m/sounds/top/&page=$2&per_page=$1 [QSA,L,R=permanent]
RewriteRule ^music/gallery_tag/([^/.]+)/([0-9]+)/([0-9]+)/{0,1}$ m/sounds/browse/tag/$1&page=$3&per_page=$2 [QSA,L,R=permanent]
RewriteRule ^music/gallery_tag/([^/.]+)/([0-9]+)/([0-9]+)/$ m/sounds/browse/tag/$1&page=$3&per_page=$2 [QSA,L,R=permanent]
RewriteRule ^music/gallery_tag/([^/.]+)/{0,1}$ m/sounds/browse/tag/$1 [QSA,L,R=permanent]
RewriteRule ^music/gallery/all/([^/.]+)/([0-9]+)/([0-9]+)$ m/sounds/albums/browse/owner/$1&page=$3&per_page=$2 [QSA,L,R=permanent]
RewriteRule ^music/gallery/all/([^/.]+)/([0-9]+)/([0-9]+)/$ m/sounds/albums/browse/owner/$1&page=$3&per_page=$2 [QSA,L,R=permanent]
RewriteRule ^music/gallery/all/([^/.]+)/{0,1}$ m/sounds/albums/browse/owner/$1 [QSA,L,R=permanent]
RewriteRule ^music/gallery/([^/.]+)/{0,1}$ m/sounds/view/$1 [QSA,L,R=permanent]
RewriteRule ^music/gallery/{0,1}$ m/sounds/view/$1 [QSA,L,R=permanent]

RewriteRule ^video/all/([0-9]+)/([0-9]+)/{0,1}$ m/videos/browse/all/&page=$2&per_page=$1 [QSA,L,R=permanent]
RewriteRule ^video/gallery_top/{0,1}$ m/videos/browse/top/ [QSA,L,R=permanent]
RewriteRule ^video/gallery_top/([0-9]+)/([0-9]+)/{0,1}$ m/videos/browse/top/&page=$2&per_page=$1 [QSA,L,R=permanent]
RewriteRule ^video/gallery_top/([0-9]+)/([0-9]+)/{0,1}$ m/videos/top/&page=$2&per_page=$1 [QSA,L,R=permanent]
0RewriteRule ^video/gallery_tag/([^/.]+)/([0-9]+)/([0-9]+)/{0,1}$ m/videos/browse/tag/$1&page=$3&per_page=$2 [QSA,L,R=permanent]
0RewriteRule ^video/gallery_tag/([^/.]+)/([0-9]+)/([0-9]+)/$ m/videos/browse/tag/$1&page=$3&per_page=$2 [QSA,L,R=permanent]
RewriteRule ^video/gallery_tag/([^/.]+)/{0,1}$ m/videos/browse/tag/$1 [QSA,L,R=permanent]
RewriteRule ^video/gallery/all/([^/.]+)/([0-9]+)/([0-9]+)$ m/videos/albums/browse/owner/$1&page=$3&per_page=$2 [QSA,L,R=permanent]
RewriteRule ^video/gallery/all/([^/.]+)/([0-9]+)/([0-9]+)/$ m/videos/albums/browse/owner/$1&page=$3&per_page=$2 [QSA,L,R=permanent]
RewriteRule ^video/gallery/all/([^/.]+)/{0,1}$ m/videos/albums/browse/owner/$1 [QSA,L,R=permanent]
RewriteRule ^video/gallery/([^/.]+)/{0,1}$ m/videos/view/$1 [QSA,L,R=permanent]
RewriteRule ^video/gallery/{0,1}$ m/videos/view/$1 [QSA,L,R=permanent]


RewriteRule ^blogs/{0,1}$ modules/boonex/blogs/blogs.php [QSA,L]
RewriteRule ^blogs/all/([0-9]+)/([0-9]+)/{0,1}$ modules/boonex/blogs/blogs.php?page=$2&per_page=$1 [QSA,L]
RewriteRule ^blogs/top/{0,1}$ modules/boonex/blogs/blogs.php?action=top_blogs [QSA,L]
RewriteRule ^blogs/top/([0-9]+)/([0-9]+)/{0,1}$ modules/boonex/blogs/blogs.php?action=top_blogs&page=$2&per_page=$1 [QSA,L]
RewriteRule ^blogs/top_posts/{0,1}$ modules/boonex/blogs/blogs.php?action=top_posts [QSA,L]
RewriteRule ^blogs/top_posts/([0-9]+)/([0-9]+)/{0,1}$ modules/boonex/blogs/blogs.php?action=top_posts&page=$2&per_page=$1 [QSA,L]
RewriteRule ^blogs/tag/([^/.]+)/{0,1}$ modules/boonex/blogs/blogs.php?action=search_by_tag&tagKey=$1 [QSA,L]
RewriteRule ^blogs/tag/{0,1}$ modules/boonex/blogs/blogs.php?action=search_by_tag&tagKey= [QSA,L]
RewriteRule ^blogs/posts/([^/.]+)/tag/([^/.]+)/{0,1}$ modules/boonex/blogs/blogs.php?action=search_by_tag&tagKey=$2&ownerName=$1 [QSA,L]
RewriteRule ^blogs/posts/([^/.]+)/category/([^/.]+)/{0,1}$ modules/boonex/blogs/blogs.php?action=show_member_blog&ownerName=$1&categoryUri=$2 [QSA,L]
RewriteRule ^blogs/entry/([^/.]+)/{0,1}$ modules/boonex/blogs/blogs.php?action=show_member_post&postUri=$1 [QSA,L]
RewriteRule ^blogs/entry/{0,1}$ modules/boonex/blogs/blogs.php?action=show_member_post&postUri= [QSA,L]
RewriteRule ^blogs/posts/([^/.]+)/{0,1}$ modules/boonex/blogs/blogs.php?action=show_member_blog&ownerName=$1 [QSA,L]
RewriteRule ^blogs/posts/{0,1}$ modules/boonex/blogs/blogs.php?action=show_member_blog&ownerName= [QSA,L]
RewriteRule ^blogs/posts/([^/.]+)/([0-9]+)/([0-9]+)/{0,1}$ modules/boonex/blogs/blogs.php?action=show_member_blog&ownerName=$1&page=$3&per_page=$2 [QSA,L]
RewriteRule ^blogs/posts/([^/.]+)/category/([^/.]+)/([0-9]+)/([0-9]+)/{0,1}$ modules/boonex/blogs/blogs.php?action=show_member_blog&ownerName=$1&categoryUri=$2&page=$4&per_page=$3 [QSA,L]
RewriteRule ^blogs/home/{0,1}$ modules/boonex/blogs/blogs.php?action=home [QSA,L]
RewriteRule ^blogs/all_posts/{0,1}$ modules/boonex/blogs/blogs.php?action=all_posts [QSA,L]
RewriteRule ^blogs/popular_posts/{0,1}$ modules/boonex/blogs/blogs.php?action=popular_posts [QSA,L]
RewriteRule ^blogs/featured_posts/{0,1}$ modules/boonex/blogs/blogs.php?action=featured_posts [QSA,L]
RewriteRule ^blogs/tags/{0,1}$ modules/boonex/blogs/blogs.php?action=tags [QSA,L]
RewriteRule ^blogs/show_calendar/{0,1}$ modules/boonex/blogs/blogs.php?action=show_calendar [QSA,L]
RewriteRule ^blogs/my_page/{0,1}$ modules/boonex/blogs/blogs.php?action=my_page&mode=main [QSA,L]
RewriteRule ^blogs/my_page/add/{0,1}$ modules/boonex/blogs/blogs.php?action=my_page&mode=add [QSA,L]
RewriteRule ^blogs/my_page/manage/{0,1}$ modules/boonex/blogs/blogs.php?action=my_page&mode=manage [QSA,L]
RewriteRule ^blogs/my_page/pending/{0,1}$ modules/boonex/blogs/blogs.php?action=my_page&mode=pending [QSA,L]
RewriteRule ^blogs/my_page/edit/([0-9]+)/{0,1}$ modules/boonex/blogs/blogs.php?action=edit_post&EditPostID=$1 [QSA,L]
RewriteRule ^blogs/member_posts/([0-9]+)/{0,1}$ modules/boonex/blogs/blogs.php?action=show_member_blog&ownerID=$1 [QSA,L]
RewriteRule ^blogs/category/([^/.]+)/{0,1}$ modules/boonex/blogs/blogs.php?action=category&uri=$1 [QSA,L]

RewriteRule ^ads/{0,1}$ modules/boonex/ads/classifieds.php?Browse=1 [QSA,L]
RewriteRule ^ads/my_page/{0,1}$ modules/boonex/ads/classifieds.php?action=my_page [QSA,L]
RewriteRule ^ads/my_page/add/{0,1}$ modules/boonex/ads/classifieds.php?action=my_page&mode=add [QSA,L]
RewriteRule ^ads/my_page/edit/([0-9]+)/{0,1}$ modules/boonex/ads/classifieds.php?action=my_page&mode=add&EditPostID=$1 [QSA,L]
RewriteRule ^ads/my_page/edit/([0-9]+)/dimg/([0-9]+)/{0,1}$ modules/boonex/ads/classifieds.php?action=my_page&mode=add&EditPostID=$1&dimg=$2 [QSA,L]
RewriteRule ^ads/my_page/manage/{0,1}$ modules/boonex/ads/classifieds.php?action=my_page&mode=manage [QSA,L]
RewriteRule ^ads/my_page/pending/{0,1}$ modules/boonex/ads/classifieds.php?action=my_page&mode=pending [QSA,L]
RewriteRule ^ads/my_page/disapproved/{0,1}$ modules/boonex/ads/classifieds.php?action=my_page&mode=disapproved [QSA,L]
RewriteRule ^ads/cat/([^/.]+)/{0,1}$ modules/boonex/ads/classifieds.php?catUri=$1 [QSA,L]
RewriteRule ^ads/all/cat/([0-9]+)/([0-9]+)/([^/.]+)/{0,1}$ modules/boonex/ads/classifieds.php?catUri=$3&page=$2&per_page=$1 [QSA,L]
RewriteRule ^ads/subcat/([^/.]+)/{0,1}$ modules/boonex/ads/classifieds.php?scatUri=$1 [QSA,L]
RewriteRule ^ads/all/subcat/([0-9]+)/([0-9]+)/([^/.]+)/{0,1}$ modules/boonex/ads/classifieds.php?scatUri=$3&page=$2&per_page=$1 [QSA,L]
RewriteRule ^ads/entry/([^/.]+)/{0,1}$ modules/boonex/ads/classifieds.php?entryUri=$1 [QSA,L]
RewriteRule ^ads/tag/([^/.]+)/{0,1}$ modules/boonex/ads/classifieds_tags.php?tag=$1 [QSA,L]
RewriteRule ^ads/calendar/{0,1}$ modules/boonex/ads/classifieds.php?action=show_calendar [QSA,L]
RewriteRule ^ads/categories/{0,1}$ modules/boonex/ads/classifieds.php?action=show_categories [QSA,L]
RewriteRule ^ads/tags/{0,1}$ modules/boonex/ads/classifieds.php?action=tags [QSA,L]
RewriteRule ^ads/all_ads/{0,1}$ modules/boonex/ads/classifieds.php?action=show_all_ads [QSA,L]
RewriteRule ^ads/top_ads/{0,1}$ modules/boonex/ads/classifieds.php?action=show_top_rated [QSA,L]
RewriteRule ^ads/popular_ads/{0,1}$ modules/boonex/ads/classifieds.php?action=show_popular [QSA,L]
RewriteRule ^ads/featured_ads/{0,1}$ modules/boonex/ads/classifieds.php?action=show_featured [QSA,L]

RewriteRule ^search/tag/([^/.]+)/{0,1}$ search.php?Tags=$1 [QSA,L]

RewriteRule ^browse/([^/.]+)/([^/.]+)/([^/.]+)$ browse.php?sex=$1&age=$2&country=$3 [QSA,L]

RewriteRule ^m/(.*)$ modules/index.php?r=$1 [QSA,L]

RewriteRule ^forum/groups/(.*)$ modules/boonex/forum/$1?orca_integration=groups [QSA,L]
RewriteRule ^forum/events/(.*)$ modules/boonex/forum/$1?orca_integration=events [QSA,L]
RewriteRule ^forum/store/(.*)$ modules/boonex/forum/$1?orca_integration=store [QSA,L]
RewriteRule ^forum/(.*)$ modules/boonex/forum/$1 [QSA,L]

RewriteRule ^page/(.*)$ viewPage.php?ID=$1 [QSA,L]

RewriteCond %{REQUEST_FILENAME} -f [OR]
RewriteCond %{REQUEST_FILENAME} -d
RewriteRule .+ - [L]
RewriteRule ^([^/]+)$ profile.php?ID=$1 [QSA,L]

</IfModule>

AddType application/vnd.adobe.air-application-installer-package+zip .air
AddType application/x-shockwave-flash .swf

Just replace the existing modified .htaccess with the original one from Dolphin 7..

I will take care of all your concern regarding upgrades with a little fee only just email me less pain in your side. Thank you.

Did you not look at the date this was posted?..lol