i want to buy script But?

Discussion in 'Installation and Updates' started by medyaoyun, Sep 21, 2006.

  1. medyaoyun

    medyaoyun Paid Customer

    hi there

    i m curently using your free version. i want to buy eSyndiCat Pro One (1) Domain license.

    but i wonder if i buy, should i transfer all cat and link database. or will i get some patch for upgrading to paid version.

    thanks
  2. Sergey Ten

    Sergey Ten <b>eSyndiCat Lead Developer</b>

    Hello medyaoyun,

    I could converting your database from free to pro version of the eSyndiCat. Send me your dump and I will try converting as soon as possible.

    sten@esyndicat.com
  3. medyaoyun

    medyaoyun Paid Customer

    can you also provide me installation help please. i get some mail subjected "bug"

    and error is bellow

    SELECT * FROM `dir_categories` WHERE `id` = '51'<br />Duplicate entry '12' for key 1

    when i tried to submit a link i get "Unknown column 'ip_address' in 'field list'" error mesagge
  4. Sai_dallas

    Sai_dallas Paid Customer

    you need to run convert_flat php file

    search for my posts, in one them I posted the file content.


    Thanks
  5. medyaoyun

    medyaoyun Paid Customer

    i have found it but i get error page when i run the convert_flat.php
    i got "Internal Server Error"

    what am i doing wrong?
    please check http://www.freightlist.net/convert_flat.php
    thanks for help
    PHP:
    <?php
    require_once('includes/config.inc.php');
    require_once(
    'classes/DirDb.php');

    $db = new Database();

    $db->mDbhost $gDirConfig['localhost'];
    $db->mDbname $gDirConfig['name'];
    $db->mDbuser $gDirConfig['myusername'];
    $db->mDbpwd $gDirConfig['mypass'];
    $db->connect();
            
    // Get categories
    $sql "SELECT `id`,`id_parent` FROM `{$gDirConfig['prefix']}categories` WHERE `id_parent` > -1";
    $cats =& $db->getAll($sql);

    if (
    $cats)
    {
        foreach (
    $cats as $key => $value)
        {
            
    $sql "INSERT INTO `{$gDirConfig['prefix']}flat_structure` (`id_parent`,`id_category`)";
            
    $sql .= "VALUES ({$value['id']}{$value['id']})";
            
    $db->query($sql);
            
    add_flat($value['id'], $value['id_parent']);
        }
    }

    function 
    add_flat($id$id_parent)
    {
        global 
    $db;
        global 
    $gDirConfig;

        
    // Insert record into "flat" table
        
    $sql "INSERT INTO `{$gDirConfig['prefix']}flat_structure` (`id_parent`,`id_category`)";
        
    $sql .= "VALUES ({$id_parent},{$id})";
        
    $db->query($sql);

        
    // Check if parent > 0 and call itself recursively
        
    if ($id_parent 0)
        {
            
    // Get parent's parent
            
    $sql "SELECT `id_parent` FROM `dir_categories` WHERE `id` = {$id_parent}";
            
    $id_parent2 $db->getOne($sql);
            
    add_flat($id$id_parent2);
        }
    }
    ?> 
    this is the php that i used.
    thanks
  6. medyaoyun

    medyaoyun Paid Customer

    Sergey could you find time to look at my dump. i have send it to you.

    also i cant add link to my directory i got this error Unknown column 'ip_address' in 'field list' "

    can you help me please
  7. Sergey Ten

    Sergey Ten <b>eSyndiCat Lead Developer</b>

    Hello medyaoyun,

    Yes, sure I could investigate your dump, please send me it. And could you please email me your FTP and Cpanel (phpMyAdmin) credentials.

    sten@esyndicat.com
  8. medyaoyun

    medyaoyun Paid Customer

    thanks sergey i have fixed it. and i get my converted dump. great support thak you verymuch
    murat
  9. Sergey Ten

    Sergey Ten <b>eSyndiCat Lead Developer</b>

    Murat,

    You are welcome.

    If you will have some questions please let me know.

Share This Page