- Written by charlie
- Category: Books & Media
Delaware's Department of Natural Resources and Environmental Control (DNREC) just released its fifth wetland related video as part of the “Wetlands 101” video series - “Restoring Wetlands: Facing Challenges” on DNREC’s YouTube Channel.
“Restoring Wetlands: Facing Challenges” focuses on common problems that wetlands face, and what Delawareans can do to help restore wetlands' natural capabilities. The five-minute video features four items that impair wetlands, interesting facts, scenic views, and live wetland wildlife.
The entire playlist of 5 wetlands related videos is here and includes:
- Wetlands 101 - What is a Wetland?
- Wetlands 101 - 3Ps
- Wetlands 101: Wetlands & Sea Level Rise
- Wetlands 101: Wild Wetlands
- Wetlands 101 - Restoring Wetlands Part 1: Facing Challenges
There are also additional wetlands related videos including one on beach grass planting produces the the DNREC.
- Written by charlie
- Category: Other
In 2011, I permanently shut down the Wetland Wiki, as the workload of constantly editing and updating the pages became onerous, and Wikipedia had much of the same, if less detailed, information. Before shutting it down, I copied the Mediawiki (Version 1.13.1) database for posterity, and occasionally thought that some of the pages/articles I wrote should not have just disappeared, but been shared in some other fashion. 5 years later, almost to the day, I tried importing the database, and ran into many unforeseen errors, primarily due to depreciated syntax and changes in MySQL - my database hadn’t changed, but the MySQL has changed enough to make importing the database impossible without some updates.
Below are the errors I encountered while importing them into PhpMyAdmin, and how I fixed them; maybe someone else will find them useful. These few changes allowed me to import the 25MB database with approximately 200,000 lines successfully. The first error I encountered was:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 8.
'TYPE=MyISAM' is depreciated, so I searched and replaced over 20 occurrences with "ENGINE=MyISAM". In a closely related error, 'TYPE=InnoDB" was also replaced with "ENGINE=InnoDB".
At this point about 20% of the database was imported successfully until the following error:
#1426 - Too big precision 14 specified for 'cl_timestamp'. Maximum is 6. which was easily corrected to timestamp(6) CREATE TABLE `categorylinks` (
`cl_from` int(8) unsigned NOT NULL default '0',
`cl_to` varchar(255) binary NOT NULL default '',
`cl_sortkey` varchar(86) binary NOT NULL default '',
`cl_timestamp` timestamp(14) NOT NULL,
UNIQUE KEY `cl_from` (`cl_from`,`cl_to`),
KEY `cl_timestamp` (`cl_to`,`cl_timestamp`),
KEY `cl_sortkey` (`cl_to`,`cl_sortkey`,`cl_from`)
The last error recieved was, #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=HEAP MAX_ROWS=25000' at line 3. Which I updated to 'ENGINE=HEAP MAX_ROWS=25000'
Additionally, PhpMyAdmin had been timing out while importing the database after a few minutes. To lengthen the amount of time available for the import, I added the following line $cfg['ExecTimeLimit'] = 6000; to config.inc.php and restarted Apache.
After all this, the entire 25MB database was imported successfully. Now all I have to do is extract the articles, but that’s for another post!
Wetlands in the News
The Numeniini — a tribe of large waders including curlews and godwits — is one of the most threatened bird groups on the planet. The once-abundant Eskimo Curlew Numenius borealis of the Americas is now considered Critically Endangered (Possibly Extinct...
The findings of a new report indicate the rehabilitation of aggregate extraction sites in Ontario has created hundreds of hectares of new aquatic habitat features. The study, entitled Surrendered Aggregate Sites in Ontario's Provincial Plan Areas, was...
WYSOX — In response to vocalized community concerns, the Wilbur Beers wetland in Wysox underwent repair on Monday. Bradford County Conservation District staff joined with area volunteers to perform both cosmetic and safety upgrades within the nature area.
One year after a dog drowned at the American Canyon wetlands, another canine nearly lost its life last month to the same culvert that sucked it under the water. Resident Barry Christian, who frequents the wetlands, reported during a meeting at City Hall on...
Hurricane Harvey was tough on wetlands, and even tougher on wetland scientists, like me. I have spent a career focusing on wetlands along the Upper Texas Gulf Coast. Like the Lorax, I speak for the wetlands (and the prairies and forests and all the rest of it!