vtiger

[sammydeus]

I must be missing something. I want to install vtiger forums on my shared hosting account which already has PHP, Apache and MySQL running. I can't find any instructions on how to do this, nor can I find anything that looks like an install file in the package. The actual install instructions explain how to install PHPbb but that doesn't help because there are no corresponding files in the package.

Any help would be much appreciated!

[cabugs]

Yes you're right, you've missed the wiki section which contains what you want.

[sammydeus]

Hate to bug you, but do you have a link where I might find that?

[cabugs]

Just have a look at the top of the page or type http://www.vtiger.com/wiki/index.php in your browser. No problem it's hot today :)

[sammydeus]

Sorry but ther's no link to any information on the vtiger forum product on the Wiki page and every time I try to do a search I receive error messages. Is there a problem with the Wiki section? This is the message I receive:

Quote: Database error
For query "vtiger forum"

A database query syntax error has occurred. This could be because of an illegal search query (see Searching www.vtiger.com), or it may indicate a bug in the software. The last attempted database query was:
SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchindex WHERE cur_id=si_page AND ( (MATCH (si_title) AGAINST ('vtiger')) AND (MATCH (si_title) AGAINST ('forum')) ) AND cur_namespace IN (0,9,11) LIMIT 0, 20
from within function "SearchEngine::showResults". MySQL returned error "1016: Can't open file: 'searchindex.MYI'. (errno: 145)".

[829]

I can remember when the forums were a part of the CRM. At any rate, check here http://www.vtiger.com/index.php?option=com_content&task=view&id=39&Itemid=65

Since the search feature looks to be broke.

[sammydeus]

Unfortunately these instructions are for the installation of vtiger forums WITH Apache, MySQL and PHP on a Linux platform. I already have these components installed and what I want to do is install the package from source on a shared hosting environment where I do not have command line access the same as you would do with vtigercrm 4.x.x but this is what I cant seem to find out how to do.

Is this as simple as manually changing the config file and running a SQL query on MySQL? If so, where is the SQL file? Or is it more involved than this? I'm very confused and just want to thank everyone who has offered suggestions up to this point. Ultimately, however, I do want to get this up and running.

[sammydeus]

Alright! I think I have a workaround that may solve this problem. It's not perfect because there may be some security concerns. Perhaps one of the developers could take a look at this information and streamline it for us. By the way, these instructions only apply to servers running MySQL.

First upload the entire file to a directory of your choice maintaining the directory and file structure.

Create a MySQL database

Edit the config.php file to reflect your database settings (The file says don't edit below this point but you can ignore this) I set the CHMOD on config to 666 but I don't know if that is absolutely essential.

CHMOD the cache and includes directories to 777 (I also set all the contained files and folders to 777 and this is where I think there might be a potential security issue)

Use something like PHP MyAdmin to run the SQL query on your database. The query can be found at

(Your extracted vtiger forum package)/product_packaging/resources/mysql/mysql_basic.sql

Point your browser to http://yourdomain.com/vtiger_forums (or whatever you have chosen to call it)

You can log in using:

username: Admin
PW: Admin

(Note, both are case sensitive)

Once you have logged in you will be able to access the admin panel by selecting the admin panel link at the bottom of the main window.

I hope this helps everyone who has experienced the same challenges as I have.

[sammydeus]

Sorry! :oops:

Username: Admin
PW: admin

Note the case changes.

Just to be safe try them both and then change your password the first time you log in as Admin for security (and simplicity) purposes.

Good luck.

[829]

Forums are based on PHPBB, you might find some additional answers there. Setup your MySQL DB
Upload the package
The config.php does need to be CHMOD to 666 during the installation and then back to 644 after install
Browse to http://your.com/forum/install.php <-- If using sub directory
After it completes, delete the install and contrib folders.
Done