DTH Development

Hi,
I have a really bad time installing the extension. It won't install with FTP layer active and I can get little further with chmod 0777 trick.
But even then I get only to see the following error:

JDatabaseMySQL::query: 1091 - Can't DROP 'group_reg'; check that column/key exists SQL=ALTER TABLE `jos_dtregister_codes` DROP `group_reg`

With no success installing at all.
With debug console I can see a bit more of information:

11 JDatabaseMySQL->query() /home/i556748/public_html/booking/administrator/components/com_dtregister/install.dtregister.php:121

What should I look at/fix to install the extension?

What version are you trying to install? I don't think it is the latest. Download the latest (presently 2.7.17) from My Orders.

Also make sure your PHP setting for upload_max_filesize is greater than 2M.

Regarding permissions, you should never set anything as 777. That will hurt more than help. You should have 755 directories and 644 files.

If you check the above and still have an issue with the 2.7.17 package install, submit a ticket please.

Hi,
Thanks for quick reply.

I want to be sure I'm doing everything right so I went to My Orders and dwnloaded the latest version 2.7.17.

At first:
I've set up the FTP layer properly (joomla can update configuration and reach the tmp folder during upload),
I used the script from http://docs.joomla.org/How_to_solve_Installation_errors_Extension_Manager to set folders to 755
The upload limit is: upload_max_filesize 12M (post_max_size is similar) and the file lands in tmp folder no problem.
Then when I use Extension Manager: Install -> Upload Package File - I get:

JFTP: :write: Bad response
Unable to write entry

Next:
I tried to unzip the com_dtregister2_7_17_J25.zip into a com_dtregister2_7_17_J25 folder and upload it to the server,
Then I go to Install from Directory with /home/useraccount/public_html/tmp/com_dtregister2_7_17_J25 and get:

-1 - An error has occurred.
Copy failed -/home/username/public_html/booking/tmp/com_dtregister2_7_17_J25/site/views/payoption/tmpl/index.html- to-public_html/booking/components/com_dtregister/views/payoption/tmpl/index.html

(where the paths are echoed by adding ".'-'.$sfid.'-'.$dfid" to the /libraries/joomla/filesystem/folder.php:102
Strange thing is that the destination file is created, so are other files there.
If I repeat the step above with or without removing com_dtregister folders from component folders the error displays different files every run.
It takes less that 20sec to get the error message so it's not max_execution_time.

So Next:
I disabled the FTP layer and brought folders to 0777 state (with this http://docs.joomla.org/How_to_solve.... script),
Then I go to Install -> Upload Package File - and get:

500 - An error has occurred.
JDatabaseMySQL::query: 1091 - Can't DROP 'group_reg'; check that column/key exists SQL=ALTER TABLE `jos_dtregister_codes` DROP `group_reg`

from:

Code: Select all

11      JDatabaseMySQL->query()      /home/i556748/public_html/booking/administrator/components/com_dtregister/install.dtregister.php:121

Finally to test the last way:
With FTP disabled and folders set to 0777 I can go to Install from Directory to get the same:

500 - An error has occurred.
JDatabaseMySQL::query: 1091 - Can't DROP 'group_reg'; check that column/key exists SQL=ALTER TABLE `jos_dtregister_codes` DROP `group_reg`

What else can I try to install this component?

With what you posted, it did lead us to a one character problem in the install file. It wouldn't affect everyone... clearly, as this is the first report of it... but we've just now updated the install package for 2.7.17. Please download it again and you should be able to install just fine.

Make sure you don't leave anything at 777. They never should be 777. I know you were just trying whatever you could though. Sorry for the confusion. Thanks.

Thanks for updating the installation package.
I can imagine that not many had such problems before because it was happening in a specific scenario:
1. On a clean joomla installation I've tried using the FTP layer first which always failed because of problems with ftp_put function returning warning on 'Accepted data connection' (known bug in PHP)
2. Then I switched to not use the FTP but grant 0777 permissions to the folders.
And while I was always cleaning the folders before the new installation of dtregister I forgot to look into database and clean there so the DT installation was landing on a partly finished previous installation.
The DROP problem never happened when I tried to install on a fresh joomla.
So I'm not surprised that not may users could reach the DROP problem.

There is still small glitch with the installation which is asking me to create the '/images/dtregister/locations' folder and to make it writable - I don't have the '/images' folder in the root of the server and won't allow joomla to write to one. Wouldn't mind if it was asking for 'images/dtregister/locations' as a relative one.