AAC Char Bazaar in myaac doesnt work?

[Qbecky]

Hi, how to fix this??
When i try to add character to auction:

 

[GamerGoiano]

Use the MySQL "DEFAULT" keyword to specify a default value for the column in the table schema. For example:

ALTER TABLE mytable MODIFY bid_account VARCHAR(255) NOT NULL DEFAULT '';

This will set the default value for the "bid_account" column to an empty string if no value is provided in the INSERT statement.

Change "mytable" to your table that the script uses.

 

[murphy]

work ?

 

[ralke]

When an auction is created, there is no bidder yet, so bid_account should usually be initialized as 0 or NULL, depending on how your script checks for “no bidder”.

First, check the real table structure:

SHOW TABLES LIKE '%auction%';
SHOW CREATE TABLE character_auctions;

Also check the insert query around this file/line:

system/pages/createcharacterauction.php line 1718

The quick database-side fix is usually one of these:
If your system uses 0 as “no bidder”:

ALTER TABLE character_auctions
MODIFY bid_account INT UNSIGNED NOT NULL DEFAULT 0;

If your system uses NULL as “no bidder”:

ALTER TABLE character_auctions
MODIFY bid_account INT UNSIGNED NULL DEFAULT NULL;

The cleaner fix is to edit the INSERT query in createcharacterauction.php and explicitly insert the initial value:

bid_account = 0

or include it in the insert columns/values:

INSERT INTO character_auctions (..., bid_account, ...)
VALUES (..., 0, ...);

In summary, it is basically what @GamerGoiano said: your table requires a value for bid_account, but the script is not sending one. So you either need to allow NULL, set a default value, or explicitly insert the initial value in the query. Can't read the specific line createcharacterauction.php(1718) since I don't have the system but probably is what I mentioned earlier.

Since this is a 3 year old thread I'll close it and mark it as solved to avoid unnecessary bumps.