Problem with database import

Discussion in 'Installation and Updates' started by cancan, Oct 13, 2006.

  1. cancan

    cancan Paid Customer

    Hi everyone !
    I had bought this script today :) I installed successfully to my Host.And then I dowload common_categories.sql dump from that web site.When ı try to import it says:
    Error
    SQL query:

    INSERT INTO `{prefix}categories` ( `id` , `id_editor` , `id_parent` , `title` , `description` , `status` , `meta_description` , `meta_keywords` , `path` , `order` , `locked` , `unique_tpl` , `level` , `num_cols` , `neighbour` )
    VALUES ( 1, 0, 0, 'Arts', 'Arts Directory', 'active', '', '', 'arts', 1, '0', '0', 1, NULL , NULL ) ;



    MySQL said:

    #1146 - Table 'campingp_linkers.{prefix}categories' doesn't exist
  2. Sergey Ten

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

    Hello cancan,

    You have to use admin panel of the eSyndiCat for adding common categories .

    Please login to admin panel and open "manage database" after "import". Upload the "common_categories.sql", choose the file in the select list and press "GO".
  3. cancan

    cancan Paid Customer

    Thank you...
    I started successfully but after seconds it gives a message
    Duplicate entry '4' for key 1 Added only 4 or 5 Categories.....

    And ı have a another Question? :) Sorry :p How can ı show folders like
    Arts (9)
    Literature, Movies, Music

    You can see in my page www.campingparksbeach.org link are only Category Name there is no sub categories shown on main page...

    Best Regards...
  4. Sergey Ten

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

    Hello cancan,


    Please send me your FTP/CPanel/Admin panel credentials and I will add common categories.

    sten@esyndicat.com


    Open your admin panel:

    configuration -> Page Navigation and Listings -> Number of links display next to category : enable

    configuration -> Page Navigation and Listings -> Number of subcategories
  5. cancan

    cancan Paid Customer

    He fixed the problem... :)
    Thank you
  6. Sergey Ten

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

    You are welcome cancan :)

Share This Page