Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL error on service update #34

Closed
Gamerboy59 opened this issue Mar 13, 2022 · 2 comments
Closed

SQL error on service update #34

Gamerboy59 opened this issue Mar 13, 2022 · 2 comments

Comments

@Gamerboy59
Copy link
Contributor

SQLSTATE[HY000]: General error: 1 near "IGNORE": syntax error
INSERT IGNORE INTO ips (id, address, service_id, is_ipv4) values (1uT3M2RP, 123.456.78.90, BHvKZqQ1, 1)

Line: app/Http/Controllers/ServerController.php:321

As a result the update is saved but the view not updated. If editing the server again, the IPs are missing. Then saving without the IPs works fine and the views get updated too. Appears to be an issue with saving the IP address.
Tested with PostgreSQL and sqlite

@cp6
Copy link
Owner

cp6 commented Mar 13, 2022

Please try again after 5b1c1b663f81fc91c2f3386554c9d313a0837877

@Gamerboy59
Copy link
Contributor Author

Gamerboy59 commented Mar 13, 2022

This edited statements fixed it for me on sqlite, thanks for being so fast at fixing this. I didn't setup another postgresql installation but since the error was equal on both, I suspect it's working again on all database types.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants