How do I import the Common Categories Dump ?

[loredan]

I've tried importing them from phpMyAdmin but I get an error:

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: Documentation
#1146 - Table 'dirbiz_directory.{prefix}categories' doesn't exist




I'm using the latest paid version and I have also uploaded the newest patch (1.2.0.1) ..




Thanks.

[loredan]

I've done a bit searching and found something: http://www.esyndicat.com/forum/post42620-10.html

I've imported that and it works, but the stats are still the same:

Total number of links: 0
Total number of categories: 0


Any ideas?

[Dave Baker]

Hello loredan,
In my opinion you use Dump which doesn't approach to your version.
Remove last changes and use the following http://www.esyndicat.com/downloads/miscellaneous.html for uploading Dump.
Using search and replacement find all {prefix} and replace them with your prefix of tables.

[loredan]

Hello loredan,
In my opinion you use Dump which doesn't approach to your version.
Remove last changes and use the following http://www.esyndicat.com/downloads/miscellaneous.html for uploading Dump.
Using search and replacement find all {prefix} and replace them with your prefix of tables.

Thank you, hope it works! :good:

[Dave Baker]

You are welcome!