Another installation problem with mod_captcha_control

[imwebdev]

HI All,
I have another problem with my installation.  I have managed to get past this last time, but want to get to the bottom of this so I know what the problem is so I know when I am installing the software again.

Here is the error I get once I have click 'Install websitebaker' on the install wizard page.
Table 'ayurvedi_wbaker.mod _captcha_control' doesn't exist

Table 'XXXX_wbaker.mod_cap tcha_control' doesn't exist
Where XXXX is the name of the database

Any ideas?
I thought I had the permissions right, but obviously not. 
And the error that is displayed is not very useful! Not sure how to get around this without uninstalling everything and starting again!
Any help would be appreciated!

Cheers

[kweitzel]

Could be the permissions of the MySQL User that you have ... needs to have the right to "create" tables etc ...

cheers

Klaus

[imwebdev]

Hi and thanks for the reply.

My MySQL table has all privileges enabled, that is why I find the error to be strange.
I have removed the entire site and the database several times, but still get the same error. 

Any other ideas?

Thanks

[imwebdev]

HI,
I ended up putting every folders permission at 777, which is not at all ideal, but for some reason the site wont work unless I do this!

I have used many other CMS's and dont require this.  I think I might just have to live with it!
Are there any security modules or anything like that I could use to secure my site more?

Cheers

[thorn]

Hallo,

Here is the error I get once I have click 'Install websitebaker' on the install wizard page.
Table 'ayurvedi_wbaker.mod _captcha_control' doesn't exist

Table 'XXXX_wbaker.mod_cap tcha_control' doesn't exist
Where XXXX is the name of the database

Are you sure about database-name , table-name and TABLE_PREFIX?
"ayurvedi_wbaker" seems to be the database-name, "mod_captcha_control" is the table-name.
The Point separates database and table.
What is your TABLE_PREFIX?

thorn.

[websanity]

I had this exact same problem. This is the second time I've installed WB and the second time I've had to spend too much time trying to sort out permissions to get it working (which, in all fairness might be my ftp program: smart ftp often seeming to get confused when asked to do more than one thing at once and the last time I caught it setting permissions madly to 22 across various directories!!!) 

Anyway, getting back to the plot, I had the exact same problem, and setting permissions for the modules directory to 777 allowed the install to run and get this table intsalled (and then set back to 755 afterwards).

G

[mikerouse]

Hi,

I'm having this problem too. However, it's happened to a site that is already up and running. We came to log in to it today and after entering username and password we are presented with the error message and cannot proceed to carry out any admin.

I'm setting all directories and files to 777 to see if it will make a difference, but doubt it. We don't have any captcha controls installed on this site - or at least we didn't think we did.

Any advice gratefully received.

Mike

[thorn]

Hello,

after some investigantions, i found an issue in the install.php from captcha-module.

Code:

`ct_text` LONGTEXT NOT NULL DEFAULT ''

This may fail on some servers, since DEFAULT-values are not allowed for TEXT-fields.

This has to be fixed in SVN ASAP.

thorn.

[mikerouse]

I think I have a workaround for this if anybody, like me, has a client with content on a site that they don't want to lose. It's a bit drastic but worked for me.

Back-up all of your files and MySQL database, especially your Pages directory and any templates.

Perform a clean re-install of websitebaker.

Using PHPMyAdmin make sure the "mod_captcha_control" table was created on your new clean installation.

If you have the table then go ahead and empty all of the other tables in the new database of their data. Take your backed-up database and import the SQL into the new database for all of the other tables. Originally I used a "wb_" prefix in my first table and no prefix in the new one so I had to be careful of this.

Then, when you've reimported all of your data you should be able to update the site and everything again. If you've done as I did and move server at the same time make sure you've set all the permissions correctly as I  forgot to do this.

The client is now able to log in to the site and update it and is now a happy client once again, though it was a little embarrassing for a while.

[crnogorac081]

HI,
I ended up putting every folders permission at 777, which is not at all ideal, but for some reason the site wont work unless I do this!

I have used many other CMS's and dont require this.  I think I might just have to live with it!
Are there any security modules or anything like that I could use to secure my site more?

Cheers

777 is not good at all, try with 755

cheers