DragonflyCMS Projects > Weather Harvest > Weather Harvest Installation error... > Community Forums > Phoenix Netology
Forum Index > Miscellania > Weather Harvest

Weather Harvest Installation error... Reply to topic


Hi there,

When I installed WH module for DragonFly I get a SQL error,

MySQL Error while executing:
INSERT INTO cms_weathercountries VALUES ('af', 'afghanistan')

Duplicate entry 'af' for key 1


what does this mean??? Rolling Eyes


Johnny,

Please enter your server specs in your user profile! 😢


it probably means that you already have an existing database and it won't duplicate an entry.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


Thanks for your reply...

As far as I can see, the only database associated with WH are:

cms_weatherblock 6 MyISAM 1.2 KB -
cms_weathercountries 213 MyISAM 11.6 KB -
cms_weatherdefaults 2 MyISAM 2.0 KB -
cms_weatherini 2 MyISAM 3.2 KB -
cms_weatherstations 2,379 MyISAM 1.2 MB -
cms_weathersummaries

when I delete these, and try to install again... it gives me the same error...

is there another DB I have to modify?
True, when I tried to install WH for the first time it timed out...

John,

Please enter your server specs in your user profile! 😢


I have the same problem.The tables are created properly.The problem is that in modules administration.the module is shown as not installed but tables database are correctly created

Please enter your server specs in your user profile! 😢


After clicking "INSTALL" you will get a message,
"The module "WeatherHarvest" has been properly installed, have a blast using it!"

Since it is a large file, it is still updating your data base with information, as indicated in your browser status bar. At 941 kb, it is well within the size limit that your server can handle.

DO NOT click "Go" - just let the install do its job and when it's done, it will automatically redirect to the admin>>modules section by itself - then you should see that the "Uninstall" link is there.

If you have an incomplete install, delete those tables using phpmyadmin and start again.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


Also detected small problem with the default blocks display - humble apologies. I should have checked the blocks on a new installation - as a wise person once told me, "Assumptions are the mothers of all f*** ups".

The attached blocks.zip contains the amended blocks so you don't have to download the full zip.
Attachment: whblocks.zip
Description
Filename whblocks.zip
Filesize 6.20 KiB
Downloaded 16 Time(s)
You are not allowed to view/download this attachment

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


no matter what i do i can't get it to show my chosen default for anonymous users. it always displays lees sumit. Sad

Please enter your server specs in your user profile! 😢


nukebiz.com/Forums/vie...1.html#561

Must be done through admin when logged in as ADMIN ONLY - that way, it interprets you as an Anonymous user.
admin.php?op=WeatherHarvest&mode=adminWHReportStation

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


i did that and when i save my changes it does say something like "anonymous user settings changed" or something like that. then when i check it out in IE when i'm not logged in as a user or admin it still shows lee's summit.

Please enter your server specs in your user profile! 😢


Clear browser cache should do it - I've tested okay quite a few times now Confused

Link?

(the old block wouldn't have shown the change, but I just checked the download and can confirm the right block is in the zip)

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


aha yeah clearing my cache did it. i really hate doing that because i have a lot of stuff i need in my cache. so i always have to go in and do it site by site which is a pain in the butt. thanks phoenix that worked.

the site isn't going to be up until august 25th but it will be floridagardenclub

Please enter your server specs in your user profile! 😢


yep, I hate deleting cache too, same reasons - sometimes a "hard" refresh does the job, like holding down F5 for 10 to 15 seconds - another way is to disable the block, refresh page, and enable the block again, but that's a real pita. Lastly, because I use both FF and IE frequently, I open Opera to check it.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


As the title says, I installed WeatherHarvest for a client, let in finish running the cpg_inst.php file, never clicked go, it simply redirected itself to maintenance mode page, and now I can't get back in.

I have cleared the cache on the site, and in the browser, and even went into the database and removed all the weatherharvest tables to no avail.

Any assistance would be greatly appreciated.

tks,

edit: BTW, the site in question is a 9.0.6.1 site.

Please enter your server specs in your user profile! 😢


Installing WeatherHarvest doesn't have anything to do with Maintenance Mode or any other admin setting - you/your client must have changed something in admin for that to come into play. There simply is nothing in the install file that can change anything.

You need to restore your maintenance mode through admin, or by changing the setting in the cms_config_custom table.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


Nothing was changed by me or my client I can assure you.

I can't log into admin, that is part of the problem, and it happened immediately after the loading of the WeatherHarvest module.

As I said, I never clicked go or anything, it simply redirected itself to it.

Mind you, it was already runnning in maintenance mode, which might, in and of itself have been part of the problem, not sure.

In any event, I cannot log in as admin, and the only thing in cms_config_custom is stuff about CPGPal, a module by Akamu, that isn't even enabled.

Any other suggestions? If worse comes to worse I suppose I can start over, but that is obviously not the desireable answer.

tks,

Please enter your server specs in your user profile! 😢

All times are Australia/Adelaide


Jump to: