a database error has occurred :: Archived

ARSLANTURK

and auto_increment on rank_id ABSENT.

WHAT DO I ?

dcollis · Heavy poster Offline Joined: Mar 18, 2005 Posts: 230

Yes, thats right.
It needs to be set to AUTO_INCREMENT.
You need to do the same for any other table that is missing it on the ID field. (which might mean all of them).

ARSLANTURK

okey okey okey. I do ranks. Thanks all. Smile

djdevon3 · Gold Supporter Offline Joined: Aug 05, 2004 Posts: 4363

bigern75 wrote:

here's his error:

Code::

includes/functions/display.php
CMS Warning line 163: block-Exchange.php
Þu an bu blokta bir sorun var.
includes/db/db.php
CMS Warning line 51: On /admin.php?op=ranks While executing query "INSERT INTO cms_bbranks (rank_title, rank_special, rank_min, rank_image) VALUES ('Moderatör', 1, -1, 'images/ranks/stars-3.png')" the following error occured: Duplicate entry '0' for key 1 In: /****/****/****/****/httpdocs/admin/modules/ranks.php on line: 144

The issue is that he is attempting to run an sql command for inserting a new rank and the fields are not matching.

PHP:

INSERT INTO `cms_bbranks` VALUES (1, 'Moderator', -1, 0, 1, 'images/ranks/stars-3.png');

run this on your database query (phpmyadmin or equivilent) and see if the error goes away.

dcollis · Heavy poster Offline Joined: Mar 18, 2005 Posts: 230

Theres nothing wrong with the sql.
You don't need to include an ID at the start of an insert if auto_increment is set. Which from his image it shows it isn't. As i said, i imagine its got something to do with him migrating hosts and not exporting from one database to another while maintaining auto_increment on ids.

My guess is that all tables will have this problem. Not just this one. And that any inserts will fail until he goes through each table and sets auto_increment to be on for each primary key/id field.

But its think the real problem here is that the questions and answers are being lost in translation Sad