Search found 26 matches

by nealk
Tue Apr 14, 2015 6:21 pm
Forum: Development
Topic: Check caching for speed
Replies: 10
Views: 8217

Re: Check caching for speed

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 works e...
by nealk
Fri Apr 10, 2015 5:55 am
Forum: Installation
Topic: sqlite missing comments
Replies: 5
Views: 3572

Re: sqlite missing comments

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 the ...
by nealk
Fri Apr 10, 2015 2:03 am
Forum: Installation
Topic: sqlite missing comments
Replies: 5
Views: 3572

Re: sqlite missing comments

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 Pl...
by nealk
Thu Apr 09, 2015 10:43 pm
Forum: Installation
Topic: sqlite missing comments
Replies: 5
Views: 3572

Re: sqlite missing comments

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'...
by nealk
Thu Apr 09, 2015 9:27 pm
Forum: Installation
Topic: sqlite missing comments
Replies: 5
Views: 3572

sqlite missing comments

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 subm...
by nealk
Thu Apr 09, 2015 6:58 pm
Forum: Development
Topic: Check caching for speed
Replies: 10
Views: 8217

Check caching for speed

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 make...
by nealk
Thu Apr 09, 2015 6:38 pm
Forum: Installation
Topic: Need sample sqlite config file
Replies: 6
Views: 4127

Re: Need sample sqlite config file

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 director...
by nealk
Wed Apr 08, 2015 11:37 pm
Forum: Installation
Topic: Need sample sqlite config file
Replies: 6
Views: 4127

Re: Need sample sqlite config file

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. :) 2...
by nealk
Wed Apr 08, 2015 10:37 pm
Forum: Installation
Topic: Need sample sqlite config file
Replies: 6
Views: 4127

Need sample sqlite config file

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 s...
by nealk
Mon Feb 24, 2014 7:55 pm
Forum: General discussions
Topic: Linking to social network sites
Replies: 1
Views: 3738

Linking to social network sites

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 Pinte...
by nealk
Mon Feb 24, 2014 7:47 pm
Forum: General discussions
Topic: Completel Disable Pingbacks
Replies: 4
Views: 3429

Re: Completel Disable Pingbacks

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 FROM ...
by nealk
Wed Feb 19, 2014 7:12 pm
Forum: General discussions
Topic: Completel Disable Pingbacks
Replies: 4
Views: 3429

Completel Disable Pingbacks

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 use ...
by nealk
Sat Aug 18, 2012 7:34 pm
Forum: Installation
Topic: Solved: Complex installation bug
Replies: 1
Views: 1633

Solved: Complex installation bug

My first update went painlessly. My second update was troublesome due to my server configuration. But I finally worked it out. The setup: I have multiple blogs on my server. The first s9y instance is under "http://server1/blog/" and is actually at /home/me/html/blog/. The second s9y instance is unde...
by nealk
Sat Aug 18, 2012 3:07 pm
Forum: Installation
Topic: Rapid update?
Replies: 9
Views: 4372

Re: Rapid update?

PS. Does (system cat file > file) work well, when the new file has changed and you push your changes of the old one in? Yes. My patch is just PHP code that I place before the original file. <?php check for stuff ?> <?php the original file... ?> PHP doesn't mind having multiple PHP blocks of code. T...
by nealk
Sat Aug 18, 2012 2:00 am
Forum: Installation
Topic: Rapid update?
Replies: 9
Views: 4372

Re: Rapid update?

Final update: Just patched the live system in under 20 seconds. Wow -- that was painless! I automated most of it in a PHP script: <?php echo "<pre>"; echo "Unpacking\n"; system("tar -xzvf serendipity-1.6.2.tar.gz"); system("cp blog/.htaccess serendipity/"); echo "Copying\n"; system("cp -vr blog/sere...