SQLite3

[w5hro]

Ok, I tried that and it no longer crashes. I will try it for a while and see what happens.

Can you check my attached file, I want to make sure it's correct.

Thanks...

[tinoest]

That looks correct, let me know how it goes.

[w5hro]

I just found a serious problem. Personal messages are no longer coming up. If you go to your inbox or sent items box and click on the subject nothing happens. The conversion must have corrupted it somehow

[tinoest]

Sorry , what conversion?

The adding of the additional SQL and correcting the error's?

[w5hro]

It must have been the conversion utility that converted my database from dB to db3.

I did notice it reduced the size of my database by about 1/2, but I thought version 3 was just more efficient. Looks like it did something to all of the PM's. They are still listed, but are gone now.

Thanks for all of your help, but I've decided to just bite the bullet and do a fresh install using MY SQL instead. I really wanted to use SQLite because I had a phpBB3 My SQL board for a long time and I got tired of the occasional connection errors and members complaining about slow and crashed uploads. If I was on a dedicated server it would probably be fine, but it's an issue when on a shared server. SQLite is really better, but most of the world has been brainwashed for so long that they think they just gotta have My SQL. As a result developers just don't spend a lot of time with it and most Mods won't work with it as a result either.

Anyway, it's either that or I just install phpBB3 with SQLlite 3 which I may do before its over. I'll see how SMF works with MY SQL first. Maybe its not a resource hog like phpBB3 is, but we will see.

[tinoest]

Which utility? Was it the one provided by SQLite? Or the one I put in with this mod?

I'd like to fix it if it was the one given with the mod that's all.

[w5hro]

Which utility? Was it the one provided by SQLite? Or the one I put in with this mod?

I'd like to fix it if it was the one given with the mod that's all.

Yes, it was the one in your mod package here. I just had not tired to click on a PM in a few days so I didn't realize there was a problem until yesterday evening.

[tinoest]

Thanks, I'll see if I can replicate it here then.

Do you still have your old database?

If you have the SQLite admin installed can you see if any data is contained within the database tables for pm's?

[w5hro]

I'll look at it, but give me couple of days. I was looking at it last night and either they are gone or they just got disconnected somehow. I still have the old SQLite board up, I just moved it to a different folder within the root so I can create the new one to match it. The I will manually export to old posts and user accounts. Luckily the board was only up for a couple of months so it only had a 100+ posts.

[w5hro]

Ok, I looked through the db3 file and the PM's are still there. They must somehow just be disconnected from where they need to connect.

Anyway, I already have the My SQL databease setup and everything imported so it's done now.

Thanks...

[tinoest]

Thanks for the feedback.

I'm yet to be able to reproduce the problem, I'm trying to figure out where it went wrong.

I'll fix the other issues that you raised, I'm assuming that they improved the performance overall.

I hope it goes well for you with MySQL

[w5hro]

When I went to my inbox and clicked on my received messages or even the ones in sent items nothing would display and/or pop up. They were listed, but wouldn't come up.

Hope that helps...

[tinoest]

Hi,

I tried that and it all went well for me. Have you tried sending any new pm's and seeing if they appear.

I do appreciate your time and feedback

[w5hro]

Hi,

I tried that and it all went well for me. Have you tried sending any new pm's and seeing if they appear.

I do appreciate your time and feedback

Yes, that's when I noticed the problem. I sent a PM and went to check my sent items box and it would not come up. Then I realized non of the PM's would display any longer, only the subject titles.

[indigious]

Hi, tinoest! Do you plan to update this useful mod for the latest versions of SMF? I mean v1.1.21 and v2.0.11?

[vbgamer45]

It should still work for 2.0.11

[tinoest]

Looking through the changes, it should still work with 2.0.11, it never supported 1.1.x as that didn't have SQLite Support in it either and was just MySQL.

There is only one change I can see thats in DbSearch-sqlite3.php where on line 72 the preg replace was changed to MEMORY from HEAP which is still in this modification.

I also never got to the bottom of the character encoding issues.

[indigious]

tinoest
vbgamer45
OK, thank you!