[Ivex]

Hey!

I've bought a script full of errors and I've been fixing database errors that occur when trying to sign up with an account. Most of them are due to default values not being set for certain things but I'm not sure what this error is trying to tell me.

If anyone could give some advice about what I need to change I'd greatly appreciate it.

[Wires]

I think it's basically trying to figure out if the users been referred or not. Can you post the actual query? You'll either have to specify the integer value as 0 or NULL or turn of MYSQL Strict Mode.

[Ivex]

I think it's basically trying to figure out if the users been referred or not. Can you post the actual query? You'll either have to specify the integer value as 0 or NULL or turn of MYSQL Strict Mode.

Hi, thank you for response. I managed to fix it by changing the type from Integer to Varchar. I might be back with more questions soon as I bought a GPT script for $30 and the quality is rather poor. A really nice design but its full of bugs and I have limited coding knowledge.

[Wires]

Hi, thank you for response. I managed to fix it by changing the type from Integer to Varchar. I might be back with more questions soon as I bought a GPT script for $30 and the quality is rather poor. A really nice design but its full of bugs and I have limited coding knowledge.

I'd advise changing it back and solving this problem as suggested above. With varchar, this allows numerous characters which could potentially lead to more errors depending on the input, especially depending on the sanitization.

[Ivex]

I'd advise changing it back and solving this problem as suggested above. With varchar, this allows numerous characters which could potentially lead to more errors depending on the input, especially depending on the sanitization.

This is how it was set originally that was causing the error.