PDA

View Full Version : Help me



kmai
06-06-2010, 11:40 PM
Nick,

I'm having the problems mentioned below:
I used Pligg_importer and the following happened.


Warning: Duplicate entry '1' for key 2 in /home/******/public_html/*********r/libs/extensions/ezSQL/mysql/ez_sql_mysql.php on line 257

After importing 504 emails were fired with the message.


******** Database Error

Date: 06 Jun 2010 19:51:53 (timezone: America/Sao_Paulo)

SQL query:
INSERT INTO taru_categories (category_name, category_safe_name, category_order, category_desc, category_keywords, category_updateby) VALUES('', '', 0, '', '', 1)

PHP error log:
Duplicate entry '1' for key 2

Current User: admin (id: 1)
User Role: admin
Page Name: plugin_settings
Sub Page:
Plugin: pligg_importer

If you need help, visit the forums at http://hotarucms.org

I had used in version 1.2 and did not have this problem, the same xml file

Thanks

Nick
06-07-2010, 12:42 AM
You only get emailed about database errors if you have DEBUG mode turned on.

Maybe this will help: http://hotarucms.org/showthread.php?717-Category-bar-not-working

shibuya246
06-07-2010, 01:04 AM
Nick,

I'm having the problems mentioned below:
I used Pligg_importer and the following happened.



After importing 504 emails were fired with the message.



I had used in version 1.2 and did not have this problem, the same xml file

Thanks

Looks like you have duplicate category names being imported into the database.

If you look at the VALUES being passed in


VALUES('', '', 0, '', '', 1)

the category name is blank.

In this table you can not have a category saved with the same name as an existing category.

The best solution is to check your existing table before import and make sure you dont have any duplicate categories.

Note: Can you make the title of your forum post a bit more meaningful next time so it is easy to search. Just saying 'help me' is not easy for us to understand your problem. Thanks :)

kmai
06-07-2010, 11:46 AM
Looks like you have duplicate category names being imported into the database.

If you look at the VALUES being passed in


VALUES('', '', 0, '', '', 1)

the category name is blank.

In this table you can not have a category saved with the same name as an existing category.

The best solution is to check your existing table before import and make sure you dont have any duplicate categories.

The installation is new database created during installation
while importing the database was clean



Note: Can you make the title of your forum post a bit more meaningful next time so it is easy to search. Just saying 'help me' is not easy for us to understand your problem. Thanks :)

Sorry!

Thanks

kmai
06-07-2010, 11:52 AM
You only get emailed about database errors if you have DEBUG mode turned on.


It is normal to the firing of 504 emails.

Thanks