For the upgrade path: If the DB is mostly the same, then I might try to install from scratch, port my templates, and then just copy my entries+comments from one DB to the other. Doing the step-wise update seems fragile and error-prone.

If you have any suggestions about what Sqlite3 DB columns can ...

My main customizations:

1. The login page is hidden, and won't accept login attempts, unless you come from the correct networks. (2FA: Something you know, and somewhere you are.) Also restricted the search engine by IP address because Google would continually submit junk queries in order to index ...

I'm currently running a modified version of 1.7 with sqlite3.
The modifications are for caching, harden a few files, and restricting the login access to use MFA.
(It's worked great for years.)

Unfortunately, the old version doesn't work with php8.

How hard is it to upgrade from 1.7 to 2.5?
Are the ...

One more hack for my temp cache...

When a user post/edits an entry, the cache should be flushed.
File: include/functions_entries.inc.php
Function: serendipity_updertEntry
At the end (right before the final return), I added:
// NAKcache
touch(S9Y_INCLUDE_PATH . "cache/flush"); // ensure rm -f ...

Yee haw! Got it fixed and working.

My solution for porting from MySQL to sqlite:

1. On a completely separate (non-production) instance, do a clean install of s9y. Set the database to be odp-sqlite. This will create the database template with all of the necessary tables properly configured. Copy ...

Did you create the sqlite database based on a mysql-dump by using a converter skript? For me that error looks like the the autoincrement is missing. This is how the table looks in my testblog:
Oh rats... That's the problem. I used one of those "almost good" conversion scripts.

Alright.. Time for ...

Debugging include/functions_comments.inc.php:
sqlite> INSERT INTO s_comments (entry_id, parent_id, ip, author, email, url, body, type, timestamp, title, subscribed, status, referer) VALUES ('667', '0', '50.xx.xx.xx', 'Test 2', 'test@hackerfactor.com', '', 'Test2', 'NORMAL', '1428612060', '', 'false ...

Hi,

I just migrated 1.7.8 from mysql to pdo-sqlite and now I'm not receiving comments.

select * from s_comments;
This returns all existing comments. And the comments show up on the web page.

But when a user submits a new comment... They see the HTML result that says the comment was successfully ...

I've noticed that two URLs on my blog comprise the majority of DB queries (> 90%). They are accesses to "/blog/" (and /blog/index.php without any "?" parameters), and accesses to my rss2 feed (that's the only RSS feed I enabled).

I just modified index.php to cache results for 5 minutes, just to ...

Thanks onli!

I did some tweaking and learned:

1. Sqlite does not require username or password. (Makes sense since you have the file.)

2. $serendipity['dbName'] is the path to the DB file. You can even set this to something like "../../databases/mydb" for accessing mydb.db outside of the web ...

I'm running 1.7.8, not 2.x. (I like how stable 1.7.8 is. I'll migrate to 2.x after it has a few months without updates/fixes.)
Can't help with sqlite unfortunately, but regular updates and fixes are not a sign of an “unstable” software. They are a sign that the software is actively maintained ...

Background:
My s9y installation is currently on GoDaddy. I'm moving it to a different server because their SQL database system has become unreliable (SQL timeouts for no discernible reason).

The old (GoDaddy) server used mysql.
The new server uses sqlite.

I've already exported the database into an ...

Hi all,

I'm trying to give my blog entries links so people can easily post the entries to Facebook, Twitter, etc. I'm doing this in my entries.tpl file, inside the {foreach $entries...} loop.

The good news: I got Twitter, Facebook, and Google+ to work.
The bad news: I cannot seem to figure out ...

You mean trackbacks, don't you.
Did you play around with the trackback section options of the spamblock plugin config?
Else you also might disable comments (which would include trackbacks I assume) in total for a while with the killswitch option.

A simple sql command could be like this
DELETE ...

I just updated my old s9y installation to 1.7.8. Suddenly my comments to moderate are flooded with pingbacks. I'm sure I have a few real comments buried in there, but I cannot find them due to the flood of pingbacks.

How do I completely disable pingbacks?

And what is the SQL query that I should ...