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.

  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.

  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.

  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

    $db = new Database();

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

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


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

    // 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);
    this is the php that i used.
  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.

  8. medyaoyun

    medyaoyun Paid Customer

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

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


    You are welcome.

    If you will have some questions please let me know.

Share This Page