a database error has occurred :: Archived

ARSLANTURK

Hi all;

I am ilker ARSLANTURK and from Turkiye. Sorry, i am a little speak english. Sad

Dragonfly error message "Admin Panel - A database error has occurred. The webmaster has been notified of the error"

Thanks..

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

turn on debugging in admininistration>main settings>debug. it should show you the real error at the bottom of the page.

ARSLANTURK · Posted: Mon Jul 17, 2006 1:51 pm Post subject: Re: a database error has occurred

Admininistration > Main settings > Debug

Here is Message for clik

Please Help !!!

Thanks

ARSLANTURK

bigern75 · Posted: Mon Jul 17, 2006 2:49 pm Post subject: Re: a database error has occurred

delete or rename block-Exchange.php, whatever that is, and see what happens

ARSLANTURK · Posted: Mon Jul 17, 2006 3:48 pm Post subject: Re: a database error has occurred

bigern75 thanks but error again. "A database error has occurred. The webmaster has been notified of the error" message to give.

Error links
Rank add ..../admin.php?op=ranks
and
Supper user add ..../admin.php?op=admins

Thanks

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

Always post the entire error message if you can - we need to see what is causing the error message.

bigern75 · Posted: Mon Jul 17, 2006 4:26 pm Post subject: Re: a database error has occurred

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

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

This sounds like a mysql problem - there is nothing wrong with that sql code that I can see.

Please check that auto_increment is set for the rank_id field.

Also please post what version of mysql you are using.

ARSLANTURK · Posted: Mon Jul 17, 2006 5:23 pm Post subject: Re: a database error has occurred

MySQL Version 4.0.26-standard

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

and auto_increment on rank_id?

ARSLANTURK · Posted: Mon Jul 17, 2006 5:48 pm Post subject: Re: a database error has occurred

Sorry, i am learning english.

thanks

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

You need to go into your actual database.
Maybe using a tool such as phpmyadmin?
Go to the cms_bbranks table and look at the table structure.
The "rank_id" field should have "auto_increment" on it. (This is under "extra" in phpmyadmin)

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

if it does not have auto_increment, run this sql:

Code::

ALTER TABLE cms_bbrank CHANGE COLUMN rankid_id rank_id smallint(5) NOT NULL auto_increment;

The question is, why would a table not have this set?
It can happen for a few reasons, the most common one being restoring from an incorrect backup of a database (e.g. if you moved servers or something).

ARSLANTURK · Posted: Wed Jul 19, 2006 7:01 pm Post subject: Re: a database error has occurred

I should be to take FTP standby on midnight. I should be to throw the end FTP version and alone on database. WHAT HAPPENT?
What time adaptation dragonfly forums MYSQL version 4.0.24-standard %100 adaptation the end version?

THANKS
ARSLANTURK

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

I'm really sorry, but i'm afraid i don't understand what you mean.

Are you still having the problem?