[HELP] ERROR MYSQL

[xBlack]

Hi, everyone. I faced a little problem again. I would be very glad if you could help me. I want to export catalog_items sql but I see an error like this. can you help me?

You must be registered for see images attach

You must be registered for see images attach

 

[Markshall]

offer_id int(11) NOT NULL DEFAULT -,

I’m on my phone so can’t type properly.
The hyphen seems invalid to me. Should that not be in quotes?

offer_id int(11) NOT NULL DEFAULT ‘-‘,

Don’t copy and paste this of course, the quotes are different because of my phone.

Give that a try and let me know

 

[xBlack]

club_only enum(‘0’, ‘1’) NOT NULL DEFAULT -,

I’m on my phone so can’t type properly.
The hyphen seems invalid to me. Should that not be in quotes?

club_only enum(‘0’, ‘1’) NOT NULL DEFAULT ‘-‘,

Don’t copy and paste this of course, the quotes are different because of my phone.

Give that a try and let me know

Thank you for your precious answer, but that's where you specified it.

You must be registered for see images attach

 

[Markshall]

Thank you for your precious answer, but that's where you specified it.

You must be registered for see images attach

Sorry about that. I’ve edited my original reply.

 

[xBlack]

Sorry about that. I’ve edited my original reply.

no it didn't :\

 

[Markshall]

no it didn't :\

You’re specifying the column as an integer, but giving the default value as a hyphen (-)
Try giving it a default if 0 or something and let me know

 

[xBlack]

You’re specifying the column as an integer, but giving the default value as a hyphen (-)
Try giving it a default if 0 or something and let me know

thank you, bro I did -1 and it happened.