Ramonfincken.com ~ Index

[solution][ubuntu] ubuntu mysql #1036 - Table 'xx' is read only

Author ramon fincken :: Posted: Sat Feb 20, 2010 3:04 pm :: Category: Mysql databases

Tagged: chown, mysql, owned, read only, said, service, solution, table

I moved some database files from my backup to my ubuntu pc with mysql running.

So far so good. I visited PhpMyadmin, database is there and tables too jay Smile

But when deleting, editing/ adding some row/entry I got stuck with this message:

Code:

Mysql Said #1036 - Table 'xx' is read only

The solution is this:

Code:

$ sudo nautilus

Move your files to /var/lib/mysql/[database_name]
Now . make sure every directory/file is owned by Mysql and NOT root or your username !
Exit nautilus
Code:

$ sudo service mysql restart

And you're done!

Read on:
http://ubuntuforums.org/showthread.php?t=411338
http://www.bigresource.com/Tracker/Trac...-ZZHBnJJf/

(0) Replies

[wordpress][plugin] Plugin to simply add a lot of posts/pages

Author ramon fincken :: Posted: Sat Feb 13, 2010 10:51 pm :: Category: CMS-ses (Joomla, WordPress, etc..)

Tagged: about, add, admin, admins, default, easy, mass, multiple, page, pages, plugin, post, posts, simple, simply, wordpress

Leave a comment

Every time I have a new client/WP install I need to add some default pages like "Home, Contact, About, Products" etc..

Because of the autosave function and the fact that it takes a few minutes I decided this could be done in a much faster way.

Therefore I created this plugin. You simply add the titles of multiple posts OR pages in a textarea, select the author of those posts/pages and hit submit. That's it !

Download:
http://wordpress.org/extend/plugins/sim...-or-posts/

Screenshots below!

Code:

=== Simple add pages or posts ===

Contributors: Simon Dirlik, Ramon Fincken

Donate link: http://donate.ramonfincken.com

Tags: admin,admins,add,mass,simple,easy,post,posts,page,pages,multiple,about,default

Requires at least: 2.0.2

Tested up to: 2.9.2

Stable tag: 1.0

Plugin to simply add multiple posts or pages at once by entering their titles. Handy tool if you have a new blog and want to quickly add pages like Home, About, Contact ...

== Description ==

Plugin to simply add multiple posts or pages at once by entering their titles. Handy tool if you have a new blog and want to quickly add pages like Home, About, Contact ...

== Installation ==

1. Upload directory `simple-add-pages-or-posts` to the `/wp-content/plugins/` directory

2. Activate the plugin through the 'Plugins' menu in WordPress.

3. Visit Plugins menu to add your post(s) or page(s).

== Frequently Asked Questions ==

None available

== Changelog ==

= 1.0 =

First release

== Screenshots ==

1. Enter title

2. After submit

Update: @16022010: More people have been waiting for this plugin:

40 Most Wanted Wordpress Plugins > http://loveishs.com/40-most-wanted-word...ugins.html

(0) Replies

Idea for NASA

Author ramon fincken :: Posted: Wed Feb 10, 2010 6:52 pm :: Category: Lounge

Tagged: idea, nasa

Leave a comment

I am watching Discovery channel right now, program "Extreme Engineering".

The problem presented was that the Orbiter when docking to the ISS or any other space station.

Now the actual problem is that a viewing window for the astronauts is made of glass (doh..) however this weighs a LOT compared to the other materials.

Now ... just a wild idea.. why not mount some cameras instead of this viewing window and present the info on a screen inside? ( you can still have a small window for a backup ... )

(0) Replies

[solution][wordpress] Problems with HTML spaces and breaks (%nbsp;,<br>), WP removes them from content

Author ramon fincken :: Posted: Sat Feb 06, 2010 12:47 pm :: Category: CMS-ses (Joomla, WordPress, etc..)

Tagged: break, html, space, spaces, wordpress

Leave a comment

I had asked this on the WordPress linkedin groups ( of which I moderate the Dutch group at http://www.linkedin.com/groups?home=&am...anet_ug_hm ).

Quote:

I have some clients reporting to me that every time they enter a space or a break (%nbsp;,<br>) in the page/post editor ( WYSIWYG or HTML tab ) ... WordPress removes this when saving.

I have tested this on a vanilla 2.9.1 install ( so no plugins, just a straight install from the zip source ) and this turns out to be true.

Is this a bug or a feature? I don't want to edit the WP core files to "fix" this.

Wim La Haye ( http://nl.linkedin.com/in/lahaye ) suggested:

Quote:

Hey Ramon,

This is caused by a wordpress function "wpautop" (wordpress auto paragraph) which formats double line breaks to paragraphs.

The function is described here:
http://codex.wordpress.org/Function_Reference/wpautop

There are multiple plugins avaiable to counteract/disable the wpautop. Among others "disable-wpautop" ( http://urbangiraffe.com/plugins/disable-wpautop/ )

The problem with spacing still remains ...

(0) Replies

I want to write my own wordpress plugin
Author Xarzu :: Posted: Sat Jan 30, 2010 4:30 pm :: Category: CMS-ses (Joomla, WordPress, etc..) Tagged: Leave a comment I want to write my own wordpress plugin. Does anyone know where I can find a lits of hooks and filters and what they do? Also, is there a book that is a good reference for people who want to write wordpress plugins? (1) Replies

List of Dutch provinces

Author ramon fincken :: Posted: Sun Jan 24, 2010 8:02 pm :: Category: HTML and other markup&programming languages

Tagged: dutch, province, provinces

Leave a comment

Ok this is mainly for my own lazyness for not having to look them up when creating a dropdown box Smile

Code:

Drenthe
Flevoland
Friesland
Gelderland
Groningen
Limburg
Noord-Brabant
Noord-Holland
Overijssel
Utrecht
Zeeland
Zuid-Holland

(0) Replies

[wordpress] A quick guide when changing urls, subdomains, or subdomain

Author ramon fincken :: Posted: Sun Jan 24, 2010 12:57 pm :: Category: CMS-ses (Joomla, WordPress, etc..)

Tagged: change, database, move, mysql, server, servers, subdomain, subdomains, transfer, url, urls, wordpress, wp-config

Leave a comment

Creating the dump/export
1. Make a full backup of your current online files
2. Make a full backup of your current database using PhpMyadmin
Setting up the new host (Only when not on the same server)
1. Create webspace / set up FTP ( write these down ! )
2. Create a database with user and password ( write these down ! )
Transfer files
Transfer the files to their new location/server/directory

Transfer database (Only when not on the same server)

Import your database using PhpMyadmin

Edit wp-config.php using values from 2b. (Only when not on the same server)

Code:

// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'database_name_here');

/** MySQL database username */
define('DB_USER', 'database_user_here');

/** MySQL database password */
define('DB_PASSWORD', 'database_pass_here');

/** MySQL hostname */
define('DB_HOST', 'localhost'); // Mostly (99%) localhost

Update website url in database (Only when changing URL !)
1. Open you options table and edit the siteurl and home option values into your new URL location
Permisions and file uploads
1. Make sure any plugin or upload directories are writable by PHP/your webserver
2. Log in at /wp-admin/ and go to miscellaneous settings ( options-misc.php ).
  Now edit/update this folder: "Store uploads in this folder" (Only when changing URL !)
Update url "referals" (Only when changing URL !)
1. Update your theme hardcoded paths
2. Update your content if they point to an old URL location, use this plugin: http://wordpress.org/extend/plugins/find-replace/

Thanks to http://www.linkedin.com/in/stephanieleary for mentioning the file upload path

(0) Replies

[wordpress][solution] Phpbb single signon phpbb_captcha_factory not found no object

Author ramon fincken :: Posted: Sat Jan 02, 2010 10:10 pm :: Category: CMS-ses (Joomla, WordPress, etc..)

Tagged: authentication, captcha, class, connector, factory, login, password, phpbb, sign on, single, solution, wordpress, wrapper

Leave a comment

I client had the phpbb single signon plugin installed but he encountered an error when he had to many login tries on WordPress itself.
http://wordpress.org/extend/plugins/php...e-sign-on/

Code:

class or object phpbb_captcha_factory not found

Why?
Phpbb3 logs every login attempt. If you have too many failed logins you must enter a code (CAPTCHA). But this WP plugin does not facilitate in that.

Here is the solution:
OPEN

Code:

connect-phpbb.php

FIND

Code:

// AUTHENTICATE
add_action('wp_authenticate_user','op_login',10,2);
function op_login(&$userdata,$password){

if(file_exists(ABSPATH.'/'.PHPBBPATH.'config.php')){ // check to see if phpBB exists
if(defined('IN_PHPBB')){
return $userdata; // return if we're already in phpBB (to avoid a loop)
}

AFTER, ADD

Code:

   // FIX start, RamonFincken.com WebsiteFreelancers.nl
   // Fix for phpbb3 login attempts. If too many failed logins, phpbb demands you enter a visual code
   // So include ( but do not use ) the class to make phpbb happy :)
   define(IN_PHPBB,true);
   include_once('./'.PHPBBPATH.'includes/captcha/captcha_factory.php');
   // FIX end, RamonFincken.com WebsiteFreelancers.nl

This solution has been reported to the author and placed at http://wordpress.org/support/topic/347509?replies=1

(1) Replies