TOPIC: install failed - table comment_setting doesn't exist

Installed Compojoom comment 4.1 beta1 but get errors indicating that the db table comment_setting doesn't exist. I'm using mySQL version 5.0.81 which seems fine. One issue may be that I am NOT using the default jos_ prefix for table names. Could that be the problem?

Any help is appreciated.

Dan...

Hey Dan,
Thank you for your purchase! I know had a look at the install script and you are right. I made one super stupid mistake.
Normally the prefix is not a problem when you are using the standard joomla functions. And I'm using them, but I don't know why I have written jos_ for prefix instead of jos_ - you see jos_ gets replaced with your prefix and jos_ stays the same

Sorry about that.
I will need you to unzip the zip package that you have downloaded, then open it and find the install.comment.php file and then on line 81 you wil see the following code:

change it to
I'll update the installation package myself today so if you can wait several hours you don't have to make the above chages.
Cheers,
Daniel

Thank you for the quick response! I see the fix in the updated download zip file in the file install.comment.php . Your post indicated that you changed 'jos_' to 'jos_' . You actually meant change 'jos_' to 'jos_' (note the 2 underscores). This seems like it should work.

However, still having the same problem. The installation creates tables beginning with 'jos_' rather than my site's prefix. I manually deleted these tables, re-ran the install, and the same thing. 'jos_' tables were created.

I verified that the database table prefix is correct in the Joomla global settings. I even installed another component to see if it created the correct prefixes (it did).

Help...

Thank you in advance, Dan...

Interestng observation. The comments here automagically change '# _ _' (but without the spaces) to 'jos_'.

This behavior makes the previous couple of posts a bit odd to read.

Dan...

Hey Dan,
Sorry! You will have to check the sql file too.(sql/install.mysql.sql) It is full of jos_ . I changed this to jos_ and I will upload the new package in 2h.

Thanks again for the quick fix!!

I'll wait and download your updates when they are ready (it's Saturday - don't you ever take a break )

Dan...

Hey Dan,
I would like to take a break, but you have a problem
Can you tell me how did you manage to install joomla without prefix? I'm trying to install it with the new joomla 1.5.16, but on the screen with database settings it won't let me proceed unless I enter a prefix.

Hey again Dan
So, the new version is in the download section.

I installed joomla on my localhsot with prefix text_
The compojoomcomment version in the download section installed on this site without any problems. All tables were created with prefix test_ and I was able to make a comment trough the frontend and edit this comment in the backend - everything seems to be working now.
However I have no idea if you will be able to get it working on site without prefix. As I said in my post above - joomla is not allowing me to install it without database prefix.
Please try the newest version and let me know.
cheers,
Daniel

I have a prefix it's just not the default 'jos' prefix. I believe you are right that you have to have something. The only reason I did that was to make the site a bit more secure from sql injection attacks. It makes the table names unique and hard to guess.

Dan...

It works! Thanks!

All the tables are being created with the site's table prefix now.

Dan...

Great! I'm happy that it is working! Sorry that you had to go through the troubles.
Please make a review for compojoomcomment extensions.joomla.org/extensions/contact...icles-comments/12259
Thanks in advance!

P.S. I have a terrible back pain and I'll be away for several hours.