Warning: PDOStatement::execute() [pdostatement.execute]: SQLSTATE[HY000]: General error: 145 Table './skippy_skippy/h_sessions' is marked as crashed and should be repaired in system/classes/databaseconnection.php line 269
skippy dot net

vhost 1.5 feed icon

vhost 1.5 is now available!

This is a minor update to my vhost plugin, making it compatible with WordPress 2.0.


  • joe
    Hi, I just installed this on a wordpress 2.0 installation. It worked, except on the sidebar of the vhost blog, instead of the "pages" section, I got: WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1] SELECT ID, post_title, post_name from wp_posts WHERE post_status = 'static' AND post_author = any ideas?
  • Mark
    Hey Skippy, got it working better on WP 2.0.1 now, but am having some problems too. I'm getting the same error as joe on the virtual category sites, but the 'parent' site works ok. It looks like you need to specify a website address for each of your users/editors, and you need a user/editor for each vhost. If you don't do this the vhost_list_pages function fails. You can just drop the post_author clause from this query if it isn't set: if($vhost_owner) { $sql = "SELECT ID, post_title, post_name from $wpdb->posts WHERE post_status = 'static' AND post_author = $vhost_owner"; } else { $sql = "SELECT ID, post_title, post_name from $wpdb->posts WHERE post_status = 'static'"; } $vhost_pages = $wpdb->get_results($sql); I'm still playing, but so far it's looking good!
  • Mark
    There seem to be some funney things going on around the user login side of things too. I've created a user with the website the same as one of the virtual hosts, but when they log in they get a blank screen. I'm testing this on a rather odd web server and I don't have access to the logs, and changing the error reporting level with ini_set() doesn't seem to help - just getting a blank screen. Anyone got any tips on setting up the users for the vitual hosts?
  • Anonymous
    This is a feature I need but I am at a total loss as to how to implement. Please point me in the right direction either here or a link to a step by step
  • NTEK
    Darn, I'm experiencing both problems discussed in original post... dunno how to fix, though.. My system is Debian, with mysql 5.0.22 and php 4.4.2 Just for reference, here are the urls: primary site url is http://protoblog.ntektechnologies.com test category url is http://testi2.ntektechnologies.com I've set up lighttpd to deliver content properly in both urls, so that is not the issue here - sql statement error is pretty odd-looking if you ask me (I don't speak sql, though) - I'm having same issue with other box using apache as webserver, mysql and php are the same. Any suggestions any1? Harri a.k.a. NTEK
  • NTEK
    One more thing, wordpress is 2.0.3 NTEK
  • NTEK
    Grrrrrr... I'm getting mildly frustrated with this one - has any1 actually got this working? Besides Skippy of course NTEK
  • NTEK
    Okay, I managed to track down the problem, it's in INNER JOIN differences inbetween mysql4 and mysql5... now how to fix this....*sigh*
  • Jfar
    Yes, it works nearly perfectly. WP : 2.0.4 I had it working by adding at least an URL to each account. If it has not it's URL it doesn't work. Also, the theme must be mamed has the same name has the Website URL of the author. There's still a problem, the redirection doesn't work properly, in fact, the do_action('admin_head') is to far after the beginning of the html page. I suggest wordpress developper to put this do_action between the head tags and the first meta tag. So the redirection can be done there. Very good work, skippy. I just think if someone can override it just by forging an URL... I'm goins to dig into this. It's the same for the relative plugin : category user, it seems that the interface hide the button but does the internal function forbid it...
  • Steve
    Hi Skippy This plugin looks great, and I'd love to use this. Is it still in beta? If so, any idea when it will be out of beta and deemed suitable for public consumption? Thanks, Steve :)
  • skippy
    Thanks for the feedback, Steve. I haven't updated this plugin in a long time. It works for me on the one site for which I use it, but I wouldn't consider it out of beta. I have no intention of updating this to work with future versions of WordPress.
  • Mikael
    Hello, I've almost got everything working. This is what I've done and in what order: Installed the latest WP in domain/wp. Created subdomains sub1 and sub2, pointing to directories domain/sub1 and domain/sub2 (- because of how my virtual hosting provider has it set up..). Removed those directories and created symlinks from directories sub1 and sub2 to wp. I installed VHost 1.5 plugin and activated it. I also copied themes to sub1 and sub2, according to instructions. Then I created categories sub1 and sub2 and created a couple of test posts. When testing, the domains come up and everything looks good... except for the same error that Joe has. Pages seem to be messed up. How can this be fixed? Is it possible to use a categories-for-pages plugin to get this sorted properly as well? Yours Mikael.
  • skippy
    Mikael: I'm not sure what the cause of your problem is. I've stopped working on this plugin, so I don't know how much the WordPress source has diverged from what the plugin expects. I haven't been tracking WordPress development at all, lately, so there the most recent version(s) may well have introduced changes that break this plugin.

About | Policies | skippy.net

Warning: PDOStatement::execute() [pdostatement.execute]: SQLSTATE[HY000]: General error: 145 Table './skippy_skippy/h_sessions' is marked as crashed and should be repaired in system/classes/databaseconnection.php line 269
Warning: PDOStatement::execute() [pdostatement.execute]: SQLSTATE[HY000]: General error: 145 Table './skippy_skippy/h_sessions' is marked as crashed and should be repaired in system/classes/databaseconnection.php line 269