Search found 26 matches
- Tue Apr 14, 2015 6:21 pm
- Forum: Development
- Topic: Check caching for speed
- Replies: 10
- Views: 27603
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 ...
- Fri Apr 10, 2015 5:55 am
- Forum: Installation
- Topic: sqlite missing comments
- Replies: 5
- Views: 6430
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 ...
- Fri Apr 10, 2015 2:03 am
- Forum: Installation
- Topic: sqlite missing comments
- Replies: 5
- Views: 6430
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.. T...
- Thu Apr 09, 2015 10:43 pm
- Forum: Installation
- Topic: sqlite missing comments
- Replies: 5
- Views: 6430
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'...
- Thu Apr 09, 2015 9:27 pm
- Forum: Installation
- Topic: sqlite missing comments
- Replies: 5
- Views: 6430
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...
- Thu Apr 09, 2015 6:58 pm
- Forum: Development
- Topic: Check caching for speed
- Replies: 10
- Views: 27603
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 m...
- Thu Apr 09, 2015 6:38 pm
- Forum: Installation
- Topic: Need sample sqlite config file
- Replies: 6
- Views: 7011
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 we...
- Wed Apr 08, 2015 11:37 pm
- Forum: Installation
- Topic: Need sample sqlite config file
- Replies: 6
- Views: 7011
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...
- Wed Apr 08, 2015 10:37 pm
- Forum: Installation
- Topic: Need sample sqlite config file
- Replies: 6
- Views: 7011
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...
- Mon Feb 24, 2014 6:55 pm
- Forum: General discussions
- Topic: Linking to social network sites
- Replies: 1
- Views: 4958
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...
- Mon Feb 24, 2014 6:47 pm
- Forum: General discussions
- Topic: Completel Disable Pingbacks
- Replies: 4
- Views: 5218
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 ...
- Wed Feb 19, 2014 6:12 pm
- Forum: General discussions
- Topic: Completel Disable Pingbacks
- Replies: 4
- Views: 5218
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 ...
- Sat Aug 18, 2012 7:34 pm
- Forum: Installation
- Topic: Solved: Complex installation bug
- Replies: 1
- Views: 3299
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 instan...
- Sat Aug 18, 2012 3:07 pm
- Forum: Installation
- Topic: Rapid update?
- Replies: 9
- Views: 7861
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...
- Sat Aug 18, 2012 2:00 am
- Forum: Installation
- Topic: Rapid update?
- Replies: 9
- Views: 7861
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/"); ec...