Back to ProBlog Support

mark8518
mark8518

When I try to install this plugin I get the following error:

Update failed "SQLSTATE[42704]: Undefined object: 7 ERROR: type "search" does not exist at character 48 (SQL: ALTER TABLE radiantweb_blog_posts ADD FULLTEXT search(title, content))" on line 624 of /home/vagrant/Sites//vendor/laravel/framework/src/Illuminate/Database/Connection.php

My installation uses Postgresql. By any chance is this error due to a hard dependency on Mysql?

This is bad. I'm unable to install the plugin, or uninstall the plugin; my entire project is now broken in a way I don't know how to fix. Can you fix this please?

ChadStrat
ChadStrat

well...I can't speak to Postgresql usage sadly. But I can say the app installs using Octobers migration API. It seems as though (and I am strictly guessing here because I know nothing about Postgresql) that Postgresql does not acknowledge the MyISAM engine which is necessary for search indexing. You might try swapping the version file reference to something else supported by Postgresql that supports searching? /plugins/radiantweb/problog/updates/create_posts_table.php

then uninstall/reinstall.

mark8518
mark8518

Hi Chad. Thank you for responding.

From what you're saying, It's clear that you have no routine in the installation to handle postgres being distinct from mysql, and that is likely why it is failing. You might want to look into addressing that for the future, as postgres is not going anywhere, it's a much nicer database than mysql, and laravel supports it natively (so October should too by my reasoning).

I think I'm giving up on October for now. I'm finding myself fighting it trying to make it do what I want it to do and getting aggravated. I'm going to roll my own simple blog in straight Laravel which (paradoxically) will be less complicated I think.

I'd appreciate a refund if you can manage it, since I'm not going to be using the plugin. If that's against policy then improve ProBlog with it.

Mark

1-3 of 3