[DiscordArchive] Did you try to execute the query in your sql editor ? Checked the data type of every column etc ?
[DiscordArchive] Did you try to execute the query in your sql editor ? Checked the data type of every column etc ?
Archived author: Exitare • Posted: 2019-10-21T18:34:50.956000+00:00
Original source
Did you try to execute the query in your sql editor ? Checked the data type of every column etc ?
Archived author: Lola Bunny = LivesMatter • Posted: 2019-10-21T18:34:52.309000+00:00
Original source
i thouth the auto increm woud do that automatic
Archived author: Lola Bunny = LivesMatter • Posted: 2019-10-21T18:35:01.202000+00:00
Original source
il try
Archived author: Lola Bunny = LivesMatter • Posted: 2019-10-21T18:36:35.796000+00:00
Original source
its valid
Archived author: Lola Bunny = LivesMatter • Posted: 2019-10-21T18:37:34.363000+00:00
Original source
like i said it does tend to make the bnet but not the account depending on what i change then of cours
Archived author: Exitare • Posted: 2019-10-21T18:39:09.367000+00:00
Original source
Just a general question why are you providing data for every column ? It’s not necessary as tc provides default values for most of the columns.
Archived author: Lola Bunny = LivesMatter • Posted: 2019-10-21T18:40:00.046000+00:00
Original source
i also used a php check website and no code errors
Archived author: Lola Bunny = LivesMatter • Posted: 2019-10-21T18:40:22.391000+00:00
Original source
https://phpcodechecker.com/
[Embed: PHP Code Checker - Syntax Check for Common PHP Mistakes]
An advanced, custom PHP code checker that searches your code for common, hard to find typos and mistakes; includes a syntax check.
https://phpcodechecker.com/
![[Image: unknown.png?ex=690c43b6&is=690af236&hm=f...ea2ad4e67&]](https://cdn.discordapp.com/attachments/376457124726702080/635911205625659432/unknown.png?ex=690c43b6&is=690af236&hm=fbd728bbf37138b0ac9c93f0b2b1e48bdde49bfbb8c61af1dd08088ea2ad4e67&)
Archived author: Lola Bunny = LivesMatter • Posted: 2019-10-21T18:44:06.080000+00:00
Original source
i tested the code using heidisql and this says somthink about foreigh key
![[Image: unknown.png?ex=690c43b6&is=690af236&hm=f...ea2ad4e67&]](https://cdn.discordapp.com/attachments/376457124726702080/635911205625659432/unknown.png?ex=690c43b6&is=690af236&hm=fbd728bbf37138b0ac9c93f0b2b1e48bdde49bfbb8c61af1dd08088ea2ad4e67&)
Archived author: Lola Bunny = LivesMatter • Posted: 2019-10-21T18:53:10.742000+00:00
Original source
PRIMARY KEY (`id`),
UNIQUE INDEX `idx_username` (`username`),
UNIQUE INDEX `uk_bnet_acc` (`battlenet_account`, `battlenet_index`),
CONSTRAINT `fk_bnet_acc` FOREIGN KEY (`battlenet_account`) REFERENCES `battlenet_accounts` (`id`) would this help to fix the problem