SQLitening Support Forum

Try downloading it now. The attachment was missing/corrupted so I just re-uploaded it again and attached it to the original post.

Quote from: cj on July 30, 2022, 05:54:11 PMPaul,
Do you get email notifications?

No I did not, but I also do not have the "Alerts or Emails" enabled for myself for this Board.

That's weird. I went into the forum admin settings and merely viewed and saved the Boards. It must have reset something that was screwing up your permissions.... I don't know why it worked, but happy that maybe it was what fixed it.

Nothing has changed with the forum. All of the Boards are there. I haven't edited any Boards in several years. Maybe try logging out of the forum and back in again?

Create table #61 and put your table descriptions there. Two fields... table name, table description.

I have added a redirect from http://sqlitening.planetsquires.com/support/index.php that seems to work.

Thanks Bern, I will do that. I did try to do the redirect but it resulted in an endless loop due to the fact that the forum is in a subdomain on the main PlanetSquires site. I will try a few more options......

I have upgraded the forum to us SSL encryption. You should see an secure padlock type of icon in your url address bar and the forum address starting with https://
If you encounter problems with the forum, please let me know. Thanks!

I think you need to use the NULLIF function.

SELECT BES_KVANT * PRIS / NULLIF(PRISKVANT,0) FROM IRA

https://www.sqlite.org/lang_corefunc.html#nullif
http://www.peachpit.com/blogs/blog.aspx?uk=Avoiding-division-by-zero-with-NULLIF-Five-SQL-Tips-in-Five-Days-Part-5-
https://stackoverflow.com/questions/19721898/where-and-how-to-use-nullifx-y-function-of-sqlite?utm_medium=organic&utm_source=google_rich_qa&utm_campaign=google_rich_qa
http://www.sqlitetutorial.net/sqlite-functions/sqlite-nullif/

You're welcome guys. It's great see Fred's awesome work continue to live on.

Perfect! Thanks
Had some issues with the main planetsquires site but overall the movement of sqlitening to the new site was pretty painless.

I finished moving the forum to a new web host. This forum is now served as a subdomain of PlanetSquires.
http://www.sqlitening.planetsquires.com/index.php

If you find any problems then please let me know. I think that you might have to re-upload any custom avatars that you were using. The attachments should be okay.

If I were to take a guess... I bet you need to wrap all of the inserts into one begin/end transaction. That should speed things up immensely even more so than the compilation time of the sql statement.

I never use NULL either. I find that it complicates things unnecessarily.

Thanks for sharing the link. Fred was truly a great man. Greatly missed indeed.